Documentation/Calc Functions/MIRR

From The Document Foundation Wiki
Jump to: navigation, search


Im-jabber.svg

Under construction.
For now, see the system Help files.


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:

Arguments:

Values corresponds to the array or the cell reference for cells whose content corresponds to the payments.

Investment is the rate of interest of the investments (the negative values of the array)

Reinvest Rate:the rate of interest of the reinvestment (the positive values of the array)

Additional details:

Examples:

Assuming a cell content of A1 = -5, A2 = 10, A3 = 15, and A4 = 8, and an investment value of 0.5 and a reinvestment value of 0.1, the result is 94.16%.

Related LibreOffice functions:

ODF standard:

Equivalent Excel functions: