| 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 |
| | |- | | |- |