Manuals/calci/ISPMT
ISPMT(R, per, nper, PV)
Where 'R' is the interest rate for the investment, 'per' is the period to find the interest, 'nper' is the total number of payment periods for the investment, and 'PV' is the present value of the investment.
This function calculates the interest paid during a specific period of an investment.
- Consistent about the units use for specifying rate and nper.
- For all the arguments, to pay out the cash is, represented by negative numbers and the cash you receive, is represented by positive numbers.
ISPMT
Syntax
Remarks
Examples
Description
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 12% | |||
| Row2 | 1 | |||
| Row3 | 4 | |||
| Row4 | 6000000 | |||
| Row5 | -540000 | |||
| Row6 |
Lets see an example,
ISPMT(R, per, nper, PV)
B
12%
1
4
6000000
=ISPMT(B2,1,B4,B5) is -540000