Manuals/calci/PPMT
PPMT(Rate, Period, NoPayments, PresentValue, FutureValue, Type)
where,
Rate - represents the interest rate for the loan.
Period - represent the period and start from 1 to NoPayments.
NoPayments - the total number of payments period in a year.
PresentValue - represents the present value.
FutureValue - represents the future value.
If omitted cosidered as a 0.
Type - represents payments due.
Type Payment Due
0 or omitted end of the period
1 beginning of the period
It returns the paymenton the principal for agiven period for an investment based on periodic, constant interest rate and constant payments.
If Type other than 0 or 1, PPMT returns the #ERROR.
PPMT
Lets see an example in (Column1, Row6)
=PPMT(0.2/12, 1, R2C1*12, R3C1,0,1)
PPMT returns -469.644554(the interest rate divided by 12 to get a monthly rate).
Consider another example
=PPMT(0.1/12,1,4*12,,52000,1,4)
It returns #ERROR(type=4).
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 20% | |||
| Row2 | 5 | |||
| Row3 | 50000 | |||
| Row4 | -469.644554 | |||
| Row5 | ||||
| Row6 |
