Npv (PQL)

Given a list and a datapoint, calculates the net present value (NPV) of cash flows for a given rate, assuming a constant set of time periods.

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

Syntax

Npv( <List> , <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. Typically it's a set of dates. It is assumed that dates are equidistant from each other.
  • The first data point needs to describe values for each of the 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 NPV function.
  • Also see the XNPV function that assumes the dates are NOT equidistant from each other.