Sensitivity, Scenario Analysis & Valuation Range - Interview-Ready Guide
A DCF can look wonderfully precise at ₹512 per share - until a 1% change in WACC moves it to ₹455, and a slightly lower terminal growth rate pulls it to ₹430. The professional answer is not “my valuation is ₹512”; it is “my defensible range is ₹430-₹560, and here is what has to be true for each end.”
- Sensitivity analysis changes one or two assumptions at a time to see which variables drive valuation the most.
- Scenario analysis changes a coherent set of assumptions together - bear, base, bull - to reflect different business futures.
- A valuation range is more credible than a single number because valuation depends on uncertain cash flows, growth, risk and market multiples.
- In a DCF, the highest-impact sensitivities are usually WACC, terminal growth, revenue growth, margin, reinvestment and exit multiple.
- Do not sensitize every cell. Sensitize the 3-5 assumptions that are economically material and explainable.
- Present the range using triangulation: DCF + trading comparables + precedent transactions + sanity checks.
- The best interview answer links the range to business logic: “low end assumes margin pressure; high end assumes operating leverage and lower risk.”
Big Picture
Valuation is not a treasure hunt for one magic number. It is a disciplined way to convert uncertain business outcomes into a defensible range, then explain the assumptions behind that range clearly.
Core Explanation
The big idea is simple: sensitivity tells you which assumptions matter, while scenario analysis tells you what the company could be worth under different business realities. Together, they stop your valuation from being a brittle spreadsheet output.
1. Sensitivity Analysis - Change One Lever, Observe the Impact
Sensitivity analysis asks: “If this one assumption changes, what happens to value?” In a DCF, you typically sensitize:
A good sensitivity grid is not a random 10-by-10 table. It is a map of risk. The two assumptions should be both important and uncertain.
2. Scenario Analysis - Change the Business Story
Scenario analysis asks: “What if the whole business environment is different?” A bear case is not just “minus 10% everywhere.” It is a coherent story: weaker demand, lower pricing power, slower margin expansion, higher risk and delayed cash conversion.
3. Presenting a Valuation Range - Triangulate, Do Not Average Blindly
A valuation range is usually presented through a football field chart: each method gives a range, and the analyst explains which methods deserve more weight. For example, a profitable mature company may lean more on trading comparables and DCF; an M&A target may give precedent transactions more relevance because they include control premiums.
4. The Five-Step Process to Build and Defend the Range
5. Worked Example - A Simple DCF Sensitivity
Assume a hypothetical company has Year 0 free cash flow of ₹100 crore, FCF grows at 8% for five years, WACC is 11%, terminal growth is 4%, net debt is ₹200 crore and shares outstanding are 50 crore.
Now sensitize the two most powerful assumptions - WACC and terminal growth. In this simplified model, changing WACC from 11% to 12% lowers value to about ₹26.7 per share; lowering terminal growth from 4% to 3% lowers it to about ₹27.7 per share. That is why a serious analyst presents a range, not a single point.
6. Valuation Range Diagnostics - What to Track
These diagnostics help you check whether your valuation range is defendable rather than cosmetic. There is no universal “good” number because industry maturity, leverage and cyclicality matter, but the ranges below are practical interview anchors.
Definitions You Must Say Cleanly
- Valuation: Aswath Damodaran defines value as the present value of expected cash flows on an asset.
- Sensitivity analysis: A technique that measures how valuation changes when one key assumption changes, holding others constant.
- Scenario analysis: A technique that values a company under coherent alternative futures using linked assumptions.
- Valuation range: A defensible interval of value estimates produced by stress-testing assumptions and triangulating methods.
- Terminal value: The estimated value of cash flows beyond the explicit forecast period in a DCF.
Tata Technologies IPO: A Valuation Range Story in the Real Market
Tata Technologies showed why valuation ranges matter in an IPO: the offer price had to balance peer multiples, growth expectations, Tata Group credibility and market demand.
Situation: Tata Technologies, an engineering and product development services company with strong automotive exposure, came to the Indian public market in 2023. For investors, the valuation question was not just “what multiple should we apply?” It was “how much should we pay for a business tied to engineering outsourcing, electric mobility, global OEM spending and Tata Group parentage?”
The move: The IPO price band was set at ₹475-₹500 per share. A serious valuation view would have triangulated across listed engineering and IT services comparables, growth and margin assumptions, client concentration risk, brand credibility and market sentiment. The primary driver of demand was confidence in the company's engineering services positioning and Tata Group association, supported by favourable IPO market conditions, scarcity value and investor appetite for profitable, high-quality listings.
Outcome and lesson: Tata Technologies listed in November 2023 at around ₹1,200 per share against the ₹500 issue price, a sharp listing premium. The lesson is not that every IPO should be priced low. The lesson is that a valuation range has to reflect both fundamentals and market clearing reality: DCF and comparables explain intrinsic reasonableness, while demand, scarcity and sentiment influence where a transaction can actually be priced.
The interview takeaway: do not explain a listing premium using one cause. The primary driver was perceived quality and scarcity of the asset; supporting drivers included Tata Group trust, favourable market appetite, profitability, and the broader appeal of engineering services themes.
How AI Changes Sensitivity, Scenario Analysis & Presenting a Valuation Range
AI does not replace valuation judgment, but it changes how quickly you can test assumptions, extract evidence and prepare a sharper valuation narrative.
Practical workflow: Load the company's annual report, investor presentation and recent earnings-call transcript into NotebookLM. Ask: “List the 10 assumptions that most affect valuation, group them into operating, risk and market variables, and draft bear-base-bull scenarios with evidence from the documents.” Then verify every assumption manually before putting it into the model.
Never let AI invent WACC, beta, peer multiples or market-share figures. Use AI to structure thinking and extract evidence, not to create unsupported valuation numbers.
Interview Relevance
“You have built a DCF for a company. How would you run sensitivity and scenario analysis, and how would you present the final valuation range to a client?”
Use this sentence in interviews: “Sensitivity tells me which assumptions are dangerous; scenarios tell me which business futures are plausible; the valuation range is where those two views overlap with market evidence.”
Common Mistake
The biggest mistake is presenting a massive sensitivity table without explaining the business logic behind the assumptions. It costs candidates because it makes valuation look like Excel mechanics, not financial judgment. One-line fix: sensitize only material drivers, build coherent scenarios, and state what must happen operationally for each end of the range.
What to Revise Next
Once you can defend a valuation range, revise the two market-based methods that usually sit beside the DCF in a football field chart.