1. What is the value of $1,000 if it earns a 6.5% annual return compounded over 30 years? What if the rate were increased to 7.5%? In the accompanying table use the formula: =prior value X (1 + r), where r = annual rate of return. Record your Year 30 Value in the highlighted cells Year 30 Value Years: 0 1 23456789101112131415161718192021222324252627282930 6.50%$1,000 $1,000 , where 2. Repeat your calculation using the future value multiplier: multiplier = (1 + r) Use the row categories provided. Tos only welfareast 10 years wing 6.5% rate of return Lanks to the Tanr De net sugly enter & waber for the year Yos only need to model 10 years Test 10 Volmet 6.5% 6.50% Multiplier Original Deposit End of Yeu Valse $ $ 1.0000 1,000 1,000 TV 3. Repeat 12 using Excel'. fater value fortien Yes must include the present value in the formal There is no wawal payment OUT). You must enter 0, Tie the period number Gper) to the Tear . placeholder Tanr 10 Yalet 5.5% Future Value