Mr. Richards is trying to update his client presentations.He would like you to perform some future value calculations showing how great his returns are and how compounding works.He would like to show how $100,000 invested for 10, 20 and 30 years grows with his superior record of 8% annual returns.Just to underscore this he would also like the same compounding information with the historical annual market returns of 4%.

Excel:Use the standard TVM setup to determine the FV value given the PV of $100,000, rate of .04 and .08 and NPR of 10, 20, 30.Set this up and then copy and change values as described for each of the additional five scenarios.

Written:Briefly describe the analysisthat you have performed and explain the effect of compound interest.Describewhat the growth rate of the money over, 10, 20 and 30 yearspans.What isthe difference in growth between the 4% and 8% rates?What do these ratessay about the level of overallreturns required to grow money and create wealth?