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

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
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
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
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
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps

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