Important Notice
The pages on this site contain documentation for very old MS-DOS software,
purely for historical purposes.
If you're looking for up-to-date documentation, particularly for programming,
you should not rely on the information found here, as it will be woefully
out of date.
IPmt# Function
◄Syntax► ◄Details► ◄Example► ◄Contents► ◄Index► ◄Back►
──────────────────────────────────────────────────────────────────────────────
IPmt# (rate#, per#, nper#, pv#, fv#, type%, status%)
■ rate# The interest rate per period (for example, .12).
■ per# The payment period; must be in the range from 1 to nper#.
■ nper# The number of payment periods in the annuity.
■ pv# The present value.
■ fv# The future value.
■ type% An integer expression: 0 = end-of-period payment;
1 = beginning-of-period payment.
■ status% A variable that indicates calculation success of failure:
0 = success; 1 = failure.
Returns
The interest payment for a given period of an annuity based on
periodic, constant payments and a constant interest rate.
See Also ◄FV#► ◄NPer#► ◄PPmt#► ◄Pmt#► ◄PV#► ◄Rate#►