Wednesday, September 8, 2010

Visual Basic Financial Function : FV

Purpose : Use the FV function to determine the huture value of an annuity based on constant payments and a constant interest rate.

Syntax :
FV (dbRate, intNumPeriods, dblpayment, [ vPresentValue , [ vWhenDue ] ] )

dbRate : Effective interest rate of the annuity.
intNumPeriods : Number of Payments.
dblpayment : Payment amount of the annuity.
vPresentValue : starting value of the annuity .
vWhenDue : Number specifying whether the payment are due at the beginning (1) or end of the period (0)

dblAmountSaved = FV ( dblInterstRate /12 , inNumberMonthes , dblAmountInvestedPerMonth, 0 , 0 )

No comments:

Post a Comment