Calculate Future Value Method

The Calculate Future Value method calculates, and then returns a number that identifies the future value of an investment, such as an annuity or a loan.

Format

FV(rate, nper, pmt, pv, due)

For more information, see Arguments You Can Use with Financial Methods.

Example

The following example calculates the future value of an annuity, according to terms that the user specifies:

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