Xnpv (PQL)

Given a list of DATES and a datapoint, calculates the net present value (NPV) of cash flows, over an uneven range of date periods.

  • Returned Output: Numeric
  • Library: PQL \ Semantic \ Financial
  • Version: 2025.00.000
  • Compatibility: Pyramid Query Language (PQL) data sources

Syntax

Xnpv( <List of Dates> , <Data Point> , <Data Point> )

* Click on the function's arguments above for more details on the input values.

Comments
  • The list needs to be a list/set of members from a date-time attribute. The dates do NOT need to be equidistant from each other.
  • The first data point needs to describe values for each of the date-time members in the list, Typically it's cash-flows (positive and negative)
  • The second data point should be the discount rate.
  • For details on how to employ and use this function see the semantic calculation overview.
Different Function types
  • This function is like the Excel XNPV function.
  • Also see the NPV function that assumes the dates are equidistant from each other.