Function Type: Financial
Description:
Returns the cumulative interest paid between two periods.
Function Structure:
=CUMIPMT(rate, nper, pv, start_period, end_period, type)
Argumet Breakdown:
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.
Example:

If you need instant expert help with Excel or Google Sheets, please visit my fiverr gig.