The model lab / service businesses
Revenue is the start.
Cash is the test.
Change the assumptions. See where the economics break. Trace every dollar through downside, base and upside cases.
Illustrative inputs, not market benchmarks. This model is not populated with any directory company’s financials. Calculations stay in your browser.
Choose an operating archetype
Your assumptions
Changing currency relabels inputs; it does not convert them.
Base-case operating math / USD
180 qualified jobs / visits × 100% = 180 completed jobs / month
180 jobs × 1 crew-hours = 180 / 220 available hours
Revenue uses completed jobs only. Travel and repair consume one shared capacity pool; neither creates a second billable unit.
Downside / USD
-$30,912
Annual cash after debt, before tax
Qualified demand −20%, completion −5 points, price −5%, variable cost +5 points
Base / USD
$61,547
Annual cash after debt, before tax
Your inputs, unchanged
Upside / USD
$113,853
Annual cash after debt, before tax
Qualified demand +15%, completion +5 points, price +3%; no assumed cost savings
Follow the cash
| Annual calculation | Downside | Base | Upside |
|---|---|---|---|
| Revenue | $272,916 | $378,000 | $447,741 |
| Owner-operated earnings proxy¹ | $111,041 | $203,500 | $255,806 |
| After replacement compensation | $31,041 | $123,500 | $175,806 |
| After maintenance capex | $19,041 | $111,500 | $163,806 |
| Debt service (principal + interest) | $49,953 | $49,953 | $49,953 |
| Cash after debt, before tax | -$30,912 | $61,547 | $113,853 |
| Initial equity incl. costs + working capital | $175,000 | $175,000 | $175,000 |
| Cash coverage of debt² | 0.38× | 2.23× | 3.28× |
| Pre-tax cash-on-cash | -17.7% | 35.2% | 65.1% |
| Break-even completed jobs / month | 159 | 141 | 137 |
What this model does—and doesn’t—say
¹ Revenue less variable and fixed operating costs is an owner-operated earnings proxy, not verified SDE or EBITDA. Owner compensation must not already be included in those costs. The next line deducts replacement compensation.
² Coverage uses cash after replacement compensation and maintenance capex. A lender may define DSCR differently. This is generic financing, not SBA eligibility or a Canadian lending offer.
No tax, seasonality, growth working capital, deferred maintenance, customer concentration, purchase-price allocation or foreign-exchange conversion is modeled. Defaults are invented teaching inputs, not industry benchmarks or any company’s financials. Validate against books, payroll, invoices, dispatch logs, equipment inspections and quoted financing.