Was this helpful?
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
Example—FV function:
/*  Compute the future value of depositing $200 per
**  month for 5 years into an account paying 7.5% per
**  year.
*/
savings = fv(pmt = 200, i = .075/12, nper = 12 * 5);
if savings is NULL then
    message 'Failed to calculate Future Value';
endif;
Last modified date: 12/20/2023