Bookshelf Home | Contents | Index | Search | PDF |
Siebel VB Language Reference > Siebel 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)
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 10-year $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 10-year $25,000 annuity @ 9.5%"
msgtext = msgtext & " with a periodic payment of $1,000 is: "
msgtext = msgtext & Format(presentvalue, "Currency")
End SubSee Also
FV Function
IPmt Function
IRR Function
NPV Function
Pmt Function
PPmt Function
Rate Function
Bookshelf Home | Contents | Index | Search | PDF |
Siebel VB Language Reference Published: 18 June 2003 |