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.