O'Reilly logo

VB.NET Language in a Nutshell, Second Edition by Steven Roman PhD, Paul Lomax, Ron Petrusha

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Name

FV Function

Class

Microsoft.VisualBasic.Financial

Syntax

FV(rate, nper, pmt[, pv [, due]])
rate (required; Double)

The interest rate per period

nper (required; Integer)

The number of payment periods in the annuity

pmt (required; Double)

The payment made in each period

pv (optional; Variant)

The present value of the loan or annuity

due (optional; Constant of the DueDate enumeration)

Specifies whether payments are due at the start or the end of the period. The value can be DueDate.BegOfPeriod or DueDate.EndOfPeriod (the default).

Return Value

A Double specifying the future value of an annuity

Description

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.

Rules 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. In other words, if you state the payment period in months, you must also express the interest rate as a monthly rate and the amount paid per month.

  • The rate per period is stated as a fraction of 100. For example, 10% is stated as .10. If you are calculating using monthly periods, you must also divide the rate per period by 12. Therefore, 10% per annum, for example, equates to a rate per period of .00833.

  • The pv argument is most commonly used as the initial value of a loan. The default is 0.

  • Payments made against a loan or added to the value of savings are expressed ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required