next up previous contents index
Next: XNPV Up: A. Function Reference Previous: WORKDAY   Contents   Index


XIRR

Syntax: XIRR(G, V, D)

G = a guessed value of the result
V = a range containing a series of cash flows
D = a range containing the dates of cash flows in V

XIRR returns the internal rate of return for a series of cash flows (V) with variable intervals (D). V and D must be one-dimensional ranges and have the same size.

Example:

  A B
1 02/01/91 -12000
2 05/01/91 2800
3 10/01/91 3250
4 02/01/92 4460
5 04/01/92 5000
     

XIRR(0.5, B1..B5, A1..A5) = 0.3632

Excel function: N/A


next up previous contents index
Next: XNPV Up: A. Function Reference Previous: WORKDAY   Contents   Index
SpreadScript User's Guide, Version 1.2
Grey Trout Software
02 March 2003