Free Template

Free SaaS Financial Model Template

A 12-month projection model built for SaaS businesses. Track MRR growth, customer acquisition, churn, expansion revenue, and unit economics in one spreadsheet.

12-month SaaS metrics and projections

  • MRR waterfall: new, expansion, contraction, churned
  • Customer count tracking with adds and churns
  • ARR calculation from monthly MRR
  • Churn rate (gross and net revenue retention)
  • Customer acquisition cost (CAC) per month
  • Lifetime value (LTV) based on churn and ARPU
  • LTV:CAC ratio for unit economics health
  • 12-month forward projection with assumptions tab

Who it's for

SaaS founders, operators, and finance teams who need to model growth scenarios, prepare for fundraising, or get a handle on unit economics. Works for early-stage through growth-stage SaaS companies.

MetricMonth 1Month 2Month 3
Beginning MRR$45,000$52,200$59,870
New MRR$8,500$9,200$10,100
Expansion MRR$1,200$1,470$1,700
Churned MRR-$2,500-$3,000-$2,800
Net New MRR$7,200$7,670$9,000
Ending MRR$52,200$59,870$68,870
ARR$626,400$718,440$826,440
New Customers171921
Churned Customers565
Total Customers112125141
Churn Rate4.5%4.8%3.6%
CAC$850$780$720
LTV$11,100$10,400$13,900
LTV:CAC Ratio13.1x13.3x19.3x
Showing 3 of 12 months · Full template includes assumptions tab and charts

Get this template free when you join the CentSight waitlist

Join the waitlist and we'll send you this SaaS financial model template, plus early access to CentSight when we launch.