About 15 minutes, in your Costco sheet from Module 10 lesson 10 (B5 8.6%; B25, value per share before the dividend, $426.47).
- In an empty cell, D2, type a risk-free rate: 0.0607, a point above 18 Nov 2026.
- Replace B5's 8.6% with that lesson's Step 4 built from D2:
=ROUND(0.987*(D2+0.81*0.0441)+0.013*(D2+0.004)*(1-0.247),3)(beta 0.81, debt at D2 plus the 0.40% spread, after tax). Leave B6 at 4%. - Record B5, B25 and the terminal value's share (B22 ÷ B23). Repeat with D2 = 0.0407, then 0.0507 (back to $426.47).
- Try 0.0152, the end-2021 yield. Look at B5 − B6. Is the answer usable?
- In your own company's sheet, if you built it, repeat with its beta and spread and write: "a 1-point rise in the 10-year moves my value by __%."
Show answer (Module 10 lesson 10's inputs, 20 Nov 2026)
| D2 | B5 | B25 | From terminal value |
|---|---|---|---|
| 6.07% | 9.6% | $353.70 (−17.1%) | 80.9% |
| 5.07% | 8.6% | $426.47 | 84.0% |
| 4.07% | 7.6% | $539.84 (+26.6%) | 87.2% |
| 1.52% | 5.0% | $1,898.97 | 96.3% |
A point moves Apple's model only −12.5% / +16.7% (Module 10 lesson 05's 11.9% and 9.9%). Costco's cost of capital sits 4.6 points above growth (Apple's 6.9) and more of its value is terminal: longer duration.
Step 4: B5 − B6 is 1.0 point, so the terminal value is 100 times the final year's cash. That's the formula blowing up, not a valuation; 4% growth isn't credible here. With B6 at 1.52%, inside Module 10 lesson 06's ceiling, the value is $686.11.
Next lesson: The yield curve: short rates against long rates, and what an "inverted" curve has and hasn't told investors.