A comprehensive financial model designed for B2B SaaS companies. Covers the full ARR waterfall (new, expansion, contraction, churn), unit economics (CAC, LTV, payback), cohort analysis, and a five-year projection with fundraising scenarios.
What's included
Template preview
Step by step
Enter expected new customer additions per month, average contract value, and sales cycle length. Factor in marketing spend to calculate CAC.
For each month, the template tracks beginning ARR, adds new and expansion ARR, subtracts contraction and churn, and calculates ending ARR.
Enter fully loaded CAC (marketing + sales costs / new customers) and gross margin. The template calculates LTV, LTV:CAC ratio, and payback period.
Enter monthly retention rates by cohort. The model uses these to project churn and expansion for each customer vintage.
Add planned fundraising rounds with timing, amount, and valuation. The template calculates dilution and shows the cash runway under each scenario.
Watch out
Confusing bookings with recognised revenue — ARR should reflect recurring contractual value
Using blended churn rates instead of modelling logo churn and revenue churn separately
Not accounting for ramp time when modelling new sales rep productivity
Ignoring professional services and one-time revenue when calculating unit economics
Related templates
Import this template directly into Grove FP and start planning. No credit card required.
FAQ