Exercise 17-15 Pension spreadsheet [LO17-8] 1.53 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 $280,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 Required: Fill in the missing amounts. (Enter credit amounts with a minus sign and debit amounts with a positive sign.) Hint Net Loss - AOCI $ 104 Pension Expense Prior Plan Service PBO Assets Cost - AOCI $ (1,040) $ 780 $ 266 (124) (52) 62.401 Cash Net Pension (Liability) I Asset $ (260) (124) Print 124 (52) References (62.40) 2626 2 6 ($ 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 I Prior service cost Cash funding Retiree benefits Balance, Dec. 31, 2018 20 (20) 1081 (108) $ (1,138) $ 950 $ 252 $ 10 $ 140 $ (320)