CUMIPMT

Syntax:

CUMIPMT ( rate , nper , pv , start-period , end-period , type )

Description: Computes the cumulative interest paid on a loan between start-period and end-period.

Arguments:

Name

Type

Description

rate

number

The interest rate.

nper

number

The total number of payment periods, truncated to integer.

pv

number

The present value.

start-period

number

The first period in the calculation. (Payment periods are numbered beginning with 1.)

end-period

number

The last period in the calculation.

type

number

The timing of the payment, truncated to integer, as follows:

Value

Timing

0

Payment at the end of the period

1

Payment at the beginning of the period

Time information in the date arguments is ignored.

Return Type and Value: number – The cumulative interest paid on a loan.

However, if

  • rate, nper, or pv ≤ 0, #NUM! is returned.

  • start-period < 1 or end-period < 1, or start-period end_period, #NUM! is returned.

  • type is any number other than 0 or 1, #NUM! is returned.

example: