14 The following pension-related data pertain to Metro Recreation's noncontributory, defined benefit pension plan for 2018: ($ in 000s) Jan. 1 10 points Dec. 31 Projected benefit obligation Accumulated benefit obligation Plan assets (fair value) Interest (discount) rate, 8% Expected return on plan assets, 106 Prior service cost-AOCI (from Dec. 31, 2017, amendment) Net loss-AOCI $5,200 3,770 6,180 $5,480 4,060 6,625 Skipped 950 638 Average remaining service life: 10 years Gain due to changes in actuarial assumptions Contributions to pension fund (end of year) Pension benefits paid (end of year) eBook 60 450 405 Print Required: Prepare a pension spreadsheet that shows the relationships among the various pension balances, shows the changes in those balances, and computes pension expense for 2018. (Enter credit amounts with a minus sign and debit amounts with a positive sign. Enter your answers in thousands (i.e. 200,000 should be entered as 200).) References Net Pension Net Loss- Prior Service Cost-AOCI Pension Expense (Liability) Asset (S in 000s) PBO Plan Assets Cash AOCI Balance, Jan. 1, 2018 Service cost Interest cost Expected ret assets Id . 14 Expected return on plan assets, 10% Prior service cost-AOCI (from Dec. 31, 2017, amendment) Net loss-AOCI 950 638 Average remaining service life: 10 years Gain due to changes in actuarial assumptions Contributions to pension fund (end of year) Pension benefits paid (end of year) 60 450 405 10 points Required: Prepare a pension spreadsheet that shows the relationships among the various pension balances, shows the changes in those balances, and computes pension expense for 2018. (Enter credit amounts witha minus sign and debit amounts with a positive sign. Enter your answers in thousands (i.e. 200,000 should be entered as 200).) Skipped eBook Net Pension Prior Service Pension Net Loss- AOCI (Liability)/ Asset Print (S in 000s) PBO Plan Assets Cash Cost-AOCI Expense Balance, Jan. 1, 2018 References Service cost Interest cost Expected return on assets Adjust for Loss on assets Amortization of Prior service cost Net loss Gain on PBO Cash funding Retiree benefits Bal, Dec 31, 2018 0 C C 0