ISPMT

FINANCE.ISPMT

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.