Rate
The annual interest rate.
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 a series of cash flows that occur on specific dates. Unlike NPV, which assumes equally spaced periods, XNPV handles irregular intervals between cash flows.
Examples
Returns roughly $196.04. Suppose you invest $2,000 on January 1, 2010, receive $800 on June 1, 2010 and $1,500 on January 1, 2011. At a 6% annual discount rate, the net present value of these cash flows is roughly $196.04, indicating a modest gain over the alternative of investing at 6%.
Returns roughly $2,196.04. This is the present value, as of January 1, 2010, of receiving $800 on June 1, 2010 and $1,500 on January 1, 2011, at a 6% annual discount rate.