MRR calculator: the normalized base, the bridge of the month and compound growth

This page answers what you have and where it is going: the snapshot of normalized MRR, the bridge that explains the month and the compound projection to the target. It sits next to the churn rate calculator, which answers a different question, how much is leaking and what that costs over the year, and to the LTV calculator, which looks at a single customer instead of the whole book. If you want to size the leak, go to churn. If you want to know what a customer is worth, go to LTV. If you want the number that goes into the board deck and the date it hits the target, stay here.

MRR is not the money that came in this month

The confusion starts early because three different numbers fight over the same name in day to day conversation.

Billings are what you invoiced: the full annual contract, the setup fee and the consulting engagement nobody will buy twice. MRR is the recurring run rate normalized to one month: only what repeats, with annual contracts divided by 12. Recognized revenue is a third thing, an accounting figure that follows accrual rules and is not built to measure growth pace.

The calculator separates monthly plans from annual contracts in the very first block because that split is where most spreadsheets break. A $24,000 annual contract signed today is not a $24,000 spike in this month MRR: it is $2,000 of MRR that starts today and keeps existing in every month after. Dropping the full amount into the month of the invoice invents growth that disappears later and hides the real pace.

How to use it

1. Fill in revenue from monthly plans: what every customer on a monthly plan pays per month, at the start of the month. Leave out setup, consulting and one-off charges.
2. Fill in active annual contracts at their annual value, summed. The tool divides by 12 on its own and shows the monthly slice and the weight of annual contracts in the base. For quarterly contracts, multiply by 4 before adding them here, or handle each case by hand.
3. Build the bridge of the month in the next five fields. New MRR is only from customers who never paid before; expansion is upgrades and heavier usage from existing customers; reactivation is someone who had cancelled and came back; downgrade and cancellation are the two exits. Every dollar of the month belongs in exactly one of those boxes.
4. Enter the ARR target you are chasing. It does not affect MRR or growth: it only feeds the last two lines, the estimated date and the pace required.
5. Read in this order: growth of the month, quick ratio, and only then the projection. Pretty growth with a low quick ratio is an expensive treadmill, and the projection will not warn you about that on its own.

How it works: the formula

The snapshot part is plain arithmetic. What separates this from a spreadsheet sum is the normalization of annual contracts, a bridge that actually closes and a compound projection, because recurring growth does not add up: it multiplies on top of what already exists.

Annualized growth is the line that surprises people most. Five percent a month is not 60% a year: it is almost 80%, because every month compounds on the previous result. The same compounding works against you when net new MRR turns negative, which is why the month the bridge flips sign matters far more than the size of the flip.

Worked example (reproduces the default output)

The prefilled values describe a small B2B SaaS: $82,000 in monthly plans, $216,000 in active annual contracts, $6,000 of new MRR, $2,000 of expansion, $500 of reactivation, $900 lost to downgrades, $2,600 lost to cancellations and a $2,000,000 ARR target.

• Annual contracts: 216,000 ÷ 12 = $18,000.00 of MRR, or 18.0% of the base. Normalized starting MRR: 82,000 plus 18,000 = $100,000.00, that is $1,200,000 of ARR.
• Gross MRR added: 6,000 plus 2,000 plus 500 = $8,500.00. Gross MRR lost: 900 plus 2,600 = $3,500.00. Net new MRR: $5,000.00.
• Ending MRR: 100,000 plus 5,000 = $105,000.00. Ending ARR: $1,260,000, with $60,000 of ARR added in one month.
• Growth of the month: 5,000 ÷ 100,000 = 5.0%. Annualized: 1.05 to the power of 12, minus 1 = 79.6%, not the 60% you get by multiplying by 12.
• Quick ratio: 8,500 ÷ 3,500 = 2.43x. Of the gross added, 29.4% came from the existing base (expansion plus reactivation). Gross revenue churn for the month: 3,500 ÷ 100,000 = 3.5%.
• Time to double MRR: log(2) ÷ log(1.05) = 14.2 months.
• Projection at the same pace: $140,710.04 of MRR in 6 months, $188,564.91 in 12 months (or $2,262,779 of ARR) and $338,635.49 in 24 months.
• A $2,000,000 ARR target equals $166,666.67 of MRR. At the current pace it arrives in 9.5 months. To hit it in exactly 12 months, 3.93% a month would be enough, below today 5%.

Those last two lines are the entire planning conversation. The company in the example is ahead of its own target, which changes the question: instead of "how do we grow more", it becomes "how much of this growth can we trade for margin". If the numbers were reversed, 3.93% required against 2% actual, the target would be out of reach at the current pace, and no amount of optimism in the deck would change that.

How to read it and where the number misleads

The first limit is the projection treated as a forecast. Repeating one month twelve times is a scenario, not a budget. B2B sales months are uneven by nature, and one large deal can inflate net new MRR enough to turn the projection into fiction. A better habit is to run the calculator on a three month average and compare it with the single month: the distance between the two projections is the size of your volatility.

The second is ARR on a small base. Multiplying by 12 amplifies everything, noise included. With $8,000 of MRR, one customer in and one out move ARR by tens of thousands of dollars, and the monthly series starts telling a rollercoaster story that does not exist in the operation.

The third is net new MRR hiding its composition. Two months with a $5,000 balance could be $5,500 in against $500 out, or $20,000 in against $15,000 out. The first is a healthy business; the second is a treadmill burning acquisition cash to stand still. That is exactly what the quick ratio measures, and why it sits right next to growth on this page.

The fourth is blending monthly and annual in the reading. A base heavily concentrated in annual contracts has stable MRR and renewals bunched into a few dates a year: the risk does not show up in the month, it shows up on the contract anniversary. Check the weight of annual contracts before celebrating how stable your MRR looks.

From the number to the decision

• If the quick ratio is low and growth is low too, the problem is retention, not acquisition. Start with reducing churn with experimentation and size the leak in the churn rate calculator.
• If expansion accounts for little of the gross added, the cheapest lever is pricing and packaging. SaaS pricing page optimization is usually where that starts.
• If new MRR is too expensive to sustain the pace, take the number to the CAC calculator and compare it with LTV before raising the budget.
• If the base leans hard on annual contracts, test the offer before changing the policy: subscription versus one time pricing covers the packaging choices that move that weight.
• If the exits cluster in the first months of a customer life, the subject is activation: trial to paid conversion testing shows what to fix before churn shows up.

Frequently asked questions

How do you calculate MRR?

Add up the recurring revenue of every active customer, normalized to a monthly basis. A monthly plan enters at its monthly value; an annual contract enters at its annual value divided by 12; a quarterly contract, divided by 3. Setup fees, consulting, one-off charges and withheld taxes stay out, because they do not repeat next month. A SaaS with $82,000 in monthly plans and $216,000 in active annual contracts has an MRR of 82,000 plus 18,000, that is $100,000.

What is the difference between MRR and ARR?

ARR is simply MRR multiplied by 12. It is not the revenue billed over the year, not the sum of invoices issued and not recognized revenue in the accounting sense. It is the current monthly run rate projected over twelve months, which means ARR changes every month alongside MRR. With $105,000 of MRR at the end of the month, ARR is $1,260,000, even if the company billed far less than that over the last twelve months.

What is net new MRR?

It is the balance of the month: the MRR that came in (new customers plus expansion plus reactivation) minus the MRR that left (downgrade plus cancellation). A month with $8,500 of gross MRR added and $3,500 of gross MRR lost has $5,000 of net new MRR, and it is that balance, not the new sales figure, that moves ARR. Companies that track only new-customer MRR believe they are growing about twice as fast as they really are.

What is the SaaS quick ratio?

It is gross MRR added divided by gross MRR lost: how much recurring revenue you build for every dollar you lose. With $8,500 coming in and $3,500 going out, the quick ratio is 2.43. The market benchmark that has circulated since Mamoon Hamid published the idea is 4 for an efficiently growing company; below 1, the treadmill runs backwards. The quick ratio is useful because it separates two companies with identical growth: growing 5% while losing almost nothing is a very different business from growing 5% while losing nearly everything you sell.

Does an annual contract enter MRR in the month it was billed?

No. This is the most common distortion in a recurring revenue spreadsheet. A $24,000 per year contract signed in March does not add $24,000 to March MRR: it adds $2,000 of MRR, in March and in every month after that while it stays active. Dropping the full amount into the month of the invoice creates a spike that vanishes the next month and makes growth look volatile when it is not. The calculator splits the two fields precisely to force that division.

Can one month of growth predict next year ARR?

It can project, not predict. The projection assumes that this month net new MRR repeats as a percentage every month, which almost never happens: seasonality, sales cycle and base maturity all change the pace. Use the projection to size an order of magnitude and to answer questions like "does this pace reach the target?", not as a budget number. The most useful line in the table is usually the monthly growth needed to hit the target, because that one turns into an operating goal.

Keep going

MRR is the scoreboard; experimentation is how you move it without buying growth. Start with growth experimentation for SaaS to build the method, then use the experimentation ROI calculator to put a price on every point of growth a test gives back.