MIRR(V, F, R)

Description
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