Explore BrainMass

Explore BrainMass

    MIRR and IRR

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

    I am an investor in a company. We are considering a project which involves opening a new store at a cost of $10,000,000 at t = 0. The project is expected to have operating cash flows of $5,000,000 at the end of each of the next 4 years. However, the facility will have to be repaired at a cost of $6,000,000 at the end of the second year. Thus, at the end of Year 2 there will be a $5,000,000 operating cash inflow and an outflow of -$6,000,000 for repairs. The company's cost of capital is 15 percent. What is the difference between the project's MIRR and its regular IRR?

    © BrainMass Inc. brainmass.com June 3, 2020, 8:13 pm ad1c9bdddf

    Solution Preview

    The first thing to do is to put down the cash flows.
    Year 0 Cash outflow = -10,000,000
    Year 1 Cash inflow = 5,000,000
    Year 2 Cash inflow = 5,000,000 and cash outflow = 6,000,000 and so the net in -1,000,000
    Year 3 Cash inflow = 5,000,000
    Year 4 Cash inflow = 5,000,000

    We can use excel to calculate the IRR and MIRR and find the difference. Using excel the IRR comes to 13.78% and MIRR comes to 14.29% and the difference is 0.51%.

    If you wish to do manually
    IRR is the rate that will make the PV of cash flows equal ...

    Solution Summary

    The solution explains how to calculate the MIRR and IRR for a project.