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 $300,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 $ (860.0) $ 600.0 (43.0) $ (929.0) $ Prior Service Cost - AOCI $ 600.0 $ Net Loss - AOCI 285.0 $ 270.0 $ 86.0 17.0 Pension Expense 103.0 $ 106.0 (48.0) 58.0 Cash (90.0) Net Pension (Liability) / Asset $ $ (260.0) 30.0 (230.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 $300,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 $ (860.0) $ 600.0 (43.0) $ (929.0) $ Prior Service Cost - AOCI $ 600.0 $ Net Loss - AOCI 285.0 $ 270.0 $ 86.0 17.0 Pension Expense 103.0 $ 106.0 (48.0) 58.0 Cash (90.0) Net Pension (Liability) / Asset $ $ (260.0) 30.0 (230.0)
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question
100%
![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 $300,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
$ (860.0) $
(43.0)
$ (929.0)
$
600.0
600.0
Prior Service
Cost - AOCI
$
$
285.0
270.0
Net Loss -
AOCI
$
$
86.0
17.0
Pension
Expense
103.0 $
106.0
(48.0)
58.0
Cash
(90.0)
Net Pension
(Liability) /
Asset
$
$
(260.0)
30.0
(230.0)](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F5042eef7-a4bf-4a90-aabd-cc56a5b00d3f%2F4b29d8db-5714-4585-9f6c-d287b2414497%2F5m7vcku_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 $300,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
$ (860.0) $
(43.0)
$ (929.0)
$
600.0
600.0
Prior Service
Cost - AOCI
$
$
285.0
270.0
Net Loss -
AOCI
$
$
86.0
17.0
Pension
Expense
103.0 $
106.0
(48.0)
58.0
Cash
(90.0)
Net Pension
(Liability) /
Asset
$
$
(260.0)
30.0
(230.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.
This is a popular solution!
Trending now
This is a popular solution!
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