Documentation/Calc Functions/MIRR

Function name:
MIRR

Category:
Financial Analysis

Summary:
Calculates the modified internal rate of return of a series of investments.

Syntax:
MIRR(Values; Investment; Reinvest Rate)

Returns:
Return a non-negative real number (expressed as a percentage or fraction) which is the modified internal rate of return of a series of investments.

Arguments:
Values is an array or a reference to a range of cells containing real numbers which are the payments.

Investment is a real number or a reference to the cell containing that number which is the rate of interest of the investments (the negative values of the array)

Reinvest Rate is a real number or a reference to the cell containing that number which is the rate of interest of the reinvestment (the positive values of the array)

Additional details:

 * The formula for MIRR is:

Related LibreOffice functions:
[[Special:MyLanguage/Documentation/Calc_Functions/IRR IRR]

[[Special:MyLanguage/Documentation/Calc_Functions/NPV NPV]

[[Special:MyLanguage/Documentation/Calc_Functions/RATE RATE]

XIRR

ODF standard:
Section 6.12.27, part 2

Equivalent Excel functions:
MIRR