MRR & ARR Calculator

Free MRR and ARR calculator. Break down monthly recurring revenue into new, expansion, contraction, and churned components. Track SaaS revenue health with net MRR movement.

About the MRR & ARR Calculator

Monthly Recurring Revenue (MRR) is the lifeblood metric for subscription businesses. MRR = sum of all active subscriptions, normalized to a monthly figure. ARR = MRR × 12. But the total number only tells half the story — what matters is how MRR moves.

MRR breaks down into five components: New MRR (new customers), Expansion MRR (upsells, cross-sells), Reactivation MRR (returning customers), Contraction MRR (downgrades), and Churned MRR (cancellations). Net New MRR = New + Expansion + Reactivation − Contraction − Churned.

This calculator computes all MRR components, ARR, net revenue retention (NRR), and projects MRR growth over time. MRR is calculated by summing the recurring revenue from all active subscriptions in a given month, while ARR simply multiplies MRR by 12 to provide an annualized view. Understanding the components of MRR change including new subscriptions, expansions, contractions, and cancellations reveals whether growth is healthy, sustainable, and accelerating over time.

Why Use This MRR & ARR Calculator?

Investors, boards, and operators all judge SaaS businesses by MRR trends and composition. A business growing MRR 10% monthly with high churn is fragile. One growing 5% with low churn and strong expansion is far healthier. This calculator makes MRR composition visible and forward-looking. Tracking MRR components monthly reveals whether growth is driven by healthy expansion or unsustainable new-customer acquisition.

How to Use This Calculator

  1. Enter beginning MRR for the period.
  2. Enter new MRR from new customers.
  3. Enter expansion MRR from upsells/upgrades.
  4. Enter reactivation MRR (optional, for returning customers).
  5. Enter contraction MRR from downgrades.
  6. Enter churned MRR from cancellations.
  7. View net new MRR, ending MRR, ARR, and key ratios.

Formula

Net New MRR = New + Expansion + Reactivation − Contraction − Churned Ending MRR = Beginning MRR + Net New MRR ARR = MRR × 12 Gross Churn Rate = Churned MRR / Beginning MRR Net Revenue Retention = (Beginning − Contraction − Churned + Expansion) / Beginning × 100%

Example Calculation

Result: Net New MRR: +$15,000 | Ending MRR: $115,000 | NRR: 99%

Net New = $15K + $5K + $1K − $2K − $4K = $15K. Ending MRR = $100K + $15K = $115K. Gross churn = $4K/$100K = 4%. NRR = ($100K − $2K − $4K + $5K)/$100K = 99%. Growth rate = 15%. ARR = $1.38M.

Tips & Best Practices

MRR Components Explained

New MRR is revenue from first-time customers. Expansion MRR comes from existing customers upgrading, adding seats, or purchasing add-ons. Reactivation MRR is from previously churned customers returning. Contraction MRR is lost when customers downgrade. Churned MRR is permanently lost when customers cancel. Understanding each component drives targeted action: if churned MRR is high, invest in retention; if expansion is low, invest in upselling.

The ARR Journey

SaaS startups track milestones: $1M ARR (product-market fit signal), $10M ARR (scaling), $100M ARR (public-ready). Time from $1M to $10M ARR is the key test — top companies do it in 3-5 years. Monthly MRR tracking with component granularity is essential for forecasting the path to each milestone.

MRR Accounting Nuances

Discounted plans should count at the discounted rate, not full price. Free trials count $0 MRR until converted. Multi-year deals: use the annual rate divided by 12. If pricing includes a one-time setup fee, exclude it from MRR. Always be consistent and document your MRR policy.

Frequently Asked Questions

MRR vs revenue: what's the difference?

MRR counts only recurring subscription revenue, normalized to monthly. It excludes one-time fees, professional services, and variable usage charges. Accounting revenue (GAAP/IFRS) follows different recognition rules. MRR is an operating metric, not an accounting metric.

How do I count annual contracts?

Divide the annual contract value by 12. A $24K/year contract = $2K MRR. Count it from the contract start date. Some companies book the full amount as "committed ARR" but spread it as MRR over the term.

What is the SaaS Quick Ratio?

Quick Ratio = (New MRR + Expansion MRR) / (Contraction MRR + Churned MRR). It measures growth efficiency. A ratio > 4 means you're adding $4 for every $1 lost. Top SaaS companies maintain 4:1 or higher. Below 1:1 means the business is shrinking.

What is net revenue retention (NRR)?

NRR measures revenue from existing customers after churn, contraction, and expansion. NRR = (Beginning MRR − Churn − Contraction + Expansion) / Beginning MRR × 100%. NRR > 100% = net expansion. Best-in-class SaaS: 120-140%.

How do I project future MRR?

Apply your current growth rate forward: Future MRR = Current MRR × (1 + monthly growth rate)^months. But this oversimplifies — growth rates typically slow as the base grows. Model conservatively by reducing the growth rate 0.5-1% per quarter.

Should I track committed MRR vs live MRR?

Track both. Committed MRR includes signed contracts not yet activated. Live MRR counts only active, billing subscriptions. The gap between them reveals onboarding/activation delays. Investors focus on live MRR, but committed MRR shows pipeline health.

Related Pages