How to Project MRR Growth

• The MRR roll-forward equation
• Step 1: Lock in your starting MRR
• Step 2: Project new MRR from pipeline, not from desire
• Step 3: Model expansion as a percentage of base
• Step 4: Subtract contraction (downgrades and seat reductions)
• Step 5: Apply churn to the right base
• Step 6: Combine into a 12-month roll-forward
• Step 7: Stress test with three scenarios
• Step 8: Tie back to cash
• Common mistakes to avoid
• What to do next

To project MRR growth, you build a month-by-month roll-forward that starts with this month's MRR, adds new business and expansion, then subtracts contraction and churn. Each line is tied to an assumption you can defend: pipeline coverage, conversion rates, ARPU, and gross revenue churn. The projection is only as credible as the assumptions feeding it.

This guide shows you the standard SaaS MRR build, the four sources of MRR movement, and how to stress test the result before you put it in a board deck or fundraising model.

The MRR roll-forward equation

Every SaaS finance team uses the same identity:

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

Each of those four movement lines comes from a different operational driver. New MRR comes from sales. Expansion comes from customer success and upsell motions. Contraction comes from downgrades and seat reductions. Churn comes from cancellations.

Plug current numbers into the MRR & ARR Projection Calculator to see a 12-month projection in seconds. Then refine the assumptions using the steps below.

Step 1: Lock in your starting MRR

Starting MRR is not your billings or your revenue from last month. It is the recurring portion of your subscription book on the first day of the month, normalized to a monthly figure.

• Annual contracts: divide annual contract value by 12.
• Quarterly contracts: divide by 3.
• Usage-based components: use the trailing 3-month average, not the most recent month, to smooth spikes.
• Setup fees and one-time services: exclude entirely.

If you cannot reconcile your starting MRR to your billing system within 1%, fix the data before projecting. Errors in the base compound.

Step 2: Project new MRR from pipeline, not from desire

The most common mistake is plugging in a new MRR number that hits the target. Real projections work the other direction: pipeline conversion drives new MRR.

New MRR = Qualified pipeline x Win rate x Average deal size / 12 (if ACV)

A concrete example. Suppose your team has $600,000 in qualified pipeline this month, a historical win rate of 22%, and an average ACV of $18,000.

• Expected closed-won ACV: $600,000 x 0.22 = $132,000
• Number of deals: $132,000 / $18,000 = ~7 deals
• New MRR: $132,000 / 12 = $11,000

If you do not have a CRM with reliable stages, fall back to last 3 months of actual new MRR averaged. Do not extrapolate aggressively from a single hot month.

Step 3: Model expansion as a percentage of base

Expansion revenue (upgrades, seat additions, usage increases from existing customers) is the engine behind net revenue retention. Project it as a monthly rate against the existing customer base.

Monthly expansion MRR = Starting MRR x Monthly expansion rate

Typical monthly expansion rates by segment:

These are OpenView 2024 benchmark ranges for SaaS companies between $1M and $50M ARR. If you are projecting numbers outside these bands, document why.

Step 4: Subtract contraction (downgrades and seat reductions)

Contraction is the mirror of expansion. Customers stay but pay less. Project it as a monthly rate against the existing base:

Monthly contraction MRR = Starting MRR x Monthly contraction rate

SMB SaaS typically sees 0.3% to 1.0% monthly contraction. Usage-based pricing models see higher contraction because customer usage naturally fluctuates.

A common error is netting expansion and contraction into one line. Investors will ask for both separately because they tell different stories. Heavy expansion plus heavy contraction means a volatile customer base. Modest expansion with low contraction means stable revenue.

Step 5: Apply churn to the right base

Churned MRR is the recurring revenue that walked away when accounts cancelled. Project it using your monthly gross revenue churn rate.

Churned MRR = Starting MRR x Monthly gross revenue churn

If your churn calculation is not solid, fix that first. See the Churn Rate Calculator and the calculation guide for the right denominators.

A worked example: starting MRR $100,000, monthly gross revenue churn 2.5%, projected churned MRR = $2,500.

Step 6: Combine into a 12-month roll-forward

Here is a sample month-by-month projection starting at $100,000 MRR with:

• New MRR: $11,000/month, growing 5% monthly
• Expansion rate: 1.5% of starting MRR
• Contraction rate: 0.5% of starting MRR
• Gross churn rate: 2.5% of starting MRR

Ending year-1 MRR is roughly 2.4x starting, or 136% growth. That maps to a "Triple, Triple, Double, Double, Double" trajectory if sustained, which is the venture growth benchmark Bessemer popularized.

Step 7: Stress test with three scenarios

Always build three scenarios. A single-point projection has no information about risk.

1. Base case. Your most likely assumptions, the numbers you would put in a board deck.
2. Downside case. Cut new MRR by 30%, increase churn by 50%. This shows what happens if pipeline conversion slips and a few large logos cancel.
3. Upside case. Add 25% to new MRR, add 50 basis points to monthly expansion. This shows the impact if a new channel or partnership lands.

The spread between downside and upside in year 12 ending MRR tells you how sensitive your business is to its assumptions. A 3x spread between cases means the projection is mostly hope.

Step 8: Tie back to cash

MRR projections are useful but they are not cash. Annual contracts billed upfront produce cash earlier than they produce GAAP revenue. Monthly subscriptions produce cash and revenue at the same time. Mix this with collections timing and you have a real cash forecast.

If you raise capital based on MRR projections without a matching cash forecast, you will run out of money in a month that the MRR chart looks great.

Common mistakes to avoid

• Projecting flat or improving churn without explaining what changes. Churn is sticky; assume it stays where it is unless you have a specific reason.
• Compounding new MRR growth at venture-style rates (10%+ monthly) for more than 6 months. Sales hiring and ramp time make this unrealistic.
• Forgetting to bake in seasonality. B2B SaaS often sees a December lull and a Q1 ramp.
• Ignoring deferred revenue and renewals timing for annual contracts.

What to do next

Once you have a clean MRR projection, layer in the cost side: sales hiring plan, CAC payback, and gross margin. The combined model becomes your operating plan. Tie the assumptions back to specific owners on the team so each line in the projection has someone accountable for hitting it.