please answer and explain. listed is the spreadsheet for excel.

The following question is based on the Defined Benefit Excel spreadsheet reviewed in class. How much money will the company have to contribute or withdraw from its Defined Benefit plan in 2020? O $740,932 O $102,868 $83,012 $80,894 D Employee Act/Exp Service Status Years Retired 40 Retired 5 Current Emp 27 Left Compan. 15 Retired-Deck 20 THE Act/Exp Retire AE 65 60 67 62 Current Ace 70 79 50 45 Expected AVE Lifespan Salary BO 100 DOO 32 150.000 75.000 85 30,000) 78 110.000 Payout Expected Bee Current Since Ramai Total Benet Benefit Retire Payout Payout 60000 S.556.44 $31.54 155797,386 68 51,115,93483 11250 519,726.94 $282,564.77 36,97801 3.4.5378 30135 5711,21347 $7112114 358415192 $584.151.91 33000 $19,123 02517520148 5290,737.44 $47.038.92 #2 SE EH 0003 4 09 5 SEO 2015 2014 2012 3033 TEC Distributions Employee 2027 2024 71.643 2010 OS 2020 76,006 2025 80,65 9 13,054 2033 60.556 19,727 12 2035 73,792 20.328 SS.CO TH CH 2 w 2.706 26,47 26.478 2 27272 27.272 S 19,120 19,702 108,411 111.664 20,293 11.04 2002 96.00 21.525 109.071 24231 112.16 21.529 22.125 2240 98151031 105,894 115.711 Total 500.000 500.000 S00.000 1050Ti 21.4 ETASIT OOO! TE STE Pension Account Been tance Distributions Lamine Endance Bond Balance Cantition www 500,000 500.000 500.000 500.000 500.000 115,014 96.900 90,015 02.10 10 23,09 24.136 2011 21,531 066 427,278474196 1.012 500.000 0.00 0.00 0.00 500.000 500.000 10841 111.064 21,100 15.0 411.686 SO SOCO 16 23.01 407160 500.000 0.000 500.000 500.000000 24 22:27 29 2016 10.000 SOU. SO104 SOLOS S00002 500,000 500.000 500.000 500.000 so ( 14 (02) 000 PE ISC SOYEZ 410.17 500.000 00000 001 SO 515 ). 16 G Act/Ep Retire Ape Employees MI Axt/EXP Service Status Year Retired 40 Retired current me 27 ceh Campane 15 Retired Dec 20 Current Age 70 79 Expected Lifespan 10 H Payout Expected le Current Since Hemain Total Benefit temala Meti Payout Payout 60000 6.44 $31.548.15$797.366.64 $1,315,014 11350 519,7265282.564.77 $607401 $342.51570 $71121147 571121347 10000 $184 ISOL 31000 $19.171.03 $175,2014 $25.737 44 $478.9392 A Salary 100 000 150.000 75.000 000 110.000 CH CH 05 STOR 58 SH 19 CP 09 NA 45 TESIS CH 0 2033 2014 2015 2030 200 2020 202 2030 35.546 2001 112 302) 49.550 19727 2037 726 20 907 2004 71.643 20,219 2029 21.054 2025 71.792 20,928 71.000 SES 26,676 24,95 24.251 112,34 21.529 99.815 20,201 115,014 20,902 96,90 SISTE To's 22.125 2.40 102, RIO 105,894 5 25.08 25,700 297 2987 27272 27272 19.12 19,702 301411 111,664 ETUSTE 10 Distribution 11 Employee 12 #1 13 1 15 64 16 17 Total 10 19 Pension Account 20 Begin Balance 21 Distribution 22 Carine 23 End Balance 24 hod/End Islance Contribution Withdraw ST60 VESE 500 000 500.000 101411 111,664 23,495 23.300 415.054 411,636 500,00D 500,000 84,916 88,364 TESTE 500.000 500.000 S00.000 500,000 00/000 115,014 36.900 100 310 10. 23,099 24,156 24011 23.546 408.066 427 278 424,196 21.022417.752 500,000 500.000 500.000 500,000 500.000 91,914 72.722 75,804 70,978 500.000 100.073 23456 414.15 500.000 BS 615 500,000 1120 21,259 410,097 500,000 500,000 115.713 21.05 407.341 500.000 92.655 500.000 500.000 500.000 500.000 25706 26.678 27222 30 28.458 28,011 10.000 120 502.251 SOLO 51002530 213,1 520.000 500 000 500000 son, 02.51 1934 (1002) (10.000) 200, 000 DOS 07 Act/Exp Service 3 Status Years # Retired 40 5 Retired 5 5 Current Emp 27 7 Left Compan 15 8 Retired-Dec 20 9 10 11 2023 2024 2 69,556 71,543 3 19,727 20,319 Current Age 70 79 50 45 65 Act/Exp Retire Age 65 60 67 62 60 Expected Lifespan BO 82 85 85 78 Avg Salary 100,000 150,000 75,000 80,000 110,000 Payout Expected Beg Current Since Remain Total Benefit Benefit Retire Payout Payout 60000 $69,556.44 $318,548.15 $797,386.68 $1,115,934.83 11250 $19,726.94 $282,564.77 $60,974.01 $343,538.78 30375 $711213,47 $711,213.47 18000 $584,151 91 $584,151 91 33000 $19,128.02 $175,201.48 $298,737.44 $$73,938.92 2030 2033 2034 2036 2035 2025 73,792 20,928 2026 76,006 2027 78,286 2028 80,635 2029 83,054 2032 90,755 2031 88,112 85,546 15 16 17 19,128 19,702 108,411 111,664 20,293 115,014 20,902 96,908 21,529 99,815 22,175 102,810 22,840 105,894 23,525 109,071 24,231 112,343 24,958 115,713 25,706 25,706 MINI 26,478 26,478 27,272 27,272 LHCE MITTE 40 20 08 82 4 Retired 5 Retired 6 Current Ems 7 Left Compar 8 Retired-Deck TO 79 50 45 67 5 27 15 20 58 bone Benet Retire Payout Payout 60000 $69.556.44 $318 548.15 $797386.68 51,115,934.33 11250 519,726.94 $282.564.77 $10.99401 $343,518.78 30375 $711.213.47 $711 212.47 18000 $584151.91 $58415191 33000 $19,120.02 $175,201.43 5298,737 44 S173.938.92 100.000 150,000 75,000 30.000 110,000 .62 60 85 78 65 2033 2034 2036 2037 2031 2013 2021 69.556 19,727 2028 B0635 SEOR 2024 71.643 20,319 2025 73,792 20,928 2026 76,006 2027 78,286 2029 83,054 2010 35,546 2031 88,112 2032 90.755 ZELI 19,128 108,411 19,702 111,664 20.293 115,014 20,902 96,908 21.529 99,815 22.175 102,810 22,840 305,894 23,525 103,071 24,231 112,343 24,958 115.713 25,706 25,700 26478 26,475 10 51 12 13 14 15 16 17 18 19 20 21 22 23 24 25 27.272 27.272 298,737 500,000 500,000 105,411 111,664 23,495 23 300 415,084 411,636 500.000 500.000 84,916 88,364 500,000 115,014 23,099 408 086 500,000 91,914 500,000 500,000 500,000 500,000 96.908 99,815 102,810 105,894 24,186 24,011 23,831 23,546 427,278 424,196 421,022 417.752 500,000 500,000 500,000 500.000 72,722 75,804 78,978 82.248 500,000 109,071 23,456 414,385 500,000 85 615 500,000 112,343 23.259 410,917 500,000 89,083 500,000 115,713 23,057 407,346 500,000 92.656 500,000 500.000 500.000 500.000 500,000 500,000 $60,000 25,706 26.478 27,272 298,12 28.458 2014 28 364 30.000 12.078 30,000 30,000 503.751 501,934 01.092 530.000 213.338 530.000 530,000 500.000 500.000 500.000 500.000 500.000 500.000 500,000 12.751 11.934) (1.092) (30.000 286,662 (10,000) 30,000 ) () ) The following question is based on the Defined Benefit Excel spreadsheet reviewed in class. How much money will the company have to contribute or withdraw from its Defined Benefit plan in 2020? O $740,932 O $102,868 $83,012 $80,894 D Employee Act/Exp Service Status Years Retired 40 Retired 5 Current Emp 27 Left Compan. 15 Retired-Deck 20 THE Act/Exp Retire AE 65 60 67 62 Current Ace 70 79 50 45 Expected AVE Lifespan Salary BO 100 DOO 32 150.000 75.000 85 30,000) 78 110.000 Payout Expected Bee Current Since Ramai Total Benet Benefit Retire Payout Payout 60000 S.556.44 $31.54 155797,386 68 51,115,93483 11250 519,726.94 $282,564.77 36,97801 3.4.5378 30135 5711,21347 $7112114 358415192 $584.151.91 33000 $19,123 02517520148 5290,737.44 $47.038.92 #2 SE EH 0003 4 09 5 SEO 2015 2014 2012 3033 TEC Distributions Employee 2027 2024 71.643 2010 OS 2020 76,006 2025 80,65 9 13,054 2033 60.556 19,727 12 2035 73,792 20.328 SS.CO TH CH 2 w 2.706 26,47 26.478 2 27272 27.272 S 19,120 19,702 108,411 111.664 20,293 11.04 2002 96.00 21.525 109.071 24231 112.16 21.529 22.125 2240 98151031 105,894 115.711 Total 500.000 500.000 S00.000 1050Ti 21.4 ETASIT OOO! TE STE Pension Account Been tance Distributions Lamine Endance Bond Balance Cantition www 500,000 500.000 500.000 500.000 500.000 115,014 96.900 90,015 02.10 10 23,09 24.136 2011 21,531 066 427,278474196 1.012 500.000 0.00 0.00 0.00 500.000 500.000 10841 111.064 21,100 15.0 411.686 SO SOCO 16 23.01 407160 500.000 0.000 500.000 500.000000 24 22:27 29 2016 10.000 SOU. SO104 SOLOS S00002 500,000 500.000 500.000 500.000 so ( 14 (02) 000 PE ISC SOYEZ 410.17 500.000 00000 001 SO 515 ). 16 G Act/Ep Retire Ape Employees MI Axt/EXP Service Status Year Retired 40 Retired current me 27 ceh Campane 15 Retired Dec 20 Current Age 70 79 Expected Lifespan 10 H Payout Expected le Current Since Hemain Total Benefit temala Meti Payout Payout 60000 6.44 $31.548.15$797.366.64 $1,315,014 11350 519,7265282.564.77 $607401 $342.51570 $71121147 571121347 10000 $184 ISOL 31000 $19.171.03 $175,2014 $25.737 44 $478.9392 A Salary 100 000 150.000 75.000 000 110.000 CH CH 05 STOR 58 SH 19 CP 09 NA 45 TESIS CH 0 2033 2014 2015 2030 200 2020 202 2030 35.546 2001 112 302) 49.550 19727 2037 726 20 907 2004 71.643 20,219 2029 21.054 2025 71.792 20,928 71.000 SES 26,676 24,95 24.251 112,34 21.529 99.815 20,201 115,014 20,902 96,90 SISTE To's 22.125 2.40 102, RIO 105,894 5 25.08 25,700 297 2987 27272 27272 19.12 19,702 301411 111,664 ETUSTE 10 Distribution 11 Employee 12 #1 13 1 15 64 16 17 Total 10 19 Pension Account 20 Begin Balance 21 Distribution 22 Carine 23 End Balance 24 hod/End Islance Contribution Withdraw ST60 VESE 500 000 500.000 101411 111,664 23,495 23.300 415.054 411,636 500,00D 500,000 84,916 88,364 TESTE 500.000 500.000 S00.000 500,000 00/000 115,014 36.900 100 310 10. 23,099 24,156 24011 23.546 408.066 427 278 424,196 21.022417.752 500,000 500.000 500.000 500,000 500.000 91,914 72.722 75,804 70,978 500.000 100.073 23456 414.15 500.000 BS 615 500,000 1120 21,259 410,097 500,000 500,000 115.713 21.05 407.341 500.000 92.655 500.000 500.000 500.000 500.000 25706 26.678 27222 30 28.458 28,011 10.000 120 502.251 SOLO 51002530 213,1 520.000 500 000 500000 son, 02.51 1934 (1002) (10.000) 200, 000 DOS 07 Act/Exp Service 3 Status Years # Retired 40 5 Retired 5 5 Current Emp 27 7 Left Compan 15 8 Retired-Dec 20 9 10 11 2023 2024 2 69,556 71,543 3 19,727 20,319 Current Age 70 79 50 45 65 Act/Exp Retire Age 65 60 67 62 60 Expected Lifespan BO 82 85 85 78 Avg Salary 100,000 150,000 75,000 80,000 110,000 Payout Expected Beg Current Since Remain Total Benefit Benefit Retire Payout Payout 60000 $69,556.44 $318,548.15 $797,386.68 $1,115,934.83 11250 $19,726.94 $282,564.77 $60,974.01 $343,538.78 30375 $711213,47 $711,213.47 18000 $584,151 91 $584,151 91 33000 $19,128.02 $175,201.48 $298,737.44 $$73,938.92 2030 2033 2034 2036 2035 2025 73,792 20,928 2026 76,006 2027 78,286 2028 80,635 2029 83,054 2032 90,755 2031 88,112 85,546 15 16 17 19,128 19,702 108,411 111,664 20,293 115,014 20,902 96,908 21,529 99,815 22,175 102,810 22,840 105,894 23,525 109,071 24,231 112,343 24,958 115,713 25,706 25,706 MINI 26,478 26,478 27,272 27,272 LHCE MITTE 40 20 08 82 4 Retired 5 Retired 6 Current Ems 7 Left Compar 8 Retired-Deck TO 79 50 45 67 5 27 15 20 58 bone Benet Retire Payout Payout 60000 $69.556.44 $318 548.15 $797386.68 51,115,934.33 11250 519,726.94 $282.564.77 $10.99401 $343,518.78 30375 $711.213.47 $711 212.47 18000 $584151.91 $58415191 33000 $19,120.02 $175,201.43 5298,737 44 S173.938.92 100.000 150,000 75,000 30.000 110,000 .62 60 85 78 65 2033 2034 2036 2037 2031 2013 2021 69.556 19,727 2028 B0635 SEOR 2024 71.643 20,319 2025 73,792 20,928 2026 76,006 2027 78,286 2029 83,054 2010 35,546 2031 88,112 2032 90.755 ZELI 19,128 108,411 19,702 111,664 20.293 115,014 20,902 96,908 21.529 99,815 22.175 102,810 22,840 305,894 23,525 103,071 24,231 112,343 24,958 115.713 25,706 25,700 26478 26,475 10 51 12 13 14 15 16 17 18 19 20 21 22 23 24 25 27.272 27.272 298,737 500,000 500,000 105,411 111,664 23,495 23 300 415,084 411,636 500.000 500.000 84,916 88,364 500,000 115,014 23,099 408 086 500,000 91,914 500,000 500,000 500,000 500,000 96.908 99,815 102,810 105,894 24,186 24,011 23,831 23,546 427,278 424,196 421,022 417.752 500,000 500,000 500,000 500.000 72,722 75,804 78,978 82.248 500,000 109,071 23,456 414,385 500,000 85 615 500,000 112,343 23.259 410,917 500,000 89,083 500,000 115,713 23,057 407,346 500,000 92.656 500,000 500.000 500.000 500.000 500,000 500,000 $60,000 25,706 26.478 27,272 298,12 28.458 2014 28 364 30.000 12.078 30,000 30,000 503.751 501,934 01.092 530.000 213.338 530.000 530,000 500.000 500.000 500.000 500.000 500.000 500.000 500,000 12.751 11.934) (1.092) (30.000 286,662 (10,000) 30,000 ) () )