Siebel VB Language Reference > VB Language Reference >
PV Function
This standard VB function returns the present value of a constant periodic stream of cash flows as in an annuity or a loan. Syntax
PV(rate, nper, pmt, fv, due)


rate 
The interest rate per period 
nper 
The total number of payment periods 
pmt 
The constant periodic payment per period 
fv 
The future value of the final lump sum amount required (as with a savings plan) or paid (0 as with a loan) 
due 
0 if due at the end of each period 1 if due at the beginning of each period 
Returns
The present value of a constant periodic stream of cash flows. Usage
Rate is assumed constant over the life of the annuity. If payments are on a monthly schedule, then rate is 0.0075 if the annual percentage rate on the annuity or loan is 9%. Example
This example finds the present value of a 10year $25,000 annuity that pays $1,000 a year at 9.5%. Sub Button_Click Dim aprate As Integer, periods As Integer Dim payment As Double, annuityfv As Double Dim due As Integer, presentvalue As Double Dim msgtext aprate = 9.5 periods = 120 payment = 1000 annuityfv = 25000 ' Assume payments are made at end of month due = 0 presentvalue = PV(aprate/12,periods,payment, annuityfv,due) msgtext = "The present value for a 10year $25,000 annuity @ 9.5%" msgtext = msgtext & " with a periodic payment of $1,000 is: " msgtext = msgtext & Format(presentvalue, "Currency") End Sub
See Also
FV Function IPmt Function IRR Function NPV Function Pmt Function PPmt Function Rate Function
