Nvidia, value per share. Inputs checked against Nvidia's filings on 20 Nov 2026. Fixed for every cell:
- Start: revenue $361.8B, operating margin 66.1% (twelve months to 25 Oct 2026, lesson 02).
- Tax rate 15.1%: fiscal 2026 income tax $21,383M ÷ pre-tax income $141,450M (10-K, year to 25 Jan 2026).
- Cost of capital 10.0%, between Story A's 9.8% and Story B's 10.5%. Sales-to-capital 1.1, between the stories' 1.2 and 1.0.
- Growth is the same each year for five years; the margin moves in equal steps from 66.1% to the year-5 target.
- Long-run growth 4%, with the final year built by lesson 06's recipe.
- Net cash $21.1B: cash $29.1B + marketable debt securities $24.4B − long-term debt $32.4B, at 25 Oct 2026 (17 Nov 2026 release, as in Module 9 lesson 04, leaving out equity stakes). Shares: 24.186B diluted, same release.
The middle cell, 15% growth a year with the margin falling to 50%, gives $157.65 a share; 80% of it is terminal value.
Optional: that cell, worked in full
The margin steps down (66.1 − 50) ÷ 5 = 3.22 points a year. $ in billions.
| Year 1 | Year 5 | Final year | |
|---|---|---|---|
| Revenue | 416.1 | 727.7 | 756.8 |
| Operating margin | 62.9% | 50.0% | 50.0% |
| After-tax operating profit | 222.0 | 308.9 | 321.2 |
| − Reinvestment (revenue increase ÷ 1.1) | 49.3 | 86.3 | 26.5 |
| = FCFF | 172.7 | 222.6 | 294.7 |
present value of years 1–5 = 741.5
terminal value = 294.75 ÷ (0.10 − 0.04) = 4,912.5; today: 4,912.5 ÷ 1.10^5 = 3,050.3
firm value = 741.5 + 3,050.3 = 3,791.8; equity = 3,791.8 + 21.1 = 3,812.9
per share = 3,812.9 ÷ 24.186 = $157.65
Reinvestment drops from 86.3 to 26.5 because growth drops from 15% to 4%. Copy year 5's FCFF forward instead, and the cell gives $130.57: for a fast grower, lesson 06's recipe matters. The script uses unrounded inputs (tax 15.117%); at exactly 15.1% this cell gives $157.69.
The grid
Value per share ($). Year-5 margin down the side, yearly revenue growth across the top.
| Margin | 5% | 10% | 15% |
|---|---|---|---|
| 40% | 89 | 106 | 126 |
| 45% | 99 | 119 | 142 |
| 50% | 109 | 132 | 158 |
| 55% | 120 | 144 | 174 |
| 60% | 130 | 157 | 190 |
| Margin | 20% | 25% |
|---|---|---|
| 40% | 149 | 177 |
| 45% | 169 | 201 |
| 50% | 188 | 225 |
| 55% | 208 | 249 |
| 60% | 228 | 272 |
Price at the 19 Nov 2026 close: $145.98. Bold cells are above it.
What the grid shows:
- Every cell assumes the margin falls. Today's 66.1% is above the grid's top row, so even 60% is a decline.
- Both inputs matter, and growth is worth more at high margins: across the 40% row the value moves $88; across the 60% row, $142. Down a column it moves $41–96.
- 14 of the 25 cells sit above the price, including the middle one. All 11 below it assume growth of 15% a year or less. Between 71% and 86% of each value is terminal value.
Reading the gap. Here the method comes out above the price in more than half the grid, as Damodaran's published valuation does ($199.49, lesson 02): a DCF can land above a price as well as below. The template's own choices can move a value by about 15% (lesson 07), so the middle cell, 8% above the price, says "near the price", no more. And five years of fast growth then 4% is short for a business the market may expect to grow fast for longer (Damodaran's model runs ten). Lesson 09 asks what the price itself needs.
Scenarios and weights
Same method, each story's own inputs (lesson 02):
| Scenario | Inputs | Value per share |
|---|---|---|
| Bull: Story A | 35%, then 20% a year; margin to 60%; sales-to-capital 1.2; 9.8% | $267.10 |
| Base: the grid's middle | 15% a year; margin to 50%; 1.1; 10.0% | $157.65 |
| Bear: Story B | 15%, then 3% a year; margin to 40%; 1.0; 10.5% | $83.45 |
Weights are my judgement:
| Weights (bull / base / bear) | Expected value per share |
|---|---|
| 25% / 50% / 25% | 0.25 × 267.10 + 0.50 × 157.65 + 0.25 × 83.45 = $166.46 |
| 40% / 40% / 20% (more hopeful) | $186.59 |
| 10% / 40% / 50% (more fearful) | $131.50 |
Tilting the weights moves the answer $20 up or $35 down, either side of the price. The outcome won't be the expected value itself (Module 2); these numbers show which assumptions the answer rests on.