Need help

Problem 17-8 Pension spreadsheet; record pension expense and funding; new gains and losses LO17-7, 17-8] A partially completed pension spreadsheet showing the relationships among the elements that constitute Carney, Inc 's defined benenit pension plan follows. Six years earler, Carney revised its pension formula and recakculated 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 $60 million. The expected rate of return on assets and the actuary's 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 shoulgpe entered as 10).) Required 1. Fill in the missing amounts. (Amounts to be deducted should be indicated with a minus debits otherwise Net Pension (Liability) Prior Net Pension Expense ($ in millions) Cash AOCI Cost-AOCI 720 (140) Balance, Jan. 1, 2016 Service cost Interest cost Expected return on assets Adjust for (860) 40 96 76 Loss on assets Amortization of Prior service cost Net loss Loss on PBO Prior service cost Cash funding Retiree benefits Bal, Dec 31. 2016 (16) 81 (860) 750 40 96 76 (75)