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]