Question
Must show all work and be in EXCEL format- must show formulas Henry wants to determine if the discount rate really makes any difference in
Must show all work and be in EXCEL format- must show formulas
Henry wants to determine if the discount rate really makes any difference in the net present value of a project. He feels that if a project is acceptable at one rate of return, it will be acceptable at all rates of return. To explain why his thinking is incorrect, you are creating an example to illustrate your point. The cash flows you are using are as follows: time zero is -$71,000, years 1 through 4 are $17,500 each, and years 5 and 6 are $22,500 each. What is net present value at a discount rate of 12 percent and 17 percent?
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