Calculates the modified internal rate of return of a series of investments.
MIRR(Values; Investment; Reinvest Rate)
Values corresponds to the array or the cell reference for cells whose content corresponds to the payments.
Investment is the rate of interest of the investments (the negative values of the array)
Reinvest Rate:the rate of interest of the reinvestment (the positive values of the array)
Assuming a cell content of A1 = -5, A2 = 10, A3 = 15, and A4 = 8, and an investment value of 0.5 and a reinvestment value of 0.1, the result is 94.16%.