ISPMT
The interest paid in a period of a loan whose principal is repaid in equal parts.
Group: Financial. Compatible with DAX.
Syntax
ISPMT ( <rate>, <per>, <nper>, <pv> )| Parameter | Type | Description |
|---|---|---|
rate | Number | The rate of interest for one period. |
per | Number | The period asked about, counting from 0 for the first. |
nper | Number | How many payment periods there are, all told. |
pv | Number | The amount borrowed. |
Returns
Number. The interest paid in that period, when the loan is repaid in equal parts of principal.
Remarks
- Here the principal falls by the same amount every period (pv / nper), so the interest falls in equal steps.
IPMTis for loans with level payments instead. - Periods count from 0: per 0 is the first period, with interest on the whole amount; the last is nper − 1.
- A positive pv (a loan received) gives negative interest. An nper of 0 is an error.
Examples
4,000 over four years at 10 %
1,000 of principal is repaid each year, so the interest drops by 100 each year.
EVALUATE
ADDCOLUMNS (
SELECTCOLUMNS ( GENERATESERIES ( 0, 3 ), "Period", [Value] ),
"Interest", ISPMT ( 0.1, [Period], 4, 4000 )
)
ORDER BY [Period]| Period | Interest |
|---|---|
| 0 | -400 |
| 1 | -300 |
| 2 | -200 |
| 3 | -100 |