! 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: $5 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 ($ in millions) Beginning of 2021 Return on plan assets, 8.0% (10% expected) (4) Cash contributions (22) Less: Retiree benefits $400 End of 2021 Plan Assets $150 12 60 (22) $200 PBO Beginning of 2021 $300 Service cost 99 Interest cost, 9% 27 Loss (gain) on PBO Less: Retiree benefits End of 2021 $41 million $50 million 10 years 9% Assume the following actuary and trustee reports indicating changes in the PBO and plan assets of Lakeside Cable during 2022: ($ in millions) Beginning of 2022 Service cost Interest cost, 9% Loss (gain) on PBO PBO $400 47 Beginning of 2022 Return on plan assets, 36 16% (10% expected) 6 Cash contributions Plan Assets $200 32 39 Less: Retiree benefits End of 2022 $464 End of 2022 (25) Less: Retiree benefits (25) $246 3. Prepare a pension spreadsheet to assist you in determining end of 2021 balances in the PBO, plan assets, prior service cost-AOCI, the net loss-AOCI, and the pension liability. (Enter your answers in millions (i.e., 10,000,000 should be entered as 10). Enter credit amounts with a minus sign and debit amounts with a positive sign.) ($ in millions) Bal., Jan. 1, 2021 Service cost Interest cost, 9% Expected return on assets Loss on assets Amortization of: Prior service cost-AOCI Net loss-AOCI Gain on PBO Cash contributions Retiree benefits Bal., Dec. 31, 2021 PBO Plan Assets Prior Service Cost-AOCI Net Loss -AOCI Pension Expense Cash Net Pension (Liability) / Asset (300) 150 41 50 (99) (27) 15 (3) (4) 60 22 (22) (400) 200 41 49