CumIpmt

Syntax

CumIpmt(Rate, PeriodCount, PresentValue, StartPeriod, EndPeriod, Type)

Parameters

Rate. Interest rate. Parameter value must be greater than zero.

PeriodCount. Total number of payment periods. Parameter value must be greater than zero.

PresentValue. The present value of the investments.

StartPeriod. The number of the first period included in calculations.

EndPeriod. Number of the last period included in calculations.

Type. Selecting payment time. The parameter may take one of the following values:

NOTE. To determine the parameter, specify either the parameter value or the cell address where it is located.

Description

It returns the cumulative interest (running total) paid on a loan between two payment periods.

Comments

Payment periods are numbered starting from 1.

Example

Formula Result Description
=CumIpmt(3.5, 24, 12000, 1, 1, 0) -42000,00

Cumulative payment based on the following conditions:

  • The interest rate is 3.5.

  • The total number of payment periods is 24.

  • The current investment value is 12000.

  • The number of the first period is 1.

  • The number of the last period included in calculations is 1.

  • The selected payment time - at the end of period.
=CumIpmt(A0, B0, 12000, 1,1,1) -82800,00

Cumulative payment based on the following conditions:

  • The interest rate is specified in the A0 cell, value is 6.9.

  • The total number of payment periods is specified in the B0 cell, value is 36.

  • The current investment value is 12000.

  • The number of the first period is 1.

  • The number of the last period included in calculations is 1.

  • The selected payment time - at the beginning of period.

See also:

Function Wizard │ Financial Functions │ Cumprinc