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 $220,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 Net Loss - AOCI PBO $ (580.0) $ 520.0 $ 209.0 $ 58.0 (29.0) Prior Service Cost-AOCI Plan Assets $ (635.0) $ 520.0 $ 198.0 $ 13.0 Pension Expense 71.0 $ 98.0 (41.6) 56.4 Cash Net Pension (Liability) /Asset $ (60.0) (82.0) $ 22.0 (38.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 2019, the pension formula was amended, creating a prior service cost of $220,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 Net Loss - AOCI PBO $ (580.0) $ 520.0 $ 209.0 $ 58.0 (29.0) Prior Service Cost-AOCI Plan Assets $ (635.0) $ 520.0 $ 198.0 $ 13.0 Pension Expense 71.0 $ 98.0 (41.6) 56.4 Cash Net Pension (Liability) /Asset $ (60.0) (82.0) $ 22.0 (38.0)
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question
acc1
![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 $220,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
Prior
Service
Assets Cost-AOCI
Plan
Net Loss
- AOCI
PBO
$ (580.0) $ 520.0 $ 209.0 $ 58.0
(29.0)
$ (635.0) $ 520.0 $
198.0 $
13.0
Pension
Expense
71.0 $
98.0
(41.6)
56.4
Cash
Net Pension
(Liability)
/Asset
(82.0)
$
$
(60.0)
22.0
(38.0)](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F00a2e412-d801-42da-87a8-c8c387a19437%2Fa70693ff-ebf0-4df4-a2c1-3a5740730f1a%2Fsi8qzla_processed.jpeg&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 2019, the pension formula was amended,
creating a prior service cost of $220,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
Prior
Service
Assets Cost-AOCI
Plan
Net Loss
- AOCI
PBO
$ (580.0) $ 520.0 $ 209.0 $ 58.0
(29.0)
$ (635.0) $ 520.0 $
198.0 $
13.0
Pension
Expense
71.0 $
98.0
(41.6)
56.4
Cash
Net Pension
(Liability)
/Asset
(82.0)
$
$
(60.0)
22.0
(38.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