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

XIRR({ -2750, 1000, 2000 }, { DATE(2008, 2, 5), DATE(2008, 7, 5), DATE(2009, 1, 5) })XIRR({ -2750; 1000; 2000 }; { DATE(2008; 2; 5); DATE(2008; 7; 5); DATE(2009; 1; 5) })

Returns roughly 12.4%.

Partly derived from the OpenOffice.org documentation, licensed under the Apache License 2.0.