Explainry Tutorials to Expert in IT

CUMIPMT function in Excel


CUMIPMT function calculates the cumulative interest paid between the start date and the end date or It is used to get interest paid between any two loan payment period.


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

rate – The rate of interest

nper – The total number of payments period.

pv – The present value

start_period – The first period in calculation, starts with 1.

end_period – The last period in the calculation.

type – The timing of the payment.

Type Timing
0 (zero) Payment at the end of the period
1 Payment at the beginning of the period




Copyright © 2016 - 2020 Explainry.com | All Rights Reserved