Create journal entry using the spreadsheet journal entries

Assignment Help Financial Accounting
Reference no: EM131265102

Melanie Vail Corp. sponsors a defined benefit pension plan for its employees. On January 1, 2012, the following balances relate to this plan. Plan assets $480,000 Projected benefit obligation 625,000 Accumulated OCI (PSC) 100,000 Dr.

• As a result of the operation of the plan during 2012, the following additional data are provided by the actuary. Service cost for 2012 $90,000 Settlement rate 9% Actual return on plan assets in 2012 57,000 Amortization of prior service cost 19,000 Expected return on plan assets 52,000 Unexpected loss from change in projected benefit obligation, due to change in actuarial predictions 76,000 Contributions in 2012 99,000 Benefits paid retirees in 2012 85,000.

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.

2. Compute the same items as in (1), assuming that the settlement rate is now 7% and the expected rate of return is 10%.

3. Prepare the journal entry using the spreadsheet Journal Entries to record pension expense in 2012.

4. Indicate the reporting of the 2012 pension amounts in the income statement and balance sheet using the spreadsheet Pensions.

Reference no: EM131265102

Questions Cloud

What was the stock price in the years preceding its failure : What was the stock price in the years preceding its failure, merger or acquisition? What was the stock price after, if it still existed? (You may find this information on Yahoo Finance.com)
Advantages of conveying a realistic recruitment message : What are the advantages of conveying a realistic recruitment message as opposed to portraying the job in a way that the organization thinks that the job applicants want to hear?
Compute the price of the call using the monte carlo method : Find (approximately) the variance of the random variable whose expectation you are trying to evaluate, and give a confidence interval for the desired quantity
Revise the given email and memo openers : Revise the following e-mail and memo openers so that they are more direct. - A memo announcing a new procedure.
Create journal entry using the spreadsheet journal entries : Prepare the journal entry using the spreadsheet Journal Entries to record pension expense in 2012. Indicate the reporting of the 2012 pension amounts in the income statement and balance sheet using the spreadsheet Pensions.
Application of management functions : Scenario: You are employed by a 240-bed urban medical center. You directly supervise 30 staff Physical Therapists in the Rehabilitation Department in which you are the Department Head (DH).
Process of ethical decision making : a) What are the dimensions of the ethical dilemma? b) What are the issues?
Statement of changes in stockholders equity-balance sheet : In 2014, Pacilio Security Services decided to expand its business to sell security systems and offer 24-hour alarm monitoring services. It plans to phase out its current service of providing security personnel at various events.  Prepare a trial bala..
What are apple key advantages : What are the key differences that set it apart from competitors? What are Apple's key advantages in how it manages its supply chain operations (support analysis with data from the case)

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