Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed
image text in transcribed
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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Oxford Handbook Of Pricing Management

Authors: Ozalp Ozer, Robert Phillips

1st Edition

0199543178, 978-0199543175

More Books

Students also viewed these Finance questions