Related Topics: | ||
Description: Returns the cumulative interest paid between two periods.
Syntax: CUMIPMT(Rate, Nper, PV, Start_Period, End_Period, Type)
Rate is the interest rate.
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 (12 per year) on a four-year loan at an annual interest rate of 10 percent, use (0.1/12) for Rate and (4*12) for Nper. If you make annual payments on the same loan, use 0.1 for Rate and 4 for Nper.
Nper, Start_Period, 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:
Total interest paid in the second year of payments, periods 13 through 24 assuming a 9% annual interest rate:
CUMIPMT(0.09/12, 30*12, 125000, 13, 24, 0) = -11135.23
© 1992-2015. ReliaSoft Corporation. ALL RIGHTS RESERVED.