Difference between revisions of "Manuals/calci/IPMT"

From ZCubes Wiki
Jump to navigation Jump to search
(Created page with "<div id="6SpaceContent" class="zcontent" align="left">  <font color="#000000">'''<font face="Arial, sans-serif"><font size="2">IPMT(R, per, nper, P value, F value, type)</...")
 
Line 1: Line 1:
−
<div id="6SpaceContent" class="zcontent" align="left"> 
+
<div style="font-size:30px">'''IPMT(r,pr,np,pv,fv,type)'''</div><br/>
 +
*<math>r</math> is the annual rate of interest.
 +
*<math>pr</math> is the period of  to find the interest rate.
 +
*<math>np</math> is the number of installments.
 +
*<math>pv</math> is the present value.
 +
*<math>fv</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,fixedpayments and fixed  interest rate.
 +
*This function can be used to calculate the payments for a loan or the future value of an investment.
 +
*In IPMT(r,pr,np,pv,fv,type) , where r is the rate of interest for a year, pr  is the period for which the interest payment is to be calculated.
 +
*It must be a value between 1 and np.np is the total number of  periods over which the loan or investment is to be paid, pv is the present value of the loan,fv is the future value of the loan, at the end of np payment.
 +
*Type is the number 0 or 1.
 +
*When type value is  0 means the payment is made at the end of the period and type value is 1 means the payment is made at the beginning of the period
 +
*Here the arguments fv and type are optional.
 +
*Suppose we are omitted the value of fv , then it will consider the value as '0'.
 +
*Also when we are not giving the type value, the default value is '0'.
 +
*Suppose we calculating the monthly payments instead of annual payment, for the argument r we have to divede by 12 and the np value we have multiply with 12.
 +
*For e.g., The  monthly payments on a 5 year loan at 10% annual interst, we have to give the arguments r and np as 10%/12 for r and 5*12 for np.
 +
*This function will give result as error when
 +
#Any one of the argument is nonnumeric
 +
#pr < 0 or pr > np
  
−
<font color="#000000">'''<font face="Arial, sans-serif"><font size="2">IPMT(R, per, nper, P value, F value, type)</font></font>'''</font>
+
==Examples==
  
−
<font color="#000000"><font face="Arial, sans-serif"><font size="2">'''Where 'R''''</font></font><font face="Arial, sans-serif"><font size="2"> is the interest rate per period, 'per' is the period to find the interest, 'nper' is the total number of payment periods in an annuity, 'P value' is the present value, 'F value' is the future value and 'type' indicates when payments are due. </font></font></font>
+
*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 halfyearly payments.
 +
*Interest is charged at a rate of 4.5% per year and the payment is made at the beginning of each halfyearly.
 +
*IPMT(4.5%/2,3,2*2,50000,10000,1)=-454.78 (EXCEL)=-480.666(CALCI)
 +
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.
 +
IPMT(7.5%/1, 5, 15*1, 55000)=-3418.570
  
−
</div>
 
−
----
 
−
<div id="1SpaceContent" class="zcontent" align="left"> 
 
  
−
<font color="#000000"><font face="Arial, sans-serif"><font size="2">This function returns the interest payment for a given period for an investment.</font></font></font>
 
  
−
</div>
+
==References==
−
----
+
[http://en.wikipedia.org/wiki/Bessel_function Bessel Function]
−
<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">
 
−
 
 
−
IPMT
 
−
 
 
−
</div></div>
 
−
----
 
−
<div id="8SpaceContent" class="zcontent" align="left"><font color="#000000"><font face="Arial, sans-serif"><font size="2">Lets see an example,</font></font></font>
 
−
 
 
−
<font color="#000000"><font face="Arial, sans-serif"><font size="2">IPMT(R, per, nper, P value, F value, type)</font></font></font>
 
−
 
 
−
<font color="#000000"><font face="Arial, sans-serif"><font size="2">B</font></font></font>
 
−
 
 
−
<font color="#000000"><font face="Arial, sans-serif"><font size="2">15%</font></font></font>
 
−
 
 
−
<font color="#000000"><font face="Arial, sans-serif"><font size="2">1</font></font></font>
 
−
 
 
−
<font color="#000000"><font face="Arial, sans-serif"><font size="2">3</font></font></font>
 
−
 
 
−
<font color="#000000"><font face="Arial, sans-serif"><font size="2">7500</font></font></font>
 
−
 
 
−
<font color="#000000"><font face="Arial, sans-serif"><font size="2"><nowiki>=IPMT(B2, 3, B4, B5) is -428.4557</nowiki></font></font></font>
 
−
 
 
−
</div>
 
−
----
 
−
<div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Syntax </div><div class="ZEditBox"><center></center></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="4SpaceContent" class="zcontent" align="left">
 
−
 
 
−
{| id="TABLE1" class="SpreadSheet blue"
 
−
|- class="even"
 
−
| class=" " |
 
−
| Column1
 
−
| Column2
 
−
| Column3
 
−
| Column4
 
−
|- class="odd"
 
−
| class=" " | Row1
 
−
| class="sshl_f" | 15%
 
−
| class="                                                                                                                                                " |
 
−
| class=" " |
 
−
| class=" " |
 
−
|- class="even"
 
−
| class=" " | Row2
 
−
| class="sshl_f" | 1
 
−
| class=" " |
 
−
| class=" " |
 
−
| class=" " |
 
−
|- class="odd"
 
−
| Row3
 
−
| class="sshl_f" | 3
 
−
| class=" " |
 
−
| class=" " |
 
−
| class=" " |
 
−
|- class="even"
 
−
| Row4
 
−
| class="sshl_f" | 7500
 
−
| class=" " |
 
−
| class=" " |
 
−
| class=" " |
 
−
|- class="odd"
 
−
| class=" " | Row5
 
−
| class="sshl_f" | -428.4557
 
−
| class=" " |
 
−
| class=" " |
 
−
| class=" " |
 
−
|- class="even"
 
−
| Row6
 
−
| class="    " |
 
−
| class=" " |
 
−
| class=" " |
 
−
| class="  SelectTD  SelectTD" |
 
−
<div id="4Space_Handle" title="Click and Drag to resize CALCI Column/Row/Cell. It is EZ!"></div><div id="4Space_Copy" title="Click and Drag over to AutoFill other cells."></div>
 
−
|}
 
−
 
 
−
<div align="left">[[Image:calci1.gif]]</div></div>
 
−
----
 

Revision as of 04:36, 16 December 2013

IPMT(r,pr,np,pv,fv,type)


  • is the annual rate of interest.
  • is the period of to find the interest rate.
  • is the number of installments.
  • is the present value.
  • is the future value.
  • is either 1 or 0.

Description

  • This function gives amount of interest for a particular time ,according to the periodic,fixedpayments and fixed interest rate.
  • This function can be used to calculate the payments for a loan or the future value of an investment.
  • In IPMT(r,pr,np,pv,fv,type) , where r is the rate of interest for a year, pr is the period for which the interest payment is to be calculated.
  • It must be a value between 1 and np.np is the total number of periods over which the loan or investment is to be paid, pv is the present value of the loan,fv is the future value of the loan, at the end of np payment.
  • Type is the number 0 or 1.
  • When type value is 0 means the payment is made at the end of the period and type value is 1 means the payment is made at the beginning of the period
  • Here the arguments fv and type are optional.
  • Suppose we are omitted the value of fv , then it will consider the value as '0'.
  • Also when we are not giving the type value, the default value is '0'.
  • Suppose we calculating the monthly payments instead of annual payment, for the argument r we have to divede by 12 and the np value we have multiply with 12.
  • For e.g., The monthly payments on a 5 year loan at 10% annual interst, we have to give the arguments r and np as 10%/12 for r and 5*12 for np.
  • This function will give result as error when
  1. Any one of the argument is nonnumeric
  2. pr < 0 or pr > np

Examples

  • 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 halfyearly payments.
  • Interest is charged at a rate of 4.5% per year and the payment is made at the beginning of each halfyearly.
  • IPMT(4.5%/2,3,2*2,50000,10000,1)=-454.78 (EXCEL)=-480.666(CALCI)

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.

IPMT(7.5%/1, 5, 15*1, 55000)=-3418.570


References

Bessel Function

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