CUMIPMT( ) function

Returns the amount of interest paid on a loan during the specified period.

Syntax

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

Parameters

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.

Output

Numeric.

Remarks

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.

Example

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.



(C) 2013 ACL Services Ltd. All Rights Reserved. | Send feedback