Changes

212 bytes added ,  23:35, 23 July 2018
no edit summary
Line 1: Line 1:  
<div style="font-size:30px">'''PPMT(r,pe,np,pv,fv,ty)'''</div><br/>
 
<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.
 +
PPMT (Rate,Period,NoPaymentPeriods,PresentValue,FutureValue,Type)
      Line 12: Line 13:  
*It is based on the period, fixed payments and a fixed interest rate.  
 
*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.  
 
*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"
 
{| class="wikitable"
 
|-
 
|-
! ty value
+
! Type value
 
! Explanation
 
! Explanation
 
|-
 
|-
writer
6,694

edits