Documentation/Calc Functions/IRR

Function name:
IRR

Category:
Financial Analysis

Summary:
Calculates the internal rate of return for an investment. The values represent cash flow values at regular intervals, at least one value must be negative (payments), and at least one value must be positive (income).

Syntax:
IRR(Values[; Guess])

Returns:
Returns a real number (expressed as a percentage or a fraction) which is the internal rate of return for a series of cash flows.

Arguments:
Values represents an array containing real numbers or a reference to a range of cells containing them.

Guess is the estimated value in percentage or fraction or a reference to the cell containing that value. An iterative method is used to calculate the internal rate of return. If you can provide only a few values, you should provide an initial guess to enable the iteration. If omitted, the value 0.1 (10%) is assumed.

Additional details:

 * If the payments take place at irregular intervals, use the XIRR function.

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

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

XIRR

ODF standard:
Section 6.12.24, part 2

Equivalent Excel functions:
IRR