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 2022, the pension formula was amended, creating a prior service cost of $180,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. Note: Enter your answers in thousands (i.e., 5,500 should be entered as 5.5). Enter credit amounts with a minus sign. ($ in thousands) Balance, January 1, 2024 Service cost Interest cost, 5% Expected return on assets Adjust for: Loss on assets Amortization: Prior service cost Amortization: Net loss Gain on PBO Prior service cost Cash funding Retiree benefits Balance, December 31, 2024 PBO Plan Assets (31.0) $ (620.0) $ 480.0 $ Prior Service Cost - AOCI 171.0 $ (677.0) $ 480.0 $ 162.0 Net Loss - AOCI $ 62.0 $ 11.0 73.0 Pension Expense $ 94.0 (38.4) 55.6 Cash (78.0) Net Pension (Liability) / Asset $ $ (140.0) 18.0 (122.0)
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 2022, the pension formula was amended, creating a prior service cost of $180,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. Note: Enter your answers in thousands (i.e., 5,500 should be entered as 5.5). Enter credit amounts with a minus sign. ($ in thousands) Balance, January 1, 2024 Service cost Interest cost, 5% Expected return on assets Adjust for: Loss on assets Amortization: Prior service cost Amortization: Net loss Gain on PBO Prior service cost Cash funding Retiree benefits Balance, December 31, 2024 PBO Plan Assets (31.0) $ (620.0) $ 480.0 $ Prior Service Cost - AOCI 171.0 $ (677.0) $ 480.0 $ 162.0 Net Loss - AOCI $ 62.0 $ 11.0 73.0 Pension Expense $ 94.0 (38.4) 55.6 Cash (78.0) Net Pension (Liability) / Asset $ $ (140.0) 18.0 (122.0)
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question
Do not give image format
![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 2022, the pension formula was amended,
creating a prior service cost of $180,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.
Note: Enter your answers in thousands (i.e., 5,500 should be entered as 5.5). Enter credit amounts with a minus sign.
($ in thousands)
Balance, January 1, 2024
Service cost
Interest cost, 5%
Expected return on assets
Adjust for:
Loss on assets
Amortization:
Prior service cost
Amortization:
Net loss
Gain on PBO
Prior service cost
Cash funding
Retiree benefits
Balance, December 31, 2024
PBO Plan Assets
$ (620.0) $ 480.0
(31.0)
$ (677.0) $
Prior Service
Cost - AOCI
$
171.0
480.0 $
Net Loss -
AOCI
$
162.0 $
62.0
11.0
Pension
Expense
73.0 $
94.0
(38.4)
55.6
Cash
(78.0)
Net Pension
(Liability) /
Asset
$
$
(140.0)
18.0
(122.0)](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F475b0c8f-9dd7-487b-9264-3e04ebb75dff%2Fc35db980-b14b-4df9-bc3a-a786d2eb9a9a%2Ffoaq1u_processed.png&w=3840&q=75)
Transcribed Image Text: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 2022, the pension formula was amended,
creating a prior service cost of $180,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.
Note: Enter your answers in thousands (i.e., 5,500 should be entered as 5.5). Enter credit amounts with a minus sign.
($ in thousands)
Balance, January 1, 2024
Service cost
Interest cost, 5%
Expected return on assets
Adjust for:
Loss on assets
Amortization:
Prior service cost
Amortization:
Net loss
Gain on PBO
Prior service cost
Cash funding
Retiree benefits
Balance, December 31, 2024
PBO Plan Assets
$ (620.0) $ 480.0
(31.0)
$ (677.0) $
Prior Service
Cost - AOCI
$
171.0
480.0 $
Net Loss -
AOCI
$
162.0 $
62.0
11.0
Pension
Expense
73.0 $
94.0
(38.4)
55.6
Cash
(78.0)
Net Pension
(Liability) /
Asset
$
$
(140.0)
18.0
(122.0)
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 3 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Recommended textbooks for you
![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Accounting](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Accounting](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
![Horngren's Cost Accounting: A Managerial Emphasis…](https://www.bartleby.com/isbn_cover_images/9780134475585/9780134475585_smallCoverImage.gif)
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
![Intermediate Accounting](https://www.bartleby.com/isbn_cover_images/9781259722660/9781259722660_smallCoverImage.gif)
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
![Financial and Managerial Accounting](https://www.bartleby.com/isbn_cover_images/9781259726705/9781259726705_smallCoverImage.gif)
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education