ISPMT
Name
Interest payment
Description
Calculates the interest paid during a specific period of an investment.
Syntax
ISPMT(rate,per,nper,pv)
Remarks
The cash you pay out is represented by negative numbers and the cash you receive by positive numbers. Be consistent with the units for rate and nper.
This function has the following arguments:
| Argument | Description |
|---|---|
| rate | Interest rate for the investment |
| per | Number of the period for which to find the interest, between 1 and nper |
| nper | Total number of payment periods for the investment |
| pv | Present value of the investment |
Data Type
Accepts numeric data for all arguments. Returns numeric data. For more information, see Data Type for Each Cell Type.
Example
ISPMT(B1,C4,C5,1)
ISPMT(R1C2,R4C3,R6C3,R7C3)