Lesson 8 of 10

Sensitivity tables and scenarios

Step 2 of 6

The idea

Sensitivity table: pick the two inputs that matter most, hold the rest fixed, and work out the value for every pair. Each cell is a full DCF.

Scenarios: whole stories, where the inputs move together (slow growth with price cuts, say). Lesson 02's Stories A and B are scenarios.

Weighting scenarios uses expected value (Module 2 lesson 05):

expected value = (bull weight × bull value) + (base weight × base value) + (bear weight × bear value)

The weights add up to 100%. They are your judgement, not facts, so show how the answer moves when they change.

Spreadsheet: with values in B2:B4 and weights in C2:C4, =SUMPRODUCT(B2:B4,C2:C4). For the grid, Excel's data table (one of the what-if tools on its Data tab) fills every cell from one model; or copy the model once per cell.