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.