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

  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