Sensitivity Analysis (Valuation)
Sensitivity Analysis in valuation tests how a model's output — typically enterprise value or share price — changes as individual input assumptions are varied one at a time, revealing which drivers have the greatest impact and the range of plausible outcomes.
No financial model is certain. Revenue growth rates, operating margins, WACC, terminal growth rates, and exit multiples are all estimates, each carrying uncertainty. Sensitivity analysis systematically maps how those uncertainties translate into valuation uncertainty, allowing analysts and investors to understand both the magnitude of key risks and the model's practical reliability.
The most common format is a two-variable data table, often called a 'sensitivity matrix.' A DCF model for a US retailer might present a grid where rows represent WACC varying from 7% to 10% and columns represent terminal growth rates from 1.5% to 3.5%. Each cell shows the implied enterprise value or per-share price for that combination of assumptions. The analyst highlights the cell corresponding to the base-case assumptions and shades cells green or red to show the range of outcomes.
In practice, the choice of which variables to sensitize is as important as the mechanics. For capital-intensive businesses like Boeing or Caterpillar, revenue and EBITDA margin assumptions drive the widest range of outcomes. For highly leveraged companies, the terminal growth rate and WACC spread — which affect how quickly the debt burden is relativized by cash flows — dominate. For asset managers or insurance companies, AUM growth and fee margin compression are the critical sensitivities.
A common pitfall is using sensitivity analysis to create a false sense of precision by presenting a narrow range that reflects only minor input variation. If the 'reasonable range' for WACC is 7-9% but the analyst presents only 7.8-8.2%, the sensitivity table understates risk. Conversely, using absurdly wide ranges (WACC from 5-15%) produces a range so large as to be analytically useless.
Sensitivity analysis complements but does not replace scenario analysis. While sensitivity analysis moves one or two variables at a time, scenario analysis constructs fully self-consistent alternative futures (bull, base, bear cases) where multiple variables shift simultaneously in coherent combinations. Robust valuation work typically employs both techniques, using sensitivity analysis to identify the most critical drivers and scenario analysis to explore how those drivers interact under different economic environments.