Difference between revisions of "Manuals/calci/PMTLISTING"

Latest revision as of 15:19, 22 February 2019

PMTLISTING (Rate,Period,NoPaymentPeriods,PresentValue,FutureValue,Type)

where

$Rate$ is the rate of interest.
$Period$ is the number of period.
is the number of installments.
- PMTLISTING() calculates the payment for a loan based on constant payments and a constant interest rate.

PMTLISTING (Rate,Period,NoPaymentPeriods,PresentValue,FutureValue,Type)

$Rate$ is the annual rate of interest for the loan.
$Period$ is the number of periods.
$NoPaymentPeriods$ is the total number of payment periods in an annuity.
$PresentValue$ is the present value or the amount borrowed or the principal of the loan.
$FutureValue$ is the future value of an investment or loan (the value you want to achieve at the end of all periods).
$Type$ is the number 0 or 1 which is specifies the time to make a payment during the period.
When we are not giving the value of ty, then it is assumed to be 0.
The amount given by the function PMT not containing any taxes,reserve payments or extra fees related with the loan.
But it contains only the principal amount and interest only.

PMTLISTING(0.09/12,10,20,50000,10000,0) = -3166.8379163721756 -2986.0405046809483 -180.7974116912274
PMTLISTING(0.11/12,7,14,25000) = -1910.9086778706514 -1776.3836036389553 -134.52507423169618
PMTLISTING(0.09/12,10,20,50000,10000,1) = -3143.263440567916 -2962.184262392901 -179.4515252518386

@@ Line 1: / Line 1: @@
 <div style="font-size:30px">'''PMTLISTING (Rate,Period,NoPaymentPeriods,PresentValue,FutureValue,Type)'''</div><br/>
+where
 *<math>Rate</math> is the rate of interest.
 *<math>Period</math> is the number of period.
 *<math>NoPaymentPeriods</math> is the number of installments.
+**PMTLISTING() calculates the payment for a loan based on constant payments and a constant interest rate.
 ==Description==
-*This function calculates the payment for a loan based on constant payments and a constant interest rate.
-*In <math>PMTLISTING (Rate,Period,NoPaymentPeriods,PresentValue,FutureValue,Type)</math>,<math>Rate</math> is the annual rate of interest for the loan.
+PMTLISTING (Rate,Period,NoPaymentPeriods,PresentValue,FutureValue,Type)
+*<math>Rate</math> is the annual rate of interest for the loan.
 *<math>Period</math> is the number of periods.
 *<math>NoPaymentPeriods</math> is the total number of payment periods in an annuity.
@@ Line 21: / Line 24: @@
 #PMTLISTING(0.11/12,7,14,25000) = -1910.9086778706514	  -1776.3836036389553	  -134.52507423169618
 #PMTLISTING(0.09/12,10,20,50000,10000,1) = -3143.263440567916	 -2962.184262392901	 -179.4515252518386
+==Related Videos==
+{{#ev:youtube|v=WzofplrjidU|280|center|PMT }}
 ==See Also==