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