Built from what we find in audits: tax charged on losses, churn on this month's sign-ups, annual totals that skip December. This one gets them right, so you can spend your time on the assumptions, not the plumbing.
Base, downside and upside side by side. Pick one in a drop-down — growth, churn, price and CAC follow.
Customers, MRR, fees, hosting, support, gross margin, marketing, payroll with yearly raises, EBITDA, tax, net income, cash.
Tax only on positive profit, with losses carried forward — no phantom refunds in loss-making months.
LTV, CAC, LTV/CAC, payback months with a plain-English verdict, plus months of runway left in every month.
Revenue, EBITDA, net income, customers, ARR run-rate and cash for years 1–3, ready to paste.
MRR, customers and cash balance over 36 months.
Same company, same team. In the downside case LTV/CAC is still a “healthy” 3.3× — and the company runs out of cash in year 2. Good unit economics do not pay salaries; the model shows both at once.
| Scenario | Customers, month 36 | Net income, year 3 | Cash, month 36 | LTV / CAC |
|---|---|---|---|---|
| Downside | 882 | −$448.6k | −$478.5k | 3.3× |
| Base | 2,779 | $322.2k | $639.1k | 7.2× |
| Upside | 7,815 | $2.08M | $3.07M | 14.7× |
Illustrative inputs shipped with the template; replace them with yours.
We adapt the template to your pricing, cohorts and hiring plan, or audit the model you already have. From $150.
Talk to us