Answered step by step
Verified Expert Solution
Question
1 Approved Answer
need assistsnce w the sensitivity analysis e. Use a two-way data table to perform a sensitivity analysis of the effect of the long term decline
need assistsnce w the sensitivity analysis
e. Use a two-way data table to perform a sensitivity analysis of the effect of the long term decline rate (10%, 15%, and 20%) and the number of years of constant savings (3, 4, and 5) on the NPV of the project. 1 Model Inputs $1,100,000 2 Initial Cost Output NPV $301.07 Break-Even First Yr Savings $199,945.28 Must re-run goal seek if inputs cha $200,000 Annual Savings 3 4 Yrs of Constant Savings 5 LT Decline Rate 6 # Years Decline 7 Cost of Capital 5 15% 10 11.0% Sensitivity Analysis Data Table 10% 15% 0 20% 0 3 0 8 0 4 5 0 0 0 0 0 -15.00% 9 10 Analysis 11 12 Second Phase Gr Rate 13 14 Time 15 0 16 1 17 2 18 3 19 4 20 5 21 6 7 23 8 24 9 25 10 26 11 27 12 13 29 14 22 Cash Flow ($1,100,000) $200,000 $200,000 $200,000 $200,000 $200,000 $170,000 $144,500 $122,825 $104,401 $88,741 $75,430 $64,115 $54,498 $46,323 28 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