CUMIPMT

Examples

• =CUMIPMT(0.05/12, 360, 200000, 1, 12, 0)

  The CUMIPMT function is used to calculate the cumulative interest paid on a loan over a specified range of payment periods. In this example, we calculate the cumulative interest paid on a $200,000 loan with an annual interest rate of 5% over the first 12 months (periods 1 to 12). The loan has a total of 360 monthly payments. Payments are made at the end of each period (type 0). The formula returns -$10,285.18, which is the total interest paid over the first 12 months.

• =CUMIPMT(0.04/4, 8, 10000, 3, 6, 1)

  In this example, we calculate the cumulative interest paid on a $10,000 investment with a quarterly interest rate of 4% per annum over the third to sixth quarters (periods 3 to 6). The investment has a total of 8 quarterly periods. Payments are made at the beginning of each period (type 1). The formula returns -$798.58, which is the total interest paid over the specified range of periods.

• =ROUND(CUMIPMT(0.06/12, 240, 150000, 1, 12, 0), 2)

  The CUMIPMT function can also be used in combination with other Excel functions. For instance, it can be used together with the ROUND function to round the result of a CUMIPMT calculation to a specific decimal place. In this example, we calculate the cumulative interest paid on a $150,000 loan with an annual interest rate of 6% over the first 12 months (periods 1 to 12). The loan has a total of 240 monthly payments. Payments are made at the end of each period (type 0). The formula returns -$9,040.98, a rounded version of the total interest paid over the first 12 months.