Question
Suppose the following cash flow represents the base case for a potential investment project. Conduct a sensitivity analysis. Use excel to solve and show all
Suppose the following cash flow represents the base case for a potential investment project. Conduct a sensitivity analysis. Use excel to solve and show all work.
Variable | -30% | -20% | -10% | 0% | 10% | 20% | 30% |
Revenues |
|
|
| $3,000 / $4,563 |
|
|
|
MARR |
|
|
| 10% / $4,563 |
|
|
|
Operating Costs |
|
|
| $1,000 / $4,565 |
|
|
|
A. Complete the above table for the appropriate changes in variable values. Fill in the table with the new revenues, MARR, and Operating Costs based on the variable changes.
B. Find the Net Present Worth for all the missing blocks in the table below.
Variable | -30% | -20% | -10% | 0% | 10% | 20% | 30% |
Revenues |
|
|
| $3,000 / $4,563 |
|
|
|
MARR |
|
|
| 10% / $4,563 |
|
|
|
Operating Costs |
|
|
| $1,000 / $4,565 |
|
|
|
C. Plot the NPV for all three variables from the table in Part B (Revenue, MARR and Operating Costs). Be sure to correctly label each line appropriately with a legend.
D. Which input variable shows the most sensitivity to NPV? Why did you choose this variable?
MARR (i) =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