MIRR

Modified internal rate

Description

Given a series of periodic cash flows, and the difference between the interest rate paid on financing versus the return received on reinvested income, calculates the modified internal rate of return as a decimal number.

Function signature

MIRR(сashflowamounts: Array, financingrate: Number, reinvestmentreturnrate: Number) => Number

Parameter

Description

Сashflow amounts

A list containing the income or payments associated with the investment.

Financing rate

The interest rate paid on funds invested.

Reinvestment return rate

The return (as a percentage) earned on reinvestment of income received from the investment

Examples

Formula

Return value

MIRR([1, -1, 2, 3, 4, 5], 1, 1)

1.709384058

MIRR([1, -1, 2, 3, 4, 5], 1, 2.5)

3.21691195

MIRR([2, -2, 2, 3, 4, 5], 0, 1)

1.208166722

MIRR([1, -1, 2, 3, 4, 5], 2, 1)

1.938250528