Back to Class Index
MIRR(V, F, R)This function returns the Modified Internal Return Rate for a range of periodic cash flows. Blanks and text are treated as zeros. Parameters V A range of values representing periodic income (positive values) and payments (negative values) F Finance rate, the interest paid on the payments R Reinvestment rate, the rate of return on the income Example A B Investment 140000 1st year return 34000 2nd year return 46000 3rd year return 45000 4th year return 47000 5th year return 46000 MIRR(B1..B6, 11%, 12.5%) = 0.14522 |