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
Partly derived from the OpenOffice.org documentation, licensed
under the Apache License 2.0.