Back to Templates
FINANCIAL MODEL
SaaS Financial Model
A complete spreadsheet for modeling MRR, Churn, Expansion Revenue, and Tier distribution over 24 months.
LIVE PREVIEW
| Month | New Customers | Churn % | Expansion % | MRR Start | New MRR | Churned MRR | Net New MRR | MRR End |
|---|---|---|---|---|---|---|---|---|
| Jan | 10 | 5% | 2% | $10,000 | $1,000 | $500 | $700 | $10,700 |
| Feb | 12 | 4.8% | 2.5% | $10,700 | $1,200 | $513 | $900 | $11,600 |
| -- | -- | -- | -- | -- | -- | -- | -- | -- |
| -- | -- | -- | -- | -- | -- | -- | -- | -- |
Instructions
- 1Input your tiered pricing assumptions.
- 2Adjust growth rates month-over-month.
- 3Calculate the 'Quick Ratio' (New Growth / Churn Loss) to measure health.
Pro Tip
You can import the downloaded CSV directly into Google Sheets, Excel, or Airtable. The formatting is universal.
About this Template
Plan your path to $1M ARR with this robust SaaS modeling tool.
Key Features
Cohort Analysis: Track retention.
Tier Split: Basic vs Pro.
Common Use Cases
Fundraising: VC pitch decks.
Budgeting: Hiring plans.
Frequently Asked Questions
What is a good growth rate?
T2D3 (Triple, Triple, Double, Double, Double) is the VC standard.