Learn sensitivity and scenario analysis
Core Concepts
Why One-at-a-Time vs. Multiple Inputs?
Sensitivity analysis isolates pure elasticity: "If WACC alone moves±2%, value moves ±$X." It's diagnostic—you discover that revenue growth dominates your model, so you should spend research time refining that forecast, not obsessing over the tax rate.
Scenario analysis captures correlation: In a recession, revenue growth and margins and default risk all move together. Varying them independently (sensitivity) mises the compound effect. A scenario bundles them into a realistic joint outcome.
Deriving the Sensitivity Framework
Start with a valuation function: where are inputs (growth , discount rate , terminal margin , etc.).
First-order sensitivity (elasticity):
WHY this formula? We want percentage change in output percentage change in input—that's the definition of elasticity. For a DCF:
If we vary alone:
WHAT this tells us: Each cash flow is weighted by its time-distance; distant cash flows (like terminal value) are hyper-sensitive to because of the exponential denominator. A 1% higher discount rate compounds over10, 20 years.
HOW to implement:
- Fix a base-case with all inputs at best estimates.
- Perturb by ±10%, ±20% (or relevant ranges).
- Recalculate each time. To show elasticity, plot the normalized change (fractional change in value) against (fractional change in input). Alternatively, for a tornado chart, plot absolute (in dollars) against the percentage change in —just be consistent about which axis is normalized.
- Rank inputs by absolute impact → tornado chart (bars sorted by magnitude).

Scenario Analysis: The Three Worlds
WHY probability-weight? A range alone ("120") doesn't tell you where to anchor. If the bear case is unlikely and the bull case likely, you should skew toward the bull value. The expected value is your risk-adjusted anchor.
Worked Example: Valuing a Retailer
Base Case:
- Revenue growth: 5%/year for 5 years
- EBIT margin: 8%
- WACC: 9%
- Terminal growth: 2%
- Result: 75.00$
Sensitivity Table (One-Variable)
| Input | -20% | -10% | Base | +10% | +20% | |----|------|------|------|---| | Revenue growth (5%) | 68.50 | 82.10 | 69.00 | 75.00 | 81.00 | | WACC (9%) | 81.20 | 69.50 | 70.20 | 75.00 | 80.90 |
WHY these ranges? Revenue growth swings 89.80 - 23.70—these dominate. EBIT margin swings only $12, so it's less critical. Action: Spend time refining revenue forecasts and assessing business/financial risk (WACC components).
Scenario Analysis
| Scenario | Rev Growth | EBIT Margin | WACC | Term Growth | Value | Probability |
|---|---|---|---|---|---|---|
| Bear | 1% | 6% | 11% | 1% | $48.20 | 20% |
| Base | 5% | 8% | 9% | 2% | $75.00 | 60% |
| Bull | 8% | 10% | 8% | 3% | $108.50 | 20% |
Expected Value: E[V] = 0.20 \times 48.20 + 0.60 \times 75.00 + 0.20 \times 108.50 = 9.64 + 45.00 + 21.70 = \76.34$$
WHAT this tells us: Despite the wide range (108), the probability-weighted fair value is 82, you're paying above the expected value but within the bull case—acceptable only if you have conviction the bull scenario is underpriced.
Common Mistakes
Practical Workflow
- Build your base DCF with best-estimate inputs.
- Identify 4–6 key inputs (usually: revenue growth, margin, WACC, terminal growth, capex).
- Create sensitivity tables for each input (±20%, ±10%, base, +10%, +20%).
- Plot a tornado chart: Rank inputs by range.
- Construct 3 scenarios:
- Bear Coherent pessimistic story (recession, competition, margin pressure).
- Base: Your original model.
- Bull: Coherent optimistic story (market expansion, pricing power).
- Assign probabilities (use market-implied vol, analyst consensus, or judgment; they must sum to 100%).
- Calculate and compare to current price.
- Stress-test: "What input changes would make this stock attractive at current price?" (Goal-seek analysis.)
Recall Explain to a 12-Year-Old
Imagine you're guessing how much money your lemonade stand will make this summer. You think you'll sell100 cups at 200. But what if it's super hot (150 cups) or rainy (50 cups)? What if your costs go up?
Sensitivity analysis is testing one thing at a time: "If I sell 150 cups but everything else stays the same, I make 100." You figure out which guesses matter most.
Scenario analysis is imagining whole weather patterns: "Hot summer = more sales + I can charge more + lower costs (no spoilage)" vs. "Rainy summer = fewer sales + lower prices (discounts) + higher costs (wasted lemons)." You plan for different worlds, not just different numbers.
Connections
- Discounted Cash Flow (DCF) Models – The valuation model you're stress-testing
- Weighted Average Cost of Capital (WACC) – Often the highest-sensitivity input
- Terminal Value Calculation – Dominates DCF sensitivity due to exponential discounting
- Monte Carlo Simulation – Advanced extension: vary ALL inputs simultaneously with probability distributions
- Option Pricing and Real Options – Captures asymetry (upside optionality) that scenarios approximate
- Risk-Adjusted Return Metrics – Scenario probabilities feed into Sharpe ratio, downside deviation
- Market-Implied Expectations – Reverse-engineer what scenarios the current stock price assumes
#flashcards/stock-market
What is sensitivity analysis in valuation? :: A one-variable-at-a-time technique that measures how much the intrinsic value changes when you vary a single input (growth, WACC, margin) across a range while holding all other inputs constant. It identifies which assumptions have the highest leverage on your conclusion.
What is scenario analysis?
Why use tornado charts in sensitivity analysis?
How do you calculate expected value from scenarios?
Why can't you just vary WACC and call it complete sensitivity analysis?
What's the difference between base case and expected value?
Why do distant cash flows (terminal value) dominate discount rate sensitivity?
What makes a good scenario (vs. random input combinations)?
Concept Map
Hinglish (regional understanding)
Intuition Hinglish mein samjho
Jab bhi aap kisi company ki valuation karte ho—DCF, multiples, jo bhi method—toh ek precise number milta hai: "Share price 62 ho jayega? Ya phir bas thoda sa budge karega? Sensitivity analysis yeh bata hai ki "Mere kaun se inputs sabse zyada dangerous hain—agar main galat hoon toh valuation kafi badal sakti hai." Aur scenario analysis complete picture banata hai: "Agar recession aye aur margins bhi gir jayein, toh kya hoga?" Bina iske, ap ek single number pe blind faith kar rahe ho, jo ki risky hai.
Sensitivity mein ap ek-ek input change karte ho (jaise revenue growth ko ±20% move karo, baki sab fixed rakho), aur dekhte ho value kitni swing karta hai. Resultek tornado chart hota hai jo dikhata hai ki konse variables high-impact hain. Jaise agar revenue growth ko change karne se value 90 tak jaa sakta hai, lekin tax rate change se sirf 77 tak jata hai, toh matlab revenue forecast pe research time spend karo, tax rate pe nahi.
Scenario analysis thoda alag hai—yahan aap pori kahani banate ho. "Bear case: Recession ayega, competition badhega, margins compress honge, aur risk premium bhi badhega—sab kuch ek sath." "Bull case: Market expand hoga, pricing power milega, efficiency badhegi." Har scenario ka ek value nikalta hai, aur phir probability assign karke expected value calculate karte ho. Yeh approach realistic hai kyunki real life mein ek chez badlne se dosri cheezon pe bhi asar padta hai—sensitivity ki tarah isolated nahi hote. Dono tools milke aapko confidence band dete hain: "Stock 110 ke bech hai, lekin expected value 82 pe kharidne ka matlab hai main bull case ka bet laga raha hoon."