Question:8

Mr. Richards needs more analysis to update his client presentations. He would like additional future value calculations. Using the same framework as in the last mini-project, calculate the future value of bank CDs that would pay 1% and 2% annual interest.

Excel: Copy the framework from the last mini-project and change the rates. Combine the summary tables from these analyses with the prior analysis to show the compound interest earned and overall growth rates for 10, 20, 30 years and annual returns of 1, 2, 4 and 8%