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