What Is Sensitivity Analysis? How to Interpret It

Search Fintrev

Search our guides, reviews and glossary.

Sensitivity analysis is a method for measuring how much a model’s output changes when one or more of its inputs change, while every other assumption is held constant. In finance, the output is usually a figure such as net present value, profit, earnings per share or a valuation, and the inputs are the assumptions behind it: sales volume, price, costs, interest rates, the discount rate or a growth rate. Because it asks “what happens to the result if this assumption is wrong?”, it is also called what-if analysis.

How Sensitivity Analysis Works

Every financial model rests on a base case: a set of input values the analyst considers most likely. Sensitivity analysis starts from that base case and changes inputs in a controlled way.

1. Build the base model. Define the output (for example, project NPV) and the inputs that feed it.
2. Choose the inputs to test, focusing on uncertain or large assumptions such as unit sales, selling price, operating costs or the discount rate.
3. Set the ranges, either fixed steps (for example, plus or minus 5%, 10% and 20%) or a realistic band of values.
4. Recalculate the output for each new value, keeping all other inputs at base-case levels.
5. Compare and rank the inputs by how far each moved the output.

A one-way analysis changes a single input. A two-way analysis changes two inputs at once and arranges the results in a grid, often called a sensitivity table or sensitivity matrix. In a discounted cash flow (DCF) model, the classic two-way table places the WACC along one axis and the terminal growth rate along the other, with the implied valuation in each cell.

Two simple formulas summarize the results:

• Sensitivity ratio: % change in output ÷ % change in input. A ratio of 3 means a 1% change in the input moves the output by about 3%.
• Sensitivity margin (common in capital budgeting coursework such as ACCA): NPV ÷ present value of the cash flows affected by the variable × 100. This gives the percentage by which that variable can worsen before NPV falls to zero.

Interpreting Sensitivity Analysis

The results answer three questions.

Which inputs matter most? Inputs with high sensitivity ratios or small margins are the key value drivers. A tornado chart, which shows the output range produced by each input as a horizontal bar sorted from widest to narrowest, makes this ranking visible at a glance.

How much room for error exists? A sensitivity margin of 3% means a small forecasting miss could turn an accepted project into a loss-making one. A margin of 40% means the decision holds even if the estimate is badly off.

Is the relationship linear? If doubling the change in an input more than doubles the change in output, the model contains nonlinear effects (discounting, operating leverage or thresholds), and small tested ranges can understate the risk at the extremes.

A high sensitivity does not mean an input is likely to change. It means the result depends heavily on it, so that assumption deserves the most research, monitoring or hedging.

Why Is Sensitivity Analysis Important?

Analysts and managers use it to:

• Identify value drivers and the variables to monitor once a project is under way.
• Catch errors in the base-case assumptions or formulas.
• Simplify the model by fixing or removing inputs that barely move the output.
• Communicate with decision-makers through a range of outcomes rather than a single point estimate.
• Set targets, such as the minimum sales or maximum cost a project needs to meet its goals.

Applications reach beyond capital budgeting. Bond analysts relate interest rates to bond prices, and equity analysts test how earnings, shares outstanding or leverage affect a share price estimate. Revenue sensitivity measures how sales respond to drivers such as price, customer traffic or conversion rates.

Example of Sensitivity Analysis

Hypothetical example for illustration. A company is considering a project that costs $1,000,000 today and is expected to generate $300,000 a year for five years. The base-case discount rate is 8%. Cash flows are assumed to arrive at year-end.

The five-year annuity factor at 8% is about 3.9927, so the present value of the cash flows is about $1,197,813 and the NPV is about $197,813.

Testing the discount rate (cash flows unchanged):

Testing annual cash flow (discount rate fixed at 8%): if cash flow falls 10% to $270,000, the present value drops to about $1,078,029 and NPV to about $78,029. A 10% fall in the input produced roughly a 60.6% fall in NPV, a sensitivity ratio of about 6.

Sensitivity margins:

• Cash flow: $197,813 ÷ $1,197,813 ≈ 16.5%. Annual cash flow can fall to about $250,457 before NPV reaches zero.
• Discount rate: NPV reaches zero at the project’s internal rate of return, about 15.2%, so the discount rate can rise roughly 7.2 percentage points before the decision flips.

Interpretation: the project tolerates a fairly wide error in the cost of capital, but it is far more exposed to the cash flow forecast. Management would spend its effort validating the revenue and cost assumptions behind that $300,000.

How to Do Sensitivity Analysis in a Spreadsheet

Keep every assumption in its own input cell and build the output formula by referencing those cells, never by typing values into the formula. In Excel, Data > What-If Analysis > Data Table runs one-way or two-way tables automatically. In Google Sheets, copy formulas across a grid. Goal Seek finds the break-even value of a single input directly.

Limitations of Sensitivity Analysis

• One variable at a time. Real inputs often move together. Higher inflation can raise both costs and the discount rate, which a one-way test ignores.
• No probabilities. It shows how much the output changes, not how likely each change is.
• Only as good as the model. Ranges usually come from historical data or judgment, and outcomes remain estimates.
• Complexity can obscure. Models with many variables and interactions can make it harder, not easier, to see which inputs truly matter.
• Arbitrary ranges. Testing every input at plus or minus 10% treats a volatile commodity price and a contracted rent as equally uncertain.

Sensitivity Analysis vs. Related Methods

Scenario analysis changes several inputs together to reflect a coherent event, such as a recession, a stock market crash or new industry regulation, and reports the result for that combined case. Sensitivity analysis isolates individual inputs to see each one’s effect.

Stress testing applies extreme but plausible shocks to check whether a firm or portfolio survives them.

Monte Carlo simulation assigns probability distributions to inputs and runs thousands of random combinations, producing a distribution of outcomes rather than a set of fixed points.

Break-even analysis finds the input level at which profit or NPV equals zero. Sensitivity margins are a form of break-even analysis applied to each variable.

Regression analysis estimates relationships between variables from historical data. Its coefficients can supply the input relationships that a sensitivity model then tests.

The Bottom Line

Analysts and managers weighing projects, valuations or share price estimates can use sensitivity analysis to find the assumptions their results depend on most. Inputs with high ratios or small margins deserve the most research, monitoring or hedging. One-way tests ignore inputs that move together and say nothing about likelihood, so the results rank exposure without predicting outcomes.