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.