Sensitivity Analysis explained: this guide covers what it means, who it applies to, the step-by-step process, documents required, fees, due dates and penalties in India — so you can stay compliant with confidence and avoid costly mistakes.
A single NPV looks precise, yet it rests on forecasts of price, volume and cost that may turn out wrong. Risk analysis asks how wrong they can be before the project stops paying. Owners and finance managers use it to decide not only whether a project is attractive on paper, but also whether it is safe enough to commit funds.
Risk in a project is the chance that actual cash flows differ from the forecast. Sensitivity analysis changes one input at a time and records the effect on NPV. Scenario analysis changes several inputs together into optimistic, most likely and pessimistic cases. The risk-adjusted discount rate raises the rate for a riskier project; the certainty equivalent method scales uncertain cash flows down instead. Ask which input hurts most and how far it can move before NPV turns negative.
Why one NPV misleads
A well-built financial model lets you flex each input and read the answer at once, which is how most of the tests below are done in practice.
The usual NPV uses a single most likely forecast. If the true figures fall short, the project can destroy value. When the cash flows have several possible outcomes, the expected cash flow is the weighted average using probabilities, and the spread around that average measures risk. In plain terms, two projects with the same expected NPV are not equally attractive if one has a wide range of outcomes. For the base method, see capital budgeting with NPV and IRR. Our guide on assumptions and sensitivity analysis in a valuation report uses the same idea for valuation.
The tools
| Tool | What it does | Strength |
|---|---|---|
| Sensitivity analysis | Changes one variable at a time | Shows which input matters most |
| Scenario analysis | Changes several variables together as cases | Shows plausible combinations |
| Risk-adjusted discount rate | Adds a premium to the rate for risky projects | Simple to apply |
| Certainty equivalent | Scales each cash flow to a sure amount, discounted at the baseline rate on government securities | Separates timing from risk |
| Simulation | Draws random values for inputs thousands of times | Shows a spread of NPVs, needs software |
| Decision tree | Maps choices and outcomes with probabilities | Suits staged decisions |
Simulation and decision trees are mentioned for completeness; a small firm rarely needs them. The first four are done by hand. Inflation should be handled consistently: use rupee cash flows that include expected price rises with a discount rate that includes inflation, or real cash flows with a real rate. Mixing the two misstates NPV.
Worked example: Veena Spices' packing line
Veena Spices, an invented firm, considers a packing line costing ₹50 lakh with a four-year life and no salvage value. To keep the example small, tax is ignored (an assumption; see our income-tax guides for the real effect). Required return is assumed at 12 per cent; the four-year annuity factor is 0.893 + 0.797 + 0.712 + 0.636 = 3.038.
Base case: volume 40,000 units a year, price ₹250, variable cost ₹150, fixed cash cost ₹18 lakh a year. Annual cash flow = 40,000 x (250 - 150) = ₹40 lakh, less 18 = ₹22 lakh. NPV = 22 x 3.038 - 50 = 66.84 - 50 = ₹16.84 lakh.
Sensitivity: each input 10 per cent worse, one at a time
| Change | Annual cash flow (₹ lakh) | NPV (₹ lakh) |
|---|---|---|
| Base | 22.00 | +16.84 |
| Price down 10% (225) | 40,000 x 75 = 30.00 - 18 = 12.00 | 12 x 3.038 - 50 = -13.54 |
| Volume down 10% (36,000) | 36,000 x 100 = 36.00 - 18 = 18.00 | 18 x 3.038 - 50 = +4.68 |
| Variable cost up 10% (165) | 40,000 x 85 = 34.00 - 18 = 16.00 | 16 x 3.038 - 50 = -1.39 |
| Fixed cost up 10% (19.8) | 40.00 - 19.80 = 20.20 | 20.2 x 3.038 - 50 = +11.37 |
Price is the most sensitive input. The cash flow needed for NPV to be zero is 50 / 3.038 = 16.46 lakh, so cash flow can fall by 22 - 16.46 = 5.54 lakh. Each rupee of price is worth 40,000 x 1 = 0.40 lakh, so price can fall by 5.54 / 0.40 = about ₹13.85, or 5.5 per cent, before the project fails.
Scenarios
| Case | Price | Volume | Annual cash flow | NPV | Probability |
|---|---|---|---|---|---|
| Optimistic | 260 | 44,000 | 44,000 x 110 = 48.40 - 18 = 30.40 | 30.4 x 3.038 - 50 = +42.36 | 25% |
| Most likely | 250 | 40,000 | 22.00 | +16.84 | 50% |
| Pessimistic | 230 | 34,000 | 34,000 x 80 = 27.20 - 18 = 9.20 | 9.2 x 3.038 - 50 = -22.05 | 25% |
Expected NPV = 0.25 x 42.36 + 0.50 x 16.84 + 0.25 x (-22.05) = 10.59 + 8.42 - 5.51 = about ₹13.49 lakh (using unrounded values, 13.49). The probabilities are the owner's judgment. There is a one in four chance, on these figures, of a loss of over ₹22 lakh.
Risk-adjusted discount rate. The owner decides this project is riskier than the firm's average and adds an assumed 4 points: 16 per cent. The four-year annuity factor at 16 per cent = 0.862 + 0.743 + 0.641 + 0.552 = 2.798. NPV = 22 x 2.798 - 50 = 61.56 - 50 = +11.56 lakh. Still positive, but lower. The premium is a judgment, and it penalises distant cash flows more than near ones.
Certainty equivalent. The owner treats only 90 per cent of each cash flow as certain, so the certain amount is 22 x 0.90 = 19.80 lakh. Discounted at an assumed baseline rate on government securities of 8 per cent, the four-year factor is 0.926 + 0.857 + 0.794 + 0.735 = 3.312. NPV = 19.80 x 3.312 - 50 = 65.58 - 50 = +15.58 lakh.
Decision. The project passes on every method, but a 5.5 per cent fall in price would end the gain. Veena's owner signs the price terms with two large buyers before buying the line, and reduces the risk further by agreeing a minimum volume.
Common mistakes
- Changing several inputs at once and calling it sensitivity analysis.
- Using probabilities as if they were facts.
- Adding a risk premium so large that every project fails, or so small that none does.
- Forgetting that the premium in the rate is the same for all years even if risk grows with time.
- Ignoring links between inputs: a fall in price often comes with a fall in volume.
- Treating the base case as the optimistic case.
The rate itself comes from cost of capital. Where the risk is exchange-rate related, see financial risk management.
Need help with project risk?
If you are about to commit to a machine or a new line, our financial modeling service builds the cash flows with switches for price, volume and cost, and shows the break-even point of each. You see where the project fails and can negotiate the weak points before you sign.
Key takeaways
- A single NPV hides the range of outcomes.
- Sensitivity analysis changes one input; scenario analysis changes several together.
- Find the break-even value of the key input, such as the price at which NPV is zero.
- A risk-adjusted rate or certainty equivalents can bring risk into the NPV.
- Act on the result: fix prices, volumes or costs before committing.
Read next
- Capital budgeting: payback, NPV, IRR
- Cost of capital and WACC
- Financial risk management for a business
- Assumptions and sensitivity analysis in valuation
Disclaimer: The methods described are standard cost accounting and financial management techniques. The worked example uses an invented business and invented figures, including any tax, interest or exchange rate, which are assumptions for illustration and not current rates. Where the article refers to a legal requirement, the linked guide and the official text should be checked. This article is general information, not legal advice; check the official text before acting.