Lesson 4 of 8

How rates change valuations

Step 4 of 6

Do it yourself

Small and practical. Do it now while it is fresh.

About 15 minutes, in your Costco sheet from Module 10 lesson 10 (B5 8.6%; B25, value per share before the dividend, $426.47).

  1. In an empty cell, D2, type a risk-free rate: 0.0607, a point above 18 Nov 2026.
  2. 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%.
  3. Record B5, B25 and the terminal value's share (B22 ÷ B23). Repeat with D2 = 0.0407, then 0.0507 (back to $426.47).
  4. Try 0.0152, the end-2021 yield. Look at B5 − B6. Is the answer usable?
  5. 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.