Explore BrainMass
Share

# Calculating IRR and NPV using excel

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

1) What is the internal rate of return (IRR) for a project whose intitial after tax cost is \$5,000,000 and it is expected to provide after tax operating cash flows of (\$1,800,000) in year 1, \$2,900,000 in year 2, \$2,700,000 in year 3, and \$2,300,000 in year 4 ?

2) A firm is evaluating a proposal that has an initial investment of \$50,000 and has cash flows of \$15,000 per year for 5 years. If the firms required return or cost is 15%, should it accept the project using the internal rate of return (IRR) as a decision criteria ?

3) What is the net present value (NPV) for a project whose cost of capital is 12% and its initial after tax cost is \$5,000,000 and it is expected to provide after tax operating cash flows of \$1,800,000 in year 1, \$1,900,000 in year 2, \$1,700,000 in year 3, and (\$1,300,000) in year 4 ?

© BrainMass Inc. brainmass.com March 21, 2019, 4:21 pm ad1c9bdddf
https://brainmass.com/economics/finance/calculating-irr-and-npv-using-excel-182475

#### Solution Preview

1) The IRR is the rate at which the present value of cash inflows = present value of cash outflows and so the NPV is zero. The IRR denotes the return that the project gives on the initial investment. We calculate IRR manually using trial and error or using the IRR ...

#### Solution Summary

The solutions explains about IRR and NPV calculations and shows how to calculate NPV and IRR using excel

\$2.19