FINANCE.ISPMT(rate, period, periods, value)
Calculates the interest payment for an investment based on an interest rate and constant payment schedule.
- rate: The interest rate for the investment.
- period: Period to calculate the interest rate for. Must be greater than 1, and less than periods.
- periods: The number of payments for the annuity.
- value: Loan amount or present value of the payments.