XIRR function
XIRR(Values, Dates,
Guess?) XIRR(Values; Dates;
Guess?)
Values
{ Number }
An array containing the payments made or received, at irregular intervals.
Dates
{ Number }
An array containing dates on which the payments were made or received.
Guess
Number or { Number } (optional)
A first guess at the rate. If omitted, 10% (0.1) is assumed.
Returns
Number or { Number }
The internal rate of return of a series of irregular cash flows.
Calculates the internal rate of return of a series of irregular cash flows.
Example
Partly derived from the OpenOffice.org documentation, licensed
under the Apache License 2.0.