please use excel to answer part 2 and part 3

Jestion Completion Status: 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 pattern 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 A B C SAVING FOR THE FUTURE 2 Annual desired pension payout 100.000 3 napont Your age Interest eamed during year 07.07.17 08.08. 27 275 29139 31.096 Total in account end of year 535.500 572.775 6 611.914 653.009 690,100 741.468 789,041 Account Depositor balance, withdrawal beginning of beginning of year 500.000 10.000 535 500 10.000 572.775 10,000 611,914 10,000 653.009 10.000 090.160 10.000 721,40 10.000 759,041 10,000 10.000 10.000 946515 (100.000 1 (100 000 (100.000 764,097 (100.000 69722 (100.000, 627,091 100,000 554.220 (100,000) aasassesssss 35308 37573 39952 42.450 450722 42326 39442 36.414 31235 2009 891.43 946515 820 754,097 697032 627.829 DAFFE westion Completion Status: OTLAND DOT 572.77511 10.000 291391 611,9141 10,000 31,0961 653,0091 10.0001 331501 696,1601 10.000 35,308 741468 10.0001 37.5731 789,041 10.000 39.952 838.993 10,000 42450 89143 10.0001 45,072 946.515 (100,000) 42.326 888.841 (100.000/ 39442 828.283 2100,000) 36414 78497 (100,000) 332351 697.932 (100,000 29,897 100,000 76.3911 554.2201 (100,000) 227111 476.9011 (100.0000 18,847 395.7785 (100.0000 14789 310.566 (100.000) 10.5280 221,005 (100,000) 127150 1 00.00001 28,507 (100,0001 0 5751 75.0680 (100.00011 6.753) (183,21 1100,000). 14.19111 298.012 (100,000) 1119.90101 4417913. 100,000 25896 (543.08 (100.0000 (2.1900 1675,909) (100,000) 114(38.8000 1614,7991 (100,000 46.7401 part (1) How much is annual withdrawn(deposit) at age 57 60,939.27 saacassassia/sjsxases/sjs/a/ BITTE G 611,9141 3,0091 696.1601 741,468 789,04111 838.9937 891.443 946.5151 888.8411 828.280 784.697 697.932. 627.829 55422011 476.931 395.778 310.586 221.095 1271501 28.507 75.0680/ (183,82101 299.012 1417.9130 (543,808 1675.999) (814,799) 900-5390 4065. 13571 QUESTION4 1.15point part How much is account balance at the beginning of age 847 Click Save and submit to save and submit. Click Save All An tonellans Question Completion Status: 1043,000 T10,0000 83 (675,999) (100.000) 36 (814,799) (100,000) part (1) How much is annual withdrawn(deposit) at age 57? 60,939.27 32, TYD (38.800) (45,740) 1075,999 (814 799) (960,539) 84 84 QUESTION 4 part 2)How much is account balance at the beginning of age 84? QUESTIONS part 3)How much is the account balance at end of age 847 QUESTION 6 13. Your annual salary is $100,000. You are offered two options for a severance package. Optio I pays you 6 months' salary now. Option 2 pays you and your heirs $6,000 per year foreve first payment at the end of this year). If your required return is 11Swhich option should you choose? 13(1)How much is the value for alternative 1? Click Save and submit to save and submit. Click Save All Answers to see all answer 90 Jestion Completion Status: 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 pattern 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 A B C SAVING FOR THE FUTURE 2 Annual desired pension payout 100.000 3 napont Your age Interest eamed during year 07.07.17 08.08. 27 275 29139 31.096 Total in account end of year 535.500 572.775 6 611.914 653.009 690,100 741.468 789,041 Account Depositor balance, withdrawal beginning of beginning of year 500.000 10.000 535 500 10.000 572.775 10,000 611,914 10,000 653.009 10.000 090.160 10.000 721,40 10.000 759,041 10,000 10.000 10.000 946515 (100.000 1 (100 000 (100.000 764,097 (100.000 69722 (100.000, 627,091 100,000 554.220 (100,000) aasassesssss 35308 37573 39952 42.450 450722 42326 39442 36.414 31235 2009 891.43 946515 820 754,097 697032 627.829 DAFFE westion Completion Status: OTLAND DOT 572.77511 10.000 291391 611,9141 10,000 31,0961 653,0091 10.0001 331501 696,1601 10.000 35,308 741468 10.0001 37.5731 789,041 10.000 39.952 838.993 10,000 42450 89143 10.0001 45,072 946.515 (100,000) 42.326 888.841 (100.000/ 39442 828.283 2100,000) 36414 78497 (100,000) 332351 697.932 (100,000 29,897 100,000 76.3911 554.2201 (100,000) 227111 476.9011 (100.0000 18,847 395.7785 (100.0000 14789 310.566 (100.000) 10.5280 221,005 (100,000) 127150 1 00.00001 28,507 (100,0001 0 5751 75.0680 (100.00011 6.753) (183,21 1100,000). 14.19111 298.012 (100,000) 1119.90101 4417913. 100,000 25896 (543.08 (100.0000 (2.1900 1675,909) (100,000) 114(38.8000 1614,7991 (100,000 46.7401 part (1) How much is annual withdrawn(deposit) at age 57 60,939.27 saacassassia/sjsxases/sjs/a/ BITTE G 611,9141 3,0091 696.1601 741,468 789,04111 838.9937 891.443 946.5151 888.8411 828.280 784.697 697.932. 627.829 55422011 476.931 395.778 310.586 221.095 1271501 28.507 75.0680/ (183,82101 299.012 1417.9130 (543,808 1675.999) (814,799) 900-5390 4065. 13571 QUESTION4 1.15point part How much is account balance at the beginning of age 847 Click Save and submit to save and submit. Click Save All An tonellans Question Completion Status: 1043,000 T10,0000 83 (675,999) (100.000) 36 (814,799) (100,000) part (1) How much is annual withdrawn(deposit) at age 57? 60,939.27 32, TYD (38.800) (45,740) 1075,999 (814 799) (960,539) 84 84 QUESTION 4 part 2)How much is account balance at the beginning of age 84? QUESTIONS part 3)How much is the account balance at end of age 847 QUESTION 6 13. Your annual salary is $100,000. You are offered two options for a severance package. Optio I pays you 6 months' salary now. Option 2 pays you and your heirs $6,000 per year foreve first payment at the end of this year). If your required return is 11Swhich option should you choose? 13(1)How much is the value for alternative 1? Click Save and submit to save and submit. Click Save All Answers to see all answer 90