Manuals/calci/PPMT - Revision history

Devika: /* Related Videos */

2018-11-15T21:04:04Z

Devika at 23:36, 23 July 2018

2018-07-23T23:36:17Z

Devika at 23:35, 23 July 2018

2018-07-23T23:35:06Z

Swapna: /* Examples */

2018-03-02T10:59:58Z

Examples

Jayaram at 11:03, 14 March 2017

2017-03-14T11:03:09Z

Swapna at 18:54, 19 July 2015

2015-07-19T18:54:50Z

Devika at 18:13, 13 May 2015

2015-05-13T18:13:57Z

Devika: /* Description */

2014-02-28T09:25:35Z

Description

Devika at 08:23, 28 February 2014

2014-02-28T08:23:17Z

Devika at 09:42, 24 February 2014

2014-02-24T09:42:29Z

@@ Line 41: / Line 41: @@
 ==Related Videos==
-{{#ev:youtube|Lyyjg0iW-T4|280|center|PPMT}}
+{{#ev:youtube|v=AqJeL9ygmuI|280|center|PPMT}}
 ==See Also==

@@ Line 1: / Line 1: @@
-<div style="font-size:30px">'''PPMT(r,pe,np,pv,fv,ty)'''</div><br/>
+<div style="font-size:30px">'''PPMT (Rate,Period,NoPaymentPeriods,PresentValue,FutureValue,Type)'''</div><br/>
 *<math>Rate </math> is the interest rate.
 *<math> Period </math> is the period.
@@ Line 6: / Line 6: @@
 *<math> FutureValue </math> is the future value.
 *<math> Type </math> is the type.
-PPMT (Rate,Period,NoPaymentPeriods,PresentValue,FutureValue,Type)
+**PPMT(),returns the payment on the principal for an investment for a given period
 ==Description==

@@ Line 1: / Line 1: @@
 <div style="font-size:30px">'''PPMT(r,pe,np,pv,fv,ty)'''</div><br/>
-*<math>r </math> is the interest rate.
+*<math>Rate </math> is the interest rate.
-*<math> pe </math> is the period.
+*<math> Period </math> is the period.
-*<math> np </math> is the total number of payment periods.
+*<math> NoPaymentPeriods </math> is the total number of payment periods.
-*<math> pv </math> is the at present value.
+*<math> PresentValue </math> is the at present value.
-*<math> fv </math> is the future value.
+*<math> FutureValue </math> is the future value.
-*<math> ty </math> is the type.
+*<math> Type </math> is the type.
@@ Line 12: / Line 13: @@
 *It is based on the period, fixed payments and a fixed interest rate.
 *This function calculates payment for an investment or a loan with the assumption of constant payments at regular intervals and a fixed interest rate.
-*In <math>PPMT(r,pe,np,pv,fv,ty)</math>, <math> r </math> is the rate of interest for the period.
+*In <math>PPMT (Rate,Period,NoPaymentPeriods,PresentValue,FutureValue,Type)</math>, <math> Rate </math> is the rate of interest for the period.
-*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.
+*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.
-*<math> pe </math> indicates the period and it is lying with in 1 to nper.
+*<math> Period </math> indicates the period and it is lying with in 1 to nper.
-*<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-the total amount that a series of future payments is worth now.
+*<math> PresentValue </math> is the present value-the total amount that a series of future payments is worth now.
-*<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.
-*<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 37: / Line 37: @@
 #PPMT(11%/12,1,5*12,50000) = -628.78782029
 #PPMT(8%/12,1,4*12,10000,1000,0) = -195.208812423
-#PPMT(8%/12,1,4*12,10000,1000,1) = -193.474537727
+#PPMT(8%/12,1,4*12,10000,1000,1) = -260.14120439390365
 ==Related Videos==

← Older revision		Revision as of 11:03, 14 March 2017
Line 51:		Line 51:
	==References==		==References==
	*[https://wiki.openoffice.org/wiki/Documentation/How_Tos/Calc:_PPMT_function Ppmt]		*[https://wiki.openoffice.org/wiki/Documentation/How_Tos/Calc:_PPMT_function Ppmt]
		+
		+
		+
		+	*[[Z_API_Functions \| List of Main Z Functions]]
		+
		+	*[[ Z3 \| Z3 home ]]

@@ Line 38: / Line 38: @@
 #PPMT(8%/12,1,4*12,10000,1000,0) = -195.208812423
 #PPMT(8%/12,1,4*12,10000,1000,1) = -193.474537727
 ==See Also==
@@ Line 45: / Line 44: @@
 *[[Manuals/calci/PMT  | PMT ]]
 *[[Manuals/calci/PV  | PV ]]
 ==References==

@@ Line 12: / Line 12: @@
 *It is based on the period, fixed payments and a fixed interest rate.
 *This function calculates payment for an investment or a loan with the assumption of constant payments at regular intervals and a fixed interest rate.
-*In PPMT(r,pe,np,pv,fv,ty),  r is the rate of interest for the period.
+*In <math>PPMT(r,pe,np,pv,fv,ty)</math>, <math> r </math> is the rate of interest for the period.
-*Suppose we are taking  a loan for 8 percent annual interest rate and paying the amount in monthly, then the r value is 8%/12. So we have to enter the r value as  8%/12 or 0.6667% or 0.006667 in to the formula as the rate.
+*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.
-*pe indicates the period and it is lying with in 1 to nper.
+*<math> pe </math> indicates the period and it is lying with in 1 to nper.
-*np is the total number of payment periods in an annuity.
+*<math> np </math> is the total number of payment periods in an annuity.
-*pv is the present value-the total amount that a series of future payments is worth now.
+*<math> pv </math> is the present value-the total amount that a series of future payments is worth now.
-*fv 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 fv ,then it is assumed to be 0.
+*<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.
-*ty is the number 0 or 1 which is specifies the time to make a payment during the period.
+*<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 ty, then it is assumed to be 0.
+*when we are not giving the value of <math> ty </math>, then it is assumed to be 0.
 {| class="wikitable"
 |-
@@ Line 33: / Line 33: @@
 *The interest rate is divided by 12 to get a monthly rate.
 *The number of years the money is paid out is multiplied by 12 to get the number of payments.
 ==Examples==

@@ Line 1: / Line 1: @@
 <div id="6SpaceContent" class="zcontent" align="left">
@@ Line 49: / Line 68: @@
 Lets see an example in (Column1, Row6)
-<nowiki>=PPMT(0.2/12, 1, R2C1*12, R3C1,0,1)</nowiki>
+UNIQf4b9b6692e59938e-nowiki-00000004-QINU
 PPMT returns -469.644554(the interest rate divided by 12 to get a monthly rate).
@@ Line 55: / Line 74: @@
 Consider another example
-<nowiki>=PPMT(0.1/12,1,4*12,,52000,1,4)</nowiki>
+UNIQf4b9b6692e59938e-nowiki-00000005-QINU
 It returns #ERROR(type=4).