Table of contents
TOC
Collapse the table of content
Expand the table of content

XNPV Function (DAX)

Owen Duncan|Last Updated: 10/5/2018
|
1 Contributor

Returns the present value for a schedule of cash flows that is not necessarily periodic.

Syntax

XNPV(<table>, <values>, <dates>, <rate>)  

Parameters

TermDefinition
tableA table for which the values and dates expressions should be calculated.
valuesAn expression that returns the cash flow value for each row of the table.
datesAn expression that returns the cash flow date for each row of the table.
rateThe discount rate to apply to the cash flow for each row of the table.

Return Value

Net present value.

Remarks

The value is calculated as the following summation:

XNPV Formula

The series of cash flow values must contain at least one positive number and one negative number.

Example

The following calculates the present value of the CashFlows table:

Present value := XNPV( CashFlows, [Payment], [Date], 0.09 )  
DatePayment
1/1/2014-10000
3/1/20142750
10/30/20144250
2/15/20153250
4/1/20152750

Present value = 2086.65

© 2018 Microsoft