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. 1 Your Name 2 Retirement Planning 3 Date $ 2.000.00 Annual Investment Interest Rate 20% Income Tax Rate Pay Income Taxes As You Go 2009 2000.22 novo Defer All Income Taxes Amount interest Total Amount Interest Invested Earned Nest Egg Year Invested Earned 1,600.00 $ 1,600.00 1 $ 2,000.00 $ 1,600.00 $ / 102.40 3,302.40 2 2,000.00 $ 160.00 1,600.00 211.35 5.113.75 3 2 ,000.00 332.80 6 15 Year 1 $ 17 2 18 3 Total Nest Egg 2,000.00 4,160.00 ,492.80 45 46 30 1.600.00 30 8,070.02 135,764.02 1660 x0.08 =A - 'Axrolo Difference Between Alternatives 2,000.00 16,634.55 After-Tax Nest Egg 226,566.42 $ 181,253.14 49 $ 45,489.12 Primary Objective: All subsequent changes will be made only to the three values in shaded box. $ 2,500.00 Spreadsheet Two Annual Investment Interest Rate Income Tax Rate Spreadsheet Three Annual Investment Interest Rate Income Tax Rate $ 3,000.00 9% 10% 25% 30%