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.