Revenue Forecasting: Build Projections That Survive Due Diligence
Last updated: February 10, 2026
The analyst circled the number. $12 million in year three. She asked where it came from. The founder pointed to the hockey stick chart and mentioned market growth. The analyst pushed harder. What customers? What churn rate? What acquisition cost supports that growth? The founder had no answers. The deal fell apart not because the projection was wrong, but because it was unsupported. Every number in a forecast needs a source, a reason, and a reality check.
Revenue forecasting combines two approaches. Top-down starts with market size and works down to your expected share. Bottom-up starts with individual customers and builds upward through acquisition and retention. When both approaches converge on similar numbers, your assumptions are consistent. When they diverge, something is off and you need to investigate.
This tool lets you build both forecasts side by side, compare them year over year, and identify gaps between market opportunity and operational capacity. Use it to prepare investor-ready projections and stress-test your assumptions before someone else does.
Inputs You Can Defend
Every forecast starts with assumptions. The difference between a credible forecast and a fantasy is whether those assumptions have sources. Investors, boards, and lenders will challenge your numbers. You need to be ready.
Market Size
Cite industry reports from recognized analysts (Gartner, Forrester, IBISWorld). Cross-reference multiple sources. If reports conflict, explain which you used and why. For niche markets, build your own estimate from Census data or public company filings.
Market Growth Rate
Use historical industry data plus analyst projections. High-growth markets (20%+) rarely sustain that pace for five years. If using aggressive growth rates, explain the drivers. Consider modeling declining growth in later years.
Customer Acquisition
Tie acquisition numbers to sales capacity. If you have two salespeople closing 10 deals per quarter each, you cannot project 200 new customers next year without explaining how. Marketing spend, conversion rates, and sales headcount must align.
Churn Rate
Use your actual churn if you have customers. Otherwise, use industry benchmarks: enterprise SaaS typically sees 5% to 10% annual churn, SMB runs 10% to 20%, and consumer subscriptions often exceed 30%. Explain why your product might beat or miss the benchmark.
Revenue Per Customer
Base this on your current pricing or competitive analysis. If projecting price increases or upsells, provide the rationale. Account for discounts, free trials, and payment failures that reduce effective revenue.
The Source Rule
Every number needs one of three things: historical data from your own business, a cited external source, or a clearly stated assumption with rationale. Unsourced numbers invite rejection.
Top-Down Forecast
Top-down forecasting answers a simple question: if the market is worth X dollars and you capture Y percent, what is your revenue? It starts big and filters down.
Top-down formula:
Revenue = Total Market Size x Your Market Share
Step 1: Size the market
Start with Total Addressable Market (TAM). Apply filters to get Serviceable Addressable Market (SAM) based on geography, customer type, or product fit. Your forecast uses SAM, not TAM.
Step 2: Project market growth
Apply growth rates year over year. A $500 million market growing at 12% becomes $560 million in year two, $627 million in year three. Use declining rates for mature markets.
Step 3: Estimate market share
New entrants typically capture 0.5% to 2% of SAM in year one. Share growth of 0.3 to 0.5 percentage points per year is aggressive but achievable with strong execution. Claims above 5% in year one require extraordinary justification.
| Year | Market Size | Your Share | Revenue |
|---|---|---|---|
| 1 | $500M | 1.0% | $5.0M |
| 2 | $560M | 1.4% | $7.8M |
| 3 | $627M | 1.8% | $11.3M |
Bottom-Up Forecast
Bottom-up forecasting builds from operational reality. Instead of market share, you model individual customers: how many you have, how many you acquire, how many you lose, and how much each pays.
Bottom-up formula:
Revenue = (Existing Customers - Churned + New) x Average Revenue Per Customer
Model by segment
Enterprise, mid-market, and SMB customers behave differently. Enterprise has higher revenue and lower churn. SMB has lower revenue but faster acquisition. Model each segment separately and sum the totals.
Apply churn first
Start-of-year customers times churn rate equals customers lost. Subtract churned customers from the starting count before adding new customers. This models real subscription dynamics.
Account for acquisition growth
New customer acquisition grows as you add sales capacity, marketing budget, and brand awareness. Model acquisition growth separately from revenue per customer growth.
Segment Example
- Enterprise: 25 customers, $80,000 ARPC, 8% churn, 12 new per year
- Mid-Market: 80 customers, $24,000 ARPC, 12% churn, 35 new per year
- SMB: 200 customers, $6,000 ARPC, 18% churn, 90 new per year
Update Cadence
Forecasts are not set-and-forget documents. They require regular updates as you learn from actual performance and market changes. The question is how often.
| Frequency | What to Update | Best For |
|---|---|---|
| Monthly | Actual vs forecast comparison, near-term projections | Early-stage, high-growth businesses |
| Quarterly | All assumptions, churn rates, acquisition rates | Growth-stage with board reporting |
| Annually | Market size, competitive landscape, pricing | Mature, stable businesses |
Rolling Forecast Method
Instead of annual forecasts that grow stale, use rolling 12-month or 18-month forecasts. Each quarter, drop the completed quarter and add a new one to the end. This keeps projections current and actionable.
Variance Analysis
When actual results differ from forecast, investigate why. Was churn higher than expected? Did acquisition slow? Document the variance and adjust future assumptions accordingly. Patterns in variance reveal where your model is weak.
Worked Examples
Example 1: B2B Cybersecurity Startup
Top-down inputs: Endpoint security market at $18.5 billion (Gartner 2025), growing 11% annually. Targeting mid-market segment worth $4.2 billion. Starting at 0.4% share, adding 0.3pp per year.
Year 1: $4.2B x 0.4% = $16.8M. Year 2: $4.66B x 0.7% = $32.6M. Year 3: $5.18B x 1.0% = $51.8M.
Bottom-up inputs: 45 enterprise customers at $85,000 ARPC (6% churn), 110 mid-market at $28,000 ARPC (11% churn). Adding 18 enterprise and 48 mid-market new customers per year with 25% acquisition growth.
Year 1 bottom-up: Enterprise (45 x $85K) + Mid-market (110 x $28K) = $3.83M + $3.08M = $6.9M. Year 3 projection: $18.4M. Gap with top-down ($51.8M vs $18.4M) signals that market share assumptions need revisiting or sales capacity must scale 3x.
Example 2: E-commerce Subscription Box
Top-down inputs: Subscription box market at $32 billion (McKinsey), growing 14% annually. Pet supplies vertical worth $2.1 billion. Starting at 0.8% share, adding 0.4pp per year.
Year 1: $2.1B x 0.8% = $16.8M. Year 2: $2.39B x 1.2% = $28.7M. Year 3: $2.73B x 1.6% = $43.7M.
Bottom-up inputs: 4,200 subscribers at $42 monthly ($504 annual), 28% annual churn. Acquiring 350 new subscribers monthly with 15% growth in acquisition rate per year.
Year 1 bottom-up: Start 4,200, churn 1,176, add 4,200, end 7,224 subscribers. Average during year ~5,700 subscribers x $504 = $2.9M. Year 3 projection: $8.2M. Closer alignment suggests assumptions are operationally grounded, though expansion may require aggressive marketing.
Sources
For Educational Purposes Only - Not Financial Advice
This calculator provides estimates for informational and educational purposes only. It does not constitute financial, tax, investment, or legal advice. Results are based on the information you provide and current tax laws, which may change. Always consult with a qualified CPA, tax professional, or financial advisor for advice specific to your personal situation. Tax rates and limits shown should be verified with official IRS.gov sources.