Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribedimage text in transcribed 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 $320,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.) ($ in thousands) Balance, Jan. 1, 2021 Service cost Interest cost, 5% Expected return on assets Adjust for: PBO Plan Assets $ (880.0) $ 620.0 (44.0) 0.0 0.0 Prior Service Net Loss Pension Cost - AOCI - AOCI Expense Cash $ 304.0 $ 88.0 $ 0.0 $ 108.0 (49.6) Net Pension (Liability) / Asset 0.0 $ (260.0) Loss on assets 0.0 18.0 Amortization: Prior service cost 0.0 0.0 0.0 0.0 0.0 Amortization: Net loss Gain on PBO Prior service cost Cash funding 0.0 0.0 0.0 0.0 0.0 0.0 32.0 (92.0) Retiree benefits Balance, Dec. 31, 2021 $ (950.0) $ 620.0 $ 288.0 $ 106.0 $ 58.4 $ (228.0)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Intermediate Accounting

Authors: J. David Spiceland, James Sepe, Mark Nelson, Wayne Thomas

9th Edition

125972266X, 9781259722660

More Books

Students also viewed these Accounting questions

Question

=+c) How many baseballs produced were out of spec?

Answered: 1 week ago