Explore BrainMass

# Internal rate of return

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

The expected cash flows are as follows

year Cash Flow
0 - \$315,000.00
1 + \$71,000.00
2 + \$150,000.00
3 + \$150,000.00

What is the project's internal rate of return and the NPV on the following discount rates?
0%
4%
8%
12%

If I hand plotted a chart where the discount rate is on the x axis and the net present value on the y axis and plotted the NPV of the project as a function of the discount rate by dots for the 4 discount rates the curve will intersect the horizontal line at a particular discount rate. What is the discount rate at which the graph intersects the horizontal axis?

#### Solution Preview

Project's IRR can be calculated through Excel. Remember the manual way to get IRR is very tedious and is a trial and error process. However, Excel is very good at calculating IRR quickly.

To get ...

#### Solution Summary

The solution answers the question below in great detail.

\$2.19