Manuals/calci/IPMT
IPMT(R, per, nper, P value, F value, type)
Where 'R' is the interest rate per period, 'per' is the period to find the interest, 'nper' is the total number of payment periods in an annuity, 'P value' is the present value, 'F value' is the future value and 'type' indicates when payments are due.
This function returns the interest payment for a given period for an investment.
IPMT
Lets see an example,
IPMT(R, per, nper, P value, F value, type)
B
15%
1
3
7500
=IPMT(B2, 3, B4, B5) is -428.4557
Syntax
Examples
Description
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 15% | |||
| Row2 | 1 | |||
| Row3 | 3 | |||
| Row4 | 7500 | |||
| Row5 | -428.4557 | |||
| Row6 |
