Manuals/calci/IPMT - Revision history

Devika at 22:34, 29 June 2018

2018-06-29T22:34:13Z

Devika at 22:30, 29 June 2018

2018-06-29T22:30:50Z

Jayaram at 10:51, 14 March 2017

2017-03-14T10:51:48Z

Devika at 22:01, 22 April 2016

2016-04-22T22:01:18Z

Swapna at 19:45, 12 June 2015

2015-06-12T19:45:36Z

Devika: /* ZOS Section */

2015-06-03T17:16:39Z

ZOS Section

Devika at 06:03, 25 June 2014

2014-06-25T06:03:54Z

Devika: /* See Also */

2014-06-25T06:03:04Z

Devika at 05:54, 25 June 2014

2014-06-25T05:54:18Z

Devika: /* Examples */

2014-03-06T05:56:51Z

Examples

@@ Line 12: / Line 12: @@
 *This function can be used to calculate the payments for a loan or the future value of an investment.
 *In <math>IPMT (Rate,Period,NoPaymentPeriods,PresentValue,FutureValue,Type)</math>, where <math>Rate</math> is the rate of interest for a year
-*<math>Period</math>  is the period for which the interest payment is to be calculated. It must be a value between <math>1</math> and <math>np</math>.
+*<math>Period</math>  is the period for which the interest payment is to be calculated. It must be a value between <math>1</math> and <math>NoPaymentPeriods</math>.
 *<math>NoPaymentPeriods</math> is the total number of periods over which the loan or investment is to be paid.
 *<math>PresentValue</math> is the present value of the loan.
-*<math>FutureValue</math> is the future value of the loan, at the end of <math>np</math> payment.
+*<math>FutureValue</math> is the future value of the loan, at the end of <math>NoPaymentPeriods</math> payment.
 *<math>Type</math> is the number <math>0</math> or <math>1</math>.
 *When type value is <math>0</math> means the payment is made at the end of the period and type value is <math>1</math> means the payment is made at the beginning of the period
@@ Line 22: / Line 22: @@
 *Also when we are not giving the <math>Type</math> value, the default value is <math>0</math>.
 *Suppose we calculate the monthly payments instead of annual payment, for the argument <math>Rate</math> we have to divide by <math>12</math> and the <math>np</math> value we have multiply with <math>12</math>.
-*For e.g. The  monthly payments on a 5 year loan at 10% annual interest, we have to give the arguments <math>rate</math> and <math>np</math> as 10%/12 for <math>Rate</math> and 5*12 for <math>NoPaymentPeriods</math>.
+*For e.g. The  monthly payments on a 5 year loan at 10% annual interest, we have to give the arguments <math>Rate</math> and <math>NoPaymentPeriods</math> as 10%/12 for <math>Rate</math> and 5*12 for <math>NoPaymentPeriods</math>.
 *This function will give result as error when
   Any one of the argument is non-numeric

@@ Line 1: / Line 1: @@
-<div style="font-size:30px">'''IPMT(rate,period,no.paymentperiods,presentvalue,futurevalue,Type)'''</div><br/>
+<div style="font-size:30px">'''IPMT (Rate,Period,NoPaymentPeriods,PresentValue,FutureValue,Type)'''</div><br/>
-*<math>rate</math> is the annual rate of interest.
+*<math>Rate</math> is the annual rate of interest.
-*<math>periods</math> is the period of  to find the interest rate.
+*<math>Period</math> is the period of  to find the interest rate.
-*<math>no.paymentperiods</math> is the number of installments.
+*<math>NoPaymentPeriods</math> is the number of installments.
-*<math>presentvalue</math> is the present value.
+*<math>PresentValue</math> is the present value.
-*<math>futurevalue</math> is the future value.
+*<math>FutureValue</math> is the future value.
 *<math>Type</math> is either 1 or 0.
 ==Description==
 *This function gives amount of interest for a particular time, according to the periodic, fixed payments and fixed  interest rate.
 *This function can be used to calculate the payments for a loan or the future value of an investment.
-*In <math>IPMT(rate,period,no.paymentperiods,presentvalue,futurevalue,Type)</math>, where <math>rate</math> is the rate of interest for a year
+*In <math>IPMT (Rate,Period,NoPaymentPeriods,PresentValue,FutureValue,Type)</math>, where <math>Rate</math> is the rate of interest for a year
-*<math>period</math>  is the period for which the interest payment is to be calculated. It must be a value between <math>1</math> and <math>np</math>.
+*<math>Period</math>  is the period for which the interest payment is to be calculated. It must be a value between <math>1</math> and <math>np</math>.
-*<math>no.paymentperiods</math> is the total number of periods over which the loan or investment is to be paid.
+*<math>NoPaymentPeriods</math> is the total number of periods over which the loan or investment is to be paid.
-*<math>presentvalue</math> is the present value of the loan.
+*<math>PresentValue</math> is the present value of the loan.
-*<math>futurevalue</math> is the future value of the loan, at the end of <math>np</math> payment.
+*<math>FutureValue</math> is the future value of the loan, at the end of <math>np</math> payment.
 *<math>Type</math> is the number <math>0</math> or <math>1</math>.
 *When type value is <math>0</math> means the payment is made at the end of the period and type value is <math>1</math> means the payment is made at the beginning of the period
-*Here the arguments <math>futurevalue</math> and <math>Type</math> are optional.
+*Here the arguments <math>FutureValue</math> and <math>Type</math> are optional.
-*Suppose we omit the value of <math>futurevalue</math>, then it will consider the value as <math>0</math>.
+*Suppose we omit the value of <math>FutureValue</math>, then it will consider the value as <math>0</math>.
 *Also when we are not giving the <math>Type</math> value, the default value is <math>0</math>.
-*Suppose we calculate the monthly payments instead of annual payment, for the argument <math>rate</math> we have to divide by <math>12</math> and the <math>np</math> value we have multiply with <math>12</math>.
+*Suppose we calculate the monthly payments instead of annual payment, for the argument <math>Rate</math> we have to divide by <math>12</math> and the <math>np</math> value we have multiply with <math>12</math>.
-*For e.g. The  monthly payments on a 5 year loan at 10% annual interest, we have to give the arguments <math>rate</math> and <math>np</math> as 10%/12 for <math>rate</math> and 5*12 for <math>no.paymentperiods</math>.
+*For e.g. The  monthly payments on a 5 year loan at 10% annual interest, we have to give the arguments <math>rate</math> and <math>np</math> as 10%/12 for <math>Rate</math> and 5*12 for <math>NoPaymentPeriods</math>.
 *This function will give result as error when
   Any one of the argument is non-numeric
-  <math>period < 0</math> or <math>period > no.paymentperiods</math>
+  <math>Period < 0</math> or <math>period > NoPaymentPeriods</math>
 ==ZOS==
-*The syntax is to calculate amount of interest for a particular time in ZOS is <math>IPMT(rate,period,no.paymentperiods,presentvalue,futurevalue,Type)</math>
+*The syntax is to calculate amount of interest for a particular time in ZOS is
-**<math>rate</math> is the annual rate of interest.
+<math>IPMT (Rate,Period,NoPaymentPeriods,PresentValue,FutureValue,Type)</math>
-**<math>periods</math> is the period of  to find the interest rate.
+**<math>Rate</math> is the annual rate of interest.
-**<math>no.paymentperiods</math> is the number of installments.
+**<math>Periods</math> is the period of  to find the interest rate.
-**<math>presentvalue</math> is the present value.
+**<math>NoPaymentPeriods</math> is the number of installments.
-**<math>futurevalue</math> is the future value.
+**<math>PresentValue</math> is the present value.
 **<math>Type</math> is either 1 or 0.
 *For e.g.,

← Older revision		Revision as of 10:51, 14 March 2017
Line 56:		Line 56:
	==References==		==References==
	[http://en.wikipedia.org/wiki/Binary_logarithm Binary Logarithm]		[http://en.wikipedia.org/wiki/Binary_logarithm Binary Logarithm]
		+
		+
		+
		+	*[[Z_API_Functions \| List of Main Z Functions]]
		+
		+	*[[ Z3 \| Z3 home ]]

@@ Line 40: / Line 40: @@
 *1.Calculate the interest payment during half yearly 1 and 2 of a loan for 50,000, that is to be reduced to 10,000 over a period of 3 years, by a series of constant half-yearly payments.
 *Interest is charged at a rate of 4.5% per year and the payment is made at the beginning of each half year.
-*IPMT(4.5%/2,3,2*2,50000,10000,1)= -480.666
+*IPMT(4.5%/2,3,2*2,50000,10000,1)= -454.78404196736113
 *2.The interest payment for a $55000 investment that earns 7.50% annually  for 15 years.
 *The interest payment is calculated for the 5th year and payments are due at the end of each year.

@@ Line 44: / Line 44: @@
 *The interest payment is calculated for the 5th year and payments are due at the end of each year.
 IPMT(7.5%/1, 5, 15*1, 55000)=-3418.570
 ==See Also==

@@ Line 49: / Line 49: @@
 *[[Manuals/calci/PMT| PMT]]
 *[[Manuals/calci/PPMT| PPMT]]
-*[[Manuals/calci/IPMT| PV]]
+*[[Manuals/calci/PV| PV]]
 ==References==
 [http://en.wikipedia.org/wiki/Binary_logarithm  Binary Logarithm]