Documentation/Calc Functions/XIRR

From The Document Foundation Wiki
Jump to: navigation, search


Im-jabber.svg

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


Function name:

XIRR

Category:

Financial Analysis

Summary:

Calculates the internal rate of return for a list of payments which take place on different dates. The calculation is based on a 365 days per year basis, ignoring leap years

Syntax:

XIRR(Values; Dates; Guess)

Returns:

Arguments:

Values and Dates refer to a series of payments and the series of associated date values. The first pair of dates defines the start of the payment plan. All other date values must be later, but need not be in any order. The series of values must contain at least one negative and one positive value (receipts and deposits).

Guess (optional) is a guess that can be input for the internal rate of return. The default is 10%.

Additional details:

If the payments take place at regular intervals, use the IRR function.

Examples:

Calculation of the internal rate of return for the following five payments:

A B C
1 2001-01-01 -10000 Received
2 2001-01-02 2000 Deposited
3 2001-03-15 2500
4 2001-05-12 5000
5 2001-08-10 1000

=XIRR(B1:B5; A1:A5; 0.1) returns 0.1828.

Related LibreOffice functions:

ODF standard:

Equivalent Excel functions: