CUMPRINC (PQL - xl)

This function returns the cumulative principal paid on a loan between the start and end 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

CUMPRINC(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 'CUMPRINC' function - using the same inputs, logic and outputs.