Explore BrainMass

Computing NPV, IRR and MIRR and deciding on project acceptance or rejection

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

** Please see the attached file for the complete problem description **

I need help understanding these concepts:

Problem 1
Suppose a company is considering two independent projects, Project A and Project B. The cash outlay for Project A is \$14,000. The cash outlay for Project B is \$20,000. The company's cost of capital is 12%. The following table shows the after-tax cash flows. For each project, compute the NPV, the IRR, the MIRR, and indicate the accept/reject decision.
Year
Project A Project B

Problem 2
Suppose a company is considering two investment projects. Both projects require an upfront expenditure of \$30 million. The company estimates that the cost of capital is 10% and that the investments will result in the following after-tax cash flows (in millions of dollars). Complete parts (a) through (e) below.

Year
Project A Project B

a) Find the regular payback period for each project.
b) Find the discounted payback period for each project.
c) Assume that the two projects are independent and the cost of capital is 10%. Which project or projects should the company undertake? Base your results on the NPV.
d) Assume that the two projects are mutually exclusive and the cost of capital is 5%. Which project or projects should the company undertake? Base your results on the MIRR.
e) Explain why quantitative measures may not always be the best way to evaluate a project.

https://brainmass.com/computer-science/legal-aspects-of-computing/computing-npv-irr-mirr-deciding-project-acceptance-rejection-512633

Solution Preview

** please see the attached file for an Excel formatted solution **

Year Project A Project B
0 (\$14,000) (\$20,000)
1 \$4,800 \$6,700
2 \$4,800 \$6,700
3 \$4,800 \$6,700
4 \$4,800 \$6,700

NPV \$579.28 \$350.24

IRR 13.95% 12.83%

MIRR 13.14% 12.49%

Project A should be accepted as the NPV of this project is higher and also the IRR rate is better than project B