How much interested have I paid? The CUMIPMT Function in Excel is a financial function designed to calculate and return the cumulative interest paid on a loan. This can be extremely useful when trying to quickly calculate your total interest for a mortgage or auto loan. 

Let’s take a look at the Syntax

 =CUMIPMT (rate, nper, pv, start_period, end_period, type) 
rate The interest rate per period.
nper The total number of payments for the loan.
pv Present value
start_period First payment
end_period Last payment
type When payments are due. 0 = end of period. 1 = beginning of period.

Let’s take a look at the following 15yr mortgage calculation.

CUMIPMT Demo

*Please note, when calculating the rate, you have to take the rate 3.75% divided by the Periods per year, 12.

The Total Interest is calculated as a negative number.

Leave a Reply

EXACT Function

The EXACT function compares two strings of text. The main limitation of using the Exact function is it is Case

Read More »

COUNTIFS Function

The countifs Function is used when you want to count data with multiple criteria. =COUNTIFS (range1, criteria1, [range2], [criteria2], …)

Read More »
Scroll to Top