What you will learn
- Explain how sensitivity analysis tests one assumption at a time
- Read a two-way sensitivity table
- Build bull, base, and bear scenarios and see the range they produce
- Identify the key value drivers that deserve the most scrutiny
You have seen again and again that a DCF depends on uncertain assumptions and is highly sensitive to them. The mature response is not to abandon the model but to stop pretending it gives a single right answer. Scenario and sensitivity analysis are the tools that turn a fragile point estimate into an understanding of the range of possible values and what actually drives them. This is the practical answer to the humility from lesson one.
Scenario analysis in financial modeling (Corporate Finance Institute)
Shows how to build base, bull, and bear cases in a model. Watch how changing a set of assumptions together produces a range of values.
Sensitivity analysis: one input at a time
Sensitivity analysis asks how much the valuation changes when you vary a single assumption while holding the others fixed. You might recompute the value across a range of discount rates, or across a range of perpetual growth rates, and watch how far the answer moves. This reveals which inputs the valuation is most sensitive to, meaning which assumptions truly matter. Often a handful of inputs, typically the discount rate, the growth rate, and key margins, dominate the result, while others barely move it.
Key terms
- Sensitivity analysis
- Varying one assumption at a time to see how much the valuation moves.
- Two-way sensitivity table
- A grid showing the valuation across combinations of two key inputs.
- Scenario analysis
- Building complete, consistent sets of assumptions, such as bull, base, and bear cases.
- Key value driver
- An assumption that moves the valuation the most and so deserves the most scrutiny.
The sensitivity table
A common and powerful presentation is a two-way sensitivity table, which shows the valuation across combinations of two key inputs at once, for example a grid of discount rates against perpetual growth rates. At a glance it shows how the estimated value ranges from a pessimistic corner to an optimistic one, and how quickly it changes as the assumptions shift. It replaces a single number with an honest map of possibilities.
| Discount rate \ Growth | g = 2% | g = 2.5% | g = 3% |
|---|---|---|---|
| 9% | $95 | $105 | $118 |
| 10% | $82 | $90 | $100 |
| 11% | $72 | $78 | $86 |
Notice how much the value moves across the grid, from about 72 in the cautious corner to about 118 in the optimistic one. That spread is the honest answer, and it comes entirely from small changes in just two inputs.
Scenario analysis: coherent stories
Where sensitivity analysis changes one variable at a time, scenario analysis builds complete, internally consistent sets of assumptions that represent different futures. A typical structure uses three cases: a base case reflecting your central expectations, a bull case in which things go notably better, and a bear case in which they go notably worse. Each scenario adjusts several assumptions together into a coherent story, and each produces its own valuation. The result is a span of outcomes tied to recognizable narratives about how the business might unfold.
Sensitivity or scenario?
Match each description to the right technique.
A single valuation pretends to know the future. A range of scenarios admits you do not, and tells you what you are really betting on.
What you gain
- A realistic range of values rather than a single false-precision number, which is how intrinsic value should be expressed in the first place.
- A clear view of the key value drivers, the assumptions that move the valuation most and therefore deserve the most scrutiny.
- A sense of the downside as well as the upside, which feeds directly into how large a margin of safety you should demand.
- Better decisions, because the analysis makes explicit what must be true for the investment to work.
One and two-way sensitivity analysis with data tables
A hands-on demo of building sensitivity tables. Watch to see how the value shifts as each input changes.
Which assumption deserves the most attention?
You run a sensitivity analysis. Changing the tax rate barely moves your valuation, but changing the revenue growth rate swings it enormously. Where should you focus your research?
Focus on the key value driver, the assumption that moves the valuation the most. Here that is the revenue growth rate, so it deserves the deepest research.Sketch three cases
Pick a company and sketch, in a few sentences, what its bull, base, and bear cases might look like. What would go right in the bull case and wrong in the bear case? What is the investment really betting on?
Write an answer before comparing it with the model response.
Model answer
A good answer gives each case a coherent story. The base case reflects steady, expected performance. The bull case has several things go right together, such as faster growth, expanding margins, and a durable moat. The bear case has them go wrong together, such as slowing growth, price competition, and a shrinking moat. Naming the three cases makes clear what the investment is really betting on and how wide the range of outcomes is.
Looking ahead to probability
Scenario and sensitivity analysis are the gateway to a more advanced technique you will meet in the statistics unit, called Monte Carlo simulation, which assigns probability ranges to the uncertain inputs and generates thousands of possible valuations to produce a full distribution of outcomes. For now, the essential discipline is simpler and just as important: never trust a lone DCF number. Stress it, vary it, and understand the range, because that range is the honest answer.
You can now express a valuation as a range and find its key drivers. The next lessons handle harder cases, starting with companies that are really several businesses in one: sum-of-the-parts valuation.