CCalclabhub

Growth

How To Calculate MRR

Monthly recurring revenue is the number a subscription business is actually valued on. It is not total revenue: it strips out one-off sales and spreads annual contracts evenly across twelve months.

Quick Answer

MRR = monthly plans + annual plans / 12 + expansion - churn

monthly plans
Subscribers billed every month, times the monthly price
annual plans
Subscribers billed yearly, times the annual price divided by twelve
expansion
Extra recurring revenue from upgrades and seat additions
churn
Recurring revenue lost to cancellations and downgrades

Take every recurring contract, convert it to a monthly figure by dividing annual amounts by twelve, then add expansion revenue and subtract churned revenue. Two hundred and fifty subscribers at forty nine a month plus forty annual plans at four hundred and ninety gives about fourteen thousand two hundred and eighty three in MRR, which annualises to roughly one hundred and seventy one thousand.

What Is MRR?

Monthly recurring revenue, almost always shortened to MRR, is the portion of a company's income that repeats every month by contract. It is the central metric of any subscription business, because it is predictable in a way that one-off sales never are, and predictability is what makes a business valuable.

The defining rule is that MRR counts contracts, not cash. If a customer pays twelve hundred pounds up front for a year, that money arrives in one lump, but the MRR it contributes is one hundred pounds, because that is the rate at which the service is being consumed. Spreading the payment across the twelve months it covers is what makes the number comparable between customers on different billing cycles.

This is why an annual prepayment can be dangerous to read naively. A month with several annual renewals will show a spike in cash and no change at all in MRR, while the following month may show almost no cash and a perfectly healthy MRR. Cash flow and MRR answer different questions, and confusing them is one of the most common early-stage reporting errors.

Calculating MRR starts by grouping recurring contracts into their billing period. Monthly subscriptions contribute their monthly price directly. Annual subscriptions contribute their annual price divided by twelve. Quarterly subscriptions contribute their quarterly price divided by three. Once every contract is expressed as a monthly rate, the figures simply add up.

On top of that base there are movements in both directions. Expansion revenue arrives when an existing customer buys more: extra seats, a higher tier, an add-on module. It increases MRR without adding a new customer, which is why it is tracked separately from new business. Contraction is the mirror image, where a customer downgrades and pays less.

Churn is the revenue lost when customers cancel outright. Net new MRR is expansion minus contraction minus churn, and it is the single most diagnostic figure in a subscription business. A company can add a hundred new customers a month and still shrink if churn is larger than the combination of new and expansion revenue.

The related figure, annual recurring revenue or ARR, is simply MRR multiplied by twelve. The two are the same measurement on different timescales, and analysts use ARR when comparing against annual budgets and MRR when looking at month-to-month momentum. Reporting both is standard practice.

Revenue per account, sometimes called ARPA, is MRR divided by the number of paying accounts. It tells you whether growth is coming from many small customers or a few large ones, and it moves the moment you change your pricing or your target market. A rising MRR with a falling ARPA means you are adding volume but selling less per customer.

There are several things that must not be counted as MRR. One-off setup fees, professional services, hardware, usage overages that are not expected to repeat and any revenue that has no contractual commitment behind it all belong outside the figure. Mixing them in inflates MRR and makes it useless as a predictor.

It is also worth being strict about the difference between committed and variable revenue. A customer on a usage-based plan who spends wildly different amounts each month is not really recurring revenue in the contractual sense. Many companies split out a separate usage revenue line rather than pretending it is MRR.

Finally, MRR should be measured at a consistent point in the month. Because cancellations, upgrades and new signups land on different days, a figure taken on the first and a figure taken on the last day of the same month will differ. Pick a convention, usually the end of the month, and apply it every time so the trend line means something.

Formula

MRR = monthly + annual/12 + expansion - churn

Every recurring contract is converted to a monthly rate before anything is added or subtracted, so the units match.

SymbolMeaning
MRRMonthly recurring revenue
MMonthly plans
AAnnual plans
EExpansion
CChurn

ARR = MRR x 12

A projection, not a forecast: it assumes the current month repeats unchanged for a year.

SymbolMeaning
ARRAnnual recurring revenue
MRRMonthly recurring revenue

ARPA = MRR / accounts

Dividing by the paying account count shows how much each customer is worth per month.

SymbolMeaning
ARPARevenue per account
MRRMonthly recurring revenue
NPaying accounts

How To Calculate MRR

  1. 1

    Separate recurring from one-off revenue

    Setup fees, services and hardware are excluded. Only contracts that repeat on a schedule belong in the calculation, and mixing the rest in destroys the number's predictive value.

  2. 2

    Normalise annual plans to a month

    Divide the annual contract value by twelve. A four hundred and ninety pound annual plan contributes about forty one pounds a month, not four hundred and ninety in the month it is signed.

  3. 3

    Add the monthly plans

    Subscribers billed every month contribute their price directly. Two hundred and fifty at forty nine pounds is twelve thousand two hundred and fifty.

  4. 4

    Add expansion and subtract churn

    Upgrades add to the total and cancellations subtract from it. In the default example twelve hundred of expansion and eight hundred of churn leave a net four hundred.

  5. 5

    Multiply by twelve for ARR

    The same figure on an annual basis. Fourteen thousand two hundred and eighty three a month is one hundred and seventy one thousand four hundred a year.

Examples

Example 1: A mixed monthly and annual book

Monthly subscribers
250
Monthly price
49
Annual subscribers
40
Annual price
490
Expansion
1200
Churn
800
StepCalculationResult
Monthly plan revenue250 x 4912250
Annual plans as a monthly rate40 x 490 / 121633.3333
Expansion revenue12001200
Churn800800
Monthly recurring revenue12250 + 1633.3333 + 1200 - 80014283.3333

Result: Two hundred and fifty monthly subscribers at forty nine and forty annual plans at four hundred and ninety give a base of 13883.3333, and after 1200 of expansion and 800 of churn the monthly recurring revenue is 14283.3333.

Example 2: A purely monthly business

Monthly subscribers
120
Monthly price
99
Annual subscribers
0
Annual price
0
Expansion
0
Churn
300
StepCalculationResult
Monthly plan revenue120 x 9911880
Annual plans as a monthly rate0 x 0 / 120
Expansion revenue00
Churn300300
Monthly recurring revenue11880 + 0 + 0 - 30011580

Result: With no annual contracts and no expansion, the MRR is 11580 after 300 of churn, which annualises to an ARR of 138960.

Example 3: When churn outruns expansion

Monthly subscribers
400
Monthly price
29
Annual subscribers
0
Annual price
0
Expansion
200
Churn
1500
StepCalculationResult
Monthly plan revenue400 x 2911600
Annual plans as a monthly rate0 x 0 / 120
Expansion revenue200200
Churn15001500
Monthly recurring revenue11600 + 0 + 200 - 150010300

Result: Four hundred low-priced subscribers give a base of 11600, but 1500 of churn against only 200 of expansion pulls the MRR down to 10300, which is net negative growth.

Calculator

Monthly recurring revenue

$14,283.33

Annual run rate
$171,400.00
Net new MRR
$400.00
Revenue per account
$49.25

Values update as you type. This calculator covers the single scenario its formula assumes — see Common Mistakes for what it leaves out.

Prefer a full-width tool? Open the MRR calculator page.

Common Mistakes

  • Counting annual prepayments as one month of revenue

    A twelve hundred pound annual plan contributes one hundred pounds of MRR, not twelve hundred. Booking the whole amount in the month it is invoiced makes that month look exceptional and the following eleven look weak.

  • Including one-off revenue in MRR

    Setup fees, onboarding, hardware and consulting do not repeat. Folding them into MRR produces a number that flatters the business and then fails to predict the next month.

  • Confusing MRR with cash collected

    Cash is when money arrives; MRR is the rate at which recurring service is delivered. A month of heavy annual renewals can show record cash and flat MRR at the same time.

  • Reporting gross new MRR as if it were net

    New business and expansion are not the whole story. Without subtracting contraction and churn, the figure describes effort rather than outcome, and a shrinking business can look like a growing one.

  • Treating variable usage revenue as recurring

    If the amount a customer pays swings with consumption and there is no contractual floor, it is not recurring. Keeping a separate usage line is more honest and more useful than averaging it in.

  • Measuring at an inconsistent point in the month

    Signups, upgrades and cancellations land on different days. Comparing a figure taken on the first of one month with one taken on the last of the next creates trend lines that are pure noise.

FAQ

What is the difference between MRR and revenue?

Revenue is everything invoiced in a period, including one-off sales and annual prepayments. MRR is only the recurring part, normalised to a monthly rate. A company can have high revenue in a month and modest MRR if most of the money came from annual renewals.

How do I convert annual contracts to MRR?

Divide the annual contract value by twelve. A four hundred and ninety pound annual plan is about forty one pounds of MRR per month. Never count the full annual amount in the month it is billed.

What is net new MRR?

It is expansion plus new business minus contraction and churn. The default example has twelve hundred of expansion and eight hundred of churn, so net new MRR is four hundred for the month.

Is ARR just MRR multiplied by twelve?

Yes, arithmetically it is. ARR is a run-rate projection that assumes the current month repeats, which is why it should be described as a run rate rather than a forecast. It is useful for annual budgeting and for comparing against yearly targets.

Should a free trial count towards MRR?

No. MRR starts when the customer is contractually committed to pay. A trial that has not converted has no recurring revenue, and counting it inflates the figure with customers who may never pay anything.

What counts as good MRR growth?

There is no universal number, but the composition matters more than the headline. Growth driven by new customers with high churn is fragile; growth driven by expansion of existing accounts compounds. A business growing twenty per cent a month with five per cent churn is in a very different position from one growing twenty per cent with fifteen per cent churn.

References

  1. [1]Wikipedia, Recurring revenue — https://en.wikipedia.org/wiki/Recurring_revenue
  2. [2]Wikipedia, Software as a service — https://en.wikipedia.org/wiki/Software_as_a_service
  3. [3]Wikipedia, Subscription business model — https://en.wikipedia.org/wiki/Subscription_business_model
  4. [4]Wikipedia, Churn rate — https://en.wikipedia.org/wiki/Churn_rate