Prepare a pension worksheet presenting both years 2017 and 2018

2018 2017 Projected benefit obligation, January 1 Plan assets (fair value and market-related value), January Pension asset/liability, January Prior service cost, January 1 Service cost Settlement rate Expected rate of return Actual return on plan assets Amortization of prior service cost Annual contributions Benefits paid retirees $600,000 190,000 Cr 160,000 40,000 $59,000 10% 10% 10% 10% 36,000 70,000 97,000 31,500 87,000 61,000 50,000 81,000 54,000 0 Increase in projected benefit obligation due to changes in actuarial assumptions Average service life of all employees 20 years