[ETIREMENT PLANNER CASE STUDY This assignment involves developing a spreadsheet to determine how much will need to be deposited into an account to meet retirement income objectives. The following information is to he placed into the cells shown: Current salary $100,000 A4 Money desired per year if retirement took place now $90,000 A5 Rate of salary growth as a decimal @ .004 for 4%";3'} A6 Rate ofination per year as a M 125 5% A? Rate of ination per year as a w 26-40 4% A12 Rate ofination per year as a w 4165 3% A13 Interest rate as a decimal during first 25 working years 9.5 % A3 Interest rate as a dec'mal dur'ng last 15 working years 8.5 \"/0 A9 Interest rate as a decimal during first 15 retirement years 3% A10 Interest rate as a dec'mal dur'ng last 10 retirement years 6% All This assignment will assume that you will work for 40 M are retired for 25 years. The first retirement withdrawal will be a. the end of year 41. Deposits will be made at the end of each year 'om years 140. Withdrawals need to increase at the rate of ination. Part A. Determine the annual deposit required for years 140 if each deposit is the same. Complete the following table for years 1 through 65. XE Beg Balance Interest Deposit Withdrawal Salary % Salary End Balance Part B. Determine the annual deposit required for years 1 40 if the amount deposited each year will increase at the same rate as the increase in salary- Complete a second table with the same columns as in part a