Forecast example
SaaS MRR Forecast Example
This example starts with $10,000 MRR, adds 8.5% monthly growth, subtracts 2.1% monthly churn, and carries ending MRR into the next month.
| Month | Starting MRR | New MRR | Churned MRR | Ending MRR | ARR run rate |
|---|---|---|---|---|---|
| 1 | $10,000 | $850 | $210 | $10,640 | $127,680 |
| 2 | $10,640 | $904 | $223 | $11,321 | $135,852 |
| 3 | $11,321 | $962 | $238 | $12,045 | $144,540 |
Formula used
Ending MRR = Starting MRR + New MRR - Churned MRR
The next month starts from the prior month ending MRR. That is why small changes in growth or churn can compound across a longer forecast period.
Build your own forecast
Use the calculator for a quick scenario or the template for a spreadsheet model with separate columns.