Explore BrainMass
Share

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
    (please see the attached file)

    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
    (please see the attached file)

    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.

    © BrainMass Inc. brainmass.com October 10, 2019, 5:38 am ad1c9bdddf
    https://brainmass.com/computer-science/legal-aspects-of-computing/computing-npv-irr-mirr-deciding-project-acceptance-rejection-512633

    Attachments

    Solution Preview

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

    Answer 1

    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

    Answer 2
    Year Project ...

    Solution Summary

    In this solution we compute the NPV, IRR and MIRR of a project and decide on the acceptance or rejection of the project based on these findings.

    $2.19