Overview
Monthly recurring revenue is the heartbeat of a subscription business. This calculator rolls it forward and shows ARR, growth and net revenue retention.
Enter the starting MRR, new and expansion revenue and churned revenue.
Worked examples
| Inputs | Result |
|---|---|
| Starting MRR ($)50,000New MRR ($)6,000Expansion MRR ($)1,500Churned MRR ($)2,500 | Ending MRR: $55,000ARR: $660,000Net new MRR: $5,000 (10% growth)Net revenue retention: 98% |
Show 2 more examples
| Starting MRR ($)10,000New MRR ($)2,000Expansion MRR ($)500Churned MRR ($)300 | Ending MRR: $12,200ARR: $146,400Net new MRR: $2,200 (22% growth)Net revenue retention: 102% |
| Starting MRR ($)250,000New MRR ($)15,000Expansion MRR ($)12,000Churned MRR ($)9,000 | Ending MRR: $268,000ARR: $3,216,000Net new MRR: $18,000 (7.2% growth)Net revenue retention: 101.2% |
Ending MRR by starting MRR
With the calculator's starting values, the ending MRR is $55,000. The table shows how it changes with the starting MRR.
| Starting MRR ($) | Ending MRR |
|---|---|
| $30,000 | $35,000 |
| $40,000 | $45,000 |
| $50,000starting value | $55,000 |
| $60,000 | $65,000 |
| $70,000 | $75,000 |
Other inputs: New MRR: $6,000 · Expansion MRR: $1,500 · Churned MRR: $2,500. Change them in the calculator above for your own numbers.
How it works
Ending MRR = starting + new + expansion − churned. ARR = MRR × 12. Net revenue retention excludes new customers.
The formula
| Expansion | Upgrades from existing customers |
Practical tips
- $50,000 + $6,000 new + $1,500 expansion − $2,500 churn ends at $55,000 MRR, $660,000 ARR and 98% NRR.
- NRR above 100% means you grow even without new customers.
- Exclude one-off fees from MRR.
Frequently asked questions
What is the difference between ARR and revenue?
ARR annualizes current recurring revenue; it is not the same as recognized revenue.
What is a good NRR?
Strong B2B SaaS companies often exceed 110%.