Logiciel Solutions Contact Us
Success Stories Tech News Investors Contact Us

Sensitivity Analysis.

Sensitivity analysis measures how much an outcome, like profit or cash, changes when one input assumption moves while everything else stays fixed.

01 / 09 Sensitivity Analysis

Definition

Sensitivity analysis is a way of testing how much an outcome in a financial model, profit, cash flow, valuation, changes when you move one input assumption up or down while holding every other assumption fixed. You take a model that already produces an answer under its current assumptions, change one input, say the price of a key raw material, and see how much the final result shifts. Do that across a range of values for that input and you get a picture of how sensitive the outcome actually is to that one assumption, which is where the name comes from.

The reason this matters is that every financial model rests on assumptions, and not all assumptions carry equal weight. Some inputs can be off by a wide margin and barely move the final number, while others can be off by a small amount and swing the outcome dramatically. Without sensitivity analysis, a team has no systematic way to tell which of its assumptions actually deserve careful scrutiny and which ones are safe to estimate roughly, so effort gets spent evenly across inputs instead of where it would help most.

What separates a real sensitivity analysis from a vague gut feeling about which assumptions matter is that it isolates one variable at a time and changes it by defined amounts, rather than mentally waving at the idea that costs are uncertain. A model that changes several inputs together to see what happens is doing something closer to scenario planning. Sensitivity analysis, done properly, holds everything constant except the one variable being tested, which is exactly what makes it useful for pinpointing which specific assumption is driving the risk in a plan.

By 2026, sensitivity analysis is a routine part of financial modeling in FP\&A, corporate development, and investment analysis, built into planning software as a standard feature rather than something an analyst has to construct by hand every time. What has changed is less the concept, which is decades old, and more the ease of running it, tornado charts and automated variable sweeps that used to take an afternoon of manual spreadsheet work now take a few clicks in most modern planning tools.

This page covers how sensitivity analysis actually works, how it compares to scenario planning, what separates it from Monte Carlo simulation, and where it earns its keep versus where it falls short. The idea to hold onto is that sensitivity analysis does not tell you what will happen, it tells you which of your assumptions matter enough that being wrong about them would actually change your decision, and that distinction is worth more than most people give it credit for.

Key Takeaways

  • Sensitivity analysis measures how much an outcome changes when one input assumption moves, with everything else held fixed.
  • It exists because not every assumption in a model matters equally, and it identifies which ones deserve real scrutiny.
  • A genuine sensitivity analysis isolates one variable at a time, unlike scenario planning, which moves several variables together to tell a coherent story.
  • By 2026 it is a routine, largely automated feature of financial modeling rather than a manual exercise built from scratch.
  • It does not predict what will happen; it identifies which assumptions matter enough that being wrong about them would change the decision.

How Sensitivity Analysis Works

The starting point is always an existing model that produces some outcome, net income, free cash flow, an enterprise value, under a defined set of assumptions. The analyst picks one input in that model, a growth rate, a cost per unit, a discount rate, and changes it across a defined range, often plus or minus some percentage from the base case, while every other input in the model stays exactly where it was.

For each value in that range, the model recalculates and produces a new outcome, and plotting the input values against the resulting outcomes shows how steep or flat that relationship is. A steep line means the outcome is highly sensitive to that input, small changes move the result a lot. A flat line means the outcome barely cares what that input does, which is useful information in its own right because it tells you not to worry about getting that particular number exactly right.

Doing this across several inputs one at a time, rather than just one, produces the classic tornado chart, a horizontal bar chart ranking inputs by how much they move the outcome, with the most influential variable's bar at the top. This visual makes it immediately obvious which handful of assumptions are actually driving the model's result and which ones are along for the ride, which is often a surprise to people who built the model and assumed a different input mattered most.

The final step, often skipped by teams in a hurry, is deciding what to do with the ranking. The variables at the top of the tornado chart are the ones worth spending more time validating, getting a better estimate, checking against external data, or building a real scenario around, while the variables at the bottom can reasonably be left as rough estimates without much risk to the overall conclusion.

Sensitivity Analysis Compared to Scenario Planning

Scenario planning changes several variables at once to describe a coherent, plausible version of the future, a recession scenario where demand, pricing, and cost all shift together in a way that tells a consistent story. Sensitivity analysis changes exactly one variable while holding the rest constant, which is a narrower, more mechanical question about the relationship between a single input and the outcome.

The two serve different purposes even though both involve changing assumptions. Sensitivity analysis answers which assumptions matter most, useful for deciding where to focus modeling effort and due diligence. Scenario planning answers what should we do if a particular combination of changes actually happens, useful for making decisions ahead of an uncertain future. Neither one substitutes for the other, and a mature planning process usually runs both.

In practice they connect directly: sensitivity analysis is often the tool that identifies which variables are worth building a full scenario around in the first place. If a tornado chart shows that a company's outcome is highly sensitive to one customer's renewal and barely sensitive to a dozen smaller cost line items, that is a strong signal to build a scenario specifically around that customer's renewal rather than around the smaller costs nobody needs to worry much about.

The tradeoff is that sensitivity analysis, taken alone, can create a false sense of precision, since it only ever moves one variable while the real world moves several at once, and real risks often come from variables moving together in ways a one-at-a-time analysis will not reveal. Treating a clean tornado chart as the whole risk picture, rather than as an input into deciding what to scenario-plan for, is a common overreach.

What Makes Sensitivity Analysis Different From Monte Carlo Simulation

Sensitivity analysis moves one variable at a time across a defined range and shows how the outcome responds to each. Monte Carlo simulation takes a different approach entirely: it assigns a probability distribution to several uncertain inputs at once, then runs the model thousands of times with randomly sampled combinations of those inputs, producing a full distribution of possible outcomes rather than a single line showing sensitivity to one variable.

The distinction matters because they answer different questions. Sensitivity analysis tells you which single assumption matters most. Monte Carlo simulation tells you the range and likelihood of outcomes when several uncertain variables interact simultaneously, which is a richer but heavier question to answer, and one that requires you to actually define probability distributions for your inputs rather than just picking a plus-or-minus range to test.

Sensitivity analysis is quicker to run and easier for a non-technical audience to understand, a chart showing that revenue growth matters more than input cost is intuitive at a glance. Monte Carlo output, a probability distribution of outcomes with percentiles attached, takes more explaining and more trust in the underlying assumptions about how each variable is distributed and how the variables relate to each other, which is harder to get right than it looks.

In practice, sensitivity analysis is often the first pass, quick, cheap, easy to communicate, that identifies which variables are worth the heavier investment of building proper probability distributions for a Monte Carlo simulation. Running a full simulation on every input in a model, most of which barely affect the outcome, wastes effort that sensitivity analysis would have told you not to spend in the first place.

Where Sensitivity Analysis Fits and Where It Does Not

Sensitivity analysis fits well any time a decision rests on a model with several uncertain inputs and you need to know which of them actually matters, a valuation, an investment case, a pricing decision, a budget with a few genuinely uncertain cost lines. It is cheap to run and gives an immediate, concrete answer to a question that otherwise gets settled by whoever argues loudest in a planning meeting.

It also fits well as a communication tool with executives or investors who need to understand risk without wading through a full model. A tornado chart showing that an investment's return depends heavily on one assumption and barely on several others gives a decision-maker a fast, honest read on where the real risk sits, which is often more persuasive than a single point estimate presented with false confidence.

It fits poorly when the real risk in a situation comes from several variables moving together, not from any one variable in isolation. A downturn that hits revenue, cost, and financing terms all at once is not well captured by testing each one separately, since the combined effect of correlated changes can be much worse than the sum of the individually tested effects, and sensitivity analysis will not reveal that on its own.

It also fits poorly as the sole basis for a major, irreversible decision. Sensitivity analysis is a diagnostic tool that tells you where to look harder, not a complete risk assessment. Treating a clean tornado chart as proof that a decision is safe, without also thinking through combined scenarios or worse, ignoring the variables that turned out to matter most, is a mistake that shows up after the decision is already made and hard to undo.

How to Do Sensitivity Analysis Well

Choose a sensible range for each variable rather than an arbitrary flat percentage applied to everything. A ten percent swing might be realistic for a stable cost line and wildly understated for a volatile input like a commodity price, so basing the range on actual historical variation or informed judgment gives a far more honest picture than applying the same rule of thumb to every input in the model.

Test the variables that are genuinely uncertain, not the ones that are easy to test. It is tempting to run sensitivity on inputs that are simple to vary in a spreadsheet, while the assumption that actually carries the most real-world uncertainty, say a competitor's pricing response, gets skipped because it is harder to model cleanly. The value of the exercise depends on testing the right variables, not the convenient ones.

Build and read the tornado chart rather than stopping at individual sensitivity tables for each variable. A ranked view across all the tested inputs is what actually tells you where to focus, and skipping that step leaves you with a pile of individual charts and no clear sense of which one matters most relative to the others.

Use the results to decide where to spend more analytical effort, not to declare the model finished. The variables at the top of the tornado chart deserve a second look, better data, an outside opinion, a scenario built specifically around them, while the ones at the bottom can be left as reasonable estimates. Skipping this follow-through wastes most of the value the analysis just created.

Remember what the analysis is not telling you. Sensitivity analysis holds all other variables constant, which is a simplification, not a description of how the real world behaves. Pair it with scenario planning or, where the situation warrants the extra effort, a Monte Carlo simulation when the real risk comes from several things moving together rather than any single variable in isolation.

Best Practices

  • Base the tested range for each variable on real historical variation or informed judgment rather than an arbitrary flat percentage applied to everything.
  • Prioritize testing the variables that carry genuine real-world uncertainty rather than the ones that happen to be easy to vary in the model.
  • Build a ranked tornado chart across all tested variables instead of reviewing each sensitivity result in isolation.
  • Use the ranking to direct further analysis, better data, outside review, a full scenario, toward the variables that matter most.
  • Pair sensitivity analysis with scenario planning or simulation when the real risk comes from several variables moving together, not one at a time.

Common Misconceptions

  • Sensitivity analysis is not a forecast; it does not predict what will happen, only how much the outcome would move if one assumption were different.
  • It is not the same as scenario planning, which changes several variables together to tell a coherent story rather than isolating one at a time.
  • It is not the same as Monte Carlo simulation, which models probability distributions across multiple variables rather than testing one variable across a fixed range.
  • A clean-looking tornado chart is not a complete risk assessment, since it misses risk that comes from variables moving together rather than in isolation.
  • It is not only useful for large, complex models; even a simple budget benefits from knowing which of its few assumptions actually matter most.
Keep exploring

Related terms.

Questions

Frequently asked.

What is sensitivity analysis in finance?

Sensitivity analysis is a method for testing how much a financial outcome, like profit or valuation, changes when one input assumption is varied while every other assumption stays fixed, which shows which assumptions actually matter most to the result.

What is a tornado chart?

A tornado chart is a horizontal bar chart that ranks a model's input variables by how much each one moves the outcome when tested individually, with the most influential variable's bar at the top, making it easy to see at a glance which assumptions matter most.

How is sensitivity analysis different from scenario planning?

Sensitivity analysis changes one variable at a time while holding everything else constant, answering which assumption matters most. Scenario planning changes several variables together to describe a coherent, plausible future and pairs it with a decision, answering what to do if that future happens.

How is sensitivity analysis different from Monte Carlo simulation?

Sensitivity analysis tests one variable across a defined range. Monte Carlo simulation assigns probability distributions to multiple variables and runs the model thousands of times with randomly sampled combinations, producing a full range of possible outcomes rather than a single sensitivity relationship.

What variables should you test in a sensitivity analysis?

Test the variables that carry genuine real-world uncertainty, revenue growth, key costs, pricing, rather than the ones that happen to be easiest to change in the spreadsheet. The value of the exercise depends on testing assumptions that could plausibly be wrong, not convenient ones.

What does it mean if an outcome is highly sensitive to a variable?

It means small changes in that input produce large changes in the outcome, so getting that specific assumption right matters far more than getting a less sensitive variable right. It signals where to focus additional data gathering, validation, or scenario planning.

Can sensitivity analysis be wrong or misleading?

It can mislead if treated as a complete risk picture, since it only tests one variable at a time and misses risk that comes from several variables moving together, such as a downturn hitting revenue, cost, and financing terms all at once.

Is sensitivity analysis still relevant with more advanced tools available?

Yes. It remains useful as a fast, easy-to-communicate first pass that identifies which variables deserve heavier analysis, and it often precedes more advanced tools like Monte Carlo simulation rather than being replaced by them.

Next step

Put Sensitivity Analysis into practice.

If you're building this into a real product - governed, secured, and scaled - we can help. Talk to the engineers who ship it.

Book an Intro Call