|
Siebel VB Language Reference > VB Language Reference >
FV Function
This standard VB function returns the future value for a constant periodic stream of cash flows as in an annuity or a loan. Syntax
FV(rate, nper, pmt, pv, due)
|
|
rate |
The interest rate per period |
nper |
The total number of payment periods |
pmt |
The constant periodic payment per period |
pv |
The present value or the initial lump sum amount paid (as in the case of an annuity) or received (as in the case of a loan) |
due |
An integer value indicating when the payments are due (0 = end of each period, 1 = beginning of the period) |
Returns
A number representing the future value of an investment such as an annuity or loan. Usage
The given interest rate is assumed constant over the life of the annuity. If payments are on a monthly schedule and the annual percentage rate on the annuity or loan is 9%, the rate is 0.0075 (.0075 = .09/12). Example
This example finds the future value of an annuity, based on terms specified by the user. Sub Button_Click
Dim aprate, periods
Dim payment, annuitypv
Dim due, futurevalue
Dim msgtext
annuitypv = 100000
aprate = 6.75
If aprate >1 then
aprate = aprate/100
End If
periods = 60
payment = 10000
' Assume payments are made at end of month
due = 0
futurevalue = FV(aprate/12,periods,-payment,-annuitypv,due)
msgtext = "The future value is: " & Format(futurevalue, "Currency")
End Sub
See Also
IPmt Function
IRR Function
NPV Function
Pmt Function
PPmt Function
PV Function
Rate Function
| 
