Cumulative interest

You can calculate the cumulative interest paid (cumipmt) on a loan for a specified period.

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 paid. Periods are index-based.
• Ending period – The ending period for measuring the cumulative interest paid.

Example expression

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

Open topic with navigation