FV() Computes future value of capital ------------------------------------------------------------------------------ Syntax FV(<nInstall>,<nInterestRate>,<nNumberofPayments>) --> nCapital Arguments <nInstall> Designates the installment amount to pay for the period. <nInterestRate> Designates the interest rate calculated for the payment period. 1 corresponds to 100%. <nNumberofPayments> Designates the number of payments. Returns FV() returns the future capital value of the total deposits, plus the interest generated. Description FUTURE VALUE FV() returns the capital available after the <nNumberofPayments> total installments at <nInstall> payment, at an <nInterestRate> interest charge for the period. Example What amount would you save, if you pay $150.00 per month for 3 years into a fund that pays an annual interest rate of 6%? nRate : 0.06/12 // Monthly interest rate ? FV(150, nRate, 36) // Result: 5900.42
See Also: PAYMENT() PV() RATE() PERIODS()