Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Question: Sabrina Consultants Inc. has had a defined benefit pension plan since January 1, 2016. The following represents beginning balances as at January 1,
Question: Sabrina Consultants Inc. has had a defined benefit pension plan since January 1, 2016. The following represents beginning balances as at January 1, 2020: Market value of Plan Asset $1,155,300; Defined Benefit Obligation $1,375,000; AOCI: Loss of $305,000 Additional Information is as follows: Current Service cost is $196,000 for 2020 and $199,000 for 2021. Company Funding/Contribution is $195,000 for 2020 and $205,000 for 2021. Funding is made on December 31 of each year. Actual return on assets is $49,500 for 2020 and $51,500 for 2021. There is an increase in obligation for $26,000 due to changes in Actuarial assumptions at Dec 31, 2020. There are payments made equal to $85,000 per year to retired employees in both 2020 and 2021 (payments to retirees are made at the end of the year on December 31). Past service cost of $65,900 from plan amendment dated December 31, 2021: liability is increased because benefits were increased on a retroactive basis. For 2020, the assumed interest rate is 5% For 2021, the assumed interest rate is 4% Required: 1. Prepare a spreadsheet to determine all the pension items for both 2020 and 2021. I
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