please answer using excel

please answer Part 1 and Part 2 in the second picture

QUESTION 3 Anuradha Dixit just turned 55. Anuradha is planning to retire in 10 years, and she currently has $500,000 in her pension fund. Based on the longevity patter of her family, she assumes that she will live 20 years past her retirement rate; during each of these years she desires to withdraw $100,000 from her pension fund. If the interest rate is 5% annually, how much will Anuradha have to save annually for the next 10 years? Assume that the first deposit to her pension fund will be today, followed by nine more annual deposits, and that the annual withdrawals from age 65 will occur at the beginning of each year. Use the following spreadsheet (the numbers are not correct) and Goal Seek to find an answer. D E 1 A B C SAVING FOR THE FUTURE 2.Annual desired pension payout 100.000 3 Annual payment 10.000 4 Interest rate Total in Your age account end of year Account Depositor balance withdrawal beginning of beginning of year 500,000 10,000 535,500 10.000 572.75 10,0001 611.914 10,0001 653 009 10,000 696,160 10,000 741.4 10.000 789041 Interest eamed during year 25,500 27 275 2 9 139 3 1 096 159 35 308 37573 19.952 535,500107407487 25