How to use the SaaS Metrics Calculator (MRR, Churn, NRR)
- Enter MRR at the start of the month.
- Enter new, expansion, contraction and churned MRR for the month.
- Add starting and lost customers for logo churn.
How it works
Ending MRR = start + new + expansion − contraction − churned. ARR = ending MRR × 12. Gross revenue churn = (contraction + churned) ÷ start. Net revenue retention = (start + expansion − contraction − churned) ÷ start. Quick ratio = (new + expansion) ÷ (contraction + churned). Logo churn = customers lost ÷ customers at start.
Worked examples
Typical month
Start 10,000; +1,500 new; +500 expansion; −200 contraction; −300 churn → ending MRR 11,500 (15% growth), NRR 100%, gross churn 5%, quick ratio 4.0.
Limitations and assumptions
- These are monthly figures; annual NRR compounds differently.
- Definitions vary between companies — keep yours consistent over time.
Frequently asked questions
Why is NRR above 100% good?
It means expansion from existing customers more than offsets downgrades and cancellations, so revenue grows even with zero new customers.
Built and reviewed by Guru G
Calculation logic is covered by automated tests against known values. Last reviewed Nov 6, 2026. Found a problem? Let us know — see our editorial policy.