SaaS MRR ARR Churn and Net Revenue Retention Calculator

Quick answer

Calculate the scenario with the SaaS MRR ARR Churn and Net Revenue Retention Calculator. Continue with CAC Payback Period Calculator, CPM CPC CTR Marketing Funnel Calculator, Website Conversion Rate Lift Profit Calculator, Customer Acquisition Cost Calculator, LTV to CAC Ratio Calculator for related but non-equivalent decisions.

Quick answer. MRR measures recurring monthly revenue; ARR annualizes a defined recurring base; NRR tracks retention of revenue from an existing customer cohort. New customer revenue should not be added to NRR, and churn can refer to customers or recurring revenue. State the metric conventions before calculating. Starting MRR $10,000 and expansion $2,000 with churn $500 yields 115% NRR absent contraction. Check the applicable source records before treating this as anything beyond an illustrative calculation.

What does this calculator actually measure?

SaaS MRR ARR Churn and Net Revenue Retention Calculator models recurring revenue growth, churn, expansion and nrr. The main decision is: Can net revenue retention exceed 100 percent? The value of a worksheet like this is that it keeps cost components, time periods and assumptions separate. Two cases may have the same headline percentage but produce different cash flows once fees, timing, benefit limits or starting balances are accounted for.

This calculator is especially useful when you already have written details about opening MRR, new MRR, and expansion MRR. Enter actual documents where available; if you are considering a proposed change, label hypothetical numbers as hypothetical and compare them with your current arrangement.

Continue with MRR, ARR, Net Revenue Retention and Churn Definitions or CAC Payback Period Calculator for the next calculation.

How to use this saas mrr arr churn and net revenue retention calculator

1. Fix the channel, reporting period, currency and customer cohort.
2. Export spend and conversion data, then reconcile to business receipts or invoices.
3. Account for fees, returns, gross margin and actual fulfillment where relevant.
4. Compute both the headline marketing metric and its contribution-profit counterpart.
5. Run a sensitivity case for weaker conversion or higher acquisition cost.

Calculator inputs explained

• Opening mrr: The value labeled “opening MRR” in the underlying document or transaction. Enter its unit, timing and whether it is gross or net of another adjustment.
• New mrr: The value labeled “new MRR” in the underlying document or transaction. Enter its unit, timing and whether it is gross or net of another adjustment.
• Expansion mrr: The value labeled “expansion MRR” in the underlying document or transaction. Enter its unit, timing and whether it is gross or net of another adjustment.
• Contraction mrr: The exact market quantity or contractual unit, including any per-contract multiplier or base-to-quote currency conversion.
• Churned mrr: The value labeled “churned MRR” in the underlying document or transaction. Enter its unit, timing and whether it is gross or net of another adjustment.

Keep all money in one currency and all rates and periods consistent. If you convert an annual amount into a monthly figure, show that conversion. When a required term is unknown, do not silently assume the most favorable outcome.

Formula and calculation method

The model for this specific worksheet is: closing_MRR=opening+new+expansion-contraction-churn; NRR=(opening+expansion-contraction-churn)/opening.

Reconcile the advertising spend, eligible conversions and realized revenue or contribution. State whether refunds, gross margin, fees, fulfillment and agency costs are already included, and calculate each denominator only when nonzero. The tool should retain full internal precision and round displayed currency amounts at the end of each legally or contractually appropriate computation. Show a complete breakdown for users who want to reproduce the result.

Worked example

Starting MRR $10,000 and expansion $2,000 with churn $500 yields 115% NRR absent contraction. This illustrates the recurring revenue growth, churn, expansion and nrr model using selected inputs, not a binding outcome. The relevant contractual or reporting record controls any additional conditions, ordering or rounding rules.

For a useful comparison, keep all other inputs fixed and change the specific parameter associated with cohort definition required. That reveals whether the difference comes from the underlying base amount, timing, stated rate, cash charges or limits—not from several unexplained changes at once.

Understanding your results

• Closing mrr: The intermediate or final result labeled “closing MRR”, calculated using the entered scenario and the explicitly stated methodology.
• Arr: The intermediate or final result labeled “ARR”, calculated using the entered scenario and the explicitly stated methodology.
• Gross churn: The intermediate or final result labeled “gross churn”, calculated using the entered scenario and the explicitly stated methodology.
• Net retention: The remaining amount after the cost categories explicitly listed in the worksheet have been deducted.

Review these figures together. Compare top-of-funnel efficiency with downstream profitability. A cheaper CPC or stronger reported ROAS can still produce a worse business outcome if conversion quality, fulfillment costs or cash timing differ. A calculation is more reliable when you can point to the exact input and rule that explains every result.

What can materially change the answer?

The most important constraint for this tool: Use consistent cohort and billing definition; NRR from starting cohort. Changes to these terms can alter the result even when the numerical inputs otherwise look similar. If the relevant record does not disclose a necessary restriction, treat the output as a partial scenario rather than a complete financial or coverage assessment.

Common errors to avoid:

• Comparing revenue ROAS with profit or page RPM as if they measure the same thing.
• Mixing customer cohorts or date ranges between spending and earned revenue.
• Double-counting costs already reflected in contribution margin or platform fees.

How reliable is this estimate?

These metrics are descriptive or scenario-based. They do not prove causal lift, future auction prices, genuine incremental conversions or realized revenue until reconciled against records. The calculation does not retrieve live information automatically. The owner should use their own verified documents and check changing rules or annual limits before using the result in a consequential decision. CalculatorGeek's methodology should remain visible alongside the tool results.

Inputs, outputs and result meaning

Bridge opening MRR through new, expansion, contraction and churned MRR while calculating closing MRR, annualized recurring revenue and starting-cohort NRR.

Inputs

Market and display currency

Enter this value from the same reporting window and keep its stated unit or option with the result.

Revenue cohort record

Enter this value from the same reporting window and keep its stated unit or option with the result.

Opening MRR

Enter this value from the same reporting window and keep its stated unit or option with the result.

New-customer MRR

Enter this value from the same reporting window and keep its stated unit or option with the result.

Expansion MRR from starting cohort

Enter this value from the same reporting window and keep its stated unit or option with the result.

Contraction MRR from starting cohort

Enter this value from the same reporting window and keep its stated unit or option with the result.

Churned MRR from starting cohort

Enter this value from the same reporting window and keep its stated unit or option with the result.

Outputs

Closing MRR

This is the primary result.

Annualized recurring revenue

This supporting result explains or cross-checks the primary answer.

Net revenue retention

This supporting result explains or cross-checks the primary answer.

Gross revenue churn

This supporting result explains or cross-checks the primary answer.

Net new MRR

This supporting result explains or cross-checks the primary answer.

Retained starting-cohort MRR

This supporting result explains or cross-checks the primary answer.

The calculator validates and normalizes the entered values before applying the documented model. Keep every result with its reporting window, denominator, attribution basis and stated limitations.

Frequently asked questions

Related CalculatorGeek reading

• MRR, ARR, Net Revenue Retention and Churn Definitions

Sources and methodology

The calculation is original scenario arithmetic. These sources define platform metrics, operating concepts or disclosure boundaries; they do not validate the user's data or prove incremental performance.

• Stripe - MRR and ARR definitions
• Stripe - Net revenue retention

Related CalculatorGeek pages

• MRR, ARR, Net Revenue Retention and Churn Definitions
• CAC Payback Period Calculator
• CPM CPC CTR Marketing Funnel Calculator
• Website Conversion Rate Lift Profit Calculator
• Customer Acquisition Cost Calculator
• LTV to CAC Ratio Calculator
• Open the SaaS MRR ARR Churn and Net Revenue Retention Calculator