Spreadsheet pensions to prepare a pension worksheet

Assignment Help Financial Accounting
Reference no: EM131217710

Complete the following exercise. Label each question clearly. Brown Corp. provides a defined benefit pension plan for its employees. The balances below are on its books as of January 1, 2017.

Account Balance

Plan assets $480,000

Projected benefit obligation (PBO) $625,000

Accumulated OCI (Prior Service Cost) $100,000* *

Prior Service Cost has a debit balance on January 1, 2017.

The actuary has provided the following information:

2017 Service cost $90,000

Amortization of prior service cost $19,000

Settlement rate 9%

Actual return on plan assets in 2017 $57,000

Unexpected loss from change in PBO due to actuarial

predictions’ change $76,000

Contributions in 2017 $99,000

Benefits paid to retirees in 2017 $85,000

Required

1. Use the spreadsheet Pensions to prepare a pension worksheet. On the pension worksheet, compute pension expense, pension asset/liability, projected benefit obligation, plan assets, prior service cost, and net gain or loss. Recall that settlement rate is 9%.

2. Compute the same items as in (1), assuming that the settlement rate is now 7% and the expected rate of return is 10%. Hint: Simply change the interest cost to 7%; change actual/expected return to balance of plant asset on January 1, 2017*10%

3. Prepare the journal entry using the spreadsheet Journal Entries to record pension expense in 2017. 4. Indicate the reporting of the 2017 pension amounts in the income statement and balance sheet for Brown Corp. using the spreadsheet Pensions.

Reference no: EM131217710

Questions Cloud

What must be proven by a plaintiff in order to prevail : In reviewing the assumption of liability by a department, what must be proven by a plaintiff in order to prevail in a case involving negligent hiring? Compare negligent hiring with negligent assignment, retention, and entrustment. What requiremen..
Concept from the conceptual framework of accounting : State and explain ONE main accounting principle, rule, assumption or any other concept from the conceptual framework of accounting that would be used by an accountant to solve the following problems. The credit department of ABC Ltd believes that the..
Compare and contrast the works of each artist : Compare and contrast the works of each artist and note some of the influences that can be seen in the work of the Impressionist artist.
Medical expenses for a nonresident alien : Guy makes $250,000 a year. He is paying out a year’s worth of income to may medical expenses for a nonresident alien. If he marries her in 2016 can he deduct expenses incurred and paid in 2016 prior to marriage? He would get her an ITIN and file a jo..
Spreadsheet pensions to prepare a pension worksheet : Use the spreadsheet Pensions to prepare a pension worksheet. On the pension worksheet, compute pension expense, pension asset/liability, projected benefit obligation, plan assets, prior service cost, and net gain or loss. Recall that settlement rate ..
Draw the equivalent circuit of the converter : ECE 534 Homework. For a converter shown in Fig 2, Vg = 50V, L= 5 mH, C = 20µF, R = 2?, D = 0.8, fsw = 200 kHz, Mosfet Rdson = 5m? and diode forward voltage drop Vd = 0.5V. Draw the equivalent circuit of the converter
Identify the strengths of the organization structure : Conduct a SWOT analysis for one of your company\'s competitors. (Remember that strengths and weaknesses are internal factors. Opportunities and threats are external factors).
Accumulate enough to liquidate the debt : What is the amount of the payments that Morgan Winslow must make at the end of each of 9 years to accumulate a fund of $81,600 by the end of the 9th year, if the fund earns 9% interest, compounded annually? Julia Ross has $19,700 to invest today at 1..
Analysis for network reconfiguration : EN3701 ASSIGNMENTS - Distribution systems are extensive and complex and so they are difficult to monitor, control, analyse and manage - Electricity distribution networks connect the high-voltage transmission system to users.

Reviews

Write a Review

Financial Accounting Questions & Answers

  What are the tax implications of the alternatives

Your client is offered a job which will last one year (ASSUME HE IS A PROFESSIONAL FOOTBALL PLAYER, AND VERY HIGHLY PAID), and is given two options for getting paid. What are the tax implications of the alternatives? What is your recommendation?

  Create a document for financial management and accounting

For this assignment the requirement is to create a document for financial management and accounting that uses generic data and examples that defines and analyzes the following terms, concepts, and principles in a business.

  How the following business transactions affect elements

Describe how the following business transactions affect the three elements of the accounting equation.

  Most associated with managerial accounting

Which of the following is most associated with managerial accounting? a) must follow GAAP b)may rely on estimates and forecast c) is prepared for users outside the organization d) always reports to the entire entity

  Three 3 personal trainers at an upscale health spa resort

three 3 personal trainers at an upscale health spa resort in sedona arizona want to start a health club that

  Portion of a definition

For each term in the first column, find the closest definition (or portion of a definition) in the second column. Each definition may be used only once or not at all. Definition (or Portion) A control established to remedy misstatements that are disc..

  Westpac chief admits banks failed in the bushthe rush by

westpac chief admits banks failed in the bushthe rush by banks to shut branches in rural areas over the past decade was

  Prepare chester inc journal entry to record

Prepare Chester, Inc.'s journal entry (or entries) to record its acquisition of Festus Corp. assuming that the separate incorporation of Festus is maintained.

  Question 1 in two to three paragraphs explain the

question 1. in two to three paragraphs explain the sarbanes-oxley act and why it is important to the accounting

  Which inventory price flow assumption could assign

In theory, when a periodic system is in use, which inventory price flow assumption could assign inventory cost to cost of goods sold even though the inventory has not yet been purchased by the merchandiser?

  What are us tax consequences of the branch activities

The Swiss franc had an average daily value of $0.50 during Year 1, $0.65 during Year 2, and was worth $0.60 at the end of Year 1, and $0.75 at the end of Year 2. What are US tax consequences of the branch’s activities in Year 1and Year 2?

  Total manufacturing overhead for the year

What is the budgeted total manufacturing overhead for the year

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