MRR & Churn Calculator

For SaaS and subscription businesses: where does MRR plateau at current churn?

Last updated 19 October 2026

Advertisement

How it works

Each month MRR loses a churn percentage and gains new and expansion revenue. Because churn is proportional and new business is fixed, MRR converges on a ceiling = (new + expansion) ÷ churn. Net revenue retention above 100% (expansion exceeds churn) means the installed base grows by itself.

Formula

MRR_{m+1} = MRR_m × (1 − churn) + new + expansion
Ceiling = (new + expansion) ÷ churn
NRR (annual) = (1 − churn + expansion ÷ MRR)¹²

Worked example

100k MRR, 8k new, 2k expansion, 2.5% churn: 12 months → 179k MRR (2.15m ARR); ceiling 400k; NRR 94%.

Frequently asked questions

What churn is acceptable?

SMB SaaS 3–5% monthly is common but painful; mid-market 1–2%; enterprise under 1% monthly (10% annual). Consumer apps are far higher.

Gross vs net churn?

Gross churn counts only lost revenue; net churn offsets it with expansion. Report both — negative net churn is the SaaS holy grail.

How do I raise the ceiling?

Halving churn doubles the ceiling. Onboarding, customer success and annual contracts move churn more than any pricing change.

Embed this calculator on your site

Paste this into your page. The calculator stays up to date automatically.

This calculator is provided for general information only and does not constitute financial, tax, legal or employment advice. Rules change and individual contracts, free-zone regulations and court rulings can differ. Always verify with your employer, the relevant ministry or a licensed professional.