Question: Exercise 1 7 - 1 5 ( Algo ) Pension spreadsheet [ LO 1 7 - 8 ] A partially completed pension spreadsheet showing the

Exercise 17-15(Algo) Pension spreadsheet [LO17-8]
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 2019, the pension formula was amended, creating a prior service cost of $140,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:
Fill in the missing amounts. (Enter your answers in thousands rounded to 1 decimal place.)
\table[[,,Prior,,,,Net Pension],[,,Plan,Service,Net Loss,Pension,,(Liability)],[($ in thousands),PBO,Assets,Cost-AOCl,-AOCl,Expense,Cash,IAsset],[Balance, Jan. 1,2021,$ (660.0),$ 440.0,$ 133.0,$ 66.0,,,$ (220.0)],[Service cost,,,,,90.0,,],[Interest cost,5%,(33.0),,,,,,],[Expected return on assets,,,,,(35.2),,],[Adjust for:,,,,,,,],[Loss on assets,,,,9.0,,,],[Amortization:,,,,,,,],[Prior service cost,,,,,,,],[Amortization:,,,,,,,],[Net loss,,,,,,,],[Gain on PBO,,,,,,,14.0],[Prior service cost,,,,,,,],[Cash funding,,,,,,(74.0),],[Retiree benefits,,,,,,,],[Balance, Dec. 31,2021,$ (719.0),$ 440.0,$ 126.0,$ 75.0,$ 54.8,,$ (206.0)]]
Exercise 1 7 - 1 5 ( Algo ) Pension spreadsheet [

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!