You are presenting an earnings model for a prominent Indian FMCG firm to your investment committee. You have meticulously calculated the Free Cash Flow to the Firm (FCFF) and arrived at a target price that suggests a 15% upside.
However, a senior analyst asks a pointed question: ‘What happens to your valuation if raw material inflation persists or if the long-term growth rate drops by just 50 basis points?’ If you only have a single ‘base case’ number, your credibility vanishes instantly, as you have failed to account for the inherent uncertainty of long-term forecasting.
Sensitivity analysis is the bridge between a static spreadsheet and a robust investment thesis. It involves systematically varying your critical inputs—such as the WACC, terminal growth rate, or revenue CAGR—to observe how these changes ripple through the terminal value and the resulting intrinsic value. By constructing a sensitivity matrix, you demonstrate that your recommendation is not a fragile point estimate, but a range of outcomes that remains valid under different macroeconomic environments.
Consider a mid-sized IT services firm currently benefiting from digital transformation tailwinds. You might project a 12% revenue growth rate, but the reality of the Indian IT sector often involves sudden shifts in client spending or visa regulations.
By creating a matrix that plots the cost of capital against the growth rate, you can visualize the ‘valuation bridge.’ If your buy recommendation holds firm even when the growth rate is cut to 9% or the WACC increases due to a hike in the repo rate, you have built a resilient case. This depth of analysis transforms you from a modeler into a strategist who understands the levers of value creation.
Ultimately, sensitivity analysis forces an analyst to quantify the margin of safety. It highlights which variables are the primary drivers of the firm’s equity value. If a 1% change in your EBITDA margin causes a 20% swing in the fair value, you know exactly which metric the market will scrutinize during the next quarterly concall. Relying on a single output is a dangerous simplification; showing your work through sensitivity tables proves to clients that you have stress-tested your judgment against the volatility of the Indian markets.
Nuance
Check Your Understanding
An analyst builds a DCF model for a manufacturing company and creates a sensitivity matrix showing how the terminal value changes with variations in WACC and the terminal growth rate. What is the primary purpose of this analysis in a professional research report?
When conducting a sensitivity analysis on a firm’s DCF, if the valuation is highly volatile regarding changes in the cost of equity but stable regarding the terminal growth rate, what should be the analyst’s focus?
This is a companion read for Section 10.5 — Discounted Cash Flows Model for Business Valuation from PASS Research Analyst Certification Examination by Akhilesh Gururani, available on Amazon Kindle.
Copyright © 2026 Akhilesh Gururani. All rights reserved.