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)
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