Changes

<div style="font-size:30px">'''PV(r,np,pmt,fv,ty)'''</div><br/>

<div style="font-size:30px">'''PV(r,np,pmt,fv,ty)'''</div><br/>

*<math>r</math>  is the interest rate.

*<math>np</math> is the total number of payment periods.

 

*<math>pmt</math> is the amount of the payment made each period.

*<math>Rate</math>  is the interest rate.

*<math>fv</math> is the future value.

*<math>NoPaymentPeriods</math> is the total number of payment periods.

*<math>ty</math> is the type.

*<math>Payment</math> is the amount of the payment made each period.

*<math>FutureValue</math> is the future value.

*<math>Type</math> is the type.

==Description==

==Description==

*It is  based on an interest rate and a constant payment schedule.  

*It is  based on an interest rate and a constant payment schedule.  

*This function calculates the present value of an investment, which is the total amount that a series of future payments is worth presently.  

*This function calculates the present value of an investment, which is the total amount that a series of future payments is worth presently.  

*In <math>PV(r,np,pmt,fv,ty)</math>,<math>r</math> is the rate of interest for the period.

*In <math>PV (Rate,NoPaymentPeriods,Payment,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.  

*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>r</math> value as  8%/12 or 0.6667% or 0.006667 in to the formula as the rate.

*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>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>pmt</math>  is the payment made each period in the annuity.  

*<math>Payment</math>  is the payment made each period in the annuity.  

*Normally, the payment is set over the life of the annuity and includes principal plus interest without any other fees.

*Normally, the payment is set over the life of the annuity and includes principal plus interest without any other fees.

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

|-

|-