PMT (PQL - xl)
This function returns the payment amount for a loan given the present value, specified interest rate, and number of terms
- 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
PMT(rate, nper, pv, OPTIONAL fv, OPTIONAL type)
Function Arguments
Name | Description | Type | Optional |
rate | Value of interest rate per period | Number |
|
nper | Total number of payment periods | Number |
|
pv | Present value, worth now | Number |
|
fv | Future value, cash value after the last payment; if omitted, the calculation uses zero | Number | Y |
type | Indicates when payments are due; at the end (0) or beginning (1) of the period; if omitted, the calculation uses the end (0) | Number | Y |
Comments
This function is the same as the Microsoft Excel 'PMT' function - using the same inputs, logic and outputs.