Sensitivity tables
Two assumptions at once, without a data table.
By Surojit Chakraverti, founder of L3VLUP and an investor running a long-short healthcare and technology equities strategy.
On this subject: sensitivity tables.Updated 30 September 2026
What it does
A grid that shows an output for every pair of two assumptions: share price against discount rate and growth, or MOIC against entry and exit multiple. Spreadsheets offer a data-table feature for this; the models here write each cell as a formula instead, so that the arithmetic is visible, the grid recalculates on its own, and the centre cell can be checked against the main sheet.
Where it lives
The same schedule in each model that carries it, with the rows to open. Open a model in the browser, go to the sheet, and click the lines.
- Sensitivity, rows 5–7: WACC step, Terminal growth step, Exit multiple step
- Sensitivity, rows 10–15: Terminal growth, WACC -2 step, WACC -1 step, WACC (base) step…
- Sensitivity, rows 18–25: Exit multiple, WACC -2 step, WACC -1 step, WACC (base) step…
- Sensitivity, rows 5–6: Multiple step, Exit year (across)
- Sensitivity, rows 9–13: Exit multiple -2 step, Exit multiple -1 step, Exit multiple (base) step, Exit multiple +1 step…
- Sensitivity, rows 16–20: Exit multiple -2 step, Exit multiple -1 step, Exit multiple (base) step, Exit multiple +1 step…
- Sensitivity, rows 23–30: Exit multiple, Entry multiple -2 step, Entry multiple -1 step, Entry multiple (base) step…
- Sensitivity, rows 5–7: Premium step, Stock mix step, Synergy step
- Sensitivity, rows 10–15: Stock mix, Premium -2 step, Premium -1 step, Premium (base) step…
- Sensitivity, rows 18–25: Run-rate synergies, Premium -2 step, Premium -1 step, Premium (base) step…
What a reviewer looks for
- A data table whose row and column inputs point at the wrong cells.
- A grid whose centre does not match the model, which means one of the two is stale.
- Steps so small that every cell says the same thing.
Learn it, then build it
Build · Lab · ~15 min
DCF Builder
Build a DCF by hand from revenue to a share price, know how much of it sits in the terminal value, and name the one assumption the answer hinges on.
Build · Lab · ~3 min
IRR by Eye
Say the IRR for any multiple and hold before the interviewer finishes the sentence, and the multiple for any IRR.
Read · Guide · 10 min
Scenario and Sensitivity Architecture: Building a Model That Can Be Stress-Tested
Read · Guide · 12 min
How to Build a DCF Model: Build Order, Terminal Value and the Sanity Checks