Products, services, and OS functions
may not be available in this country.

XNPV

The XNPV function returns the present value of an investment or annuity based on a series of irregularly spaced cash flows and at a discount interest rate.

XNPV(discount, payments, dates)

discount: The discount rate to apply to the cash flows.

payments: A range of cells that contain the payments for the investment or annuity. Payments must contain at least one positive payment and one negative payment, and if the first value is a payment, it must be negative.

dates: A range of cells that contain dates that correspond to the cash flows in payments. The first date corresponds with the beginning of the payments; all other dates must come after this date, otherwise an error occurs.

Notes

  • If any values in discount, payments, or dates don’t contain numeric values, XNPV returns an error.

  • If the numbers used in dates don’t correspond with a valid date, XNPV returns an error.

  • If payments and dates don’t contain the same number of values, XNPV returns an error.

  • The currency shown in this function result depends on your Language & Region settings (in System Preferences in macOS 12 and earlier, System Settings in macOS 13 and later, and Settings in iOS and iPadOS).

Example

Given the following table:

Cash flow

Date

A

B

1

-7,000

01/01/2019

2

3,000

03/02/2019

3

2,500

05/17/2019

4

1,000

08/26/2019

5

2,000

10/27/2019

=XNPV(.08,A1:A5,B1:B5) returns approximately $1220.67.

See alsoPVXIRRNPVIRRMIRR
Morty Proxy This is a proxified and sanitized view of the page, visit original site.
Helpful?
Character limit: 250
Maximum character limit is 250.
Thanks for your feedback.
Morty Proxy This is a proxified and sanitized view of the page, visit original site.