please show how to enter into excel

2. Monthly vs. Yearly Savings You are able to save $200 a month ($2,400 per year) You can invest in a CD account with 4.5% annual return or an equity fund with an expected annual return of 8%. Assume that the expected annual return of the equity fund materializes, what will be your savings in 35 years for both investment opportunities? a) If you make annual savings of $2,400 to the CD. (assume annual compounding) b) If you make annual savings of $2,400 to the equity fund. (assume annual compounding) c) If you make monthly savings of $200 to the CD. (assume annual compounding) d) If you mke monthly savings of $200 to the equity. (assume annual compounding) e) If you make monthly savings of $200 to the CD. (assume monthly compounding) f) If you make monthly savings of $200 to the equity. (assume monthly compounding) B D | Retirement Worksheet 2 A) CD Annual Savings and Annual Compounding 3 Annual Sarings 4 Years until Retirement 5 Periods 5 Rate of Betum before Retirement 7 Sans Until Retirement 2.400 33 1 4 50% B) Equity Fund: Annual Savings and Annual Compounding Anrusal Savings Years until Retirement Periods Rate of Return before Retirement Savings Until Retirement 2,400 35 8.00 10 CD Monthly Savings and Annual Compounding 11 Monthly Strings 12 Yeart til Retirement 13 Periode 14 Rite of Return before Retirement 200 35 12 450W D) Equity Fund: Monthly Savings and Annual Compounding Monthly Savings 200 Years until Retirement 35 Periods 12 Rate of Return before Retirement 8.00 Nominal Rate Swingt Until Retirement 16 Santil Retirement 12 19 19 E) CD: Monthly Savings and Monthly Compounding 20 Monthly Savings 21 Years until Retirement 22 Periods 23 Rate of Return before Retirement 24 Savings Until Retirement 25 26 200 35 12 4.309 F) Equity Fund: Monthly Savings and Monthly Compounding Monthly Savings 200 Years until Retirement 35 Periodo 12 Rate of Return before Retirement 8.00% Savings Until Retirement