CT_FV

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

 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.