SaaS Forecasting Tool
A 48-month subscription forecast: new, renewed, churned and reactivated subscribers, revenue, billings, deferred revenue, MRR and ARR, with contract and billing cycles set separately.
ARR at the end of the forecast
$1.4M
Revenue over 48 months
$2.3M
Subscribers at the end of the forecast
3,934
LTV / CAC
21
Unit economics
- Lifetime value (LTV)1 / churn x revenue per month x gross margin
- $525
- CAC payback, months
- 0.95
Totals
- Billings over 48 months
- $2,980,663
- Marketing spend over 48 months
- $124,417
- New subscribers over 48 months
- 4,151
- Churned subscribers over 48 months
- 217.3
- Deferred revenue at the end
- $677,475
- MRR at the end
- $118,009
- Average monthly growth in subscribers
- 12.1%
By month
This runs the same math as the spreadsheet, checked against the workbook on every change. When you want the formulas, download the workbook with your inputs, or get the model with its docs and the Google Sheets version.