Description
CumPRINC returns the total paid towards the principal on a loan, between the start and end periods specified.
Arguments
rate is a positive, non-zero number that specifies the interest rate per period.
nPeriods is a positive number specifying the total number of payment periods.
presentValue is a positive number or currency representing the total value of the loan.
startPeriod is a positive number specifying the first period to be included in the calculation.
endPeriod is a number, greater than or equal to startPeriod, specifying the last period to be included in the calculation. The end period cannot be greater than the number of periods.
type is a number specifying when the payments are made. 0 = end of the payment period, 1 = start of the payment period.
Action
CumPRINC returns the total paid towards the principal on a loan, between the start and end periods specified. This function sums the value returned from PPMT for the periods specified. The value will be negative since it represents a sum of payments.
Examples
Suppose you have taken out a $5000, six-year loan with an annual interest rate of 8.3% with semiannual payments paid at the end of the month.
CumPRINC(0.083/2,6*2,5000,3,4,0)
Returns -$730.57 as the total principal paid off during the second year of the load. Note that both the interest rate and the duration have to be written on a per period basis.
CumPRINC(0.083/2,6*2,5000,1,12,0)
Returns -$5000 since over the duration of the loan you have paid off the entire principal. Note that both the interest rate and the duration have to be written on a per period basis.
Comments
This function is designed to work like the Excel function of the same name.