Difference between revisions of "Manuals/calci/PPMT"

Latest revision as of 16:04, 15 November 2018

PPMT (Rate,Period,NoPaymentPeriods,PresentValue,FutureValue,Type)

$Rate$ is the interest rate.
$Period$ is the period.
$NoPaymentPeriods$ is the total number of payment periods.
$PresentValue$ is the at present value.
$FutureValue$ is the future value.
is the type.
- PPMT(),returns the payment on the principal for an investment for a given period

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(Rate,Period,NoPaymentPeriods,PresentValue,FutureValue,Type)$ , $Rate$ 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 $Rate$ value is 8%/12. So we have to enter the $Rate$ value as 8%/12 or 0.6667% or 0.006667 in to the formula as the rate.
$Period$ indicates the period and it is lying with in 1 to nper.
$NoPaymentPeriods$ is the total number of payment periods in an annuity.
$PresentValue$ is the present value-the total amount that a series of future payments is worth now.
$FutureValue$ 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 $FutureValue$ ,then it is assumed to be 0.
$Type$ 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 $Type$ , then it is assumed to be 0.

Type 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

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) = -260.14120439390365

References

Ppmt

List of Main Z Functions

Z3 home

@@ Line 1: / Line 1: @@
-<div id="6SpaceContent" class="zcontent" align="left">
+<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.
+*<math> NoPaymentPeriods </math> is the total number of payment periods.
+*<math> PresentValue </math> is the at present value.
+*<math> FutureValue </math> is the future value.
+*<math> Type </math> is the type.
+**PPMT(),returns the payment on the principal for an investment for a given period
-'''PPMT'''(Rate, Period, NoPayments, PresentValue, FutureValue, Type)
+==Description==
+*This function gives the payment on the principal for a given period.
-where,
+*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.
-'''Rate''' - represents the interest rate for the loan.
+*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> 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.
-'''Period''' - represent the period and start from 1 to NoPayments.
+*<math> Period </math> indicates the period and it is lying with in 1 to nper.
+*<math> NoPaymentPeriods </math> is the total number of payment periods in an annuity.
-'''NoPayments''' - the total number of payments period in a year.
+*<math> PresentValue </math> is the present value-the total amount that a series of future payments is worth now.
+*<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.
-'''PresentValue''' - represents the present value.
+*<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> Type </math>, then it is assumed to be 0.
-'''FutureValue''' - represents the future value.
+{| class="wikitable"
+|-
-If omitted cosidered as a 0.
+! Type value
+! Explanation
-'''Type''' - represents payments due.
+|-
+| 0
-'''Type              Payment Due'''
+| Payments are due at the end of the period
+|-
-or omitted    end of the period
+| 1
+|Payments are due at the beginning of the period
-                     beginning of the period
+|}
+*The interest rate is divided by 12 to get a monthly rate.
-</div>
+*The number of years the money is paid out is multiplied by 12 to get the number of payments.
-----
-<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>
+==Examples==
-----
+#PPMT(11%/12,1,5*12,50000) = -628.78782029
-<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">
+#PPMT(8%/12,1,4*12,10000,1000,0) = -195.208812423
+#PPMT(8%/12,1,4*12,10000,1000,1) = -260.14120439390365
-PPMT
+==Related Videos==
-</div></div>
+{{#ev:youtube|v=AqJeL9ygmuI|280|center|PPMT}}
-----
-<div id="8SpaceContent" class="zcontent" align="left">
-Lets see an example in (Column1, Row6)
+==See Also==
+*[[Manuals/calci/FV  | FV ]]
+*[[Manuals/calci/IPMT  | IPMT ]]
+*[[Manuals/calci/PMT  | PMT ]]
+*[[Manuals/calci/PV  | PV ]]
-<nowiki>=PPMT(0.2/12, 1, R2C1*12, R3C1,0,1)</nowiki>
+==References==
+*[https://wiki.openoffice.org/wiki/Documentation/How_Tos/Calc:_PPMT_function Ppmt]
-PPMT returns -469.644554(the interest rate divided by 12 to get a monthly rate).
-Consider another example
-<nowiki>=PPMT(0.1/12,1,4*12,,52000,1,4)</nowiki>
+*[[Z_API_Functions | List of Main Z Functions]]
-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>
+*[[ Z3 |   Z3 home ]]
-----

Difference between revisions of "Manuals/calci/PPMT"

Latest revision as of 16:04, 15 November 2018

Contents

Description

Examples

Related Videos

See Also

References

Navigation menu

Search