MRR and ARR Calculator: Net New Revenue & Quick Ratio

How to calculate MRR, ARR, and the SaaS Quick Ratio

Monthly Recurring Revenue (MRR) and Annual Recurring Revenue (ARR) measure the normalized predictable subscription income of a software or recurring-services business. Tracking the components of MRR movements—new accounts, expansions, downgrades, and cancellations—reveals whether top-line expansion is driving durable growth or merely masking high customer churn.

All calculations process locally in your browser. Your private subscription numbers, expansion metrics, and revenue figures are never sent to external servers.

Core mathematical formulas

$$\text{Net New MRR} = \text{New MRR} + \text{Expansion MRR} - \text{Contraction MRR} - \text{Churned MRR}$$

$$\text{Ending MRR} = \text{Starting MRR} + \text{Net New MRR}$$

$$\text{ARR (Annual Recurring Revenue)} = \text{Ending MRR} \times 12$$

$$\text{Monthly Growth Rate} = \frac{\text{Net New MRR}}{\text{Starting MRR}} \times 100$$

$$\text{SaaS Quick Ratio} = \frac{\text{New MRR} + \text{Expansion MRR}}{\text{Contraction MRR} + \text{Churned MRR}}$$

Component definitions:

• Starting MRR: The active recognized recurring revenue at the beginning of the monthly period.
• New MRR: Revenue generated from brand-new customer accounts acquired during the month.
• Expansion MRR: Additional revenue from existing customers upgrading plan tiers, adding user seats, or purchasing add-ons.
• Contraction MRR: Revenue lost when existing customers downgrade to lower tiers or reduce user seats without cancelling completely.
• Churned MRR: Total recurring revenue lost from complete customer account cancellations.

Worked example: SaaS growth walkthrough

Consider a growing software company auditing its monthly revenue performance:

• Starting MRR: $12,000
• New Customer MRR: $1,500 (30 new customers at $50/mo)
• Expansion MRR: $500 (existing customers adding seats)
• Contraction MRR: $200 (customers downgrading plans)
• Churned MRR: $600 (lost customer cancellations)

Step-by-step arithmetic:

1. Gross Revenue Added: $$1,500 + $500 = \mathbf{$2,000.00}$
2. Gross Revenue Lost: $$200 + $600 = \mathbf{$800.00}$
3. Net New MRR: $$2,000.00 - $800.00 = \mathbf{+$1,200.00}$
4. Ending MRR: $$12,000.00 + $1,200.00 = \mathbf{$13,200.00}$
5. Annualized Run-Rate (ARR): $$13,200.00 \times 12 = \mathbf{$158,400.00}$
6. Monthly Growth Rate: $\frac{$1,200.00}{$12,000.00} \times 100 = \mathbf{10.0%}$
7. SaaS Quick Ratio: $\frac{$2,000.00}{$800.00} = \mathbf{2.50}$

The business generated $2.50 in new expansion and acquisition revenue for every $1.00 lost to contraction and churn, signaling sustainable expansion.

SaaS Quick Ratio benchmarks

The Quick Ratio measures how efficiently a recurring business outgrows its churn:

What must be excluded from MRR and ARR calculations

A frequent accounting mistake in early-stage startups is conflating cash collections with recurring revenue. Always exclude:

1. One-Time Implementation Fees: Setup, onboarding, custom data migration, and training charges.
2. Consulting & Professional Services: Hourly or fixed-bid custom development work.
3. Refunds & Taxes: Deduct customer credits, chargebacks, and state/VAT sales taxes.
4. Non-Recurring Pilot Contracts: Short pilot programs without an active renewal contract.

Frequently asked questions

Can annual upfront contracts be booked directly as MRR?

No. An annual $12,000 upfront contract must be divided by 12, recognizing $1,000 as MRR each month as the service is delivered, while the remaining cash sits on the balance sheet as deferred revenue.

What is the difference between ARR and annual revenue?

Annual Revenue (GAAP/IFRS) represents total recognized revenue over a calendar year, including one-time professional services. ARR is an annualized snapshot (Current MRR × 12) of purely recurring subscription contracts.

Why is Expansion MRR so valuable?

Acquiring new customers costs 5 to 7 times more than expanding existing accounts. When Expansion MRR exceeds Churned MRR, your business achieves negative net churn, growing automatically even during slower marketing months.