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 in Defined Benefit payments will Employee #5 and his/her Spouse earn in total? O $267436 $706,606 O $439.170 O $110.000 D G H Employee 1 2 #3 W4 #15 B Act/Exp Service Status Years Retired 40 Retired 5 Current Emp 27 Left Compant. 15 Retired Deci 20 Current Age 70 79 SO 45 65 F Act/Exp Retire expected Age Lifespan 65 80 60 R2 67 85 62 85 60 78 Avg Salary 100,000 150,000 75.000 80,000 110,000 Payout Expected Bog Current Since Remain Total Benefit Benefit Retire Payout Payout 60000 $69.556.44 $318,548 15 $797.186.68 51.115.934 83 11250 519,726 94 $282.564.77 560,974.01 $383.538.78 30375 $71121147 5711,213.47 18000 $584,151.91 $584151 91 33000 519,128.02 $175,201 48 $298,737.44 $473,938 92 8 2033 2034 2015 2015 20 2023 69,556 19,727 2026 76,006 2024 71.643 20,319 2025 73.792 20,928 2027 78,286 2028 80,635 2012 90.755 2031 BR.112 2029 83,054 2030 85,546 20,902 96,900 21.529 99.815 20,293 115,014 24.231 132,34 23.535 109,071 22,175 22.840 102,810 105.894 19.128 19,702 108,411 111,664 27.272 24958 115.712 25.706 25,706 26,878 26,470 TO Distributions 11 Employee 12 1 13 22 14 3 15 4 16 15 17 Total 18 19 Pension Account 20 Begin Balance 21 Distributions 22 Earnings 23 End Balance 24 Reed/End Balance 25 Contribution withdraw) 500,000 109,071 23.456 500.000 500.000 108,411 111,664 23,495 23,300 415 084 411636 500,000 500,000 84,916 88,364 500,000 500.000 500,000 500,000 500,000 115,014 96.90 99.815 102.810105,894 23.099 24,186 24,011 23,831 23.646 408,086 427,278 424,196 421,022 417,752 500.000 500.000 500.000 500.000 500,000 91.914 72.722 75.800 78975 82.248 500.000 112.343 20259 410,917 500,000 39,082 500.000 115,713 22.052 407,34 500 000 33.656 500.000 500.000 500.000 500.000 500 25.700 26.478 27.222 21.455 28,164 30 000 12 502,751501,934 501,092 $30,000 213, 500.000 500.000 500.000 SOO D00 500 (2,751) 11,090) (0.0024 500.000 85,615 The following question is based on the Defined Benefit Excel spreadsheet reviewed in class. How much in Defined Benefit payments will Employee #5 and his/her Spouse earn in total? O $267436 $706,606 O $439.170 O $110.000 D G H Employee 1 2 #3 W4 #15 B Act/Exp Service Status Years Retired 40 Retired 5 Current Emp 27 Left Compant. 15 Retired Deci 20 Current Age 70 79 SO 45 65 F Act/Exp Retire expected Age Lifespan 65 80 60 R2 67 85 62 85 60 78 Avg Salary 100,000 150,000 75.000 80,000 110,000 Payout Expected Bog Current Since Remain Total Benefit Benefit Retire Payout Payout 60000 $69.556.44 $318,548 15 $797.186.68 51.115.934 83 11250 519,726 94 $282.564.77 560,974.01 $383.538.78 30375 $71121147 5711,213.47 18000 $584,151.91 $584151 91 33000 519,128.02 $175,201 48 $298,737.44 $473,938 92 8 2033 2034 2015 2015 20 2023 69,556 19,727 2026 76,006 2024 71.643 20,319 2025 73.792 20,928 2027 78,286 2028 80,635 2012 90.755 2031 BR.112 2029 83,054 2030 85,546 20,902 96,900 21.529 99.815 20,293 115,014 24.231 132,34 23.535 109,071 22,175 22.840 102,810 105.894 19.128 19,702 108,411 111,664 27.272 24958 115.712 25.706 25,706 26,878 26,470 TO Distributions 11 Employee 12 1 13 22 14 3 15 4 16 15 17 Total 18 19 Pension Account 20 Begin Balance 21 Distributions 22 Earnings 23 End Balance 24 Reed/End Balance 25 Contribution withdraw) 500,000 109,071 23.456 500.000 500.000 108,411 111,664 23,495 23,300 415 084 411636 500,000 500,000 84,916 88,364 500,000 500.000 500,000 500,000 500,000 115,014 96.90 99.815 102.810105,894 23.099 24,186 24,011 23,831 23.646 408,086 427,278 424,196 421,022 417,752 500.000 500.000 500.000 500.000 500,000 91.914 72.722 75.800 78975 82.248 500.000 112.343 20259 410,917 500,000 39,082 500.000 115,713 22.052 407,34 500 000 33.656 500.000 500.000 500.000 500.000 500 25.700 26.478 27.222 21.455 28,164 30 000 12 502,751501,934 501,092 $30,000 213, 500.000 500.000 500.000 SOO D00 500 (2,751) 11,090) (0.0024 500.000 85,615
