Predicting MRR Growth with a Simple Model
Most MRR growth forecasts are either wild guesses or complicated models that nobody understands. The right approach is building a simple model with five inputs: new customer acquisition rate, average new customer MRR, expansion rate, contraction rate, and churn rate. Plug in your historical averages, project forward month by month, and you get a realistic forecast that actually matches how your business works. The model takes an hour to build and gives you 80% of the accuracy of sophisticated forecasting systems.
To calculate MRR growth on a monthly basis, start by determining your monthly revenue earned from new customers, expansions (upgrades), reactivations, downgrades, and cancellations. Net monthly recurring revenue (net MRR) is calculated by adding new and expansion MRR, then subtracting contraction and churn MRR. Tracking net MRR growth and the net MRR growth rate each month is essential for understanding your revenue momentum. Several key factors—such as customer acquisition, expansion, and churn—directly influence MRR growth. These calculations are fundamental for subscription based businesses and are considered core SaaS metrics. Monitoring your revenue MRR growth rate and monthly revenue earned helps SaaS companies make informed, data-driven decisions.
Introduction to Key Metrics
For any SaaS business, understanding and tracking the right metrics is the foundation of sustainable growth. Among these, monthly recurring revenue (MRR) and the MRR growth rate stand out as essential indicators of financial health. The MRR growth rate measures how quickly your recurring revenue is increasing or decreasing over a given period, providing a clear view of your company’s momentum.
Calculating the MRR growth rate is straightforward: [(Ending MRR – Starting MRR) / Starting MRR] x 100For example, if your SaaS company starts the month with $100,000 in monthly recurring revenue and ends with $110,000, your MRR growth rate is 10%. This single percentage captures the net effect of new customer acquisition, expansion from existing customers, and any lost revenue due to churn or contraction.
Why does this matter? Tracking your MRR growth rate allows you to monitor recurring revenue trends, assess the effectiveness of your customer acquisition strategies, and quickly spot changes in your recurring revenue streams. It’s a key metric for SaaS companies because it reflects the predictability and stability of your revenue, which is critical for planning, forecasting, and attracting investors. Consistent recurring revenue MRR growth signals a healthy business model and supports confident decision-making as you scale.
By focusing on these key metrics, SaaS businesses can better understand their growth rate, optimize their recurring revenue model, and ensure long-term financial health.
Why Complex Models Don’t Work for Most SaaS Companies
We’ve reviewed dozens of financial models from SaaS companies seeking funding or trying to understand their business. Half of them are just revenue trending up at some assumed growth rate. The other half are sprawling Excel nightmares with 200 inputs that break when you change anything.
Neither approach works. The trend-based models ignore business mechanics and blow up when conditions change. The complex models are impossible to maintain and nobody trusts them because nobody understands what’s happening inside.
The right model sits in between. It captures how your business actually works (customers come in, some expand, some churn) without requiring a PhD in financial modeling to operate.
Here’s what a simple MRR model looks like and why it works better than either extreme, especially when treated as a driver-based financial model guided by a fractional CFO.
The Five Inputs That Drive Customer Acquisition and Everything Else
Your MRR growth comes from five fundamental drivers. These five inputs reflect the main sources of new business and the ongoing expansion of paying customers. Model these accurately as a driver-based financial model grounded in operational metrics and everything else follows:
New customers per month. How many new customers are you adding? This comes from your sales pipeline, marketing funnel, or historical acquisition patterns. For a company adding 15 new customers monthly, that’s your input. Acquiring new paying customers is a key part of a company’s recurring revenue growth and should be supported by a strong customer acquisition strategy.
Average MRR per new customer. What do new customers typically pay? If some pay $500, some pay $2,000, use the average. For our example, let’s say $800.
Monthly expansion rate. What percentage of your existing customer base expands each month through upsells, additional seats, or price increases? Historical data shows this. Maybe it’s 4% of starting MRR monthly.
Monthly contraction rate. What percentage downgrades, reduces seats, or negotiates price cuts? Maybe it’s 1% of starting MRR monthly.
Monthly churn rate. What percentage of customers cancel completely? Maybe it’s 2% of starting MRR monthly. The customer churn rate directly impacts the revenue earned and the overall health of the company’s recurring revenue.
That’s it. Five numbers. If you can’t confidently state these five numbers for your business, stop reading and go calculate them from historical data. They’re the foundation of everything.
Expansion MRR and Existing Customers
Expansion MRR is one of the most powerful drivers of recurring revenue growth for SaaS companies. Unlike new MRR, which comes from acquiring new customers, expansion MRR is the additional monthly recurring revenue generated from your existing customers. This can come from upselling customers to higher-tier plans, cross-selling complementary products, or offering valuable add-ons that enhance the customer’s current subscription plan. Even reactivating previously canceled subscriptions can contribute to expansion MRR.
Why is expansion MRR so valuable? Growing revenue from your existing customers typically requires less effort and cost than acquiring new ones. When you successfully increase expansion revenue, you boost your monthly recurring revenue growth rate and strengthen your company’s financial health. For example, moving a customer from a basic to a premium plan, or encouraging them to add more users or features, directly increases your recurring revenue without the need for additional marketing or sales spend.
Retaining and nurturing your existing customers is crucial for sustainable growth, and improving gross retention through better onboarding and customer success often has outsized impact on long-term MRR. Effective customer retention strategies—such as delivering excellent customer service, regularly releasing new features, implementing structured renewal management processes, and offering flexible pricing plans—help reduce customer churn and create more opportunities for expansion MRR. By focusing on the needs and satisfaction of your current subscribers, you not only protect your revenue base but also unlock new revenue streams through expansion.
In summary, prioritizing expansion MRR and investing in customer retention are key factors for SaaS companies aiming to increase their monthly recurring revenue, achieve higher MRR growth rates, and build a resilient, scalable business while avoiding financial red flags like rising churn and weakening net revenue retention. Sustainable recurring revenue growth starts with maximizing the value of your existing customer relationships.
Building the Month-by-Month Model
Here’s how the model works, using realistic numbers:
Starting point (January): $100K MRR, 125 customers
Month 1 (February) calculation:
– Starting MRR: $100K
– New customer MRR: 15 customers × $800 = +$12K
– Expansion MRR: $100K × 4% = +$4K
– Reactivation MRR: $0 (no reactivated customers this month, but include as a potential positive input)
– Contraction MRR: $100K × 1% = -$1K (revenue lost from downgrades)
– Churn MRR: $100K × 2% = -$2K (revenue lost from cancellations)
– Ending MRR: $100K + $12K + $4K + $0 – $1K – $2K = $113K
– Ending customers: 125 + 15 – (125 × 2%) = 137 customers
Month 2 (March) calculation:
– Starting MRR: $113K
– New customer MRR: 15 × $800 = +$12K
– Expansion MRR: $113K × 4% = +$4.5K
– Reactivation MRR: $0 (no reactivated customers this month, but track for future months)
– Contraction MRR: $113K × 1% = -$1.1K (revenue lost from downgrades)
– Churn MRR: $113K × 2% = -$2.3K (revenue lost from cancellations)
– Ending MRR: $113K + $12K + $4.5K + $0 – $1.1K – $2.3K = $126.1K
– Ending customers: 137 + 15 – (137 × 2%) = 149 customers
Continue this month by month for 12, 24, or 36 months. Each month’s ending MRR becomes next month’s starting MRR. The expansion, contraction, and churn rates apply to the growing base, so they compound.
In this example, the company grows from $100K to $126K in two months (26% growth) even though they’re only adding $12K in new customer MRR monthly. That’s because expansion (+4% monthly) more than offsets contraction and churn (-3% combined, representing revenue lost), creating net revenue retention of 101%. The net MRR for each month reflects the sum of new, expansion, reactivation, contraction, and churn MRR, mirroring the structure of a SaaS revenue bridge that decomposes growth drivers.
Why This Simple Model Works
The model captures the fundamental mechanics of SaaS growth: you add customers, they expand or contract over time, some leave. Everything else is details.
More importantly, you can actually maintain this model. Update your five inputs monthly based on actual performance. If new customer acquisition accelerates from 15 to 20 monthly, plug in 20, ideally informed by leading indicators that predict SaaS demand 60–90 days ahead. If churn spikes from 2% to 3%, reflect that immediately.
The model lets you test scenarios easily:
What if we double sales capacity and add 30 customers monthly instead of 15? Change one number, see the impact.
What if we improve onboarding and reduce churn from 2% to 1.5%? Change one number, see the dramatic long-term effect, and compare it to scenarios built from accurate SaaS churn forecasting using cohorts and leading indicators.
What if expansion slows from 4% to 3% because we’re running out of upsell opportunities? Model it.
We’ve seen companies with 50-tab Excel models that take a full-time FP&A person to maintain get more value from this simple five-input model because they can actually use it for decision making instead of just creating it once for fundraising.
Adding Sophistication Where It Matters
The basic model works for most companies, but you can add layers of sophistication where your business requires it:
Segment by customer size. Run separate models for SMB, mid-market, and enterprise if these segments behave differently. Each has its own new customer acquisition, expansion, and churn rates. Sum them to get total MRR.
Model acquisition by channel. If you acquire customers through paid search, content, and direct sales with different volumes and unit economics, model each channel separately. This reveals which channels drive growth most efficiently.
Add sales capacity constraints. Instead of assuming you can always add 15 customers monthly, tie new customer acquisition to rep productivity. If you have 3 reps each closing 5 customers monthly, and you plan to hire 2 more reps who ramp over 3 months, model that growth curve.
Include cohort aging effects. Newer customers might churn at 3% monthly while customers over 12 months old churn at 1%. Split your customer base into cohorts and apply different retention rates.
When modeling expansion and contraction, analyze the customer’s current subscription plan to identify upsell, cross-sell, or downgrade opportunities and tailor retention strategies accordingly, and connect these patterns back to accurate NRR and GRR modeling across customer lifecycles.
Layer in pricing changes. If you’re raising prices in Q3, model the expansion impact on existing customers and higher starting MRR for new customers, making sure your SaaS pricing model and its financial implications are consistent with your growth strategy. Refining your value proposition can help ensure your pricing aligns with customer expectations and drives revenue growth while supporting healthy SaaS gross margin targets in the 70–80% range.
The key is adding complexity only where it meaningfully improves accuracy, such as layering in a SaaS scenario planning framework with best, base, and worst cases. A company with 90% of revenue from one customer segment doesn’t need segmentation. A company with equal revenue from three distinct segments does.
Testing Your Model Against Reality
Build the model using historical data, then test it by forecasting the last 12 months and comparing to what actually happened. If your model predicted $850K MRR in December and you ended at $820K, you’re 3.5% off—that’s good. If you predicted $850K and ended at $650K, something’s wrong with your assumptions.
Common reasons models miss reality:
Your expansion rate is wrong. You assumed 4% monthly expansion but actual historical average was 2.5%. Fix the input.
Your churn is seasonal. You assumed constant 2% monthly churn but Q4 actually sees 3.5% churn due to contract renewals and budget resets. Model seasonal patterns, and use SaaS cohort analysis to see how different signup periods behave over time.
Your new customer acquisition isn’t steady. You assumed 15 per month but actually you do 8-10 most months with spikes to 25 in Q4, especially if you’re operating a product-led growth motion with PLG-specific KPIs. Model the pattern, don’t average it.
Your average MRR per new customer has been declining. You assumed $800 but you’re actually moving downmarket and new customers average $600. Update the assumption.
Test, adjust, test again until the model reliably projects recent history within 5-10%. Then you can trust it to project the future.
Using the Model for Strategic Planning and Financial Forecasting
Once you have a working model, use it to answer the questions that actually matter:
How much do we need to grow new acquisition to hit our revenue target? Plug in different new customer numbers until the output matches your goal. This reveals whether you need 10% more sales capacity or 3x more sales capacity.
Is it better to invest in reducing churn or increasing expansion? Model both scenarios. Reducing churn from 2% to 1.5% might increase ending MRR more than increasing expansion from 4% to 5%. Now you know where to invest product resources.
How long until we hit $1M MRR at current growth rates? Run the model forward until you hit the milestone. This grounds planning in reality rather than arbitrary timelines. The same model can also be used to project annual recurring revenue (ARR) and set long-term growth targets, which are critical for SaaS business valuation and strategic planning.
What happens if our growth rate slows by 30%? Reduce new customer acquisition by 30% and see the impact, then translate those scenarios into cash flow forecasts that help avoid common SaaS cash mistakes. This stress-tests your cash runway and helps with contingency planning by forcing you to confront SaaS unit economics like CAC, LTV, and payback period. Tracking year over year growth in these scenarios is important for assessing long-term business health and overall performance.
What’s our path to break-even if we can’t raise the next round? Model reduced spending on acquisition (fewer new customers) while maintaining product investment to improve retention. Find the scenario where revenue growth covers burn rate.
We’ve used this model in board meetings to settle debates about where to invest. Sales wants more budget to hire reps. Product wants budget to reduce churn. Model both investments with realistic assumptions about impact. Whichever increases MRR faster wins the budget.
Common Mistakes That Break the Model
The model is simple but easy to mess up if you’re not careful:
Using bookings instead of MRR. If you sign a $100K annual contract, that’s not $100K MRR, it’s $8,333 MRR. Keep everything in monthly recurring terms.
Forgetting that expansion, contraction, and churn compound. These rates apply to the growing base each month. A 4% expansion rate means growing amounts of expansion dollar as MRR grows, not a fixed dollar amount.
Modeling gross metrics instead of net. If 4% of customers expand but 1% contract, don’t model 4% expansion. Model 3% net expansion. Or track expansion and contraction separately (better), especially if you also operate usage-based SaaS revenue streams that behave differently.
Not differentiating between voluntary churn and involuntary churn, or ignoring cohort retention metrics that reveal how behavior changes over time. Voluntary churn happens when customers choose to cancel, often due to perceived lack of value or pricing concerns, while involuntary churn is typically due to failed payments or other issues. Each type requires different retention strategies, so it’s important to model them separately for accurate MRR growth projections.
Not updating assumptions regularly. If market conditions change, your historical averages become less predictive. Update the model monthly with rolling 6-month averages of your key rates.
Assuming perfection. Don’t model 0.5% churn if you’ve never achieved below 2%. Be realistic about what’s achievable, not aspirational.
Not accounting for sales rep ramp time. New reps don’t produce immediately. Model a 3-month ramp where they close 30%, 60%, then 100% of quota.
What Good Monthly Recurring Revenue (MRR) Modeling Looks Like
Companies that model MRR well update their assumptions monthly and track forecast versus actual religiously. When actual MRR comes in different than forecast, they investigate why and refine their model.
They use the model in leadership meetings to align around growth strategy, as part of a broader early-stage SaaS CFO checklist for financial systems and metrics. Everyone understands the five inputs and how they drive outcomes. When sales says they need three more reps, finance can model the impact and show it increases MRR 22% over 12 months for $450K investment. Now you have a real ROI discussion.
They build scenarios regularly. Best case (everything improves 20%), base case (current trends), worst case (deterioration across metrics). This shows a range of outcomes and helps with risk management.
They don’t treat the model as truth, they treat it as a tool for understanding drivers, alongside compliant SaaS revenue recognition practices under ASC 606. When reality diverges from the model, that’s information about what’s changing in the business.
Most importantly, they keep it simple enough that non-finance people can understand and use it. The sales leader can plug in different acquisition numbers. The product leader can adjust churn rates. The CEO can test strategic scenarios without needing a data analyst.
This is what separates useful models from decorative models. Useful models get used weekly to make decisions. Decorative models get built for fundraising and then forgotten.
Q: How far forward should we forecast with this model?
For operational planning, 12 months is useful. For fundraising, 24-36 months is expected but gets increasingly uncertain. Beyond 36 months, too many variables change for the model to be meaningful. The right approach is building a detailed 12-month forecast you trust, extending it to 24-36 months with clear scenarios, and being honest with investors that the outer years are directional not precise. Update the model quarterly as you get more data.
Q: What if we don’t have enough historical data to calculate reliable rates?
If you’re pre-revenue or very early, use industry benchmarks as placeholders: 3-5% monthly churn for SMB SaaS, 1-2% for mid-market, 3-4% monthly expansion, 1% contraction. Update these aggressively as you gather actual data. Even 3 months of real data is better than pure benchmarks. If you have 6 months of data, use rolling 6-month averages. If you have 12+ months, use rolling 12-month averages to smooth seasonality.
Q: Should we model pessimistic, realistic, or optimistic assumptions?
Build three versions: base case using historical averages (most likely), upside case showing 20% improvement across key metrics (what’s possible if things go well), and downside case showing 20% degradation (what happens if we hit headwinds). Present all three to boards and investors. Use base case for internal planning because it’s most likely to be accurate. The scenarios help everyone understand the range of outcomes and what drives them, which is more valuable than pretending you know exactly what will happen.
