CUMPRINC

Description: Returns the cumulative principal paid on a loan between two periods.

Syntax: CUMPRINC(Rate, Nper, PV, Start_Period, End_Period, Type)

• Rate is the interest rate in decimals.
• Nper is the total number of payment periods.
• PV is the present value.
• Start_Period is the first period in the calculation. Payment periods are numbered beginning with 1.
• End_Period is the last period in the calculation.
• Type is the timing of the payment.

Type	Timing
0 (zero)	Payment at the end of the period
1	Payment at the beginning of the period

 

Remarks:

• Make sure that you are consistent about the units you use for specifying Rate and Nper. If you make monthly payments on a four-year loan at an annual interest rate of 12 percent, use 0.12/12 for Rate and 4*12 for Nper. If you make annual payments on the same loan, use 0.12 for Rate and 4 for Nper.
• Nper, Start_Period and End_Period must be integers.
• Rate, Nper and PV must be >= 0.
• Start_Period and End_Period must be >= 1 and Start_Period <= End_Period.
• Type must be either 0 or 1.

• When used in an event analysis flowchart, the parameters must evaluate to numerical values. They can include:

• Numerical values

• Standard operands (+, -, *, /)

• Predefined mathematical functions (exp, log, sin, etc.)

• Event analysis internal functions

• Event analysis resources

• References to any ReliaSoft Workbooks

Example:

• The total principal paid in the second year of payments, periods 13 through 24.

CUMPRINC(.09/12, 30*12, 125000, 13, 24, 0) = -934.1071