Prepare the journal entry using the spreadsheet

Assignment Help Cost Accounting
Reference no: EM13870923

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
Click here to download an Excel workbook containing the spreadsheets you will need for this exercise.

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: EM13870923

Questions Cloud

The company uses the effective interest method : On November 1, 2009, the Reid Corporation acquired bonds with a face value of $700,000 for $673,618.61.
Describe the electronic submission process : Describe the electronic submission process and the security measures present in this approach. Analyze the advantages over classic paper solicitations
The bonds pay interest semiannually : On January 1, 2010, Rodgers Company purchased $200,000 face value, 10%, three year bonds for $190,165.35, a price that yields a 12% effective annual interest rate. The bonds pay interest semiannually on June 30 and December 31.
Compute the value of the utility function at bundle a : Compute the value of the utility function at bundle A, where x = 10 and y = 1. Show your work. Working with bundle A, find the MRS as x rises from x = 10 to x = 20. Show your work.
Prepare the journal entry using the spreadsheet : Prepare the journal entry using the spreadsheet Journal Entries to record
Effective in neurological problems : About half of all pharmaceuticals, including many effective in neurological problems, are derived originally from plants. Find information and provide your informed explanation why the giant red toadstool, the fly amanita orAmanita muscaria, and the ..
Explain under what condition the mrs equals the price ratio : Explain under what condition the MRS equals the price ratio rule (as a condition that the optimal solution has been found) can be violated.
What is hrm role in improving employee satisfaction : What is HRM's role in ensuring or improving employee satisfaction in your organization or one with which you are familiar? What are some specific examples of HR activities aimed at this goal
Why monte carlo simulation was unable to exactly replicate : Explain why the Monte Carlo simulation was unable to exactly replicate the per- centage of times the lowest priced station was found.

Reviews

Write a Review

Cost Accounting Questions & Answers

  Cost accounting assignment

Evaluate Method of measuring costs associated with production, budgeting process, normal job-order costing system , master budget, cycle time.

  Prepare the journal entries

Prepare the journal entries to record the bond issue and interest expense.

  Advise as to the liability of all the parties

Write a report on given case study and Advise as to the liability of ALL the parties both under common law and the Corporations Law.

  Prepare revenues budget

Prepare Revenues budget and Production budget in units

  Effect of exchange rate changes on cash and cash

Effect of exchange rate changes on cash and cash

  Corporate governance

You are to reflect on how this case of China Sky relates to what the arguments for and against allowing audit firm partners and/or employees to join audit committees.

  Cost-benefit analysis

A cost-benefit analysis of electronic medical records in primary care

  Non-annual interest rates and annuities

Theory of Interest- Non-annual interest rates and annuities

  Job costing in service organizations

How is job costing in service organizations different from job costing in manufacturing environments?

  Accounting for bad debt expense

Accounting for bad debt expense

  Accounting and partnership problems

Accounting and Partnership problems

  Development of relevant cash flows

Development of relevant cash flows - Cost estimating and financial analysis

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