Calculates the level of interest for unchanged amortization installments.
ISPMT(Rate; Period; Total Periods; Invest)
Rate sets the periodic interest rate.
Period is the number of installments for calculation of interest.
Total Periods is the total number of installment periods.
Invest is the amount of the investment.
For a credit amount of 120,000 currency units with a two-year term and monthly installments, at a yearly interest rate of 12% the level of interest after 1.5 years is required.
=ISPMT(1%;18;24;120000) = -300 currency units. The monthly interest after 1.5 years amounts to 300 currency units.