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.