MRR Calculator

Calculate Monthly Recurring Revenue, ARR, LTV and forward projections.

Ad placeholder (leaderboard)
Enjoying the tools? Go Pro for £4.99 (one-time) and remove all ads — forever, on this device. Remove ads — £4.99

MRR (Monthly Recurring Revenue) is the single most important metric for any subscription or SaaS business. It tells you, in one number, the normalised monthly value of all active paying customers — stripping out one-off fees, project revenue and anything non-recurring. Track it correctly and you have a real-time pulse on business health. Miss one of the five components and your growth story becomes noise.

This calculator lets you decompose MRR into its five standard movements, compute derived metrics including ARR, ARPU, LTV and churn, and project forward to see where you will be in 3, 6, 12, 24 or 60 months if current trends hold.

The five MRR movements

Every change to MRR in a given month falls into exactly one bucket:

  • New MRR — revenue from customers who were not paying at the start of the period.
  • Expansion MRR — extra revenue from existing customers (upsells, add-ons, seat increases).
  • Reactivation MRR — revenue from previously churned customers who came back.
  • Contraction MRR — revenue lost to plan downgrades or partial cancellations (customer stays, pays less).
  • Churned MRR — revenue lost to full cancellations.

Ending MRR = Starting MRR + New + Expansion + Reactivation - Contraction - Churned

Net New MRR is the single-line summary: the sum of all gains minus all losses.

ARR, ARPU and LTV

  • ARR = Ending MRR × 12. A snapshot annualisation, useful for investor and board reporting.
  • ARPU (Average Revenue Per User) = Starting MRR / Total customers. A rising ARPU alongside rising MRR signals healthy pricing power; falling ARPU suggests you are acquiring smaller accounts.
  • LTV (Customer Lifetime Value) = ARPU × gross-margin fraction / monthly churn rate. For a business with $100 ARPU, 70% gross margin and 2% monthly churn: LTV = (100 × 0.70) / 0.02 = $3,500. The LTV:CAC ratio (target 3× or higher) tells you whether acquiring customers is profitable at scale.

Worked example

A SaaS company starts June with $50,000 MRR and 500 customers.

MovementAmount
New MRR+$8,000
Expansion MRR+$2,000
Reactivation MRR+$500
Contraction MRR-$1,000
Churned MRR-$2,500
Net New MRR+$7,000
Ending MRR$57,000

MoM growth = $7,000 / $50,000 = 14% — well above the ~15% annual growth needed to double in five years.

With 25 churned customers: monthly churn = 25 / 500 = 5%, annual churn = 46%. At $100 ARPU and 70% gross margin, LTV = $1,400. That’s the signal to fix retention before pouring more budget into acquisition.

Formula reference

  • Ending MRR = Starting MRR + New + Expansion + Reactivation - Contraction - Churned
  • ARR = Ending MRR × 12
  • ARPU = MRR / Customers
  • Gross MRR churn = Churned MRR / Starting MRR
  • Net MRR churn = (Churned + Contraction - Expansion - Reactivation) / Starting MRR
  • Monthly customer churn = Churned customers / Starting customers
  • Annual churn = 1 - (1 - monthly churn)^12
  • Avg lifetime = 1 / monthly churn (months)
  • LTV = ARPU × (gross margin %) / monthly churn

Every figure is calculated in your browser — nothing is uploaded.

Ad placeholder (rectangle)