writer
6,694
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − + + + + + + − '''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'''+ − + − + + + + + + + + − 1 beginning of the period − </div>+ − + − <div id="1SpaceContent" class="zcontent" align="left">+ + − It returns the payment for a loan based on constant interest rate and constant payments.+ + + + + + − </div> − ---- − <div id="7SpaceContent" class="zcontent" align="left"> − − If Type other than 0 or 1, PMT returns the #ERROR. − − </div> − ---- − <div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left"> − − PMT − − </div></div> − ---- − <div id="8SpaceContent" class="zcontent" align="left"> − − Lets see an example in (Column1, Row6) − − <nowiki>=PMT(0.2/12, R2C1, R3C1, R4C1, R5C1)</nowiki> − − PMT returns -10333.287654. − − Consider another example − − <nowiki>=NPER(0.1/12,50,52000,1,4)</nowiki> − − It returns #ERROR. − − </div> − ---- − <div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Syntax </div><div class="ZEditBox"><center></center></div></div> − ---- − <div id="4SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Remarks </div></div> − ---- − <div id="3SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Examples </div></div> − ---- − <div id="11SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Description </div></div> − ---- − <div id="2SpaceContent" class="zcontent" align="left"> − − {| id="TABLE3" class="SpreadSheet blue" − |- class="even" − | class=" " | − | Column1 − | class=" SelectTD ChangeBGColor SelectTD" | − <div id="2Space_Handle" class="zhandles" title="Click and Drag to resize CALCI Column/Row/Cell. It is EZ!"></div><div id="2Space_Copy" class="zhandles" title="Click and Drag over to AutoFill other cells."></div><div id="2Space_Drag" class="zhandles" title="Click and Drag to Move/Copy Area.">[[Image:copy-cube.gif]] </div>Column2 − | Column3 − | Column4 − |- class="odd" − | class=" " | Row1 − | class="sshl_f" | 20% − | − | − | − |- class="even" − | class=" " | Row2 − | class=" " | 5 − | − | − | − |- class="odd" − | Row3 − | class=" " | 50000 − | − | − | − |- class="even" − | class=" " | Row4 − | class=" " | 0 − | − | − | − |- class="odd" − | class=" " | Row5 − | class="sshl_f " | 1 − | − | − | − |- class="even" − | Row6 − | class="sshl_f" | -10333.287654 − | − | − | − |} − <div align="left">[[Image:calci1.gif]]</div></div>+ − ----
no edit summary
<div id="6SpaceContent" class="zcontent" align="left">
<div style="font-size:30px">'''PMT(r,np,pv,fv,ty)'''</div><br/>
*<math>r </math> is the interest rate.
*<math> np </math> is the total number of payment periods.
*<math> pv </math> is the at present value.
*<math> fv </math> is the future value.
*<math> ty </math> is the type.
==Description==
*This functon gives the payment amount for the loan.
*It is based on the period, fixed payments and a fixed interest rate.
*In <math>PMT(r,np,pv,fv,ty)</math> ,<math> r </math> is the annual rate of interest for the loan.
*Suppose we are taking a loan for 8 percent annual interest rate and paying the amount in monthly, then the <math> r </math> value is 8%/12.
*So we have to enter the <math> r </math> value as 8%/12 or 0.6667% or 0.006667 in to the formula as the rate.
*<math> np </math> is the total number of payment periods in an annuity.
*<math> pv </math> is the present value or the amount borrowed or the principal of the loan.
*<math> fv </math> is the future value of an investment or loan (the value you want to achieve at the end of all periods) when we are omitting the value of <math>fv </math> ,then it is assumed to be 0.
*i.e.,future value of a loan is 0.
*<math> ty </math> 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 <math>ty</math>, then it is assumed to be 0.
{| class="wikitable"
|-
! ty value
! Explanation
|-
| 0
0 or omitted end of the period
| Payments are due at the end of the period
|-
| 1
|Payments are due at the beginning of the period
|}
*The amount given by the function <math> PMT </math> not containing any taxes,rserve payments or extra fees related with the loan.
*But it contains only the principal amount and interest only.
*Also to calculate the total amount paid during the loan period, multiply the returned <math> PMT </math> value by <math> np </math>.
==Examples==
----
#=PMT(11%/12,14,25000) = -1910.908677870
#=PMT(9%/12,20,50000,10000,0) = -3166.8379163721
#=PMT(9%/12,20,50000,10000,1) = -3143.26344056
==See Also==
*[[Manuals/calci/FV | FV ]]
*[[Manuals/calci/IPMT | IPMT ]]
*[[Manuals/calci/PPMT | PPMT ]]
*[[Manuals/calci/NPER | NPER ]]
*[[Manuals/calci/PV | PV ]]
==References==