Exceljet

Quick, clean, and to the point

Excel CUMIPMT Function

Excel CUMIPMT function
Summary 
The Excel CUMIPMT function is a financial function that returns the cumulative interest paid on a loan between a start period and an end period. You can use CUMIPMT to calculate and verify the total interest paid on a loan, or the interest paid between any two payment periods.
Purpose 
Get cumulative interest paid on a loan
Return value 
The interest amount
Syntax 
=CUMIPMT (rate, nper, pv, start_period, end_period, type)
Arguments 
  • rate - The interest rate per period.
  • nper - The total number of payments for the loan.
  • pv - The present value, or total value of all payments now.
  • start_period - First payment in calculation.
  • end_period - Last payment in calculation.
  • type - When payments are due. 0 = end of period. 1 = beginning of period.
Usage notes 
  1. Be consistent with inputs for rate. For example, for 5-year loan with 4.5% annual interest, enter the rate as 4.5%/12.
  2. The loan value (pv) must be entered as a positive value.