Future Value - Download as Excel

W
Shared by: liwenting
Categories
Tags
-
Stats
views:
9
posted:
10/2/2011
language:
English
pages:
4
Document Sample
scope of work template
							FV = PV (1 + r)^ periods / quarters / years                             PV = FV /(1+r)^n
Solving for the Future Value using Compounding                          Solving for Present Value using Compound Interest
       PV                                  FV      rate     years            PV                     FV       rate     years
           $100.00                         $104.04     2%           2         $96.12               $100.00       2%         2




ANSWERS HERE

SM3-1: Dollars and Sense
1a
1b
1c
2a
2b
2c
3
4
5                                SOLVE THESE WITH ONLINE CALCULATORS
WORKSHEET 2: SOLVING FOR FUTURE VALUES


FV = PV or Principal * interest rate * number of years + Principal
Solving for the Future Value using Simple Interest
    PV                           FV         rate       years
 $1,000.00                     1,270.00          3%           9




PROBLEMS NEEDED HERE

FV = PV (1 + r)^ periods / quarters / years
Solving for the Future Value using Compounding
    PV                         FV           rate   years
   $100.00                       104.04         2%       2




             ANSWERS HERE
                    1    1,270.00
                    2    1,344.00
                    3    7,650.00
                    4   72,050.00
                    5    5,171.00
                    6   18,972.00
                    7    4,700.00
                    8   12,341.00
                    9    5,775.00
WORKSHEET 3: SOLVING FOR PRESENT VALUES

PV = FV / (1+r)
Solving for Present Value Using Simple Interest
       PV                        FV          rate
           $98.04              $100.00            2%




PV = FV /(1+r)^n
Solving for Present Value using Compound Interest
       PV                        FV        rate        years
           $55.37               $100.00         3%          20




ANSWERS HERE
           1
           2
           3
           4
           5

						
Related docs
Other docs by liwenting
Prudential Long-Term Care LTC3 Sales Ideas
Views: 7  |  Downloads: 0
Seite 1 von 5 Tischtennis Ein we
Views: 49  |  Downloads: 0
Activating Bridge Baron
Views: 216  |  Downloads: 0
doc_15_
Views: 4  |  Downloads: 0
MERCADOS FINANCIEROS
Views: 199  |  Downloads: 0
Business Object Type Library Dr
Views: 11  |  Downloads: 1
Hot Buy
Views: 67  |  Downloads: 0