AC 313 Please Help

Exercise 17-15 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 2016, the pension formula was amended, creating a prior service cost of $200,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 credit amounts with a minus sign and debit amounts with a positive sign.) Prior Net Pension Plan Service Net Loss Pension (Liability) / Asset (S in 000s) O Cost-AOCI 700 $ Assets -AOCI Expense Cash Balance, Jan. 1, 2018 Service cost (960) 190 $ 96 (260) 116 Interest cost, 5% Expected return on assets Adjust for (48) (56.00) Loss on assets 22 Amortization: Prior service cost Amortization: Fill in the missing amounts. (Enter credit amounts with a minus sign and debit amounts with a positive sign.) Prior Net Pension Plan Service Net Loss Pension (Liability) / Asset (S in 000s) O Assets Cost-AOCI -AOCI Expense Cash Balance, Jan. 1, 2018 $ (960) $ 700 $ 190 $ 96 (260) Service cost 116 (48) Interest cost, 5% Expected returm on assets (56.00) Adjust for Loss on assets 22 Amortization: Prior service cost Amortization: Net loss Gain on PBO 20 Prior service cost Cash funding (100) Retiree benefits Balance, Dec. 31, 2018 $ (1,054) $ 180 Prev 6 of 10 Next >