What Is Scenario Analysis?
Scenario analysis builds a small number of coherent stories about the future, each with its own full set of assumptions, and runs the model under every one. A base case might reflect management's plan, an upside case might assume faster revenue growth with margin expansion, and a downside case might layer a recession onto pricing pressure. The output is a range of valuations or returns tied to narratives an investment committee can debate.
The technique differs from sensitivity analysis, which flexes one input at a time while holding everything else constant. Scenarios move revenue growth, margins, capital spending, and exit assumptions together because those drivers move together in reality, so a downside case is more punishing and more realistic than any single-variable shock.
How Analysts Build Scenarios
In practice, a model carries a scenario toggle, often a single cell driving CHOOSE or INDEX formulas, that swaps entire assumption columns at once. Each case must be internally consistent: if the downside assumes a demand collapse, it should also assume weaker pricing, slower receivables collection, and a lower exit multiple rather than pairing recession revenue with peak-cycle margins. Cases are usually labeled base, upside or bull, downside or bear, and sometimes a management case taken directly from company projections.
Some teams go a step further and probability-weight the cases. Assigning a 50% chance to a $60 base case, 25% to an $80 upside, and 25% to a $35 downside implies a probability-weighted value of $58.75, and comparing that figure to the current price frames the risk-reward of the position.
Why It Matters in Banking and Investing
Lenders size debt against the downside case, not the base case, so LBO models must show that the company can service interest and amortization even when EBITDA falls 20% or more. Equity investors use scenario ranges to judge asymmetry: a stock with $5 of downside and $25 of upside is a very different bet from one with the reverse profile, even if both share the same base-case target.
For analysts, scenario work is where modeling skill becomes judgment. Anyone can flex a growth rate, but constructing a downside that hangs together operationally, and defending why it deserves a 25% probability rather than 10%, is the kind of thinking that separates strong candidates in PE and hedge fund interviews.
