Manuals/calci/PMT - Revision history

Devika at 23:31, 23 July 2018

2018-07-23T23:31:18Z

Devika at 23:29, 23 July 2018

2018-07-23T23:29:51Z

Devika at 23:29, 23 July 2018

2018-07-23T23:29:01Z

Jayaram at 11:02, 14 March 2017

2017-03-14T11:02:44Z

Swapna at 18:53, 19 July 2015

2015-07-19T18:53:52Z

Devika at 18:15, 3 June 2015

2015-06-03T18:15:37Z

Devika at 18:10, 13 May 2015

2015-05-13T18:10:14Z

Devika at 10:55, 24 September 2014

2014-09-24T10:55:20Z

Abin: /* ZOS Section */

2014-03-18T09:51:09Z

ZOS Section

Abin: /* Description */

2014-03-18T09:49:53Z

Description

@@ Line 6: / Line 6: @@
 *<math> FutureValue</math> is the future value.
 *<math> Type</math> is the type.
 ==Description==

← Older revision		Revision as of 23:29, 23 July 2018
Line 1:		Line 1:
−	<div style="font-size:30px">'''PMT(r,np,pv,fv,ty)'''</div><br/>	+	<div style="font-size:30px">'''PMT (Rate,NoPaymentPeriods,PresentValue,FutureValue,Type)'''</div><br/>
−	~~PMT (Rate,NoPaymentPeriods,PresentValue,FutureValue,Type)~~

	*<math>Rate </math> is the interest rate.		*<math>Rate </math> is the interest rate.

@@ Line 1: / Line 1: @@
 <div style="font-size:30px">'''PMT(r,np,pv,fv,ty)'''</div><br/>
-*<math>r </math> is the interest rate.
+PMT (Rate,NoPaymentPeriods,PresentValue,FutureValue,Type)
-*<math> np </math> is the total number of payment periods.
-*<math> pv </math> is the at present value.
+*<math>Rate </math> is the interest rate.
-*<math> fv </math> is the future value.
+*<math> NoPaymentPeriods </math> is the total number of payment periods.
-*<math> ty </math> is the type.
+*<math> PresentValue </math> is the at present value.
 ==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.
+*In <math>PMT (Rate,NoPaymentPeriods,PresentValue,FutureValue,Type)</math> ,<math> Rate </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.
+*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> r </math> value as  8%/12 or 0.6667% or 0.006667 in to the formula as the rate.
+*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.
-*<math> np </math> is the total number of payment periods in an annuity.
+*<math> NoPaymentPeriods </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> PresentValue </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.
+*<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.
-*<math> ty </math> is the number 0 or 1 which is specifies the time to make a payment during the period.
+*<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>ty</math>, then it is assumed to be 0.
+*when we are not giving the value of <math>Type</math>, then it is assumed to be 0.
 {| class="wikitable"
 |-
-! ty value
+! Type value
 ! Explanation
 |-
@@ Line 31: / Line 33: @@
 *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>.
+*Also to calculate the total amount paid during the loan period, multiply the returned <math> PMT </math> value by <math> NoPaymentPeriods </math>.
 ==ZOS Section==

← Older revision		Revision as of 11:02, 14 March 2017
Line 59:		Line 59:
	==References==		==References==
	*[http://www.techonthenet.com/excel/formulas/pmt.php PMT]		*[http://www.techonthenet.com/excel/formulas/pmt.php PMT]
		+
		+
		+
		+	*[[Z_API_Functions \| List of Main Z Functions]]
		+
		+	*[[ Z3 \| Z3 home ]]

@@ Line 45: / Line 45: @@
 #=PMT(0.09/12,20,50000,10000,0) = -3166.8379163721
 #=PMT(0.09/12,20,50000,10000,1) = -3143.26344056
 ==See Also==

@@ Line 34: / Line 34: @@
 ==ZOS Section==
-*The function to calculate PMT in ZOS is
+*The function to calculate PMT in ZOS is PMT(Rate,NoPaymentPeriods,PresentValue,FutureValue,Type)
+*<math>rate </math> is the interest rate.
 ==Examples==

@@ Line 48: / Line 48: @@
 *[[Manuals/calci/NPER  | NPER ]]
 *[[Manuals/calci/PV  | PV ]]
 ==References==

@@ Line 38: / Line 38: @@
 ==Examples==
-#=PMT(11%/12,14,25000) = -1910.908677870
+#=PMT(0.11/12,14,25000) = -1910.908677870
-#=PMT(9%/12,20,50000,10000,0) = -3166.8379163721
+#=PMT(0.09/12,20,50000,10000,0) = -3166.8379163721
-#=PMT(9%/12,20,50000,10000,1) = -3143.26344056
+#=PMT(0.09/12,20,50000,10000,1) = -3143.26344056
 ==See Also==

← Older revision		Revision as of 09:51, 18 March 2014
Line 34:		Line 34:

	==ZOS Section==		==ZOS Section==
		+	*The function to calculate PMT in ZOS is
		+	:

	==Examples==		==Examples==

← Older revision		Revision as of 09:49, 18 March 2014
Line 33:		Line 33:
	*Also to calculate the total amount paid during the loan period, multiply the returned <math> PMT </math> value by <math> np </math>.		*Also to calculate the total amount paid during the loan period, multiply the returned <math> PMT </math> value by <math> np </math>.

		+	==ZOS Section==

	==Examples==		==Examples==