Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Excel Problem: Upload your solution to the dropbox on eLearning. HRC Company sponsors a defined benefits pension plan to its employees. On January 1,
Excel Problem: Upload your solution to the dropbox on eLearning. HRC Company sponsors a defined benefits pension plan to its employees. On January 1, 2021, the balances related to pension plan were as follows: Projected benefit obligation (PBO) $4,600,000 Fair value of plan assets $4,500,000 AOCI - Prior service cost -0- AOCI - gain/loss -0- The discount (or settlement) rate applicable to the plan is 10%. On December 31, 2021, the company amends the pension agreement resulting in a prior service cost of $800,000. The company uses straight- line amortization of prior service costs over the average remaining service life of the employees. Other data related to the pension plan are as follows: 2021 2022 Service cost $150,000 $170,000 Contributions (funding) to the plan 500,000 880,000 Benefits paid 220,000 280,000 Actual return on plan assets 300,000 350,000 Increase in PBO due to changes in actuarial 450,000 -0- assumptions Expected return on plan assets 10% Average service life of all employees 10% 20 years Required: Using the Excel template provided (or you can use your own template as well): 1. Prepare Pension worksheet for the year 2021 and 2022 in Excel. Make sure to include all accompanying computations at the bottom of the worksheet (such as amortization of gain/losses).
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started