Sensitivity Analysis
Testing how a financial model's outputs change when individual input assumptions are varied.
Sensitivity analysis examines how the outputs of a financial model (valuation, profitability, cash flow, returns) change in response to changes in individual input assumptions, holding all other variables constant. It identifies which assumptions most strongly drive model outputs, quantifies the range of possible outcomes, and highlights where additional analytical rigor or risk mitigation is most valuable.
In practice, sensitivity analysis is performed by systematically varying one input at a time across a range of values and recording the resulting output. For example, in a DCF valuation, sensitivity analysis might test the effect of varying the discount rate (8–14%) and terminal growth rate (1–4%) on the implied equity value, producing a sensitivity table showing value at every combination of these two variables.
Two-variable sensitivity tables ('data tables' in Excel) are standard in investment banking and corporate finance presentations, showing how a metric (EV/EBITDA, IRR, enterprise value) changes across two key variables simultaneously. This reveals whether the output is sensitive primarily to one variable, both equally, or neither (indicating the model is robust to assumption changes).
Sensitivity analysis is a stepping stone to scenario analysis (testing coherent combinations of variable changes that reflect specific business conditions—a recession scenario, a competitive disruption scenario) and Monte Carlo simulation (probabilistic analysis using many random draws from assumption distributions).
For CFOs and board presentations, sensitivity analysis demonstrates modeling integrity—it shows that key assumptions have been stress-tested and provides a realistic range of outcomes rather than false precision from single-point estimates. Investors expect to see key sensitivity tables accompanying any valuation or business projection.
FAQs
What is the difference between sensitivity analysis and scenario analysis?
Sensitivity analysis varies one input at a time while holding others constant, showing the isolated impact of each assumption on the output. Scenario analysis changes multiple related assumptions simultaneously to reflect coherent 'stories' about future business conditions—an upside scenario (higher growth, better margins, lower discount rate) or a downside scenario (slower growth, price pressure, higher funding costs). Sensitivity analysis asks 'what if this one thing changes?'; scenario analysis asks 'what if this whole set of things change together?' Scenarios are more realistic for planning because assumptions are correlated in the real world—economic downturns affect revenue, margins, and financing conditions simultaneously.
How do you identify which inputs to include in a sensitivity analysis?
The most important inputs for sensitivity analysis are those that: have the greatest mathematical impact on the output (identifiable through simple formula inspection—high-weight inputs in a DCF like discount rate and terminal value), carry the most uncertainty (inputs that are difficult to predict or highly variable historically), are under management control (and thus can be optimized), or have important strategic implications (market share assumptions, pricing assumptions). A well-designed sensitivity analysis typically includes 3–6 key variables that capture the majority of the model's output variability. Sensitivity to inputs that are either highly certain or mathematically insignificant adds noise without insight.
What is tornado chart analysis in sensitivity analysis?
A tornado chart is a visualization that ranks inputs by their relative impact on a model's output, with the most influential variables at the top (widest bars) and least influential at the bottom—creating a funnel or tornado shape. For each input, the chart shows how much the output changes when the input is varied by a standard amount (e.g., ±10% or ±1 standard deviation). The tornado chart quickly communicates which assumptions the model is most sensitive to, guiding where analytical effort and monitoring attention should be concentrated. It is commonly used in financial modeling, risk analysis, and project economics to communicate model sensitivity to executive audiences efficiently.
Related Terms
Scenario Planning
Developing multiple coherent narratives about future business conditions to prepare strategic responses.
Financial Modeling
Building quantitative representations of a company's finances to support decision-making and valuation.
Discounted Cash Flow
A valuation method that estimates the present value of a company or investment by discounting projected future cash flows at an appropriate rate.
Break-Even Analysis
Calculation of the sales volume at which total revenue equals total costs, generating zero profit.
