|
<< Click to Display Table of Contents >> PPMT (payment on the principal) |
Syntax:
PPMT(Rate, Per, NPer, PV [, FV] [, Type])
Description:
Returns the principal due in the given period of an investment based on periodic constant payments, and a constant interest rate.
You can use this function, for example, to calculate how large the principal 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%
Repayments: monthly
Duration: 6 years
How much is the principal portion in the 32nd period (i.e., the 32nd month)?
PPMT(10%/12, 32, 72, 100000) returns -1.318.
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 IPMT function is the counterpart to PPMT: It supplies the interest 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: