Using Excel to Account for Pensions PROBLEM Uvo Corporation is a private company with a defined benefit pension plan. The following information is available for Uvo Corporation for 2023. Opening balance, DBO Student Work Area Required: Provide input into cells shaded in yellow in this template. Use mathematical formulas with cell references to the Problem and work areas as indicated. $ 210,000 Opening balance, plan assets 200,000 Service cost 58,000 Employer contributions paid evenly through 2023 77,000 Applicable interest or discount rate 10% Actual return on plan assets $ 25,000 Actuarial loss due to change in actuarial assumptions 14,000 Assuming that Uvo follows IFRS, determine the 2023 effect of the pension plan on pension expense and the company's shareholders' equity. Display amounts to be subtracted as negative amounts. Average plan assets Defined benefit expense: Current service cost Defined benefit expense Remeasurement gain or loss (OCI): ་ Effect on shareholders' equity

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
Using Excel to Account for Pensions
PROBLEM
Uvo Corporation is a private company with a defined benefit pension plan. The following
information is available for Uvo Corporation for 2023.
Opening balance, DBO
Student Work Area
Required: Provide input into cells shaded in yellow in this template. Use mathematical
formulas with cell references to the Problem and work areas as indicated.
$
210,000
Opening balance, plan assets
200,000
Service cost
58,000
Employer contributions paid evenly through 2023
77,000
Applicable interest or discount rate
10%
Actual return on plan assets
$
25,000
Actuarial loss due to change in actuarial assumptions
14,000
Assuming that Uvo follows IFRS, determine the 2023 effect of the pension plan on
pension expense and the company's shareholders' equity. Display amounts to be
subtracted as negative amounts.
Average plan assets
Defined benefit expense:
Current service cost
Defined benefit expense
Remeasurement gain or loss (OCI):
་
Effect on shareholders' equity
Transcribed Image Text:Using Excel to Account for Pensions PROBLEM Uvo Corporation is a private company with a defined benefit pension plan. The following information is available for Uvo Corporation for 2023. Opening balance, DBO Student Work Area Required: Provide input into cells shaded in yellow in this template. Use mathematical formulas with cell references to the Problem and work areas as indicated. $ 210,000 Opening balance, plan assets 200,000 Service cost 58,000 Employer contributions paid evenly through 2023 77,000 Applicable interest or discount rate 10% Actual return on plan assets $ 25,000 Actuarial loss due to change in actuarial assumptions 14,000 Assuming that Uvo follows IFRS, determine the 2023 effect of the pension plan on pension expense and the company's shareholders' equity. Display amounts to be subtracted as negative amounts. Average plan assets Defined benefit expense: Current service cost Defined benefit expense Remeasurement gain or loss (OCI): ་ Effect on shareholders' equity
AI-Generated Solution
AI-generated content may present inaccurate or offensive content that does not represent bartleby’s views.
steps

Unlock instant AI solutions

Tap the button
to generate a solution

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