CUMIPMT(rate,periods,amount,start_period,end_period<,type>)

`rate`Numeric. The interest rate per period.

`periods`Numeric. The number of payment periods in the term of the loan.

`amount`Numeric. The principal amount of the loan.

`start_period`Numeric. The first period of the calculation. You cannot use 0 for the first period.

`end_period`Numeric. The last period of the calculation. The end period cannot be greater than the total number of payment periods.

`type`Optional. Numeric constant. Specifies whether payments are due at the beginning or end of the period. Use the default of 0 for payments that are due at the end of a period. Use 1 for payments that are due at the beginning of a period.

Numeric.

You must use consistent units to specify the rate and periods. For example, if you make monthly payments on a two-year loan at a rate of 6 percent, use 0.06/12 for rate and 2 * 12 for periods. If you make annual payments on the same loan, use 0.06 for rate and 2 for periods.

**Calculating the interest paid
on a loan**

Use the following to find the amount of interest paid during the second year of a twenty-five year, $275,000 mortgage at 6.5 percent per annum, with payments due at the end of the month:

`CUMIPMT(0.065/12,
12*25, 275000, 13, 24, 0)`

returns **17,437.23**.
The amount of interest paid is $17,437.23.

Use the following to find the amount of interest paid on the same loan in the first year of the loan:

`CUMIPMT(0.065/12, 12*25, 275000,
1, 12, 0)`

returns **17,741.31**. The amount of
interest paid is $17,741.31.