MIrr

MIrr(values,I,financeRate,reinvestRate)

Requires Analytica 4.2 or later

Computes the modified internal rate of return for series of cash flows («values») at equally-spaced intervals, where financeRate is the interest rate per period at which money is borrowed to finance the negative values (outflows) and «reinvestRate» is the interest rate per period received on earnings (positive «values») after they are realized.

The MIRR is an indication of the quality of an investment that overcomes some of the distortions inherent in the standard Internal Rate of Return (IRR) measure.

To compute the MIRR for a cash flow at arbitrary time points, use XMIrr.

Modified Internal Rate of Return

MIRR computes a measure expressed as a rate of return, by utilizing net present value in a way that makes it more akin to Npv in terms of its robustness than to Irr.

The idea is to split the original cash-flow into two streams -- the positive cash flows and the negative cash flows. Then we replace the positive cash flow stream with a single inflow gain occurring at the final time point, having the same net present value as the stream of inflows. Likewise, we replace all outflows with a single absolute-value outflow cost occurring now. With one gain at the n^th time point and one expense at the zeroth time, the rate of return is just

MIRR = (gain/cost)^(1/n)-1

To obtain the present-value equivalent of the outflows, we assume that all inflows are reinvested at the reinvestRate until the final time period. Setting the present value of a single gain in the final time period equal to the present value of this series, we obtain:

Similarly, to obtain the present-value equivalent of the negative flow stream, we obtain

cost = Npv(frate,-x*(x<0),T)*(1+frate)

We have to multiply by (1+frate) to obtain the present value assuming the first event in x occurs at the zeroth time period.

Hence the full MIRR is equivalent to:

MIRR(x,T,rrate,frate) := ((Npv(rrate,x*(x>0),T) * (1+rrate)^(n+1)) / Npv(frate,x*(x<0),T) *(1+frate))^(1/n) - 1

See Also

• Irr, XMIrr
• Npv, XNpv