- DAX Functions Tutorial
- DAX Functions - Home
- DAX Functions - Introduction
- DAX Parameter Naming Conventions
- Description Structure
- DAX Functions - Aggregation
- DAX Functions - Filter
- DAX Functions - Time Intelligence
- DAX Functions - Date and Time
- DAX Functions - Information
- DAX Functions - Logical
- Math & Trigonometric Functions
- DAX Functions - Parent & Child
- DAX Functions - Statistical
- DAX Functions - Text
- DAX Functions - Other
- DAX Functions Useful Resources
- DAX Functions - Quick Guide
- DAX Functions - Useful Resources
- DAX Functions - Discussion
DAX Statistical - XNPV function
Description
Returns the present value for a schedule of cash flows that is not necessarily periodic.
DAX XNPV function is new in Excel 2016.
Syntax
XNPV (<table>, <values>, <dates>, <rate>)
Parameters
| Sr.No. | Parameter & Description |
|---|---|
| 1 |
table A table for which the values and dates expressions should be calculated. |
| 2 |
values An expression that returns the cash flow value for each row of the table. |
| 3 |
dates An expression that returns the cash flow date for each row of the table. |
| 4 |
rate The 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 −
$$\sum_{j=1}^N\:\frac{P_{j}}{(1+rate)\frac{d_{j}-d_{1}}{365}}$$
Where $P_{j}$ is the j-th payment $d_{j}$ payment date, and $d_{1}$ is the first payment date.
The series of cash flow values must contain at least one positive number and one negative number.
Example
= XNPV (CashFlows, [AMOUNT], [DATE],8.5)
