Question: Ingram Electric Products is considering a project that has the following cash flow and WACC data. What is the project's MIRR?
Note: A project's projected MIRR can be less than the WACC (and even negative), in which case it will be rejected.
Year 0 1 2 3
Cash flows -$800 $350 $350 $350
This solution illustrates how the MIRR can be calculated using Excel. This is a fairly basic calculation, but all necessary steps are included.