CUMIPMT

Definition: CUMIPMT is a function that returns the cumulative interest paid on a loan between two periods.

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

Situation: This formula is suitable when you need to calculate the cumulative interest paid on a loan between two periods.

Example: If you have a loan with a principal value of $100,000, an interest rate of 5%, a term of 20 years, and want to calculate the cumulative interest paid between the 1st and 10th year, the formula =CUMIPMT(5%/12, 20*12, 100000, 1, 10, 0) can be used.