Question: This question uses excel. Please provide any formulas or steps in completing the problem. Thanks! A project has the following cash flows: Year Cash Flow
This question uses excel. Please provide any formulas or steps in completing the problem. Thanks!

A project has the following cash flows: Year Cash Flow Set up the NPV formula for these cash flows generate values of NPV | -500 600 300 using a range of discount rates from 0% to 80% incremented by 5% by using the data table function. Observe the general location of the two IRRs and then use the IRR function to get the precise 0 2 3 300solutions. Because there are two solutions, you will have to give 4 200 5 Excel a starting value fairly close to where you think it is. Key -1,000 output: two formula-driven IRRs and a brief statement if you would invest in this project if your discount rate is 20%
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
