Purchase Solution

Solution to "NPV and IRR" question

Not what you're looking for?

Ask Custom 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?

Purchase this Solution
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 ...

Purchase this Solution
Free BrainMass Quizzes
Team Development Strategies

This quiz will assess your knowledge of team-building processes, learning styles, and leadership methods. Team development is essential to creating and maintaining high performing teams.

Transformational Leadership

This quiz covers the topic of transformational leadership. Specifically, this quiz covers the theories proposed by James MacGregor Burns and Bernard Bass. Students familiar with transformational leadership should easily be able to answer the questions detailed below.

Social Media: Pinterest

This quiz introduces basic concepts of Pinterest social media

Introduction to Finance

This quiz test introductory finance topics.

Writing Business Plans

This quiz will test your understanding of how to write good business plans, the usual components of a good plan, purposes, terms, and writing style tips.

View More Free Quizzes
Related BrainMass Solutions

  • Projected IRR can be less than the WACC

    Please see the excel file again and also the NPV, IRR has been calculated through the excel function. Reply for your doubts and eliminate the rating 2. Regards Solution discusses the projected IRR can be less than the WACC

  • NPV over IRR

    The solution is very easy to understand as well. Overall, an excellent response to the question being asked. It clearly illustrates why NPV is better than IRR.

  • NPV, IRR, Profitability Index, and MIRR

    407811 NPV IRR Calculations Please view attachment for question. a. Calculate the NPV, IRR, Profitability Index, and MIRR for this project with a cost of capital of 12%.

  • The Modified IRR (MIRR) Method

    156605 The Modified IRR (MIRR) Method This is a True/ False question. 1)The modified IRR (MIRR) method has wide appeal to professors, but most business executives prefer the NPV method to either the regular or modified IRR.

  • Mutually Exclusive Projects and Net Cash Flow

    The IRR for Project L comes to 18.1% and for Project S it is 23.6% The solution explains the evaluation of two mutually exclusive projects.

  • NPV and IRR of an investment

    The solution explains the calculation of NPV, IRR and payback period for an investment.

  • Calculating Net Present Value

    54639 Calculating Net Present Value Question -For independent projects, is it true that if PI>0, then NPV>0, and IRR>K? Is my answer correct?

  • Embodied reinvestment rate

    Reinvestment rate: NPV - Cost of capital IRR - IRR MIRR - Cost of Capital Hope this will help. Thanks Answers conceptual question on what is the embodied reinvestment rate in IRR, NPV and MIRR.

  • Payback, NPV, IRR

    531866 Payback, NPV, an IRR Please help with the attached Corporate Finance Question regarding Payback, NPV, and IRR. I am looking for the calculations and work shown (any formulas) on how the answer was obtained.

  • Internal rate of return

    The solution answers the question below in great detail.

View More Related Solutions