Explore BrainMass

Explore BrainMass

    MIRR for a Projects Cost of Capital

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

    Consider the following project.

    0 1 2 3 4

    |----------------|---------------|---------------|---------------|

    - 1000 300 500 200 300

    Project's cost of capital = 11%

    a) Find the MIRR of the project.

    b) Is this project acceptable? Why?

    Need help with this problem...

    © BrainMass Inc. brainmass.com June 3, 2020, 8:56 pm ad1c9bdddf
    https://brainmass.com/business/modified-internal-rate-of-return/mirr-projects-cost-capital-159135

    Solution Preview

    In MIRR the intermediate cash flows are compounded at the cost of capital to the terminal year and then we find the rate that will make the PV of terminal year cash flow equal to the initial investment. MIRR can be calculated using the MIRR function in excel. The manual method is
    Step 1 - Compound the intermediate cash flows to terminal year at cost of capital
    The ...

    Solution Summary

    The solution explains how to calculate the MIRR of the project and determine if the project is acceptable

    $2.19

    ADVERTISEMENT