[<<Previous Entry]
[^^Up^^]
[Next Entry>>]
[Menu]
[About The Guide]
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()
This page created by ng2html v1.05, the Norton guide to HTML conversion utility.
Written by Dave Pearson