Manuals/calci/PMT
Jump to navigation
Jump to search
PMT(Rate, NoPayments, PresentValue, FutureValue, Type)
where,
Rate - represents the interest rate for the loan.
NoPayments - the total number of payments for the loan.
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 payment for a loan based on constant interest rate and constant payments.
If Type other than 0 or 1, PMT returns the #ERROR.
PMT
Lets see an example in (Column1, Row6)
=PMT(0.2/12, R2C1, R3C1, R4C1, R5C1)
PMT returns -10333.287654.
Consider another example
=NPER(0.1/12,50,52000,1,4)
It returns #ERROR.
Syntax
Remarks
Examples
Description
Column1 | Column2 | Column3 | Column4 | |
Row1 | 20% | |||
Row2 | 5 | |||
Row3 | 50000 | |||
Row4 | 0 | |||
Row5 | 1 | |||
Row6 | -10333.287654 |