0 Required Information The following information applies to the questions displayed below) Actuary and trustee reports indicate the following changes in the PBO and plan assets of Lakeside Cable during 2021. Prior service cost at Jan. 1, 2021, from plan amendment at the beginning of 2019 (amortization: $6 million per year) Net loss pensions at Jan. 1, 2021 (previous losses exceeded previous gains) Average remaining service life of the active employee group Actuary's discount rate $36 Sillion 564 million 10 years 18% In millions) PBO Plan Assets 3200 Beginning of 2021 Service cast Interest cost 10% Loss gain) on Po Less. Retiree benefits End of 2021 $300 48 34 (2) (30 5390 Beginning of 2021 Return on plan assets, 9.5$ (ies expected) Cash contributions Less Retiree benefits ind of 2021 19 61 30 5258 Assume the following actuary and trustee reports indicating changes in the PBO and plan assets of Lakeside Cable dur 2022 is in millions plan PED Beginning of 2 Beginning of 1922 Saved AUN Loss (gain) on PBO Less: Retiree benefits End of 2021 (2) (30) $390 AURA Cash contributions Less: Retiree benefits End of 2021 51 (30) $250 Assume the following actuary and trustee reports indicating changes in the PBO and plan assets of Lakesid 2022 ($ in millions) PBO Plan Assets $250 Beginning of 2022 Service cost Interest cost, 10% LOSS (gain) on PBO Less Retiree benefits $390 42 39 5 (20) $456 Beginning of 2022 Return on plan assets, 16% (10% expected) Cash contributions Less Retiree benefits End of 2022 48 34 (20) 5384 End of 2022 7. Prepare a pension spreadsheet to assist you in determining end of 2022 balances in the PBO plan assets.p he net loss-AOCI. and the pension liability (Enter your answers in millions rounded to 1 decimal place (.e.. entered as 5.5). Enter credit amounts with a minus sign and deblt amounts with a positive slgn.) NE ($ in millions) Plan Assets PBO Prior Service Cost-AOCI Net Loss -AOCI Cash Pension Expense 1 $384 End of 2022 $456 End of 2822 7. Prepare a pension spreadsheet to assist you in determining end of 2022 balances in the PBO, plan assets, prior service cost the net loss AOCI, and the pension liability. (Enter your answers in millions rounded to 1 decimal place (.e., 5,500,000 should entered as 5.5). Enter credit amounts with a minus sign and debit amounts with a positive sign.) (5 in millions PBO Net Pension Liability ASS Prior Service Cost-AOCI Plan Assets Net Loss AOCI Pension Expense Bal.. Jan. 1. 2022 Service cost Interest cost 10% Expected return on assets Gain on assets Amortization of Prior service cost-AOCI Net loss AOCI Los on PBO Cash contributions Retiree benefits B. Dec 31, 2022