|
<< Click to Display Table of Contents >> IPMT (interest payment) |
Syntax:
IPMT(Rate, Per, NPer, PV [, FV] [, Type])
Description:
Returns the interest due in the specified period, based on an investment with periodic constant payments, and a constant interest rate.
You can use this function, for example, to calculate how large the interest portion of the annuity is in a particular period for a loan.
"Period" means a payment period. For example, for a loan with monthly repayments, the third period is the third month.
The function expects the following arguments:
Rate is the interest rate (per payment period).
Per is the payment period to be evaluated.
NPer is the total number of payment periods.
PV is the present value.
FV (optional) is the future value (the total value after the last payment). If omitted, it will be set to zero.
Type (optional) is the timing of the payments:
0 or omitted: Payment at the end of each period.
1: Payment at the beginning of each period.
Example:
A loan of $100,000 is taken out under the following terms:
Annual interest rate: 10%
Payments: monthly
Duration: 6 years
What is the interest portion of the payment (annuity) in month 32?
IPMT(10%/12, 32, 72, 100000) returns -534
Note that all values have to use the same time unit, months in this case, since the payments are made monthly.
Therefore, in the above formula, the yearly interest rate had to be divided by 12 to get the monthly interest rate.
Annotation:
The PPMT function is the counterpart to IPMT: It supplies the principle portion of the payment in this period.
The PMT function, on the other hand, returns the total amount of the payment (annuity) per period, that is, the sum of the principal portion and the interest portion.
See also: