Formula Engine Reference Guide
 

 

Back to Class Index

 

XNPV(R, V, D)

Description
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.
 
Parameters
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
 
Example
A                 B
01/10/91   -12000
04/01/91   3000
09/30/91   4150
01/10/92   3300
04/01/92   3150
XNPV(9.00%, B1..B5, A1..A5) = 705.1677