A partially completed pension spreadsheet showing the relationships among the elements that comprise the defined benefit...

Transcribed Image Text:

A partially completed pension spreadsheet showing the relationships among the elements that comprise the defined benefit pension plan of Universal Products is given below. The actuary's discount rate is 5%. At the end of 2022, the pension formula was amended, creating a prior service cost of $300,000. The expected rate of return on assets was 8%, and the average remaining service life of the active employee group is 20 years in the current year, as well as, the previous two years. Required: Fill in the missing amounts. Note: Enter your answers in thousands (i.e., 5,500 should be entered as 5.5). Enter credit amounts with a minus sign. ($ in thousands) PBO Plan Assets Prior Service Net Loss - Cost - AOCI AOCI Pension Expense Cash Net Pension (Liability)/ Asset Balance, January 1, 2024 $ (860.0) $ 600.0 $ 285.0 $ 86.0 $ (260.0) Service cost 106.0 Interest cost, 5% (43.0) Expected return on assets (48.0) Adjust for: Loss on assets Amortization: Prior service cost Amortization: Net loss Gain on PBO Prior service cost Cash funding Retiree benefits Balance, December 31, 2024 $ (929.0) $ 270.0 17.0 (90.0) 30.0 A partially completed pension spreadsheet showing the relationships among the elements that comprise the defined benefit pension plan of Universal Products is given below. The actuary's discount rate is 5%. At the end of 2022, the pension formula was amended, creating a prior service cost of $300,000. The expected rate of return on assets was 8%, and the average remaining service life of the active employee group is 20 years in the current year, as well as, the previous two years. Required: Fill in the missing amounts. Note: Enter your answers in thousands (i.e., 5,500 should be entered as 5.5). Enter credit amounts with a minus sign. ($ in thousands) PBO Plan Assets Prior Service Net Loss - Cost - AOCI AOCI Pension Expense Cash Net Pension (Liability)/ Asset Balance, January 1, 2024 $ (860.0) $ 600.0 $ 285.0 $ 86.0 $ (260.0) Service cost 106.0 Interest cost, 5% (43.0) Expected return on assets (48.0) Adjust for: Loss on assets Amortization: Prior service cost Amortization: Net loss Gain on PBO Prior service cost Cash funding Retiree benefits Balance, December 31, 2024 $ (929.0) $ 270.0 17.0 (90.0) 30.0