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 $240,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: Loss on assets Amortization: Prior service cost Amortization: Net loss Gain on PBO Prior service cost Cash funding Retiree benefits Balance, Dec. 31, 2021 Plan PBO Assets S (560.0) S 540.0 S (28.0) S (614.0) S Prior Service Cost - AOCI 228.0 540.0 S 216.0 Net Loss - AOCI $ 56.0 14.0 Pension Expense $ 70.0 $ 100.0 (43.2) 56.8 Cash (84.0) Net Pension (Liability) / Asset S S (20.0) 24.0 4.0

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Question
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 $240,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:
Loss on assets
Amortization:
Prior service cost
Amortization:
Net loss
Gain on PBO
Prior service cost
Cash funding
Retiree benefits
Balance, Dec. 31, 2021
Plan
Assets
Net Loss
- AOCI
S (560.0) $ 540.0 S 228.0 $ 56.0
PBO
(28.0)
Prior
Service
Cost - AOCI
S (614.0) S
540.0 $
69
216.0 $
14.0
70.0
Pension
Expense
69
100.0
(43.2)
56.8
Cash
(84.0)
Net Pension
(Liability)
/Asset
$
$
(20.0)
24.0
4.0
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 2019, the pension formula was amended, creating a prior service cost of $240,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: Loss on assets Amortization: Prior service cost Amortization: Net loss Gain on PBO Prior service cost Cash funding Retiree benefits Balance, Dec. 31, 2021 Plan Assets Net Loss - AOCI S (560.0) $ 540.0 S 228.0 $ 56.0 PBO (28.0) Prior Service Cost - AOCI S (614.0) S 540.0 $ 69 216.0 $ 14.0 70.0 Pension Expense 69 100.0 (43.2) 56.8 Cash (84.0) Net Pension (Liability) /Asset $ $ (20.0) 24.0 4.0
Expert Solution
steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Knowledge Booster
Accounting for Employee Compensations and Benefits
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.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education