Excel functions / Financial

XNPV function

Net present value of cash flows that fall on any dates, not evenly spaced ones.

Syntax

=XNPV(rate, values, dates)

Arguments

When to use it

XNPV gives the net present value of cash flows that fall on any dates, discounting each by its date. NPV assumes equal periods; XNPV is the one to use when payments are uneven. The first cash flow is treated as today and not discounted.

Examples

  1. Uneven cash flows at 9%

    ABCD
    1DateCash flow
    22008-01-01-100002086.65
    32008-03-012750
    42008-10-304250
    52009-02-153250
    62009-04-012750

    In D2: =XNPV(9%, B2:B6, A2:A6) → 2086.65

    Try this example

Common mistakes

XNPV in other languages

Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.

Translate a whole formula

Try XNPV in the playground

Related functions