Given a particular period, calculates an investment's interest paid. This is done based on a constant interest rate and periodic payments of constant amounts.
ISPMT(rate: Number, period: Number, numberofperiods: Number, presentvalue: Number) => Number
The interest rate
The time frame for which you want to view the interest payment.
Number of periods
The number of payments to be made.
The current value of the annuity.