Using the Excel CUMIPMT Function
SummaryThe CUMIPMT function returns the cumulative interest paid on a loan or investment between two user provided dates.
To find the interest paid per period for a loan or investment, see the IPMT function.
Syntax=CUMIPMT (rate, nper, pv, start_period, end_period, type)
Required. Interest rate per period.
Required. Total number of payment periods.
Required. Present value that a series of future payments is worth today. PV should be entered as a positive number.
Required. The first period in the calculation beginning with 1.
Required. Last period in the calculation.
Required. Argument indicating when payments are due. Use 1 for beginning of the period and zero (0) for end of the period.
Usage NotesCUMIPMT is one of Excel's financial functions and is used to find the cumulative interest paid between two dates. The function can be used to calculate the total interest paid on a loan, or the interest between two specific periods.
It is necessary to ensure rate and nper units are consistent. For example, if you make monthly payments for a 5 year loan at 5% annual interest, use 5*12 for nper and 5%/12 for rate. If you were making annual payments it would be acceptable to use 5 for nper and 5% for rate.
CUMIPMT will return the #NUM! error under the following circumstances:
- Start period < 1; OR
- End period < 1; OR
- Start period > end period; OR
- The type argument is any value besides 1 or zero (0); or
- Rate, nper, or PV is <= 0