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.