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])
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