. B D D E F 1 Complete the following pension spreadsheet: Format the spreadsheet using Accounting. This is a worksheet - no $ signs (Too busy). Include underlines to show numbers being 2 combined. Formatting is part of your grade. At January 1, 2020, the account balances (for both General Ledger and Memo Record accounts) related to the company's pension 3 plan are as follows: 4 Projected Benefit Obligation, 1/1 1,100,000 5 Plan Assets(Mkt Related Value), 1/1 820.000 6 Pension asset/liability, 1/1 (280,000) 8 Additional Information: 2020 2021 On 1/1/20, through plan amendments grants 9 prior service benefits having present value of 10 Service cost 11 Settlement rate 12 Expected rate of return 13 Actual rate of return 14 Amortization of prior service cost 15 Annual contributions 16 Benefits paid retirees Increases in PBO due to changes in actuarial 17 assumptions at 12/31/21 18 19 320,000 80,000 10% 10% 82,000 140,000 194,000 63,000 118,000 10% 10% 122.000 100,000 162,000 108,000 174,000 General Journal Entries Memo Record 20 Other Comprehensive Income Annual Pension Expense Prior Service Cost Pension Asset/ Liability Projected Benefit Obligation Cash Gains / Losses / Plan Assets 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 . B D D E F 1 Complete the following pension spreadsheet: Format the spreadsheet using Accounting. This is a worksheet - no $ signs (Too busy). Include underlines to show numbers being 2 combined. Formatting is part of your grade. At January 1, 2020, the account balances (for both General Ledger and Memo Record accounts) related to the company's pension 3 plan are as follows: 4 Projected Benefit Obligation, 1/1 1,100,000 5 Plan Assets(Mkt Related Value), 1/1 820.000 6 Pension asset/liability, 1/1 (280,000) 8 Additional Information: 2020 2021 On 1/1/20, through plan amendments grants 9 prior service benefits having present value of 10 Service cost 11 Settlement rate 12 Expected rate of return 13 Actual rate of return 14 Amortization of prior service cost 15 Annual contributions 16 Benefits paid retirees Increases in PBO due to changes in actuarial 17 assumptions at 12/31/21 18 19 320,000 80,000 10% 10% 82,000 140,000 194,000 63,000 118,000 10% 10% 122.000 100,000 162,000 108,000 174,000 General Journal Entries Memo Record 20 Other Comprehensive Income Annual Pension Expense Prior Service Cost Pension Asset/ Liability Projected Benefit Obligation Cash Gains / Losses / Plan Assets 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38