XNPV Function

The XNPV function is one of the financial functions. It is used to calculate the net present value for an investment based on a specified interest rate and a schedule of irregular payments.

Syntax

XNPV(rate, values, dates)

The XNPV function has the following arguments:

Argument	Description
rate	The discount rate for the investment.
values	An array that contains the income (positive values) or payment (negative values) amounts. At least one of the values must be negative and at least one positive.
dates	An array that contains the payment dates when the payments are made or received.

Notes

How to apply the XNPV function.

Examples

The figure below displays the result returned by the XNPV function.