next up previous contents index
Next: XOR Up: A. Function Reference Previous: XIRR   Contents   Index


XNPV

Syntax: XNPV(R, V, D)

R = discount rate to apply to the cash flows
V = a range containing a series of cash flows
D = a range containing the dates of cash flows in V

XNPV returns the net present value 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 01/10/91 -12000
2 04/01/91 3000
3 09/30/91 4150
4 01/10/92 3300
5 04/01/92 3150
     

XNPV(9.00%, B1..B5, A1..A5) = 705.1677

Excel function: N/A


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