Exercise 17-15 (Algo) Pension spreadsheet (LO17-8] A partially completed pension spreadsheet showing the relationships a

Post by **answerhappygod** » Thu May 19, 2022 12:50 pm

: Exercise 17 15 Algo Pension Spreadsheet Lo17 8 A Partially Completed Pension Spreadsheet Showing The Relationships A 1 (22.36 KiB) Viewed 46 times

Exercise 17-15 (Algo) Pension spreadsheet (LO17-8] 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 2019, the pension formula was amended, creating a prior service cost of $120,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. (Enter your answers in thousands rounded to 1 decimal place.) Answer is not complete.
Fill in the missing amounts. (Enter your answers in thousands rounded to 1 decimal place.) Pension Expense Net Pension (Liability) I Asset $ (260.0) Prior Plan Service Net Loss PBO Assets Cost - AOCI - AOCI $ (680.0) $ 420.0 $ 114.0 $ 68.0 (88.0) 0.0 0.0 0.0 (34.0) 0.0 0.0 0.0 0.0 42.0 0.0 Cash 88.0 0.0 (33.6) 0.0 (8.0) 0.0 8.0 (s in thousands) Balance, Jan. 1, 2021 Service cost Interest cost, 5% Expected return on assets Adjust for: Loss on assets Amortization: Prior service cost Amortization: Net loss Gain on PBO Prior service cost Cash funding Retiree benefits Balance, Dec 31, 2021 0.0 0.0 (6.0) 0.0 0.0 12.0 0.0 12.0 0.0 0.0 50.0 $ (740.0) $ 0.0 0.0 0.0 72.0 (50.0) 476.0 0.0 0.0 0.0 0.0 0.0 108.0 (12.0) 0.0 0.0 (72.0) 0 0.0 64.0 $ 54.4 (248.0)
Prior Net Pension (Liability) Pension Net Loss - AOCI PBO Expense Cash Plan Service Cost - Assets AOCI $ 420.0 $ 114.0 0.0 0.0 0.0 0.0 42.0 X I Asset $ (260.0) $ 68.0 0.0 $ (680.0) (88.0) (34.0) 0.0 88.0 0.0 0.0 0.0 (33.6) 0.0 (8.0) 0.0 8.0 ($ in thousands) Balance, Jan. 1. 2021 Service cost Interest cost, 5% Expected return on assets Adjust for: Loss on assets Amortization: Prior service cost Amortization: Net loss Gain on PBO Prior service cost Cash funding Retiree benefits Balance, Dec. 31, 2021 0.0 0.0 (6.0) 0.0 0.0 0.0 0.0 0.0 (12.0) 0.0 12.0 0.0 12.0 0.0 0.0 0.0 0.0 0.0 108.0 0.0 0.0 0.0 72.0 (50.0) $ 476.0 (72.0) 50.0 $ (740.0) 0.0 64.0 $ $ 54.4 $ (248.0)