ISPMT
Syntax:
ISPMT ( rate , per, nper , pv )
Description: Computes the interest paid during a specific period of an investment.
Arguments:
Name |
Type |
Description |
|---|---|---|
rate |
number |
The interest rate for the investment. |
per |
number |
The period for which the interest is to be found, and shall be in the range 1–nper. |
nper |
number |
The total number of payment periods for the investment. |
pv |
number |
The present value the investment. |
Arguments representing cash paid by investor shall be expressed as negative numbers; arguments representing cash received by the investor shall be expressed as positive numbers.
Return Type and Value: number – The interest paid during a specific period of an investment.
example: