ISPMT
Calculates the interest paid during a specific period of an investment
Syntax
ISPMT(rate, per, nper, pv)
Parameters
- rate: Required. The interest rate for the investment
- per: Required. The period for which you want to find the interest
- nper: Required. The total number of payment periods
- pv: Required. The present value of the investment
Example
=ISPMT(0.1/12, 1, 3*12, 8000000)