# 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 ﬂows. Cash ﬂow at the end of this year will be $5,000, and cash ﬂows in future years are expected to grow indeﬁnitely 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