Difference between revisions of "Manuals/calci/PPMT"

From ZCubes Wiki
Jump to navigation Jump to search
Line 9: Line 9:
  
 
==Description==
 
==Description==
−
This function gives the payment on the principal for a given period. 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.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.pe indicates the period and it is lying with in 1 to nper.np 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.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. ty 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.
+
*This function gives the payment on the principal for a given period.  
−
ty value           Explanation
+
*It is based on the period, fixed payments and a fixed interest rate.  
−
0                     Payments are due at the end of the period.
+
*This function calculates payment for an investment or a loan with the assumption of constant payments at regular intervals and a fixed interest rate.  
−
1                     Payments are due at the beginning of the period. 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.
+
*In PPMT(r,pe,np,pv,fv,ty),  r 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.
−
where where r , , , ,  and  .
+
*pe indicates the period and it is lying with in 1 to nper.
−
 
+
*np 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.
−
 
+
*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.  
−
<div id="6SpaceContent" class="zcontent" align="left">
+
*ty 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.
−
'''PPMT'''(Rate, Period, NoPayments, PresentValue, FutureValue, Type)
+
{| class="wikitable"
−
 
+
|-
−
where,
+
! ty value
−
 
+
! Explanation
−
'''Rate''' - represents the interest rate for the loan.
+
|-
−
 
+
| 0
−
'''Period''' - represent the period and start from 1 to NoPayments.
+
| Payments are due at the end of the period
−
 
+
|-
−
'''NoPayments''' - the total number of payments period in a year.
+
| 1
−
 
+
|Payments are due at the beginning of the period
−
'''PresentValue''' - represents the present value.
+
|}
−
 
+
*The interest rate is divided by 12 to get a monthly rate.  
−
'''FutureValue''' - represents the future value.
+
*The number of years the money is paid out is multiplied by 12 to get the number of payments.
−
 
 
−
If omitted cosidered as a 0.
 
−
 
 
−
'''Type''' - represents payments due.
 
−
 
 
−
'''Type              Payment Due'''
 
−
 
 
−
0 or omitted    end of the period
 
−
 
 
−
1                     beginning of the period
 
−
 
 
−
</div>
 
−
----
 
−
<div id="1SpaceContent" class="zcontent" align="left">
 
−
 
 
−
It returns the paymenton the principal for agiven period for an investment based on periodic, constant interest rate and constant payments.
 
−
 
 
−
</div>
 
−
----
 
−
<div id="7SpaceContent" class="zcontent" align="left">
 
−
 
 
−
If Type other than 0 or 1, PPMT returns the #ERROR.
 
−
 
 
−
</div>
 
−
----
 
−
<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">
 
−
 
 
−
PPMT
 
−
 
 
−
</div></div>
 
−
----
 
−
<div id="8SpaceContent" class="zcontent" align="left">
 
  
−
Lets see an example in (Column1, Row6)
 
  
−
UNIQf4b9b6692e59938e-nowiki-00000004-QINU
+
==Examples==
 +
#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 returns -469.644554(the interest rate divided by 12 to get a monthly rate).
 
  
−
Consider another example
+
==See Also==
 +
*[[Manuals/calci/FV  | FV ]]
 +
*[[Manuals/calci/IPMT  | IPMT ]]
 +
*[[Manuals/calci/PMT  | PMT ]]
 +
*[[Manuals/calci/PV  | PV ]]
  
−
UNIQf4b9b6692e59938e-nowiki-00000005-QINU
 
−
 
−
It returns #ERROR(type=4).
 
−
 
−
</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"
 
−
|- class="even"
 
−
| class=" " |
 
−
| Column1
 
−
| class="      " | 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="sshl_f" | -469.644554
 
−
|
 
−
|
 
−
|
 
−
|- class="odd"
 
−
| class=" " | Row5
 
−
| 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>
 
−
|
 
−
|
 
−
|
 
−
|- class="even"
 
−
| Row6
 
−
|
 
−
|
 
−
|
 
−
|
 
−
|}
 
  
−
<div align="left">[[Image:calci1.gif]]</div></div>
+
==References==
−
----
 

Revision as of 02:23, 28 February 2014

PPMT(r,pe,np,pv,fv,ty)


  • is the interest rate.
  • is the period.
  • is the total number of payment periods.
  • is the at present value.
  • is the future value.
  • is the type.


Description

  • This function gives the payment on the principal for a given period.
  • 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.
  • 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.
  • pe indicates the period and it is lying with in 1 to nper.
  • np 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.
  • 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.
  • ty 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.
ty value Explanation
0 Payments are due at the end of the period
1 Payments are due at the beginning of the period
  • 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

  1. PPMT(11%/12,1,5*12,50000) = -628.78782029
  2. PPMT(8%/12,1,4*12,10000,1000,0) = -195.208812423
  3. PPMT(8%/12,1,4*12,10000,1000,1) = -193.474537727


See Also


References

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