IRR function

IRR(Values, Guess?) IRR(Values; Guess?)

Values

{ Number }

An array containing the payments made or received, at regular intervals.

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 cash flows.

Calculates the internal rate of return of a series of cash flows.

Example

IRR({ -5000, 1000, 2000, 3000 })IRR({ -5000; 1000; 2000; 3000 })

Returns roughly 8.21%.

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