
FV Function | 309
The Language
Reference
This is the Title of the Book, eMatter Edition
Copyright © 2006 O’Reilly & Associates, Inc. All rights reserved.
FV Function
Class
Microsoft.VisualBasic.Financial
Syntax
Dim result As Double = FV(rate, nPer, pmt[, pv [, due]])
rate (required; Double)
The interest rate per period.
nPer (required; Double)
The number of payment periods in the annuity.
pmt (required; Double)
The payment made in each period.
pv (optional; Double)
The present value of the loan or annuity. Defaults to 0.
due (optional; DueDate enumeration)
A value indicating when payments are due, from the Microsoft.VisualBasic.
DueDate enumeration. DueDate.EndOfPeriod indicates that payments are due at
the end of the payment period; DueDate.BegOfPeriod indicates that payments are
due at the beginning of the period. If omitted, the default value is DueDate.
EndOfPeriod.
Description
The FV function calculates the future value of an annuity (either an investment or loan)
based on a regular number of payments of a fixed value and a static interest rate over
the period of the annuity.
Usage at a Glance
• The time units used for the number of payment periods, the rate of interest, and
the payment amount must be the same. For instance, if you state the payment
period in months, you must also express the interest rate as a monthly rate and
indicate the amount paid per month.
• The rate is supplied as a decimal percent. ...