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>)
参数
| Sr.No. | 参数与说明 |
|---|---|
| 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.
示例
= XNPV (CashFlows, [AMOUNT], [DATE],8.5)
dax_functions_statistical.html
