Churned MRR (Cancellation MRR) Calculator

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 cu...

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).

Single periodProject over N months

Single period = one-period gross churn. Projection = compounded projection over N months using a monthly churn rate.

$

Baseline MRR from customers active at the start. Exclude New MRR (new sales) and exclude Expansion/Contraction movements.

Your churn inputs are interpreted for this exact period. Example: 3% Quarterly means 3% of Starting MRR is lost to cancellations over the quarter (not compounded).

Pick the input style you have. The calculator will compute the others from your Starting MRR.

%

Percent of Starting MRR lost to cancellations over the selected period (enter as a positive number).

$

Recurring revenue lost from existing customers who canceled during the selected period. Enter as a positive number.

$

Ending MRR for the existing customer base after churn for the selected period (no expansion, no new sales).

%

Retention is the share of Starting MRR kept after churn for the selected period. Churn % = 100 − retention %.

%

Monthly churn rate used for the projection (compounded).

Projection horizon in months. Ending MRR = Starting × (1 − monthly churn)^N.

Optional: convert churn rates between periods using effective compounding.

%

If you have monthly churn m, quarterly churn = 1 − (1 − m)^3 and annual churn = 1 − (1 − m)^12.

Scenarios
Examples (rates are for the selected period; projection uses monthly churn).
Single period (Monthly, 3%)Single period (Quarterly, 5%)Projection (12 months @ 2% monthly)

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)— %

Enter your inputs above to calculate the results.

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

Churned MRR = Starting MRRtimes Churn Rate
Ending MRR = Starting MRR-Churned MRR = Starting MRRtimes(1-Churn Rate)
Retention(%) = (1-Churn Rate) × 100
Projected Ending MRR = Starting MRRtimes(1-Monthly Churn)N
Projected MRR Lost = Starting MRR-Projected Ending MRR
Cumulative Churn(%) = (1-(1-Monthly Churn)N) × 100

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%

Frequently Asked Questions

Is churned MRR the same as “gross revenue churn” or “net revenue churn”?

Churned MRR is the $ amount of recurring revenue you lost from your existing base in a period. Gross revenue churn rate is that loss as a % of starting MRR. Net revenue churn adjusts for expansion (upsells) and can be lower—or even negative.

What should count as “Cancellation MRR” in this calculator?

MRR lost from customers who fully cancel recurring subscriptions. Don’t mix in downgrades/contraction unless you’re intentionally measuring gross revenue churn (cancellations + contraction). Keep “new MRR” and expansions out of it—this is existing-customer loss.

I only know customer churn (logo churn). Can I use it to get churned MRR?

Only roughly. Customer churn and revenue churn diverge when ARPA differs across customers. If you must estimate, use a revenue churn assumption: Churned MRR ≈ Starting MRR × revenue churn rate (for the same period).

For a 12-month view, do I just multiply monthly churned MRR by 12?

No—churn compounds. Use a compounded projection: Ending MRR = Starting MRR × (1 − monthly churn)^N. Then Cumulative MRR lost = Starting MRR − Ending MRR.

Sources & Methodology