MIRR function

MIRR(values, financeRate, reinvestRate) MIRR(values; financeRate; reinvestRate)

values — { Number }

An array containing the payments made or received, at regular intervals.

financeRate — Number

The rate of interest you pay per period on outstanding balances.

reinvestRate — Number

The rate of interest you receive per period on invested balances.

Returns — Number

The modified internal rate of return of a series of cash flows.

Returns the modified internal rate of return of a series of cash flows.

Example

MIRR({ -5000, 1000, 2000, 3000 }, 5%, 8%)MIRR({ -5000; 1000; 2000; 3000 }; 5%; 8%)

Returns roughly 8.16%.

Partly derived from the OpenOffice.org documentation, licensed under the Apache License 2.0.