[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

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:

CUMIPMT(0.09/12,30*12,125000,13,24,0) results in -11135.23
CUMIPMT(0.09/12,30*12,125000,1,1,0) results in -937.50

end example]