ZCubes Wiki

Difference between revisions of "Manuals/calci/PMT"

(Created page with "<div id="6SpaceContent" class="zcontent" align="left"> '''PMT'''(Rate, NoPayments, PresentValue, FutureValue, Type) where, '''Rate''' - represents the interest rate...")
 
 
(10 intermediate revisions by 4 users not shown)
Line 1: Line 1:
−
<div id="6SpaceContent" class="zcontent" align="left">
+
<div style="font-size:30px">'''PMT (Rate,NoPaymentPeriods,PresentValue,FutureValue,Type)'''</div><br/>
  
−
'''PMT'''(Rate, NoPayments, PresentValue, FutureValue, Type)
+
*<math>Rate </math> is the interest rate.
 +
*<math> NoPaymentPeriods </math> is the total number of payment periods.
 +
*<math> PresentValue </math> is the at present value.
 +
*<math> FutureValue</math> is the future value.
 +
*<math> Type</math> is the type.
 +
**PMT(), returns the periodic payment for an annuity
  
−
where,
 
  
−
'''Rate''' - represents the interest rate for the loan.
+
==Description==
−
 
+
*This functon gives the payment amount for the loan.
−
'''NoPayments''' - the total number of payments for the loan.
+
*It is based on the period, fixed payments and a fixed interest rate.
−
 
+
*In <math>PMT (Rate,NoPaymentPeriods,PresentValue,FutureValue,Type)</math> ,<math> Rate </math> is the annual rate of interest for the loan.
−
'''PresentValue''' - represents the present value.
+
*Suppose we are taking  a loan for 8 percent annual interest rate and paying the amount in monthly, then the <math> Rate </math> value is 8%/12.
−
 
+
*So we have to enter the <math> Rate </math> value as  8%/12 or 0.6667% or 0.006667 in to the formula as the rate.
−
'''FutureValue''' - represents the future value.
+
*<math> NoPaymentPeriods </math> is the total number of payment periods in an annuity.
−
 
+
*<math> PresentValue </math> is the present value or the amount borrowed or the principal of the loan.
−
If omitted cosidered as a 0.
+
*<math> FutureValue </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>FutureValue </math> ,then it is assumed to be 0.  
−
 
+
*i.e.,future value of a loan is 0.
−
'''Type''' - represents payments due.
+
*<math> Type </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>Type</math>, then it is assumed to be 0.
−
'''Type              Payment Due'''
+
{| class="wikitable"
−
 
+
|-
−
0 or omitted    end of the period
+
! Type value
−
 
+
! Explanation
−
1                     beginning of the period
+
|-
−
 
+
| 0
−
</div>
+
| Payments are due at the end of the period
−
----
+
|-
−
<div id="1SpaceContent" class="zcontent" align="left">
+
| 1
−
 
+
|Payments are due at the beginning of the period
−
It returns the payment for a loan based on constant interest rate and constant payments.
+
|}
−
 
+
*The amount given by the function <math> PMT </math> not containing any taxes,rserve payments or extra fees related with the loan.
−
</div>
+
*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> NoPaymentPeriods </math>.
−
<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>
+
==ZOS Section==
−
----
+
*The function to calculate PMT in ZOS is PMT(Rate,NoPaymentPeriods,PresentValue,FutureValue,Type)
−
<div id="8SpaceContent" class="zcontent" align="left">
+
*<math>rate </math> is the interest rate.
 +
*<math> NoPaymentPeriods </math> is the total number of payment periods.
 +
*<math> PresentValue </math> is the current value for the amount.
 +
*<math> FutureValue </math> is the future value.
 +
*For e.g.,PMT(0.62/12,19..22,34000)
  
−
Lets see an example in (Column1, Row6)
+
==Examples==
 +
#=PMT(0.11/12,14,25000) = -1910.908677870
 +
#=PMT(0.09/12,20,50000,10000,0) = -3166.8379163721
 +
#=PMT(0.09/12,20,50000,10000,1) = -3143.26344056
  
−
<nowiki>=PMT(0.2/12, R2C1, R3C1, R4C1, R5C1)</nowiki>
+
==Related Videos==
  
−
PMT returns -10333.287654.
+
{{#ev:youtube|k5xSlA1jpW4|280|center|PMT}}
  
−
Consider another example
+
==See Also==
 +
*[[Manuals/calci/FV  | FV ]]
 +
*[[Manuals/calci/IPMT  | IPMT ]]
 +
*[[Manuals/calci/PPMT  | PPMT ]]
 +
*[[Manuals/calci/NPER  | NPER ]]
 +
*[[Manuals/calci/PV  | PV ]]
  
−
<nowiki>=NPER(0.1/12,50,52000,1,4)</nowiki>
+
==References==
 +
*[http://www.techonthenet.com/excel/formulas/pmt.php PMT]
  
−
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"
+
*[[Z_API_Functions | List of Main Z Functions]]
−
|- 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>
+
*[[ Z3 |  Z3 home ]]
−
----
 

Latest revision as of 17:31, 23 July 2018

PMT (Rate,NoPaymentPeriods,PresentValue,FutureValue,Type)


  • Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Rate } is the interest rate.
  • Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle NoPaymentPeriods } is the total number of payment periods.
  • Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle PresentValue } is the at present value.
  • Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle FutureValue} is the future value.
  • Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Type} is the type.
    • PMT(), returns the periodic payment for an annuity


Description

  • This functon gives the payment amount for the loan.
  • It is based on the period, fixed payments and a fixed interest rate.
  • In Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle PMT (Rate,NoPaymentPeriods,PresentValue,FutureValue,Type)} ,Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Rate } 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 Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Rate } value is 8%/12.
  • So we have to enter the Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Rate } value as 8%/12 or 0.6667% or 0.006667 in to the formula as the rate.
  • Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle NoPaymentPeriods } is the total number of payment periods in an annuity.
  • Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle PresentValue } is the present value or the amount borrowed or the principal of the loan.
  • Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle FutureValue } 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 Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle FutureValue } ,then it is assumed to be 0.
  • i.e.,future value of a loan is 0.
  • Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle 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  , then it is assumed to be 0.
Type value Explanation
0 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 Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle PMT } 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 Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle PMT } value by Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle NoPaymentPeriods } .

ZOS Section

  • The function to calculate PMT in ZOS is PMT(Rate,NoPaymentPeriods,PresentValue,FutureValue,Type)
  • Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle rate } is the interest rate.
  • Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle NoPaymentPeriods } is the total number of payment periods.
  • Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle PresentValue } is the current value for the amount.
  • Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle FutureValue } is the future value.
  • For e.g.,PMT(0.62/12,19..22,34000)

Examples

  1. =PMT(0.11/12,14,25000) = -1910.908677870
  2. =PMT(0.09/12,20,50000,10000,0) = -3166.8379163721
  3. =PMT(0.09/12,20,50000,10000,1) = -3143.26344056

Related Videos

PMT

See Also

References


Retrieved from "http://wiki.zcubes.com/index.php?title=Manuals/calci/PMT&oldid=210765"