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 2009, the pension formula was amended, creating a prior service cost of $120,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:

Copy the incomplete spreadsheet and fill in the missingamounts.

Transcribed Image Text:

(s indicate credits, debits PBO P PriNet Pension Cash Net Pension otherwise ( in 000s) Assets Service Loss Expense (Liability Asset Cost 114 80 (200) Balance, Jan. 1, 2011 Service cost Interest cost 5% Expected return on assets Adjust for Loss on assets Amortization Prior sevice cost Amortization Net loss Gain on PBO Prior service cost Cash funding Retiree benefits Balance, Dec. 31, 2011 (800) 600 84 (40) (48) 12 (68) 862 108