XNPV function
Rate
The annual interest date.
Values
An array containing payments made. This number is positive if paid to you and negative if you pay.
Dates
An array containing the dates on which those payments are made.
Returns
The net present value of an investment with irregular cash payments.
Returns the net present value of an investment with irregular cash payments.
Examples
Returns roughly $-12.65. If you bought an investment for $1,000 on January 1, 2008, which paid $500 on January 1, 2009 and $550 on July 1, 2009 you would make a small loss, compared to investing at a 5% interest rate.
Returns roughly $987.35, the net present value on January 1, 2008, of an investment which paid $500 on January 1, 2009 and $550 on July 1, 2009, using a 5% interest rate.