Lesson 3 of 10

Forecasting revenue and margins

Step 2 of 6

The idea

Four pieces:

  • Base year: the last full year of actual figures you start from.
  • Growth fade: fast growth slows as a company gets bigger, so step the growth rate down year by year towards a long-run pace.
  • Target margin: the operating margin (operating income ÷ revenue, Module 6) you expect the business to settle at. Move towards it in equal steps.
  • Base rates: what similar companies, and this company, have actually done. Check every assumption against them.

In words, for each forecast year:

revenue          = last year's revenue × (1 + growth rate)
operating income = revenue × operating margin

Spreadsheet, one row per year: revenue in column B, growth in C, margin in D, operating income in E. Row 2 is the base year; for row 3, then fill down:

B3: =ROUND(B2*(1+C3),0)     revenue
D3: =D2-0.002               margin, stepping down 0.2 points a year
E3: =ROUND(B3*D3,0)         operating income

Base rates: why 20% for ten years is a big claim

Growth compounds. 20% a year for 10 years multiplies revenue by 1.20¹⁰ = 6.19. For Apple that would mean $478.8B × 6.19 ≈ $2,965B of yearly revenue, more than six times today's. Apple's own revenue grew 5.5% a year over the last five years. Before you forecast fast growth for a giant, ask what would have to be true.