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

  Financial statement analysis and preparation

Financial Statement Analysis and Preparation

  Shareholder of a company

Describe the ways that a person can become a shareholder of a company. Why Wal-Mart would split its stock?

  Financial and accounting principles

An understanding of financial and accounting principles can be a valuable tool for managers. While not all managers will find themselves calculating financial ratios or preparing annual financial data.

  Prepare a statement of cash flow using the direct method

Prepare a Statement of Cash Flow using the Direct Method and Prepare the Operations section of the Statement of Cash Flow using the Indirect Method.

  Financial accounting assignment

This assignment has one case study and two question apart from case study. Questions related to document Liquidation question and Company financial statements question - Torquay Limited

  Prepare general journal entries for goela

Prepare general journal entries for Goela Ltd

  Principles of financial accounting

Prepare the journal entry to record the acquisition of the assets.

  Prepare general journal entries to record the transactions

Prepare general journal entries to record the transactions, assuming use of the periodic inventory system

  Global reporting initiative

Compare the view espoused by the economist Milton Friedman about the social responsibilities of business with the views express by Stigler.

  Explain the iasb conceptual frameworks

Explain the IASB Conceptual Framework's perspective of users and their decisions.

  Determine the company''s financial statements

T he focus of the report is to determine the extent to which you are comfortable relying on the financial statements as presented by management .

  Computation of free cash flow

Computation of Free Cash Flow

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