Formula
Operating cash flow = (monthly customer collections + other operating inflows) − (supplier and inventory payments + payroll and contractors + rent, utilities, insurance, software + taxes and owner draws).
Investing cash flow = −(equipment and other purchases). Financing cash flow = new funding received − loan and advance payments.
Net monthly cash flow = operating + investing + financing. Closing cash balance = opening cash balance + net monthly cash flow.
Months of runway = closing cash balance ÷ monthly burn, where burn = −net monthly cash flow when net is negative; if net is zero or positive the business is cash positive. Operating margin on cash = operating cash flow ÷ total inflows.
Worked examples
Example 1: the default month, with $80,000 collected and $75,000 of operating outflows
Inflows = $80,000 collections + $0 other = $80,000. Operating outflows = $42,000 suppliers + $22,000 payroll + $7,000 rent and overheads + $4,000 taxes and draws = $75,000. Operating cash flow = $80,000 − $75,000 = $5,000. Investing cash flow = −$2,000 (equipment). Financing cash flow = $0 new funding − $5,000 loan payments = −$5,000. Net monthly cash flow = $5,000 − $2,000 − $5,000 = −$2,000. Closing balance = $30,000 opening − $2,000 = $28,000. Burn = $2,000 a month, so runway = $28,000 ÷ $2,000 = 14.0 months. Operating margin on cash = $5,000 ÷ $80,000 = 6.3 percent. The tool shows −$2,000, $5,000, −$2,000, −$5,000, $28,000, 14.0 and 6.3 percent. The reading: the operation makes money, but debt service and small purchases consume more than it makes. Fourteen months is time to fix it; the fix is either $2,000 of monthly cost out, $2,000 more of collections, or a lower debt payment.
Example 2: a loss-making month with two months of cash
Opening $45,000; collections $60,000; other inflows $2,000; suppliers $38,000; payroll $20,000; rent and overheads $6,500; taxes and draws $3,000; equipment $1,500; debt payments $8,000; new funding $0. Inflows = $62,000. Operating outflows = $67,500. Operating cash flow = −$5,500. Investing = −$1,500. Financing = −$8,000. Net = −$15,000. Closing = $45,000 − $15,000 = $30,000. Runway = $30,000 ÷ $15,000 = 2.0 months. Operating margin on cash = −$5,500 ÷ $62,000 = −8.9 percent. Two months is an emergency, and the breakdown says where it comes from: the operation itself loses $5,500 and debt service takes another $8,000. A new loan would show up as positive financing cash flow and lengthen the runway, but it would also raise next month's debt payments. The owner's first job is the operating line: collections, pricing or payroll. The second is the debt line, where the refinance calculator may find relief. The cash flow stress test shows how little margin remains.
Example 3: a cash-positive month funded by a new loan
Opening $12,000; collections $95,000; suppliers $50,000; payroll $26,000; rent and overheads $9,000; taxes and draws $5,000; equipment $15,000; debt payments $7,000; new funding $25,000. Inflows = $95,000. Operating outflows = $90,000. Operating cash flow = $5,000. Investing = −$15,000. Financing = $25,000 − $7,000 = +$18,000. Net = $5,000 − $15,000 + $18,000 = +$8,000. Closing = $12,000 + $8,000 = $20,000. Runway: cash positive, so no burn. Operating margin on cash = 5.3 percent. The month looks healthy on the net line, and it is not. Operating cash flow of $5,000 did not fund a $15,000 equipment purchase; the loan did. Without the $25,000 the net would have been −$17,000 and the closing balance negative. Next month the $7,000 of debt payments rise to include the new loan. This is the pattern to recognize: a positive net cash flow created by financing is borrowed time, and the operating line is the one to judge the month by.