Check my work Exercise 17-15 Pension spreadsheet (LO17-8] points 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 2016, the pension formula was amended, creating a prior service cost of $160,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. eBook Hint Required: Fill in the missing amounts. (Enter credit amounts with a minus sign and debit amounts with a positive sign.) Print Check my wc I III III LIIC HISTY unlUILJ. CITLC CI CUIL C UILD WILT US sy arru UCWIL GIUUIILS VILT MUSTLIVC Syil. Plan PBO Assets $ (640) $ 460 Prior Service Net Loss Cost - AOCI - AOCI $ 152 $ 64 Pension Expense Net Pension (Liability) Asset $ (180) Cash points 92 eBook (32) (36.80) Hint Print References ($ in 000s) Balance, Jan. 1, 2018 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, 2018 (76) $ (698) $ 460 $ 144 $ 74 $ 55 $ (164) Check my work Exercise 17-15 Pension spreadsheet (LO17-8] points 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 2016, the pension formula was amended, creating a prior service cost of $160,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. eBook Hint Required: Fill in the missing amounts. (Enter credit amounts with a minus sign and debit amounts with a positive sign.) Print Check my wc I III III LIIC HISTY unlUILJ. CITLC CI CUIL C UILD WILT US sy arru UCWIL GIUUIILS VILT MUSTLIVC Syil. Plan PBO Assets $ (640) $ 460 Prior Service Net Loss Cost - AOCI - AOCI $ 152 $ 64 Pension Expense Net Pension (Liability) Asset $ (180) Cash points 92 eBook (32) (36.80) Hint Print References ($ in 000s) Balance, Jan. 1, 2018 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, 2018 (76) $ (698) $ 460 $ 144 $ 74 $ 55 $ (164)