Manuals/calci/PV

PV(r,np,pmt,fv,ty)

• $r$ is the interest rate.
• $np$ is the total number of payment periods.
• $pmt$ is the amount of the payment made each period.
• $fv$ is the future value.
• $ty$ is the type.

Description

• This function gives the present value for an investment.
• 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.
• In $PV(r,np,pmt,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.
• $np<math>isthetotalnumberofpaymentperiodsinanannuity.*<math>pmt$ 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.
• $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 present value can be calculated using the following formula:

$PV={\frac {FV*1}{(1+r)^{n}}}$

• where $FV$ is the future value, $r$ is the rate of interest, $n$ is the number of periods.
• Also the result is coming in a negative sign ,it is indicating the money that we would pay, an outgoing cash flow.
• The interest rate is dividing by 12 to get a monthly rate.
• The years the money is paid out is multiplied by 12 to get the number of payments.

Examples

1. =PV(9.2%/12,15*12,10000,0) =-974470.2640587
2. =PV(5%/12,25*12,25000,0) = -4276501.176022
3. =PV(5%/12,25*12,25000,1) = -4276501.46327

where  ,, ,  , and  

PV(Rate, NoPaymentPeriods, Payments, FutureValue, Type)

where,

Rate - is the interest rate per period.

NoPaymentPeriods - is the total number of payment periods

Payments - the payment made each period, it not change over the life of the annnuity.Payment contains principal and interest but except other fees and taxes.If omitted, include PresentValue parameters.

FutureValue - the future value.If omitted assumed to be 0 and include Payments parameters.

Type - is indicates payments due by number  0 or 1

TYPE          Payments due

0              At the end of the period

1              At the beginning of the period

---

Returns the present vlaue of an investment.

---

If Type other than 0 or 1, PV returns the #ERROR.

---

PV

---

Lets see an example in (Column1, Row6)

?UNIQ581acce90e066248-nowiki-00000004-QINU?

PV returns -1245262.336586.

Consider an another example(Column1, Row2)

?UNIQ581acce90e066248-nowiki-00000005-QINU?

PV returns #ERROR(Type other than 0 or 1).

---

Syntax

---

Remarks

---

Examples

---

Description

---

	Column1	File:Copy-cube.gif  Column2	Column3	Column4
Row1	8000
Row2	2%
Row3	15
Row4	8
Row5	1
Row6	-1245262.336586

File:Calci1.gif

---