MRR Calculator
Created by: Emma Collins
Last updated:
Calculate monthly recurring revenue from multi-tier subscription plans, then model net MRR movement, ARR, net growth, and net revenue retention from expansion, contraction, and churn.
MRR Calculator
FinanceModel current MRR from up to five pricing tiers and track net MRR movements from new, expansion, contraction, and churn.
Pricing Tiers
| Tier name | Customers | ARPU ($) |
|---|---|---|
Monthly MRR Movements
What Is an MRR Calculator?
An MRR calculator helps subscription businesses quantify recurring revenue run-rate and understand what is driving change month to month.
Instead of only tracking top-line revenue, it isolates recurring components that matter for SaaS and subscription planning.
This version supports up to five pricing tiers and explicit movement categories for new, expansion, contraction, and churned MRR.
That structure gives a clean bridge from current MRR to projected next-month MRR.
Because MRR movement quality matters as much as movement size, the calculator also reports ARR and net revenue retention.
These metrics help operators distinguish growth from healthy expansion versus growth from acquisition that may not be durable.
How MRR Movement Modeling Works
Current MRR is calculated as the sum of customers multiplied by ARPU across pricing tiers.
ARR is then derived from MRR as a 12-month run-rate estimate.
This establishes the baseline recurring-revenue engine before period movement is applied.
Net new MRR is calculated from four movement components: new and expansion increase run-rate, while contraction and churn reduce it.
NRR then evaluates how the existing base performed after those retention dynamics, independent of new-logo additions.
Core MRR Formulas
Tier MRR = Tier customers × Tier ARPU
Current MRR = Sum of all tier MRR values
ARR = Current MRR × 12
Net new MRR = New + Expansion − Contraction − Churned
NRR = (Current MRR + Expansion − Contraction − Churned) / Current MRR
Example Scenarios
SaaS Board Update
A leadership team uses the movement waterfall to explain why MRR grew less than expected: strong new sales were partially offset by higher contraction in mid-market accounts.
Pricing Package Review
Product and revenue teams compare tier mix and expansion contribution before and after a packaging update to assess whether upgrades are improving net retention quality.
Quarter Planning Baseline
Finance uses MRR and NRR outputs as planning anchors for hiring, spend pacing, and cash runway assumptions in a subscription business model.
How People Use This Calculator
- Monthly recurring revenue tracking by plan tier.
- Net MRR movement attribution across growth and retention channels.
- ARR run-rate monitoring for strategic planning.
- NRR trend checks for retention-quality diagnostics.
- Cross-functional KPI alignment across product, sales, and customer success.
MRR Modeling Tips
Separate logo growth from expansion quality.
Strong new sales with weak expansion and high contraction can mask retention risk if only top-line MRR is monitored.
Audit ARPU assumptions regularly.
Small ARPU drift across larger tiers can materially alter MRR trend interpretation.
Pair MRR with customer-count context.
Revenue movement without customer and cohort context can hide concentration risk and pricing-mix effects.
Frequently Asked Questions
What is MRR?
MRR stands for monthly recurring revenue. It is the normalized monthly subscription revenue expected from active recurring customers, excluding one-time fees.
How is ARR related to MRR?
ARR is annual recurring revenue and is typically estimated as MRR multiplied by 12. It provides a yearly run-rate view for planning and investor reporting.
What is net new MRR?
Net new MRR equals new MRR plus expansion MRR minus contraction MRR minus churned MRR. It explains whether recurring revenue momentum is accelerating or decelerating.
What is net revenue retention (NRR)?
NRR measures how recurring revenue from an existing customer base evolves after expansion, contraction, and churn. Values above 100% generally indicate expansion more than offsets losses.
Should upgrades and downgrades be tracked separately?
Yes. Separating expansion and contraction MRR improves diagnostic clarity and helps identify whether pricing, packaging, or customer success is driving movement.
Can this replace full SaaS reporting?
No. It is a planning model for quick analysis. Full SaaS reporting should include cohort, logo retention, collection timing, and revenue-recognition controls.
Sources and References
- SaaS metric primers from OpenView and SaaStr on MRR and NRR definitions.
- SEC investor-reporting discussions on recurring-revenue disclosure framing.
- Public SaaS earnings materials for NRR benchmarking examples.
- Revenue operations playbooks for movement-based MRR attribution.