Related Topics: | ||
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.
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
© 1992-2013. ReliaSoft Corporation. ALL RIGHTS RESERVED.