Scripting Formulas Finance


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.