|
<< Click to Display Table of Contents >> XIRR (internal rate of return) |
Syntax:
XIRR(Values, Dates [, Guess])
Description:
This returns an estimate of the internal rate of return of an investment with irregular cash flows.
The calculation is based on the cash flows specified in the Values argument. Payments have to be entered as negative values, and income as positive values. Payments may be made at any time. The date of each cash flow has to be specified using the Dates argument.
The function expects the following arguments:
For Values, you specify a cell range or array in which the cash flows were entered. There must be at least one payment and one income.
Dates is a cell range or array containing the dates for each cash flow specified in Values.
Guess (optional) lets you specify an estimate for the result (see note below).
Note:
The result of this function is calculated using an iterative search technique. If the function does not find a result with an accuracy of 0.00001% or better after 20 iterations, it aborts and the #NUM! error value is returned. If this occurs, try specifying a different value for Guess.
See also: