Unit 3 · Unit 3: Revenues

Revenues

The top line drives everything below it. Learn to build revenue bottom-up, top-down, or by growth rates — and to fade it honestly to a rate that can last forever.

What you'll learn

  • Explain why revenue is the single most important and most uncertain line in a model, and how errors there cascade through every statement.
  • Build a revenue forecast bottom-up (volume × price, units, segments) and recognise when that granularity is worth the effort.
  • Build a revenue forecast top-down (market size × market share) and use it as an independent sanity check.
  • Apply growth-rate methods and fade an opening growth rate to a sustainable terminal rate over an explicit horizon.
  • Sanity-check a revenue forecast against reported history, management guidance, and Wall Street consensus.
  • Use the tool's multi-model growth engine, terminal fade, and event factors to triangulate a defensible top line.

Beyond the spreadsheet

  • The engine fits MULTIPLE revenue-growth models to the SEC EDGAR history and applies a terminal fade automatically, so you compare fitted trajectories instead of guessing a single number.
  • The Factors tab and Market Intel triangulate Wall Street consensus from several sources, giving you an external check the Excel course never provides.
  • AI-clustered news EVENT FACTORS are overlaid onto projected revenue and EPS, so discrete catalysts — a product launch, a recall, a price hike — can be reflected on top of the trend.

Why revenue is king — and the riskiest guess in the model

Revenue sits at the top of the waterfall, so its error propagates into every line below it.

Revenue is the first line of the income statement and the foundation of the entire forecast. Costs are frequently modelled as a percentage of revenue, working capital scales with revenue, and capex is often sized to support a revenue level. Get the top line wrong and every downstream number inherits the error — margins, free cash flow, and ultimately the valuation. This is why analysts spend more time on revenue than on any other single assumption.

It is also the line you know least about. Margins and tax rates are relatively stable and mean-reverting; revenue depends on demand, competition, pricing power, and the macro cycle — none of which you control. A disciplined modeller treats the revenue forecast as a range of defensible outcomes, not a point estimate, and is explicit about the assumptions driving it.

Garbage in, garbage everywhere Because so many other lines are anchored to revenue, a 2% error in your growth rate is never just a 2% error in revenue — it compounds across the horizon and is magnified in the terminal value, where most of a DCF's worth usually sits.

Three families of revenue forecasting

  • Bottom-up: build revenue from operational units — volume × price, stores × sales per store, subscribers × ARPU, or by product segment.
  • Top-down: start from the total addressable market and apply a market-share assumption.
  • Growth-rate: apply a percentage growth rate to last period's revenue, usually fading over time toward a sustainable terminal rate.

Bottom-up vs. top-down

Two independent routes to the same number — the best forecasts reconcile both.

Bottom-up forecasting builds revenue from the operational drivers of the business. You forecast the quantity sold and the price, then multiply and sum across products or segments. It is the most credible approach when you understand the unit economics — units shipped, subscriber counts, same-store sales, average revenue per user — because each driver can be defended on its own.

Revenue = Σ (Volume_i × Price_i) for each product or segment iForecast volume and price separately for each line of business, then sum. This separates a pricing thesis from a volume thesis.

Top-down forecasting works in the opposite direction: estimate the size of the total addressable market (TAM), assume how it grows, and apply a market-share assumption to land on the company's revenue. It is most useful for early-stage or fast-changing markets where unit economics are unstable, and as an independent cross-check on a bottom-up build.

Revenue = Total Addressable Market × Market ShareIf your top-down and bottom-up numbers disagree wildly, you have learned something — go find out which assumption is wrong.

ApproachBest whenWatch out for
Bottom-upYou understand unit economics (units, price, segments)Spurious precision; many small errors compounding
Top-downEarly-stage or fast-changing markets; cross-checksAn implausible market-share path; soft TAM estimates
Growth-rateMature, stable businesses; quick first passA flat rate that ignores fade and competition

Triangulate, don't pick The strongest revenue forecasts are built one way and checked the other. If a bottom-up build implies a market share the top-down lens says is impossible, the model is telling you to revisit your drivers before you defend the number.

Growth rates and the terminal fade

No company grows above the economy forever — fade your opening rate to a sustainable terminal rate.

The growth-rate method applies a percentage increase to the prior period's revenue. Its great danger is holding a high rate flat across the whole forecast. Competition, market saturation, and the law of large numbers all pull growth down over time. A credible forecast therefore fades the opening growth rate toward a sustainable terminal rate — a rate the company could in principle grow at forever.

Revenue_t = Revenue_(t−1) × (1 + g_t)g_t is the growth rate for period t — and g_t should generally decline as t increases.

g_t = g_start − (g_start − g_terminal) × (t / N)Fade the opening rate g_start to the terminal rate g_terminal linearly across the N-year horizon. Other shapes (exponential decay) are common too.

The terminal rate is a hard ceiling A terminal growth rate above long-run nominal GDP (roughly 2–4% in developed markets) implies the company eventually becomes larger than the whole economy. That is impossible, and reviewers will flag it instantly. Keep the terminal rate at or below long-run nominal GDP.

Sanity checks before you trust the number

  • Compare your forecast growth to the company's own recent historical CAGR — a sharp break needs a reason.
  • Check it against management's stated guidance and any long-term targets.
  • Compare it to Wall Street consensus; being far from the Street is fine, but you should know why.
  • Confirm the implied market share (top-down) and implied volumes (bottom-up) are physically plausible.

How the tool forecasts revenue

Multiple fitted growth models, an automatic terminal fade, and consensus plus event factors layered on top.

In The Cash Flow Projector you don't start from a blank growth assumption. When a model is seeded from SEC EDGAR history, the engine fits multiple revenue-growth models to that history and applies a terminal fade automatically, producing a default trajectory you can inspect and override on the Assumptions tab. You are choosing between defensible, fitted paths rather than typing a single hopeful number.

  1. On the Assumptions tab, find the revenue drivers and review the engine's default growth path and terminal rate.
  2. Adjust the opening growth rate or the terminal rate and watch the whole top line — and everything anchored to it — recalculate.
  3. Open the Factors tab to see triangulated Wall Street consensus alongside your forecast.
  4. Review the AI-clustered news event factors and consider whether any discrete catalyst should be reflected on top of the trend.
  5. Cross-check the resulting revenue and EPS trajectory against history and consensus before moving on.

Consensus and catalysts, built in The Factors tab and Market Intel triangulate consensus from several sources and overlay AI-clustered event factors onto projected revenue and EPS. This is the external, real-world check the Excel CFA course can't give you — your top line is tested against what the market and the news flow actually expect.

Override with intent The fitted default is a starting point, not a verdict. The skill the course is building is knowing when the history is a good guide and when a structural change — a new product cycle, a pricing reset, a recession — means you should override it.

Hands-on

  • Tune the revenue drivers and feel the cascade — See how changing the opening growth rate and terminal rate re-prices the entire model, and how the engine fades growth automatically. (Assumptions tab (revenue drivers))
  • Triangulate your top line against the Street — Compare your revenue/EPS forecast to triangulated consensus and decide whether any event factor belongs in the model. (Factors tab)