Financial Analysis
Summary:
Key metrics:
• Install Rev: YTD $594k, Margin 33%; Jul-19 $111k, Margin 30%
• Service Revenue: YTD $58.7k, Margin 61%; Jul-19 $11k, Margin 61%
• Device Revenue: YTD $34k, Margin 32%; Jul-19 $250
• Net Income: YTD $65k; Jul-19 $19k
Revenue & Margin
• Install Margins: 6 projects completed in the month: [Project 1] 32% margin; [Project 2] 30% margin; [Project 3] 38% margin; [Project 4] 36% margin; [Project 5] 32% margin; and [Project 6] 19% margin (also a service project with 89% margins, probably misclassed some COGS – reviewing with team).
Cash Flow: ($1.9k) cash increase YTD ($63k lower than net income) – A lot of puts and takes but essentially operating cash flow is better than net income by about $12k thanks to A/R+Customer Prepayments, which has all been pulled out as owner draw ($85.7k)
• A/R and Customer Prepayments $51k positive
• A/P and Credit Cards $4.7k negative
• Warranty Liability $7k positive (non-cash expense recognizing on PnL, limited actual warranty work)
• Net Owner Draw: $85.7k YTD negative ($5k Draw in July)
• WIP $24k negative
• Payroll $3.6 negative (timing of wages recognition and cash out of account)
Balance Sheet:
• A/R: $86k total outstanding at end of month ($60k of which is still o/s as of Aug 11) – a few aged items totaling $10.5k mainly for [Project 11] (project delayed)
• A/P: $89k total outstanding at end of month ($89k of which is still o/s as of Aug 11) all [Vendor 1]
• WIP: $22k of projects in process: Largest – [Project 7] $11k; [Project 8] $9.5k; [Project 9] $6.9k: (Expensed Aug WIP for completed Projects) – shows $28.8k on the BS but that is pulling back Labor and materials purchased in this month to prior closed month.
• Customer Prepayments: $101k balance at July 31, 2019 – $53k increase over prior month balance – 14 projects, 3 largest are [Project 7], [Project 8], and [Project 9].
• -$1,482 due from vendors
• -$1,231.73 payment from Progressive for van – to be paid out for repair
• -$250 returned check for [Project 3] job – owed to [Contractor 1], determining how to pay him
• $7,128 undeposited funds – One payment, [Project 7], hits bank this month on the 2nd.
• Payroll Payable -$933 related to overpay of overtime on payroll, to be recovered on future payroll
COGS & Expense Notes: Opex at $19k
• $4.4k Other Direct Labor COGS – Payroll not allocated to customers mainly from PTO (Second highest month YTD)
• $655 Other Direct Materials COGS – Truck Stock
• $886 Fuel – Auto