You are here: Reference > Standard rules > Library rules > Cumulative interest principal

Cumulative interest principal

You can calculate the cumulative interest principal paid (cumprinc) on a loan within a given period of time.

This function takes the following arguments:

Interest rate – The interest rate that applies to the loan.
Total number of periods – The total number of periods for the loan.
Present value – The present value of the loan.
Starting period – The starting period for measuring the cumulative interest principal paid. Periods are index-based.
Ending period – The ending period for measuring the cumulative interest paid.

Example expression

@Financial.cumprinc(0.005, 360, 200000, 1, 12)