Profession Calculators
SaaS & Digital Business

Subscription Revenue Forecast Calculator

Project 12-month subscription revenue based on current subscribers, ARPU, new subscriber growth, and monthly churn rate with a month-by-month forecast table.

Share:
Subscription Metrics

Month-over-month increase in new subscriber acquisition

12-Month Forecast

Enter subscription metrics and click forecast.

Embed This Calculator on Your Website

Add this free calculator to your blog, website, or CMS with a simple copy-paste embed code.

Introduction

Subscription businesses fail at predictable revenue modeling more often than they fail at customer acquisition. A SaaS founder with 400 subscribers at $49/month may feel confident about $19,600 MRR, but that number ignores monthly churn, expansion revenue from upgrades, and contraction from downgrades. McKinsey research shows that subscription businesses with a 5% monthly churn rate lose 46% of their subscriber base annually. At that rate, the company above needs to acquire 184 new subscribers every month just to maintain flat MRR. Most founders only discover this math after twelve months of furious growth that produced no net revenue gain. Accurate subscription revenue forecasting requires modeling new subscriber acquisition, monthly churn, upgrade and downgrade rates, and the expansion multiplier simultaneously.

What This Calculator Does

This calculator forecasts subscription revenue over a 12-month period by modeling starting subscriber count, monthly new subscriber growth, churn rate, average revenue per user (ARPU), and expansion revenue from upgrades. It outputs monthly MRR projections, subscriber count trajectory, annual recurring revenue (ARR), and net MRR movement broken down into new MRR, churned MRR, and expansion MRR. It uses 2026 SaaS benchmarks where median monthly churn for SMB-focused SaaS is 3% to 5% and enterprise SaaS is 0.5% to 1.5%.

The Formula

MRR (Month N) = MRR(N-1) + New MRR - Churned MRR + Expansion MRR | New MRR = New Subscribers × ARPU | Churned MRR = Active Subscribers × Churn Rate × ARPU | ARR = MRR × 12

Each month, MRR changes by three components. New MRR is generated by newly acquired subscribers multiplied by ARPU. Churned MRR is lost from the existing base: active subscriber count multiplied by monthly churn rate multiplied by ARPU. Expansion MRR comes from existing subscribers upgrading to higher-priced tiers, expressed as a percentage of current MRR (typically 1% to 3% for healthy SaaS businesses). The net result compounds month over month. A business starting at $10,000 MRR with 3% churn, $2,000 new MRR, and 1.5% expansion MRR grows to $23,800 MRR by month 12. The same business with 5% churn and no expansion grows to only $14,200.

Step-by-Step Example

1

Enter starting MRR and subscriber count

Example: 200 subscribers, $49/month ARPU = $9,800 starting MRR. If you have multiple tiers, calculate a blended ARPU by dividing total MRR by total active subscribers.

2

Set monthly new subscriber acquisition

Enter flat monthly new subscribers (e.g., 25/month) or a growth rate percentage (e.g., 5% MoM subscriber growth). Flat inputs are more conservative and typically more accurate for early-stage businesses under 12 months old.

3

Input churn rate and expansion rate

Monthly churn: 4.0% (SMB SaaS median). Monthly expansion rate: 1.5% of current MRR (from plan upgrades, seat additions). Net Revenue Retention (NRR) = 1 - churn + expansion = 97.5% per month, which annualizes to approximately 97% NRR. Healthy SaaS targets NRR above 100%.

4

Review 12-month forecast output

Starting MRR: $9,800. After 12 months at 25 new subscribers/month, 4% churn, 1.5% expansion: projected MRR $17,240, ARR $206,880. Subscribers grow from 200 to 301. Total revenue collected over 12 months: $158,640. Compare to a no-expansion scenario: MRR $15,400, ARR $184,800, 12-month revenue $143,280.

Real-World Use Cases

Series A Fundraise Revenue Model

A SaaS founder preparing for a Series A needs to model 36-month revenue projections for investors. The calculator shows that at current 3.2% monthly churn and 18% monthly new subscriber growth, ARR hits $1.2M by month 24. Reducing churn to 1.5% (the investor benchmark target) moves ARR to $1.8M at the same growth rate, illustrating that churn reduction is worth $600,000 in projected ARR to the business.

Pricing Tier Change Impact Modeling

A SaaS business increasing its base plan from $29 to $39/month models the revenue impact against expected churn from price-sensitive customers. The calculator shows that if 12% of subscribers churn due to the price increase, MRR still increases from $5,800 to $6,864 due to the 34% price increase on retained subscribers. This is the standard elasticity-versus-ARPU trade-off analysis.

Annual vs. Monthly Plan Mix Optimization

A subscription business with 70% monthly and 30% annual subscribers models shifting to 50% annual. Annual subscribers have 60% lower effective monthly churn than monthly subscribers. The calculator shows that shifting 100 monthly subscribers to annual plans reduces annualized subscriber churn from 36% to 21%, adding $4,200 in MRR stability within 12 months.

Comparison

SaaS SegmentMedian Monthly ChurnTarget NRRMedian ARPUBenchmark ARR Growth
Consumer / B2C5-8%>95%$5-$2525-40% YoY
SMB SaaS3-5%>100%$50-$20030-50% YoY
Mid-Market SaaS1.5-3%>105%$500-$2,00040-70% YoY
Enterprise SaaS0.5-1.5%>115%$5,000-$50,00030-50% YoY
Vertical SaaS2-4%>108%$200-$1,50035-60% YoY

Common Mistakes to Avoid

  • Forecasting subscriber growth linearly when acquisition channels are non-linear. Content marketing, SEO, and paid acquisition all have S-curve growth patterns. A model assuming flat 20 new subscribers/month for 12 months ignores that paid acquisition can scale quickly but also plateau or become uneconomical if CAC rises above LTV.

  • Not separating monthly churn into voluntary versus involuntary. Involuntary churn (failed payments) typically represents 20% to 40% of total churn and is recoverable through dunning emails and payment retry logic. Treating all churn the same leads to expensive acquisition spending when a dunning optimization would recover the same subscribers at near-zero cost.

  • Using gross revenue retention instead of net revenue retention to report growth. Gross Revenue Retention (GRR) only counts churn. Net Revenue Retention (NRR) adds expansion. A business with 95% GRR and 115% NRR is shrinking its existing customer base by count but growing revenue from it, which is the better health indicator for investors.

  • Applying an annual churn rate monthly by dividing by 12. Annual churn of 36% does not equal 3% monthly churn. The correct monthly churn rate for a 36% annual rate is 1 - (1 - 0.36)^(1/12) = 3.5%. The difference matters significantly in multi-year projections.

Frequently Asked Questions

Accuracy and Disclaimer

Subscription revenue forecasts generated by this calculator are estimates based on the inputs you provide and 2026 SaaS industry benchmarks from Openview Partners, ChurnZero, and Baremetrics. Actual revenue depends on product-market fit, market conditions, pricing elasticity, and execution. These projections are planning tools only and do not constitute financial advice or investor-grade financial modeling. Consult a qualified financial advisor or CFO for fundraising or board reporting purposes.

Conclusion

Subscription revenue forecasting is not linear math. It is a compounding system where churn and expansion fight each other month by month. A business with 3% churn and 2% monthly expansion MRR is growing faster than one with 1% churn and no expansion motion. Once you have your 12-month forecast, use the Churn Rate Calculator to drill into the cost of your current churn rate and what reducing it by 1% would mean for 3-year ARR, and the LTV to CAC Ratio Calculator to confirm that your customer acquisition costs are sustainable against the revenue lifetime each subscriber represents.