Gross MRR churn (existing customers only) Calculator

Calculate MRR lost from churn (cancellations) for your existing customer base only. Excludes New MRR, Expansion MRR, and Contraction MRR (so this is not net churn / NRR).

Inputs

Compute gross churn for a specific period (Monthly/Quarterly/Annual). Any rate you enter is interpreted for that exact period.
$
%
$
$
%
%

Helpers

%

Results

  • MRR lost to churn (existing customers, for the selected period) $
  • Ending MRR (existing customers) $
  • Churn rate (computed, for the selected period) %
  • Retention (computed, for the selected period) %
  • Projected MRR lost to churn (cumulative, existing customers) $
  • Projected ending MRR (existing customers) $
  • Projected cumulative churn over horizon %
  • Quarterly churn (from monthly, effective) %
  • Annual churn (from monthly, effective) %

What is Churned MRR (Cancellation MRR)?

Churned MRR (Cancellation MRR) is the portion of existing-customer monthly recurring revenue that disappears in a given period because customers cancel (and stop paying).

It’s a direct measure of revenue leakage that weakens ARR run-rate, reduces gross revenue retention (GRR), and lowers the predictability of future cash flows.

In value-creation terms, higher churned MRR compresses LTV, worsens CAC payback, and increases execution risk in planning, budgeting, and valuation work.

Formula






Example

Single period (Monthly):

  • Starting MRR (existing customers): $100,000
  • Churn rate (monthly): 3%
  • Churned MRR: $100,000 × 0.03 = $3,000
  • Ending MRR: $100,000 − $3,000 = $97,000
  • Retention: (1 − 0.03) × 100 = 97%

Project over N months (Compounded):

  • Starting MRR (existing customers): $100,000
  • Monthly churn rate: 2%
  • Horizon: 12 months
  • Projected ending MRR: $100,000 × (0.98)^12 = $78,472
  • Projected MRR lost (cumulative): $100,000 − $78,472 = $21,528
  • Cumulative churn: [1 − (0.98)^12] × 100 = 21.53%

How to Use the Churned MRR (Cancellation MRR) Calculator

Pick whether you want a single-period snapshot or a multi-month projection, then enter your existing-customer starting MRR and churn assumption to see MRR lost and ending MRR.

  1. Choose your mode

    • Use Single period for a one-month/quarter/year snapshot, or Project over N months to forecast churn impact over time.
  2. Enter Starting MRR (existing customers)

    • Input the MRR you’re trying to protect—existing-customer MRR at the start of the period (exclude new MRR you haven’t earned yet).
  3. Set the timeframe and churn input

      • In Single period, select the Period (e.g., Monthly) and enter the Churn rate (%) for that same period.

    Churned MRR = Starting MRR × Churn rate

    Ending MRR = Starting MRR × (1 − Churn rate)

    Retention (%) = 100% − Churn rate (%)

  4. Project over N months (if using projection mode)

      • Enter the Monthly churn rate and the number of months (N) to project. The calculator compounds churn across months.

    Projected ending MRR = Starting MRR × (1 − monthly churn)^N

    Projected MRR lost (cumulative) = Starting MRR − Projected ending MRR

    Projected cumulative churn (%) = 1 − (1 − monthly churn)^N

  5. Read results and share

    • Review MRR lost to churn, ending MRR, and (in projection mode) cumulative churn over the horizon. Use Share / Embed if you want to paste the result into a doc or dashboard.

Frequently Asked Questions

Methodology & Sources

Bibliography

  1. (2018). Going to Pieces: Valuing Users, Subscribers and Customers — Stern School of Business, New York University (NYU Stern)
    Accessed 2025-12-19
  2. (2003). Valuing Customers — Columbia Business School, Columbia University (Journal of Marketing Research working paper version)
    Accessed 2025-12-19
  3. (2025). What is MRR, or monthly recurring revenue? How to calculate, increase and use MRR to guide growth — Stripe
    Accessed 2025-12-19