CUMIPMT (PQL - xl)
This function returns the cumulative interest paid on a loan between the starting and ending periods
- 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
CUMIPMT(rate, nper, pv, start period, end period, type)
Function Arguments
Name | Description | Type | Optional |
rate | Interest rate | Number |
|
nper | Total number of payment periods | Number |
|
pv | Present value | Number |
|
start period | Starting period | StringOrNumber |
|
end period | Ending period | StringOrNumber |
|
type | Type of payment timing; can be any of: 0 - Payment at end of the period, 1 - Payment at beginning of the period | Number |
|
Comments
This function is the same as the Microsoft Excel 'CUMIPMT' function - using the same inputs, logic and outputs.