💡 LTV = Monthly price ÷ churn. | LTV:CAC > 3× = healthy unit economics. | ARPU increase compounds monthly (upsells, price increases). | New customers per month set independently for each year.
Year 5 ARR
—
Annual recurring revenue
Year 5 customers
—
End of period
LTV : CAC
—
Customer lifetime value ratio
LTV
—
Customer lifetime value
CAC payback
—
Months to recover CAC
MRR growth over 60 months ($)
Net customer adds — new vs churned (quarterly)
Quarterly customer & revenue waterfall
ARR by year ($)
Revenue per customer (ARPU) trend — monthly
Key Cost Assumptions
$25,000
$2,000
$3,000
$100,000
5%
✓ No model errors — P&L, Balance Sheet and Cash Flow tie out
P&L waterfall ($k)
COGS breakdown ($k)
Profit & Loss Statement (USD)
Asset composition ($k)
Equity build-up ($k)
Balance Sheet (USD)
Cash flow components ($k)
Closing cash ($k)
Cash Flow Statement (USD)
Required investment to sustain operations
—
IRR @ 30% / 12×: based on 30% ownership and 12× EV/EBITDA exit multiple. | NPV @ 20%: If you demand 20%/yr returns, this is how many extra dollars this deal makes you vs. that alternative. Positive = beats your hurdle. | Cash-on-cash: Total cash you receive (operating dividends + exit) ÷ invested. 3× means you tripled your money. | Terminal value: Estimated sale price (Year 5 EBITDA × exit multiple). Your share is prorated by ownership %.
IRR @ 30% / 12×
—
Base case
NPV @ 20% hurdle
—
Extra value vs 20%/yr alt.
Cash-on-cash
—
Total returned ÷ equity
Required equity raise
—
Min. to sustain operations
Year 5 EBITDA
—
Base for exit calc
Equity cash flows ($k) — 30% ownership base case
Value creation bridge ($k) — 30% ownership
How to read this: You invest the required equity at the start in exchange for a % of the company (left axis). At end of Year 5 the business is sold at X × its Year 5 EBITDA (top axis). Each cell shows your IRR (annualised return). Example: 30% ownership at 12× exit → IRR shown in the teal cell. The pre-money valuation embedded in each row tells you what you're implying the business is worth today for that ownership %.
IRR sensitivity — Investor ownership % vs EV/EBITDA exit multiple at end of Year 5
Edit assumptions below. Changes are reflected immediately.