Question
Perform sensitivity analysis on the NPV for the given projects. Project Initial Investment Cash Flow Year 1 Cash Flow Year 2 Cash Flow Year 3
Perform sensitivity analysis on the NPV for the given projects.
Project | Initial Investment | Cash Flow Year 1 | Cash Flow Year 2 | Cash Flow Year 3 | Discount Rate | Base NPV |
Q | $200,000 | $60,000 | $80,000 | $100,000 | 10% | $20,000 |
R | $250,000 | $70,000 | $90,000 | $120,000 | 12% | $25,000 |
What is the NPV for Project Q if the cash flows are increased by 10%?
What is the NPV for Project R if the cash flows are decreased by 10%?
Requirement: Perform sensitivity analysis under different conditions.
What is the NPV for Project Q if the discount rate increases to 12%?
What is the NPV for Project R if the discount rate decreases to 10%?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started