MIrr

MIrr(values,I,financeRate,reinvestRate)

Requires Analtyica 4.2 or better

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.

See Also

• Irr, XMIrr
• Npv, XNpv