CUMIPMT
Definition of CUMIPMT
Calculates the cumulative interest over a range of payment periods for an investment based on constantamount periodic payments and a constant interest rate.
Sample Usage
CUMIPMT(0.12,12,100,1,5,0)
CUMIPMT(A2,B2,C2,D2,E2,1)
Syntax
CUMIPMT(rate, number_of_periods, present_value, first_period, last_period, end_or_beginning)
rate
 The interest rate.number_of_periods
 The number of payments to be made.present_value
 The current value of the annuity.first_period
 The number of the payment period to begin the cumulative calculation.first_period
must be greater than or equal to1
.
last_period
 The number of the payment period to end the cumulative calculation.last_period
must be greater thanfirst_period
.
end_or_beginning
 Whether payments are due at the end (0
) or beginning (1
) of each period.
Notes
 Ensure that consistent units are used for
rate
andnumber_of_periods
. For example, a car loan for 36 months may be paid monthly, in which case the annual percentage rate should be divided by 12 and the number of payments is 36. On the other hand, a different type of loan of the same length might be paid quarterly, in which case the annual percentage rate should be divided by 4 and the number of payments would be 12.
See Also
RATE
: Calculates the interest rate of an annuity investment based on constantamount periodic payments and the assumption of a constant interest rate.
PV
: Calculates the present value of an annuity investment based on constantamount periodic payments and a constant interest rate.
PMT
: Calculates the periodic payment for an annuity investment based on constantamount periodic payments and a constant interest rate.
NPER
: Calculates the number of payment periods for an investment based on constantamount periodic payments and a constant interest rate.
IPMT
: Calculates the payment on interest for an investment based on constantamount periodic payments and a constant interest rate.
FVSCHEDULE
: Calculates the future value of some principal based on a specified series of potentially varying interest rates.
FV
: Calculates the future value of an annuity investment based on constantamount periodic payments and a constant interest rate.
CUMPRINC
: Calculates the cumulative principal paid over a range of payment periods for an investment based on constantamount periodic payments and a constant interest rate.
To use the CUMIPMT Formula, simply begin with your edited Excellentable:
Begin typing the CUMIPMT formula in the cell you want the result to appear:
rate
 The interest rate.nper
 The number of payments to be made. The NPER formula can be used to calculate this value.pval
 The current value of the annuity. The PV formula can be used to calculate this value.startperiod
 The number of the payment period to begin the cumulative calculation.first_period
must be greater than or equal to1
.
endperiod
 The number of the payment period to end the cumulative calculation.last_period
must be greater thanfirst_period
.
 paytype  Whether payments are due at the end (
0
) or beginning (1
) of each period.
The result will show in the chosen cell:
A

B

C

D



1


2


3


4


5


6


7


8


9


10
