The XNPV function calculates the net present value for cash flows that may or may not be periodic. Net present value is used in investment planning and capital budgeting.
Formula in cell C12:
=XNPV(C2, B5:B10, C5:C10)
Excel Function Syntax
XNPV(rate, values, dates)
Required. The discount rate.
Required. A number of values representing cash flow, the first value is optional and may be a cost or payment. Make sure the first value is a negative value if it is a cost or payment. At least one value must be negative and one value must be positive.
Required. Dates that correspond to the cash flow values.
The XNPV function returns:
#VALUE! error if arguments are non-numeric.
#NUM! error if any number in dates precedes the starting date.
#NUM! error if values and dates don't have the same number of values.
#VALUE! error if any number in dates is not a valid date.
The formula looks like this:
di = the ith, or last, payment date.
d1 = the 0th payment date.
Pi = the ith, or last, payment.
This extensive function reference list provides detailed information including syntax, arguments, return values, and examples for many of the functions used in Excel formulas. Click on headers to sort table.
Functions in 'Financial'
The XNPV function function is one of many functions in the 'Financial' category.