Sensitivity Analysis

What Is Sensitivity Analysis?

Sensitivity analysis tests how a financial result, valuation, risk measure, or decision changes when one or more input assumptions change. In finance, it is a practical way to identify which assumptions matter most and how fragile an outcome may be.

A model that barely changes when an input moves has low sensitivity to that input. A model that changes sharply has high sensitivity. That difference can affect valuation confidence, risk management, pricing, budgeting, and investment decisions.

How Sensitivity Analysis Works

A sensitivity analysis changes one input while holding others constant, then observes the result. A discounted cash flow model might test revenue growth, margins, discount rate, terminal growth, or capital spending. A mortgage affordability model might test interest rate, down payment, insurance, taxes, or income. A lending model might test default rate, recovery rate, or collateral value.

The goal is not to predict one perfect answer. The goal is to see where the decision is vulnerable. If a valuation depends almost entirely on a tiny change in terminal growth, the model may look precise while being highly fragile.

Common Sensitivity Examples

Sensitivity Versus Scenario Analysis

Sensitivity analysis usually changes one variable at a time. Scenario analysis changes several variables together to reflect a broader story, such as a recession, rate shock, supply-chain problem, or upside growth case. Both are useful, but they answer different questions.

Sensitivity asks, "Which lever matters?" Scenario analysis asks, "What happens if a realistic combination of conditions occurs?" A strong model often uses both because real-world inputs rarely move in isolation.

How It Matters Financially

Sensitivity analysis helps prevent false confidence. A spreadsheet can produce a single neat output, but the real decision may depend on a handful of uncertain assumptions. If a project's expected return collapses when costs rise 3%, management needs to know that before committing capital.

Investors use sensitivity to understand upside and downside. Lenders use it to test repayment capacity. Businesses use it to set pricing, budgets, and contingency plans. Households use it, often informally, when testing whether a mortgage payment, retirement plan, or education budget still works if rates, income, or expenses change.

Model Boundaries

Sensitivity analysis can create a false sense of control if the tested range is too narrow or the wrong inputs are chosen. It can also miss nonlinear effects. A small rate change may be manageable, while a larger one triggers covenant issues, refinancing failure, or customer churn.

The analysis should therefore include realistic ranges, stress cases, and judgment about how variables interact. Sensitivity analysis is a tool for thinking clearly, not a substitute for understanding the business or market.

Presentation also matters. A good sensitivity table should make the important ranges easy to see instead of burying the decision in dozens of small variations. The point is to improve judgment: which assumption deserves diligence, which risk needs a hedge, and which decision still works if the first forecast is wrong.

The Bottom Line

Sensitivity analysis measures how much financial outcomes change when assumptions change. It is one of the simplest ways to identify model fragility, key risks, and the assumptions that deserve the most attention.