A partially completed pension spreadsheet showing the relationships among the elements that constitute Carney, Inc.s defined benefit pension plan follows. Six years earlier, Carney revised its pension formula and recalculated benefits earned by employees in prior years using the more generous formula. The prior service cost created by the recalculation is being amortized at the rate of $5 million per year. At the end of 2016, the pension formula was amended again, creating an additional prior service cost of $35 million. The expected rate of return on assets and the actuarys discount rate were 10%, and the average remaining service life of the active employee group is 10 years. (Enter your answers in millions (i.e., 10,000,000 should be entered as 10).)

A partially completed pension spreadsheet showing the relationships among the elements that constitute Carney, Inc.s defined benefit pension plan follows. Six years earlier, Carney revised its pension formula and recalculated benefits earned by employees in prior years using the more generous formula. The prior service cost created by the recalculation is being amortized at the rate of $5 million per year. At the end of 2016, the pension formula was amended again, creating an additional prior service cost of $35 million. The expected rate of return on assets and the actuarys discount rate were 10%, and the average remaining service life of the active employee group is 10 years.

Required 1. Fill in the missing amounts. (Amounts to be deducted should be indicated with a minus sign.) s indicate credits debits otherwise Net Pension Prior Service Net Loss Pension in millions) AOCI Expense Cash (Liability) Asset PBO Plan Assets Cost-AOC (110) (960) 850 20 Balance, Jan. 1, 2016 106 Service cost 96 Interest cost Expected return on assets Adjust for: (10) Loss on assets Amortization of Prior service cost Net loss Loss on PBO (26) Prior service cost Cash funding 91 Retiree benefits 800 (960) 20 (45) 106 96 Bal., Dec. 31, 2016