CUMPRINC( ) function

Returns the amount paid against the principal of a loan for the specified period.

Syntax

CUMPRINC(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.

end_period

Numeric. The last period of the calculation.

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, or 1 for payments that are due at the beginning of a period.

Output

Numeric.

Remarks

You must use consistent units to specify 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 principal repaid on a loan

Use the following to find the amount paid against the principal in 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:

CUMPRINC(0.065 / 12, 12*25, 275000, 13, 24)

returns 4844.61. The amount paid against the principal is $4844.61.

Use the following to find the amount paid against the principal on the same mortgage in a single payment in the first month:

CUMPRINC(0.065 / 12, 12*25, 275000, 1, 1)

returns 367.24. The amount paid against the principal is $367.24.



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