Solution to "NPV and IRR" question
NPV/IRR. Growth Enterprises believes its latest project, which will cost $80,000 to install, will generate a perpetual growing stream of cash flows. Cash flow at the end of this year will be $5,000, and cash flows in future years are expected to grow indefinitely at an annual rate of 5 percent. a. If the discount rate for this project is 10 percent, what is the project NPV? b. What is the project IRR?
Please show excel sheet and formulas. I had OTA 102799 help me with this but did not get the formula or excel. Original answer for NPV was $20,000 - not sure if this is correct or not?
© BrainMass Inc. brainmass.com March 4, 2021, 6:01 pm ad1c9bdddfhttps://brainmass.com/business/net-present-value/24230
Solution Preview
We can find the NPV in 2 ways: 1 way is through Excel formulae (see the attached sheet). The other and more rigorous way ...
$2.19