The CUMIPMT function calculates the cumulative interest paid between two periods. It can be a very handy function and is relatively straightforward.

CUMIPMT takes 5 required arguments and 1 optional argument:

Syntax: CUMIPMT(rate, nper, pv, start_period, end_period, [type])

#1)
Using the CUMIPMT function:
#2)
Using the CUMIPMT function to calculate the interest for a single period:
#3)
The arguments for the CUMIPMT function are:
Argument Required? Description
rate Required The interest rate.
nper Required The total number of payment periods.
pv Required The present value.
start_period Required The first period in the calculation. Payment periods are numbered beginning with 1.
end_period Required The last period in the calculation.
type Optional The timing of the payment
#4)
A few more things:
If rate ≤ 0, nper ≤ 0, or pv ≤ 0, CUMIPMT returns the #NUM! error value.
If start_period < 1, end_period < 1, or start_period > end_period, CUMIPMT returns the #NUM! error value.
If type is any number other than 0 or 1, CUMIPMT returns the #NUM! error value.

Summary

The CUMIPMT function calculates the cumulative interest paid between two periods.
comments powered by Disqus