CUMIPMT function in Excel

Use

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.

Syntax

=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

Example

Formula:

Result:

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