Forecasting template
MRR and Churn Template for Subscriptions
Model a subscription business month by month. Customers carry over, new ones are added and churn is removed.
Guide: Track MRR and churn in a spreadsheet
Opening a template uses no credits.
What's inside
| 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 |
Preview with sample numbers. Formulas are shown in green.
The formulas, explained
E3 =E2*(1-$B$4)+$B$3
Last month's customers minus churn, plus new customers.
F2 =E2*$B$5
Monthly recurring revenue: customers times price.
Make it yours by asking
Try a request like this in Tabstra:
"Build a subscription model with starting customers, new customers, churn rate, ending customers, price and MRR"