MIRR

MIRR, which stands for Modified Internal Rate of Return, is the annualized discount rate that sets the present value of all future cash flows of the project to zero. The MIRR function in Excel is a modified version of the original IRR function and allows for the introduction of reinvestment rates into the equation.