ISPMT

  • Updated

Calculates the interest paid at a particular period of an investment.

Sample Usage

ISPMT(15%,2,5,1000)

 

Syntax

ISPMT(rate, period, total_periods, present_value)

  • rate - The annualized rate of interest.
  • period - The period for which you want to find the interest payment.
  • total_periods - The total number of payment periods.
  • present_value - The present value of the annuity.

Examples

ISPMT(15%,2,5,1000) calculates the interest paid in the second of five periods. 

Notes

  • period must be number between 1 and total_periods.
  • Ensure that consistent units are used for rate, period and total_periods.