Lesson 8 of 10

Sensitivity tables and scenarios

Step 3 of 6

Worked example

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:

  1. Every cell assumes the margin falls. Today's 66.1% is above the grid's top row, so even 60% is a decline.
  2. 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.
  3. 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.