ISPMT Function Explained

The ISPMT Function in Microsoft Excel calculates the interest paid during a specific period of a loan or an investment based on a constant interest rate. It takes four arguments: rate, per, nper, and pv. Rate is the interest rate for the loan, per is the period for which the interest is calculated, nper is the total number of payment periods in the loan, and pv is the present value of the loan. The function returns the interest paid during the specified period.

ISPMT Function Syntax

ISPMT(rate,per,nper,pv)

  • rate: The interest rate for the loan.
  • per: The period for which the interest is to be calculated.
  • nper: The total number of payment periods in the loan.
  • pv: The present value, or the total amount that a series of future payments is worth now.