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 $35 million $50 million 10 years 9% ($ in millions) PBO Plan Assets $150 $200 90 18 Beginning of 2021 Service cost Interest cost, 9% Loss (gain) on PBO Less: Retiree benefits End of 2021 Beginning of 2021 Return on plan assets, 8.0% (10% expected) Cash contributions Less: Retiree benefits End of 2021 44 (6) (6) $300 $200 Assume the following actuary and trustee reports indicating changes in the PBO and plan assets of Lakeside Cable during 2022: ($ in millions) Plan Assets $200 PBO $300 41 27 4 (19) $353 Beginning of 2022 Service cost Interest cost, 9% Loss (gain) on PBO Less: Retiree benefits End of 2022 30 Beginning of 2022 Return on plan assets, 15% (10% expected) Cash contributions Less: Retiree benefits End of 2022 (19) $244 7. Prepare a pension spreadsheet to assist you in determining end of 2022 balances in the PBO, plan assets, prior service cost-AOCI, the net loss-AOCI, and the pension liability. (Enter your answers in millions rounded to 1 decimal place (i.e., 5,500,000 should be entered as 5.5). Enter credit amounts with a minus sign and debit amounts with a positive sign.) ($ in millions) PBO Plan Assets Prior Service Cost-AOCI Net Loss -AOCI Pension Expense Cash Net Pension (Liability) Asset Bal., Jan. 1, 2022 Service cost Interest cost, 9% Expected return on assets Gain on assets Amortization of: Prior service cost-AOCI Net loss-AOCI Loss on PBO Cash contributions Retiree benefits Bal., Dec. 31, 2022