Explore BrainMass

Explore BrainMass

    Solution to "NPV and IRR" question

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    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 ad1c9bdddf
    https://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

    ADVERTISEMENT