Accounting Spreadsheet Assignment Planning for Retirement You are sick and tired of going to school. This is understandable, since you've been going to school seemingly all of your life. However, you aren't thrilled with the idea of "working for a living." As a result, your ultimate goal is to retire in thirty years (or less). The question you are most interested in answering is how much difference there is by investing tax deferred. Retirement Please replicate the following spreadsheet. Your spreadsheet should extend for a period of thirty years. Assume that all funds are invested at the end of the year. Use formulas wherever possible, as you will be asked to make revisions. D G H B 1 Your Name 2 Retirement Planning 3 Date $ 2,000.00 89 20% 5 Annual Investment 6 7 Interest Rate 8 9 Income Tax Rate 10 11 12 Pay Income Taxes As You Go 13 14 Amount Interest Total 15 Year Invested Farned Nest Egg 16 1 $ 1,800.00 $ 1,600.00 17 2 1,600.00 $ 102.40 3,302.40 18 3 1,600.00 211.35 5.113.75 Defer All Income Taxes Year Interest Eamed Amount Invested 1 $ 2,000.00 2 2,000.00 $ 3 2,000.00 $ Total Nest Egg 2,000.00 4,160.00 6,492.80 160.00 332.80 30 1,600.00 8,070.02 135,764.02 30 2,000.00 16,634.55 226,566.42 45 46 47 48 49 After-Tax Nest Egg $ 181,253.14 Difference Between Alternatives $ 45,409.12 Primary Objective: All subsequent changes will be made only to the three values in shaded box Spreadsheet Two Annual Investment Interest Rate Income Tax Rate S $ 2,500.00 9% 25% Spreadsheet Three Annual Investment Interest Rate Income Tax Rate 3,000.00 10% 30% 5:38