The Syntax for the function is
=CUMPRINC(RATE, NUMBER OF PAYMENT PERIOD, PRESENT VALUE,START PERIOD,END PERIOD, TYPE)
RATE Interest Rate (loan interest rate).
NUMBER OF PAYMENT PERIOD Number of payment period.(e.g. 20 years,30 years)
PRESENT VALUE Current value of principal.
START PERIOD FIRST Period for calculation. It starts from 1.
END PERIOD LAST Period of calculation.
TYPE Timing of payment
Type | Timing |
---|
0 (zero) | Payment at the end of the period |
1 | Payment at the beginning of the period |