SaaS MRR and churn spreadsheet
Track MRR and churn in a spreadsheet
Model monthly recurring revenue with new customers, churn and ARPU. Every month is a formula built from clear assumptions.
Opening the template uses no credits. Building from a prompt uses credits; the Free plan includes 25.
Subscription revenue compounds: small changes in churn have large effects a year later. A transparent MRR model makes that visible.
What the spreadsheet looks like
| Row | A | B | C | D | E | F |
|---|---|---|---|---|---|---|
| 1 | Input | Value | Month | Customers | MRR | |
| 2 | Starting customers | 200 | 1 | =B2 | =E2*$B$5 | |
| 3 | New per month | 40 | 2 | =E2*(1-$B$4)+$B$3 | =E3*$B$5 | |
| 4 | Monthly churn | 0.04 | 3 | =E3*(1-$B$4)+$B$3 | =E4*$B$5 | |
| 5 | Price per month | 49 | 4 | =E4*(1-$B$4)+$B$3 | =E5*$B$5 |
This is the real first sheet of the Customer Churn and MRR template. Every total is a formula.
Who it's for
- SaaS founders
- Subscription and membership businesses
- Investors checking a model
What you get
- Customers start, new, churned and end per month
- MRR from customers × ARPU
- Churn as a single assumption
- Excel download
How it works
- 1
Set the drivers
Starting customers, new per month, churn % and price.
- 2
Watch compounding
See how churn changes the year-end MRR.
- 3
Extend
Ask for expansion revenue, plans or cohorts.
Prompts to try
Tips from practice
- Model churn as a percentage of starting customers each month.
- Track logo churn and revenue churn separately when you can.
- Compare against actuals monthly.
Good to know: It's a model, not a billing integration.
Formulas used here: Percentage change, ROUND, IFERROR