XNPV (PQL - xl)

This function calculates the net present value for a schedule of cash flows that may not be periodic

  • Library: PQL \ Spreadsheet \ Financial
  • Compatibility: Any content (regardless of data source) in the Tabulate spreadsheet module
  • Solve: This function can be used with the Solve plug-in: both as part of the objective function and constraint functions

Syntax

XNPV(rate, values, dates)
Function Arguments

Name

Description

Type

Optional

rate

Discount rate to apply to the cash flows

Number

values

Series of cash flows that correspond to a schedule of payments in dates. The first payment is optional and corresponds to a cost or payment that occurs at the beginning of the investment

Number

dates

Schedule of payment dates that corresponds to the cash flow payments in values

StringOrNumber

Comments

This function is the same as the Microsoft Excel 'XNPV' function - using the same inputs, logic and outputs.