Prepare a spreadsheet to determine all the pension items

Assignment Help Financial Accounting
Reference no: EM132920153

Question - Sabriina Consultants Inc. has had a defined benefit pension plan since January 1, 2016.

The following represents beginning balances as at January 1, 2019:

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 2019 and $199,000 for 2020.

Company Funding/Contribution is $192,000 for 2019 and $205,000 for 2020.

Funding is made on December 31 of each year.

Actual return on assets is $49,600 for 2019 and $51,400 for 2020.

There is an increase in obligation for $28,000 due to changes in Actuarial assumptions at Dec 31, 2019.

There are payments made equal to $83,000 per year to retired employees in both 2019 and 2020 (payments to retirees are made at the end of the year on December 31).

Past service cost of $65,600 from plan amendment dated December 31, 2020: liability is increased because benefits were increased on a retroactive basis.

For 2019, the assumed interest rate is 4%. For 2020, the assumed interest rate is 5%.

Required -

1. Prepare a spreadsheet to determine all the pension items for both 2019 and 2020.

2. Prepare the required journal entries for both 2019 and 2020.

3. Prepare a partial balance sheet and a partial income statement for both 2019 and 2020.

4. Prepare the Pension Notes to the financial statements for 2019 only.

Reference no: EM132920153

Questions Cloud

Review and reflect on many aspects of the overall process : Developing a deeper awareness, appreciation and empathy with the wider strategic business planning and plan development processes
What is the net advantage or disadvantage : Alternatively, the keyboards could be sold "as is" for $7,200. What is the net advantage or disadvantage of re-working the keyboards
What is the present value of the annuity : What is the present value of the following annuity - $2,698 every half year at the beginning of the period for the next 8 years
How much the preferred and common shareholders will receive : Calculate how much the preferred and common shareholders will receive. 40,000, $ 0.80, no par value preferred shares $ 400,000
Prepare a spreadsheet to determine all the pension items : Current Service cost is $196,000 for 2019 and $199,000 for 2020. Prepare a spreadsheet to determine all the pension items for both 2019 and 2020
Evaluate the benefits of promotional activities : The organisation you work for has been promoting their main service completing tax returns via TV advertisements. How would you analyse costs and time lines to
Present an amortization table indicating amount of interest : With proper headings, present an amortization table, indicating the amount of interest expense, interest paid, discount or premium amortized and balance
Swot analysis of a company : Highly Brill Leisure Center (a Sports Facility) has hired you to help them with their marketing decision making.
Prepare the necessary journal entries for abc : Prepare the entry to record bad debt expense assuming that in transaction #4, $4,000 of A/R had been written off instead of $1,500.

Reviews

Write a Review

Financial Accounting Questions & Answers

  Find what is the simple rate of return on the new equipment

What is the simple rate of return on the new equipment? Ferris Company has an old machine that is fully depreciated but has a current salvage value of $5,000.

  What is cost of ending inventory if uses lifo costing method

If Windrose uses the LIFO costing method, what is the cost of its ending inventory? Windrose, Inc. uses a periodic inventory system

  What is the amount of interest revenue

Assuming that Moss Co. uses the effective-interest method, what is the amount of interest revenue that would be recognized in 2013 related to these bonds?

  How much should rereina show in statement of financial

Rereina Corporation bought 15 percent, How much should Rereina show in its 20x2 statement of financial performance as income from this investment?

  How does the originate-to-distribute model of lending

How does the originate-to-distribute model of lending differ from traditional lending? Which lending approach results in lenders having less concern

  What is the present value of a three-year annuity

What is the present value of the annuity in (a) if you have to wait an additional year for the first payment? What is the present value of a 3-year annuity

  Difference between adjusting entries and correcting entries

Required- Journalize the adjusting entries required on March 31. What is the difference between adjusting entries and correcting entries

  What is the equity at year-end

Company's assets are $300,000 and the its equity is 100,000. during the year, asset increase $800,000 and liabilities increase to $50,000. What is the equity

  Preparation the financial statements of lota for the year

Show how the financial instruments will be treated in the financial statements of Lota for the year ended 31 December 2012

  Make a classified balance sheet for the year ended december

Make a classified balance sheet for the year ended December 31, 2020. Information is available for The Eagles Company for the year ended December 31, 2020

  What is the estimated inventory on september

What is the estimated inventory on September 28, 2013, immediately prior to the fire - fire destroyed the entire merchandise inventory of Carroll Corporation.

  What amount of these losses can he currently deduct

Connor's AGI is $175,000 and he performs 650 hours of services in real property trades or businesses. What amount of these losses can he currently deduct

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd