MRR/ARR Growth Forecast
Forecast SaaS subscription revenue with churn and expansion. Enter values for instant results with step-by-step formulas.
Formula
Net Growth = New% - Churn% + Expansion%; MRR(t+1) = MRR(t) × (1 + Net Growth%)
Worked Examples
Example 1: Healthy SaaS Growth
Problem: Current MRR: $50K. Monthly new: 10%, Churn: 4%, Expansion: 3%. Forecast 12 months.
Solution: Starting: $50,000 MRR ($600K ARR)\n\nNet growth rate: 10% - 4% + 3% = 9% monthly\n\nQuick Ratio: (10 + 3) / 4 = 3.25 (Healthy)\nNRR: 100 - 4 + 3 = 99% (Just below neutral)\n\nMonth 1: $50K × 1.09 = $54,500\nMonth 3: $50K × 1.09^3 = $64,700\nMonth 6: $50K × 1.09^6 = $83,900\nMonth 12: $50K × 1.09^12 = $140,600\n\nProjected ARR at 12 months: $1.69M\nGrowth: 181% annually\n\nThis is strong early-stage growth.\nChurn is manageable.\nExpansion partially offsets.
Result: 9% net monthly | $141K MRR at M12 | 181% growth | Quick Ratio: 3.25
Example 2: Churn Crisis
Problem: MRR: $80K. Monthly new: 6%, Churn: 8%, Expansion: 1%. Forecast 12 months.
Solution: Starting: $80,000 MRR\n\nNet growth: 6% - 8% + 1% = -1% (SHRINKING!)\n\nQuick Ratio: (6 + 1) / 8 = 0.88 (Crisis)\nNRR: 100 - 8 + 1 = 93% (Terrible)\n\nMonth 1: $80K × 0.99 = $79,200 (-$800)\nMonth 6: $80K × 0.99^6 = $75,300 (-$4,700)\nMonth 12: $80K × 0.99^12 = $71,100 (-$8,900)\n\nProjected ARR at 12 months: $853K (was $960K)\nGrowth: -11% (shrinking!)\n\nDeath spiral unless churn fixed.\nStop all growth spend until retention solved.\n\nCritical: Interview churned customers, fix product issues, focus on activation and onboarding.
Result: -1% net monthly (CRISIS) | $71K MRR at M12 | -11% annual | Fix retention NOW
Example 3: Expansion-Led Growth
Problem: MRR: $200K. Monthly new: 5%, Churn: 3%, Expansion: 5%. Forecast 12 months.
Solution: Starting: $200,000 MRR ($2.4M ARR)\n\nNet growth: 5% - 3% + 5% = 7% monthly\n\nQuick Ratio: (5 + 5) / 3 = 3.33 (Excellent)\nNRR: 100 - 3 + 5 = 102% (Negative churn!)\n\nMonth 12: $200K × 1.07^12 = $451,000\n\nProjected ARR: $5.41M\nGrowth: 126% annually\n\nThis is healthy expansion-driven growth:\n- Low churn (3% is good)\n- Strong expansion (5% is rare)\n- Negative churn means existing customers expand faster than new churns\n\nStrategy: Focus on land-and-expand.\nCustomer success drives revenue without CAC.
Result: 7% net monthly | $451K MRR at M12 | 126% growth | Expansion-driven model
Frequently Asked Questions
What is MRR and ARR?
MRR (Monthly Recurring Revenue) is predictable monthly subscription revenue. ARR (Annual Recurring Revenue) is MRR × 12. Both exclude one-time fees, variable usage, or professional services. MRR is the core health metric for subscription businesses. Growth MRR indicates company trajectory.
What's a good MRR growth rate?
Depends on stage. Early stage (seed): 10-20% monthly is excellent. Growth stage (Series A-B): 5-10% monthly. Mature: 3-5% monthly. SaaS Capital index shows median ~5% monthly for $1M-10M ARR companies. Compound growth matters—5% monthly = 80% annually.
What MRR milestones matter for fundraising?
Rough milestones: $10K MRR = seed stage viability, $50K MRR = solid product-market fit, $100K MRR = Series A range, $500K+ MRR = Series B+ territory. Growth rate matters as much as absolute number. $50K at 10% monthly growth > $100K flat.
Should I forecast using gross growth or net?
Use net growth (new + expansion - churn) for realistic forecasting. Gross growth alone is vanity metric—ignoring churn creates overly optimistic projections. Conservative forecasting uses historical net growth rate, not aspirational gross.
How far out should I forecast?
Accurate forecasts: 3-6 months using current trends. Strategic forecasts: 12-24 months with scenarios (conservative/expected/aggressive). Beyond 2 years, too many variables change. Re-forecast quarterly based on actuals. Include scenarios, not single-line projections.
How do I forecast revenue?
Bottom-up forecasting multiplies expected units sold by price. Top-down starts with market size and estimates market share. For existing businesses, use historical growth rates with adjustments. For SaaS: Forecast MRR = Current MRR + New MRR - Churned MRR + Expansion MRR. Always model best, expected, and worst case scenarios.