Short answer: To forecast MRR for next quarter, start with your current MRR. Estimate net new MRR from sales pipeline and past conversion rates. Subtract expected churn MRR and add expansion MRR. Sum monthly projections across three months.
Key takeaways
- Start with current MRR as baseline.
- Estimate new MRR from sales pipeline and historical conversion.
- Account for churn MRR using average churn rate.
- Include expansion MRR from upgrades and cross-sells.
- Adjust for seasonality if your business has patterns.
- Compare forecast to actuals monthly to improve accuracy.
What you will find here
Forecasting MRR for next quarter is essential for planning hires, spending, and growth targets. But many founders guess. A structured approach turns uncertainty into a reliable estimate. Here’s how to forecast MRR using your existing data.
Why Forecast MRR?
MRR is the lifeblood of a SaaS business. Without a forecast, you can’t know if you’ll have cash to hire developers or pay for ads. A good forecast helps you set realistic goals and spot problems early. It also builds confidence with investors and board members.
Step 1: Start with Current MRR
Your forecast starts today. Write down your MRR for the current month. This is your baseline. If you’re not sure how to calculate it, review our guide on ARR vs MRR: Key Differences Every SaaS Founder Must Know. For example, if your MRR is $50,000 this month, that’s your starting point.
Step 2: Estimate New MRR from Sales
New MRR comes from new customers. Look at your sales pipeline. Multiply the total value of deals in each stage by your historical close rate for that stage. Then divide by the average contract term (in months) to get MRR.
For instance, if you have $200,000 in potential annual contracts in the negotiation stage, and you close 40% historically, that’s $80,000 in annual revenue = $6,667 in MRR. Spread this across months based on expected close dates. Use last quarter’s sales data as a sanity check.
Step 3: Subtract Churn MRR
Churn is the biggest enemy of growth. Calculate your monthly churn rate (lost MRR / starting MRR). Apply it to your current MRR to estimate losses. If you have 5% monthly churn on $50,000 MRR, expect to lose $2,500 in MRR from churned customers each month.
Remember that churn can be seasonal. If you have historical data, use an average of the same quarter last year. For a deeper look at churn’s impact, check our piece on How to Calculate ARR the Right Way — churn affects ARR too.
Step 4: Add Expansion MRR
Existing customers often spend more. This is expansion MRR from upgrades, add-ons, or seat increases. Look at your historical expansion rate (expansion MRR / starting MRR). Apply it to the current MRR. If expansion is 2% monthly, that’s $1,000 on $50,000 MRR.
Be conservative. Not every month has the same upgrade activity. If you have a large renewal quarter, expansion may be higher. Use an average of the last three months.
Step 5: Build the Monthly Forecast
Now combine the pieces. For each month in the quarter, calculate:
- Starting MRR = previous month’s ending MRR
- + New MRR from closed deals
- – Churn MRR = starting MRR × churn rate
- + Expansion MRR = starting MRR × expansion rate
- = Ending MRR
Repeat for each month. The quarter’s average MRR or ending MRR becomes your forecast. Here’s a simple table example for a $50,000 baseline, 5% monthly churn, 2% expansion, and $5,000 new MRR each month:
| Month | Start MRR | New MRR | Churn MRR | Expansion MRR | End MRR |
|---|---|---|---|---|---|
| Month 1 | $50,000 | $5,000 | $2,500 | $1,000 | $53,500 |
| Month 2 | $53,500 | $5,000 | $2,675 | $1,070 | $56,895 |
| Month 3 | $56,895 | $5,000 | $2,845 | $1,138 | $60,188 |
Adjust for Seasonality
Not all quarters are equal. If you sell to businesses, Q4 may have higher churn due to budget freezes. Q1 might have strong expansion. Use your own historical data to adjust rates. If you have only one year of data, be cautious. The How to Calculate ARR the Right Way guide covers longer-term trends.
Validate and Iterate
A forecast is never perfect. Compare your predicted MRR to actual MRR each month. Identify where you over- or underestimated. Maybe your churn rate is creeping up. Or perhaps your sales cycle is longer than expected. Adjust next quarter’s assumptions accordingly.
Share the forecast with your team. Revisit it monthly. Over time, your forecasting will become more accurate. You’ll gain confidence in resource allocation and growth planning.
Common Pitfalls in MRR Forecasting
Ignoring contraction. Some customers downgrade. Include contraction MRR as part of churn. Track it separately if possible.
Over-optimistic sales pipeline. The pipeline is not closed revenue. Apply realistic close rates. Discount late-stage deals further if you have a long sales cycle.
Not updating assumptions. Your business changes. Revisit churn rates and expansion rates each quarter. Use rolling averages instead of static numbers.
When to Build a More Complex Model
If you have multiple product lines, customer segments, or pricing models, a single MRR forecast may be too simplistic. Build separate forecasts by segment and sum them. Use cohort analysis for more accurate churn predictions. As you grow, consider using a dedicated finance tool or spreadsheet automation.
Forecasting MRR is a skill. Start simple, improve over time. Your first forecast won’t be perfect, but it will be far better than guessing.
Frequently asked questions
What data do I need to forecast MRR for next quarter?
You need current MRR, historical churn rate, historical expansion rate, and a sales pipeline with close probabilities. If you have seasonality data, include that too.
How far in advance can I forecast MRR reliably?
One quarter is typically reliable. Beyond that, uncertainty increases significantly due to market changes and unpredictable sales cycles.
Should I include one-time fees in MRR forecast?
No. MRR only includes recurring revenue. One-time fees like setup or onboarding should be tracked separately in a non-recurring revenue line.
What if my churn rate is very high?
High churn makes forecasting difficult. Focus on reducing churn first. Your forecast will be more accurate with a stable, low churn rate. Use a shorter forecast window.
How often should I update my MRR forecast?
Update at least monthly. Compare to actuals and adjust assumptions. Some teams update weekly if they have volatile sales cycles or high transaction volumes.