CUMIPMT

Cumulative interest

Description
Calculates the cumulative interest for an investment over multiple payment periods. This is done based on a constant interest rate and periodic payments with constant amounts.
Function signature
CUMIPMT(rate: Number, numberofperiods: Number, presentvalue: Number, firstperiod: Number, lastperiod: Number, paymentsatthebeginningofperiod: Boolean) => Number
Parameter
Description
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.
Last period
The number of the payment period to end the cumulative calculation.
Payments at the beginning of period
Whether payments are due at the end (false) or beginning (true) of each period
Examples
Formula
Return value
CUMIPMT(0.012, 12, 100, 1, 5, false)
-5.05299881
CUMIPMT(0.02, 12, 100, 1, 5, false)
-8.4786848
CUMIPMT(0.01, 12, 100, 1, 5, true)
-3.17186904

COUPPCD

CUMPRINC

Last updated 11 months ago

Formula	Return value
`CUMIPMT(0.012, 12, 100, 1, 5, false)`	`-5.05299881`
`CUMIPMT(0.02, 12, 100, 1, 5, false)`	`-8.4786848`
`CUMIPMT(0.01, 12, 100, 1, 5, true)`	`-3.17186904`

Parameter	Description
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.
Last period	The number of the payment period to end the cumulative calculation.
Payments at the beginning of period	Whether payments are due at the end (false) or beginning (true) of each period