Using the Excel CUMIPMT Function


The 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.


=CUMIPMT (rate, nper, pv, start_period, end_period, type)

Syntax Breakdown

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.

Start Period
Required. The first period in the calculation beginning with 1.

End Period
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 Notes

CUMIPMT 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.

Consistent Units
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