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. A 1 Your Name B 2 Retirement Planning 3 Date C D E F G H 6 7 10 11 12 13 14 Amount Interest Total 15 Year Invested Earned Nest Egg Annual Investment Interest Rate Income Tax Rate Pay Income Taxes As You Go 2009-400 2,000.00 8% 20% (2000x0.2 Defer All Income Taxes Amount Interest Total Year Invested Earned Nest Egg 16 1 $ 1,600.00 $ 1,600.004 1 $ 2,000.00 $ 2,000.00 17 2 102.40 1,600.00 $ 3,302.40 2 2,000.00 $ 160.00 4,160.00 18 3 1,600.00 211.35 5,113.75 3 2,000.00 332.80 6,492.80 45 46 47 30 30 1,600.00 8,070.02 135,764.02 30 2,000.00 16,634.55 226,566.42 1600 x0.08=A 48 49 A+90% After-Tax Nest Egg $ 181,253.14 Difference Between Alternatives $ 45,489.12 Primary Objective: All subsequent changes will be made only to the three values in shaded box. Spreadsheet Two Annual Investment $ 2,500.00 Spreadsheet Three Annual Investment $ 3,000.00 2 Interest Rate Income Tax Rate 9% Interest Rate 10% 25% Income Tax Rate 30%