Modified Internal Rate of Return
Also known as · MIRR
MIRR compounds all positive cash flows forward to the end, discounts all negative cash flows back to today, and takes the single-period growth rate between the two: . This avoids the multiple-Internal Rate of Return problem.
When to use
On the cheat sheet's decision tree, for mutually exclusive projects pick the greatest Net Present Value or the greatest MIRR. Excel: MIRR.
See Cheat sheet.