3. Prepare a pension spreadsheet to assist you in determining end of 2024 balances in the PBO, plan assets, prior service cost-AOCI, the net loss-AOCI, and the pension liability. Note: Enter your answers in millions (i.e., 10,000,000 should be entered as 10). Enter credit amounts with a minus sign and debit amounts with a positive sign. ($ in millions) Balance, January 1, 2024 Service cost Interest cost, 8% Expected return on assets Loss on assets Amortization of: Prior service cost-AOCI Net loss-AOCI Gain or Loss on PBO Cash contributions Retiree benefits Balance, December 31, 2024 PBO (300) (48) (24) (372) Plan Assets 200 200 Answer is not complete. Prior Service Cost- AOCI 0 Net Loss -AOCI Pension Expense 48 24 72 Cash Net Pension (Liability) or Asset
3. Prepare a pension spreadsheet to assist you in determining end of 2024 balances in the PBO, plan assets, prior service cost-AOCI, the net loss-AOCI, and the pension liability. Note: Enter your answers in millions (i.e., 10,000,000 should be entered as 10). Enter credit amounts with a minus sign and debit amounts with a positive sign. ($ in millions) Balance, January 1, 2024 Service cost Interest cost, 8% Expected return on assets Loss on assets Amortization of: Prior service cost-AOCI Net loss-AOCI Gain or Loss on PBO Cash contributions Retiree benefits Balance, December 31, 2024 PBO (300) (48) (24) (372) Plan Assets 200 200 Answer is not complete. Prior Service Cost- AOCI 0 Net Loss -AOCI Pension Expense 48 24 72 Cash Net Pension (Liability) or Asset
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question
![3. Prepare a pension spreadsheet to assist you in determining end of 2024 balances in the PBO, plan assets, prior service cost-AOCI,
the net loss-AOCI, and the pension liability.
Note: Enter your answers in millions (i.e., 10,000,000 should be entered as 10). Enter credit amounts with a minus sign and debit
amounts with a positive sign.
($ in millions)
Balance, January 1, 2024
Service cost
Interest cost, 8%
Expected return on assets
Loss on assets
Amortization of:
Prior service cost-AOCI
Net loss-AOCI
Gain or Loss on PBO
Cash contributions
Retiree benefits
Balance, December 31, 2024
PBO
(300) ✔
(48)✔
(24) ✔
(372)
Plan
Assets
200✔
200
X Answer is not complete.
Prior
Service
Cost-
AOCI
0
Net Loss
-AOCI
0
Pension
Expense
48 ✓
24✔
72
Cash
Net
Pension
(Liability)
or Asset
0](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F3308e699-db46-49c0-85ea-fd99c830234a%2Fd8d7b8fa-0303-4170-b5dd-0765714dfdf1%2Fvu9pmlr_processed.jpeg&w=3840&q=75)
Transcribed Image Text:3. Prepare a pension spreadsheet to assist you in determining end of 2024 balances in the PBO, plan assets, prior service cost-AOCI,
the net loss-AOCI, and the pension liability.
Note: Enter your answers in millions (i.e., 10,000,000 should be entered as 10). Enter credit amounts with a minus sign and debit
amounts with a positive sign.
($ in millions)
Balance, January 1, 2024
Service cost
Interest cost, 8%
Expected return on assets
Loss on assets
Amortization of:
Prior service cost-AOCI
Net loss-AOCI
Gain or Loss on PBO
Cash contributions
Retiree benefits
Balance, December 31, 2024
PBO
(300) ✔
(48)✔
(24) ✔
(372)
Plan
Assets
200✔
200
X Answer is not complete.
Prior
Service
Cost-
AOCI
0
Net Loss
-AOCI
0
Pension
Expense
48 ✓
24✔
72
Cash
Net
Pension
(Liability)
or Asset
0
![Actuary and trustee reports indicate the following changes in the PBO and plan assets of Lakeside Cable during 2024:
Prior service cost at January 1, 2024, from plan amendment at the beginning of
2022 (amortization: $4 million per year)
Net loss-pensions at January 1, 2024 (previous losses exceeded previous gains)
Average remaining service life of the active employee group
Actuary's discount rate
($ in millions)
Beginning of 2024
Service cost
Interest cost, 8%
Loss (gain) on PBO
Less: Retiree benefits
End of 2024
Beginning of 2025
Service cost
PBO
$ 300
48
Interest cost, 8%
Loss (gain) on PBO
Less: Retiree benefits
End of 2025
24
(2)
(20)
$ 350
PBO
$ 350
38
28
5
(16)
Beginning of 2024
Return on plan assets, 7.5% (10%
expected)
$ 405
Cash contributions
Less: Retiree benefits
End of 2024
Assume the following actuary and trustee reports indicating changes in the PBO and plan assets of Lakeside Cable during
2025:
($ in millions)
Beginning of 2025
Return on plan assets, 15% (10%)
expected)
$ 32 million
$ 40 million
10 years
8%
Cash contributions
Less: Retiree benefits
End of 2025
Plan
Assets
$ 200
15
45
(20)
$ 240
Plan
Assets
$ 240
36
30
(16)
$ 290](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F3308e699-db46-49c0-85ea-fd99c830234a%2Fd8d7b8fa-0303-4170-b5dd-0765714dfdf1%2F0mefh1q_processed.jpeg&w=3840&q=75)
Transcribed Image Text:Actuary and trustee reports indicate the following changes in the PBO and plan assets of Lakeside Cable during 2024:
Prior service cost at January 1, 2024, from plan amendment at the beginning of
2022 (amortization: $4 million per year)
Net loss-pensions at January 1, 2024 (previous losses exceeded previous gains)
Average remaining service life of the active employee group
Actuary's discount rate
($ in millions)
Beginning of 2024
Service cost
Interest cost, 8%
Loss (gain) on PBO
Less: Retiree benefits
End of 2024
Beginning of 2025
Service cost
PBO
$ 300
48
Interest cost, 8%
Loss (gain) on PBO
Less: Retiree benefits
End of 2025
24
(2)
(20)
$ 350
PBO
$ 350
38
28
5
(16)
Beginning of 2024
Return on plan assets, 7.5% (10%
expected)
$ 405
Cash contributions
Less: Retiree benefits
End of 2024
Assume the following actuary and trustee reports indicating changes in the PBO and plan assets of Lakeside Cable during
2025:
($ in millions)
Beginning of 2025
Return on plan assets, 15% (10%)
expected)
$ 32 million
$ 40 million
10 years
8%
Cash contributions
Less: Retiree benefits
End of 2025
Plan
Assets
$ 200
15
45
(20)
$ 240
Plan
Assets
$ 240
36
30
(16)
$ 290
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