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. For example, 10% is stated as 0.1. If you are calculating using monthly periods, you must also divide the annual rate by 12. For example, a 10% per annum rate equates to .00833 per period. The pv argument is most commonly used as the initial value of a loan. Payments made against a loan or added to the value of savings are expressed as negative numbers.
See Also IPmt Function, NPer Function, NPV Function, PPmt Function, PV Function, Rate Function |
