Scenario analysis
Scenario analysis recomputes a project's NPV under a small set of internally consistent cases, such as worst, base and best, rather than varying one input at a time.
See it move
A €200,000 project, discounted at 10% over five years, has an NPV of −€48,369 in a worst case, €65,355 in a base case, and €179,079 in a best case. Weighting each by its 25%, 50% and 25% probability and summing gives an expected NPV of €65,355.
The formula
Variables
- Probability assigned to scenario i (decimal)
- Net present value computed under scenario i (€)
Combines the NPV computed under each named scenario into a single probability-weighted expected NPV.
Check yourself
Anchor Robotics is evaluating a €150,000 project using scenario analysis. The worst case (20% probability) has an NPV of −€50,636. The base case (30% probability) has an NPV of €15,606. The best case (50% probability) has an NPV of €114,970. What is the project's expected NPV across the three scenarios?