Prepared by Titus Kuepfer · Prosynergy Bookkeeping
May was your strongest month of the year — $56,987 in net income on $247K of revenue. Even so, the cash in the business fell about $24,500 to $36,152. The reason is timing: much of that profit is still sitting in customer invoices rather than in the bank (see the cash flow below).
As of June 17, about $57,540 of receivables are more than 30 days past due. Timet Morgantown alone owes $43,842 — most of it 31 to 90 days out — and Imler Equipment owes $8,403 that is now over 90 days.
Each month the business sends roughly $28,000 to lenders — about $8,600 in interest and $19,700 in principal — against $1.73M of long-term debt, much of it family loans. May's profit covered that comfortably (2.3×), but leaner months will not.
Marketing ($14,162), Office ($9,193), and Professional Fees ($8,180) all landed well above their monthly averages in May — about $31,500 combined versus a typical $19,200. Marketing and Professional Fees were each the highest of the year.
| Line | Jan | Feb | Mar | Apr | May | YTD | 5-Mo Avg |
|---|---|---|---|---|---|---|---|
| Revenue | 122,043 | 102,290 | 200,130 | 210,653 | 247,322 | 882,438 | 176,488 |
| Cost of Goods Sold | 105,380 | 100,106 | 142,758 | 158,443 | 120,304 | 626,991 | 125,398 |
| Gross Profit | 16,664 | 2,184 | 57,371 | 52,210 | 127,018 | 255,447 | 51,089 |
| Gross Margin % | 13.7% | 2.1% | 28.7% | 24.8% | 51.4% | 29.0% | 29.0% |
| Vehicle | 13,169 | 11,257 | 19,985 | 19,953 | 14,072 | 78,436 | 15,687 |
| Marketing | 4,539 | 4,830 | 9,192 | 7,926 | 14,162 | 40,649 | 8,130 |
| Payroll Expenses | 8,072 | 4,766 | 13,360 | 8,651 | 3,043 | 37,891 | 7,578 |
| Office | 3,713 | 3,350 | 10,040 | 4,121 | 9,193 | 30,417 | 6,083 |
| Professional Fees | 3,767 | 3,959 | 5,395 | 3,615 | 8,180 | 24,916 | 4,983 |
| Banking | 2,789 | 1,771 | 5,519 | 3,489 | 3,961 | 17,528 | 3,506 |
| General & Admin | 3,174 | 1,711 | 1,634 | 1,025 | 4,468 | 12,012 | 2,402 |
| All other operating | 3,824 | 2,971 | 12,231 | 10,576 | 4,766 | 34,369 | 6,874 |
| Total Operating Expenses | 43,048 | 34,615 | 77,355 | 59,356 | 61,845 | 276,219 | 55,244 |
| Operating Profit | −26,384 | −32,431 | −19,984 | −7,146 | 65,173 | −20,772 | −4,154 |
| Operating Margin % | −21.6% | −31.7% | −10.0% | −3.4% | 26.4% | −2.4% | −2.4% |
| Net Income | −30,522 | −37,940 | −25,129 | −11,440 | 56,987 | −48,045 | −9,609 |
| Net Margin % | −25.0% | −37.1% | −12.6% | −5.4% | 23.0% | −5.4% | −5.4% |
May beat budget across the board — net income of $56,987 came in well above the $23,700 target. Year-to-date, though, the business is still $133,645 below its net income target, driven mainly by cost of goods and operating expenses running higher than planned.
| Line | Bud % | Budget | Act % | Actual | Variance |
|---|---|---|---|---|---|
| Revenue | — | 220,000 | — | 247,760 | +27,760 |
| Cost of Goods Sold | 60% | 132,000 | 49% | 120,304 | −11,696 |
| Gross Profit | 40% | 88,000 | 51% | 127,456 | +39,456 |
| Operating Expenses | 26% | 57,200 | 25% | 61,845 | +4,645 |
| Operating Income | 14% | 30,800 | 26% | 65,611 | +34,811 |
| Interest & Other Expense | — | 7,100 | — | 8,624 | +1,524 |
| Net Income | 11% | 23,700 | 23% | 56,987 | +33,287 |
| Line | Bud % | Budget | Act % | Actual | Variance |
|---|---|---|---|---|---|
| Revenue | — | 865,000 | — | 884,184 | +19,184 |
| Cost of Goods Sold | 60% | 519,000 | 71% | 626,991 | +107,991 |
| Gross Profit | 40% | 346,000 | 29% | 257,193 | −88,807 |
| Operating Expenses | 26% | 224,900 | 31% | 276,220 | +51,320 |
| Operating Income | 14% | 121,100 | −2% | −19,027 | −140,127 |
| Interest & Other Expense | — | 35,500 | — | 29,018 | −6,482 |
| Net Income | 10% | 85,600 | −5% | −48,045 | −133,645 |