Prepare a pension worksheet for 2022.
2021 Pension worksheet is below:
Please fill out using this worksheet: 
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 $32 million beginning of 2019 (amortization: $4 million per year) Net loss-pensions at Jan.1, 2021 (previous losses exceeded previous gains) $40 million Average remaining service life of the active employee group 10 years Actuary's discount rate 8% ($ in millions) Plan PBO Assets Beginning of 2021 $300 Beginning of 2021 $200 Service cost 48 Return on plan assets, Interest cost, 8% 24 7.5% (10% expected) 15 Loss (gain) on PBO (2) Cash contributions 45 Less: Retiree benefits (20) Less: Retiree benefits (20) End of 2021 $350 End of 2021 $240 ( )s indicate credits; debits otherwise AOCI Pension Expense Gain / Loss Cash PSC 32 Pension Asset / Liability (100) Projected Benefit Obligation (300) Plan Assets 200 (40) $ 200 Items Balance, January 1, Prior Serv Cost (plan amended in CY) Adjusted Balance, January 1, Service costs Interest costs Expected return on assets Adjust for gain/loss on assets Amortization of: $ 48 (300) (48) (24) $ 24 $ 15 (15) (5) $ $ (5) 4 $ (4) Prior Service Cost - AOCI Net Gain or Loss 1 $ 1 $ 2 2 Gain/Loss on PBO Contributions to fund $ (45) 45 Benefits paid to retirees 20 (20) Composite Journal entry $ 57 $ (45)'$ (10) (50) 40 (4) $ 32 $ $ (2) $ (40) (42) $ Balance, December 31, $ 28 $ (110) (350) 240 ()s indicate credits; debits otherwise AOCI Pension Expense Gain / Loss Pension Asset/ Liability Projected | Benefit Obligation Plan Assets Cash PSC Items Balance, January 1, Prior Serv Cost (plan amended in CY) Adjusted Balance, January 1, Service costs Interest costs Expected return on assets Adjust for gain/loss on assets Amortization of: Prior Service Cost - AOCI Net Gain or Loss Gain/Loss on PBO Contributions to fund Benefits paid to retirees Composite Journal entry Balance, December 31, 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 $32 million beginning of 2019 (amortization: $4 million per year) Net loss-pensions at Jan.1, 2021 (previous losses exceeded previous gains) $40 million Average remaining service life of the active employee group 10 years Actuary's discount rate 8% ($ in millions) Plan PBO Assets Beginning of 2021 $300 Beginning of 2021 $200 Service cost 48 Return on plan assets, Interest cost, 8% 24 7.5% (10% expected) 15 Loss (gain) on PBO (2) Cash contributions 45 Less: Retiree benefits (20) Less: Retiree benefits (20) End of 2021 $350 End of 2021 $240 ( )s indicate credits; debits otherwise AOCI Pension Expense Gain / Loss Cash PSC 32 Pension Asset / Liability (100) Projected Benefit Obligation (300) Plan Assets 200 (40) $ 200 Items Balance, January 1, Prior Serv Cost (plan amended in CY) Adjusted Balance, January 1, Service costs Interest costs Expected return on assets Adjust for gain/loss on assets Amortization of: $ 48 (300) (48) (24) $ 24 $ 15 (15) (5) $ $ (5) 4 $ (4) Prior Service Cost - AOCI Net Gain or Loss 1 $ 1 $ 2 2 Gain/Loss on PBO Contributions to fund $ (45) 45 Benefits paid to retirees 20 (20) Composite Journal entry $ 57 $ (45)'$ (10) (50) 40 (4) $ 32 $ $ (2) $ (40) (42) $ Balance, December 31, $ 28 $ (110) (350) 240 ()s indicate credits; debits otherwise AOCI Pension Expense Gain / Loss Pension Asset/ Liability Projected | Benefit Obligation Plan Assets Cash PSC Items Balance, January 1, Prior Serv Cost (plan amended in CY) Adjusted Balance, January 1, Service costs Interest costs Expected return on assets Adjust for gain/loss on assets Amortization of: Prior Service Cost - AOCI Net Gain or Loss Gain/Loss on PBO Contributions to fund Benefits paid to retirees Composite Journal entry Balance, December 31
