MRR/ARR Growth Forecast

Formula

Net Growth = New% - Churn% + Expansion%; MRR(t+1) = MRR(t) × (1 + Net Growth%)

## MRR Growth Formulas **Net Monthly Growth Rate**: Net Growth% = New MRR% - Churn% + Expansion% **Next Month MRR**: MRR(t+1) = MRR(t) × (1 + Net Growth%) **Compound Annual Growth Rate (CAGR)**: CAGR = (Final MRR / Starting MRR)^(12/months) - 1 **Net Revenue Retention (NRR)**: NRR% = 100% - Churn% + Expansion% **Quick Ratio**: Quick Ratio = (New MRR% + Expansion%) / Churn% **ARR from MRR**: ARR = MRR × 12 ## Why Compound Growth Matters The power of subscription businesses is compound growth. 8% monthly growth doesn't mean 96% annually (8 × 12)—it means 151% annually due to compounding. Each month's growth becomes the base for next month's growth. Net growth formula captures all revenue movements: new customers add revenue, churn removes revenue, expansion increases existing revenue. The sum determines trajectory. Positive net growth compounds to explosive results; negative means death spiral. Quick Ratio reveals growth quality. High ratios (>3) mean growth is efficient—adding much more than losing. Low ratios (<1) mean you're losing more than gaining. It's the revenue equivalent of putting water in a leaky bucket. NRR above 100% (negative churn) is the holy grail—you'd grow even with zero new customers. This dramatically reduces customer acquisition dependence and improves unit economics.

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) Net growth rate: 10% - 4% + 3% = 9% monthly Quick Ratio: (10 + 3) / 4 = 3.25 (Healthy) NRR: 100 - 4 + 3 = 99% (Just below neutral) Month 1: $50K × 1.09 = $54,500 Month 3: $50K × 1.09^3 = $64,700 Month 6: $50K × 1.09^6 = $83,900 Month 12: $50K × 1.09^12 = $140,600 Projected ARR at 12 months: $1.69M Growth: 181% annually This is strong early-stage growth. Churn is manageable. Expansion 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 Net growth: 6% - 8% + 1% = -1% (SHRINKING!) Quick Ratio: (6 + 1) / 8 = 0.88 (Crisis) NRR: 100 - 8 + 1 = 93% (Terrible) Month 1: $80K × 0.99 = $79,200 (-$800) Month 6: $80K × 0.99^6 = $75,300 (-$4,700) Month 12: $80K × 0.99^12 = $71,100 (-$8,900) Projected ARR at 12 months: $853K (was $960K) Growth: -11% (shrinking!) Death spiral unless churn fixed. Stop all growth spend until retention solved. Critical: 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) Net growth: 5% - 3% + 5% = 7% monthly Quick Ratio: (5 + 5) / 3 = 3.33 (Excellent) NRR: 100 - 3 + 5 = 102% (Negative churn!) Month 12: $200K × 1.07^12 = $451,000 Projected ARR: $5.41M Growth: 126% annually This is healthy expansion-driven growth: - Low churn (3% is good) - Strong expansion (5% is rare) - Negative churn means existing customers expand faster than new churns Strategy: Focus on land-and-expand. Customer 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 is Quick Ratio for SaaS?

Quick Ratio = (New MRR + Expansion MRR) / Churned MRR. Measures growth efficiency. >4 is excellent, 2-4 is good, 1-2 is acceptable, <1 means shrinking. Unlike customer Quick Ratio, uses revenue not customer counts. Shows if growth is healthy or just offsetting churn.

What's the difference between gross and net revenue?

Gross MRR: All recurring revenue including new, expansion, and existing. Net New MRR: New + Expansion - Churn. Net New MRR is growth metric. Gross MRR is total revenue metric. Focus on Net New MRR for growth health.

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.

Background & Theory

## Concept Overview MRR (Monthly Recurring Revenue) forecasting projects future subscription revenue based on growth components: new customer revenue, expansion from existing customers, and churned revenue. Accurate forecasting is essential for: resource planning, fundraising, goal setting, and investor communication. The key insight of subscription forecasting is decomposing growth into components. "We're growing 10% monthly" is incomplete—is that 15% new acquisition offset by 5% churn? Or 5% net growth from new plus expansion minus churn? The composition reveals business health and sustainability. ARR (Annual Recurring Revenue) is simply MRR × 12, providing an annualized view. Investors and companies use ARR for benchmarking and valuation. Market multiples (valuation / ARR of 10x, 20x) depend on growth rate, retention, and margins. ## Key Variables and Their Intuition **Current MRR**: Starting point for all projections. Sum of all subscription revenue for current month. Excludes one-time fees, usage overage, and non-recurring items. Clean MRR tracking is foundational. **Monthly Growth Rate**: New customer MRR as percentage of existing MRR. 10% growth means adding $10K new MRR to $100K base. Scales with base—$10K → $11K is 10%; $11K → $12.1K is also 10% (compounding). **Churn Rate**: MRR lost to cancellations as percentage of starting MRR. "5% churn" means losing 5% of revenue each month. Annual churn ≠ monthly × 12 due to compounding. 5% monthly ≈ 46% annual churn. **Average Revenue Per Account (ARPA)**: MRR divided by customer count. Used to convert between revenue and customer metrics. Increasing ARPA through upselling improves economics even if customer count is flat. **Expansion Rate**: Additional revenue from existing customers (upgrades, add-ons, usage growth) as percentage of MRR. The holy grail of SaaS—expansion revenue has no CAC. Negative churn (expansion > churn) enables growth without new customers. **Forecast Horizon**: How far to project. 12-month forecasts are standard for planning. 24+ months for strategic planning but accuracy decreases. Monthly refresh forecasts as actuals come in. ## Assumptions in Forecasting - Growth, churn, and expansion rates are stable (not always true) - No major market changes, competition, or product issues - Current rates reflect steady-state (early data may be noisy) - Seasonality is either absent or averaged in rates - Unit economics support projected scale - No capacity constraints on growth ## Limitations and Edge Cases **Non-Linear Growth**: Rates change over time. Early explosive growth slows as TAM is penetrated. Churn may increase as you move downmarket. Simple projection of current rates extrapolates poorly. **Seasonality**: Many products have seasonal churn or growth (B2B often see Q4 spike, Q1 slowdown). Annual patterns aren't captured in month-by-month constant-rate projections. **Cohort Differences**: Newer cohorts may have different retention than older cohorts. Projecting overall churn forward assumes cohorts behave similarly. **Example Edge Case**: Company at $50K MRR growing 10% monthly. Projection shows $1M MRR in 30 months. But: TAM is only $5M annually. As they penetrate market, growth rate must slow. Constant-rate projection would show impossible market share. ## Interpretation Guide **Net Growth Rate**: Combined effect of new, expansion, and churn. This is the true growth rate. Positive = growing, negative = shrinking. **Quick Ratio**: Efficiency of growth. How much revenue gained (new + expansion) per dollar lost (churn). >3 is healthy, 1-3 is acceptable, <1 is crisis. **Net Revenue Retention**: Revenue retention + expansion from existing customers. >100% (negative churn) is elite. 90-100% is good. <90% is concerning. **Forecast Trajectory**: The projected revenue path. Use for planning hiring, capacity, fundraising. Treat as scenario, not guarantee. ## Practical Tips - **Forecast monthly, review quarterly**: Update projections as actuals come in. Adjust rates based on trends. - **Build scenarios**: Conservative (lower growth, higher churn), expected (current rates), aggressive (improved rates). Plan for conservative. - **Track cohort retention**: Different customer groups (small vs enterprise) may have wildly different churn. Segment forecasts. - **Focus on net revenue, not customer count**: 100 $500/mo customers > 200 $200/mo customers even though fewer customers. - **Don't extrapolate linearly forever**: Growth rates change with scale. Build in deceleration for mature stage. - **Link forecast to initiatives**: Growth projections should connect to planned activities (sales hiring, marketing spend) not just wishes. ## Common Mistakes - **Ignoring churn in forecasts**: Projecting gross growth without subtracting churn creates fantasy forecasts. - **Extrapolating early rates**: First few months may not represent steady-state. Wait for 6+ months of data. - **Treating MRR and cash as same**: MRR is recurring revenue; cash flow depends on payment terms, collections. Annual contracts provide cash upfront but MRR is monthly. - **Not distinguishing one-time from recurring**: Including setup fees in MRR inflates true recurring revenue. - **Forecasting without checking unit economics**: Fast growth with negative unit economics leads to profitless revenue. - **Forgetting expansion revenue**: Modeling only new customers misses significant revenue from existing customer growth. ## When NOT to Use This Model - **Pre-product-market fit**: When churn and growth rates are wildly volatile, forecasting is pointless. Focus on finding fit. - **Annual contract business with lumpy deals**: Monthly MRR forecast doesn't match quarterly/annual contract close patterns. - **Mixed revenue models**: If subscriptions are <50% of revenue, MRR forecast doesn't represent business. - **Immediately post-major change**: After pricing change, product pivot, or market shift, wait for new steady-state before forecasting.

History

## Origins of Subscription Business Models Subscription models date to 17th century book publishing (subscriptions funded printing). Newspapers (1800s) and magazine publishing (1900s) refined monthly/annual subscription economics. However, subscription metrics as we know them emerged with software-as-a-service. Traditional software licensing (1980s-90s) involved large upfront payments with optional maintenance fees. Salesforce.com (1999) pioneered pure SaaS: monthly subscription with no upfront cost. This inverted the revenue model—instead of one large payment, many small recurring payments. ## MRR Metrics Emergence Early SaaS companies (2000s) initially tracked "total customers" or "monthly revenue." The unique challenges of subscription revenue—churn, expansion, forecasting—required new metrics. MRR (Monthly Recurring Revenue) became the standard unit of measurement. Bessemer Venture Partners, Andreessen Horowitz, and SaaS Capital published frameworks (2010-2013) defining metrics like churn rate, customer lifetime value, and CAC payback period. These became lingua franca for SaaS valuation and operations. David Skok's influential blog posts on SaaS metrics (2009+) educated founders on unit economics. The metrics evolved from simple "total recurring revenue" to sophisticated decomposition: new MRR, expansion MRR, churned MRR, resurrected MRR. ## Modern SaaS Metrics Sophistication The 2015+ era brought emphasis on: Net Revenue Retention (NRR) as the key metric for mature companies, Quick Ratio for growth health, and Rule of 40 (growth% + profit% should exceed 40) for balancing growth and profitability. Public SaaS companies (Salesforce, Adobe, Microsoft) now report subscription metrics in earnings calls. Investors value these metrics more than traditional earnings for growth companies. ARR multiples (valuation / ARR) became standard valuation method. ## Common Historical Misconceptions - **"MRR growth is always good"**: Growth at any cost (ignoring unit economics) led to many failed startups. Profitable growth matters. - **"Churn doesn't matter for fast-growing companies"**: Leaky bucket problem—adding users without retention wastes acquisition spend. - **"ARR is revenue"**: ARR is forward-looking projection; it's not recognized revenue until earned. Important for accounting vs metrics distinction. - **"Higher growth always means higher valuation"**: In 2022 market correction, profitable SaaS maintained value while unprofitable high-growth companies crashed. Unit economics matter. - **"Once you hit ARR milestone, you're set"**: Many companies hit $1M ARR then stagnate due to churn or saturation. Sustained growth requires continuous improvement.