HesapHanem

Expansion MRR Calculator

Enter upgrading accounts and their average MRR increase to find expansion MRR.

How it is calculated

The tool multiplies the number of accounts that expanded by their average monthly increase: expansion MRR = accounts × average increase. The expansion rate is expansion MRR ÷ starting MRR × 100, and the annual effect is expansion MRR × 12. Accounts means customers who upgraded or added seats this period (not your total customers), and the average increase is the extra monthly revenue per such account. Accounts must be above zero. If starting MRR is left empty or zero, the rate shows 0.00% because it cannot be calculated, but the other two figures still work. The tool counts expansion only: new customers, churn and downgrades are separate lines, and it does not give net revenue retention.

Worked example

In one month, 40 customers upgrade their plan and each pays 75 more per month. Step 1: expansion MRR = 40 × 75 = $3,000.00. Step 2: starting MRR was 50,000, so the expansion rate = 3,000 ÷ 50,000 = 6.00%. Step 3: the annualised effect = 3,000 × 12 = $36,000.00 of extra yearly recurring revenue. The 36,000 is simply 12 times this month's expansion and assumes none of the upgrades are reversed.

Try this example →

Common mistakes

  • Entering all customers as accounts. Only the customers who actually increased their payment count, so using the full customer base inflates expansion MRR.
  • Entering the new total price instead of the increase. If a plan went from 100 to 175, the average increase is 75, not 175.
  • Mixing in new customers or reactivations. They belong in new MRR; expansion MRR covers existing customers only.
  • Leaving starting MRR empty and reading the 0.00% rate as no growth. It only means no base was given, so the rate was not calculated.
  • Treating the annual figure as a forecast. It multiplies one month by 12, so it ignores later churn and downgrades.

About this calculator

Expansion MRR is the additional monthly recurring revenue a SaaS company earns from its existing customer base — through upgrades, added seats, or cross-sells — as opposed to revenue from brand-new customers. This calculator multiplies the number of upgrading accounts by the average MRR increase per account, expresses it as an expansion rate (Expansion MRR ÷ starting MRR, when you enter a starting MRR), and projects the annualized impact (×12) if that expansion pace continued for a full year.

Expansion MRR is one of the clearest signals of product-led growth and a key ingredient of net revenue retention (NRR): a company with strong expansion can grow revenue even with zero new customer acquisition, and NRR above 100% (expansion outpacing churn and contraction) is a benchmark investors watch closely. This calculator does not compute NRR itself, since that also needs churned and contraction MRR. SaaS founders, revenue operations teams, and venture investors track expansion MRR monthly alongside new MRR and churned MRR to build a full MRR waterfall and gauge the health of the existing customer base.

Was this helpful?

You can pick up to 3 reactions.

Comments (1)

  • Editorial team

    Once you have the expansion figure, the natural next step is net revenue retention, which the tool does not compute. Take the starting MRR, add expansion, subtract churned and contraction MRR, then divide by the starting MRR. With 60,000 to start, 3,000 of expansion and 1,800 lost to churn and downgrades, you get 61,200 ÷ 60,000, or 102 percent. Do you track expansion monthly or by quarter?

Popular calculators

Loan Calculator

Monthly payment, total interest and full amortization schedule.

Percentage Calculator

Percent change, percent of, and ratio calculations.

Discount Calculator

Calculate final price, savings, and discount amount.

BMI Calculator

Body mass index from height and weight (metric or imperial).

Age Calculator

Compute your exact age in years, months and days from a birth date.

Compound Interest Calculator

Calculate the final amount and interest earned with compounding.

All Calculators