What’s the correct Net MRR Churn Rate formula (with expansion, contraction, and churn)?

Use: Net MRR churn rate = (Contraction MRR + Churned MRR − Expansion MRR) ÷ Starting MRR. It isolates existing-customer MRR movement only.

Can Net MRR churn be 0% even if some customers churned?

Yes. If expansion offsets contraction + churn (e.g., upgrades fully cover downgrades and cancellations), net churn can be 0% (or even negative).

What does a negative Net MRR churn rate mean?

It means “net negative churn”: expansions from existing customers are larger than the MRR you lost from downgrades + churn—your existing base is growing without counting new customers.

Should I include new customer MRR in this calculator?

No. Starting MRR and all movements here should reflect existing customers only; new customer MRR belongs in Net New MRR / New MRR tracking.

Net MRR Churn Rate Calculator (Net Revenue Churn %)

Net MRR Churn (Rate) Calculator

Calculate Net MRR Churn Rate for existing customers: (Churned MRR + Contraction MRR − Expansion MRR) ÷ Starting MRR. Net churn can be negative when expansion outweighs losses.

Inputs

Starting MRR (existing customers)

Expansion MRR

Contraction MRR

Churned MRR

Results

Net MRR churn rate %
Net change in existing-customer MRR $
Ending MRR (existing customers) $

What is Net MRR Churn Rate?

Net MRR churn rate is the net percentage of Starting MRR from existing customers lost over a period after accounting for Expansion MRR, Contraction MRR, and Churned MRR.

It matters because it directly reflects recurring cash flow durability, the quality of revenue growth, and the economics behind LTV, CAC Payback Period, and long-term value creation.

Formula

Example

Starting MRR (existing customers): $120,000

Expansion MRR: $12,000

Contraction MRR: $5,000

Churned MRR: $7,000

Net change in existing-customer MRR: $12,000 − $5,000 − $7,000 = $0

Ending MRR (existing customers): $120,000 + $0 = $120,000

Net MRR churn rate: (($7,000 + $5,000 − $12,000) ÷ $120,000) × 100 = 0.0%

How to Use the Net MRR Churn (Rate) Calculator

Enter your starting MRR from existing customers, then add expansion, contraction, and churned MRR for the same period to see net churn %, net change, and ending existing-customer MRR.

Set your Starting MRR (existing customers)
- Enter MRR at the start of the period for your existing customer base (exclude new customer MRR).
Enter Expansion MRR
- Add MRR gained from upgrades, add-ons, or seat increases from existing customers during the period.
Enter Contraction MRR and Churned MRR
- - Contraction MRR = downgrades (existing customers paying less).
- Churned MRR = cancellations (existing customers leaving).
- The calculator computes.
Review Net change in existing-customer MRR
- This shows the $ amount your existing base grew or shrank during the period (net of upgrades/downgrades/churn).
Read Ending MRR (existing customers)
- This is your existing-customer ending MRR after accounting for all movements.

Frequently Asked Questions

Use: Net MRR churn rate = (Contraction MRR + Churned MRR − Expansion MRR) ÷ Starting MRR. It isolates existing-customer MRR movement only.
Yes. If expansion offsets contraction + churn (e.g., upgrades fully cover downgrades and cancellations), net churn can be 0% (or even negative).
It means “net negative churn”: expansions from existing customers are larger than the MRR you lost from downgrades + churn—your existing base is growing without counting new customers.
No. Starting MRR and all movements here should reflect existing customers only; new customer MRR belongs in Net New MRR / New MRR tracking.

Methodology & Sources

Bibliography

Stripe (2024). Revenue churn 101: How to calculate it and why it matters — Stripe https://stripe.com/resources/more/revenue-churn-101-how-to-calculate-it-and-why-it-matters
Accessed 2025-12-15
Wall Street Prep (2024). Revenue Churn | Formula + Calculator — Wall Street Prep https://www.wallstreetprep.com/knowledge/revenue-churn-mrr/
Accessed 2025-12-15
Mark Agnew; Brian O’Connor; A.J. Wasserstein (2020). On the Nature of Revenue: Not All Revenue Is Created Equally (YALE CASE) — Yale School of Management https://som.yale.edu/sites/default/files/2025-04/On%20the%20Nature%20of%20Revenue.pdf
Accessed 2025-12-15

Net MRR Churn (Rate) Calculator

Inputs

Results

What It Means?

What is Net MRR Churn Rate?

Formula

Example

How to Use the Net MRR Churn (Rate) Calculator

Set your Starting MRR (existing customers)

Enter Expansion MRR

Enter Contraction MRR and Churned MRR

Review Net change in existing-customer MRR

Read Ending MRR (existing customers)

Frequently Asked Questions

Methodology & Sources

Bibliography

Other Calculators in SaaS Metrics

Average Order Value (AOV) Calculator

Gross Revenue Retention Calculator

SaaS Rule of 40 Calculator

Average Revenue Per User (ARPU) Calculator

SaaS Magic Number Calculator

Annual Recurring Revenue (ARR) Calculator