6. Functions : Finance Library Functions : FV Function
 
Share this page                  
FV Function
The FV function calculates the future value of an annuity earning a specified rate of interest over a given number of periods, according to the following formula:
fv = pv*(1 + i)^n + pmt*(1 + i*paybegin)*((1 + i)^n - 1) / i
Note:  Paybegin is either 1 or 0, indicating that the payment is made at the beginning or end of the period.
This function has the following syntax:
FV(pmt = value, i = value, nper = value [, pv = value, paybegin])
Arguments
Data Type
Description
pmt
Float
Periodic payment
i
Float
Interest per period
nper
Float
Number of periods
pv
Float
Present value
Default: 0
paybegin
Integer
1 = beginning of period
0 = end of period
Default: 0
This function returns:
• Float—The future value of periodic payments (pmt) at the specified interest rate (i) or a lump sum deposit (pv) at same specified interest rate over a specified number of periods (nper)
• Null—On error