Part 1: one input (5 minutes)
Change B4 to Damodaran's industry sales-to-capital, 3.51. What happens to FY2027 reinvestment, FY2027 FCFF and the value per share before the dividend?
Show answers
FY2027 reinvestment = (330,438 − 303,154) ÷ 3.51 = 7,773; FCFF = 9,580 − 7,773 = 1,807. The final year's reinvestment rises too (2,615 → 4,843). Value per share falls to $325.91, down 24%. One input from a table moves the answer about $100 a share.
Part 2: your company (an hour or two the first time)
Build the same DCF for the company you've followed since Module 5, in a copy of your Costco sheet. There's no single right answer: use the ranges and the checklist.
| Cell | Replace with (source) | Sanity range |
|---|---|---|
| B1–B3 | Revenue, operating margin (over 3–5 years), tax rate, from the 10-K | margin near its history; tax 10–30% |
| B14:B18 | Growth: its own pace, guidance, Damodaran's growth table | fading to 4–6% by year 5 |
| B4 | Its revenue increase ÷ reinvestment over 3 years, or Damodaran's capex table | 0.5–7 |
| B5 | Lesson 05: Treasury + industry beta × current ERP, debt blended in | 7–12% |
| B6 | Keep 4% | below the Treasury; if it isn't, see Module 11 lesson 04 |
| B7–B9 | Cash, debt (balance sheet); diluted shares | — |
Sanity checks: FY2027 FCFF near last year's; terminal value 60–85% of firm value; value per share between a quarter and four times the price. Outside those, check units and shares first.
Then ask two questions. Is the gap bigger than the tool's own 15% (lesson 07)? If not, write "near the price, on these inputs". If it is, what would have to be true? Goal Seek B25 to the price by changing B2, then B5; turn the B5 answer into a beta ((B5 − 5.07%) ÷ 4.41%); compare each with the record (lesson 09).
Done when every input has a source and date beside it, each choice has a sentence of story (lesson 02), row 19 uses the recipe, the terminal value's share is shown, and both sentences are written.
When it fits badly. For banks and insurers, debt and reinvestment don't mean what this sheet assumes: pick another company, or compare price to book with return on equity (Modules 6 and 9). For a loss-maker, set a target margin and the year it's reached, and treat the answer as a wide range.
Next lesson: Interest rates are gravity, the first lesson of Module 11, Macro for investors: rates, inflation, cycles.