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

  Computer village sells computer equipment

Determine whether Computer Villages should discontinue the furniture line and the financial benefit (cost) of dropping it.

  Determine the capitalized cost of the equipment

Determine the capitalized cost of the equipment - Mad Hatter Enterprises purchased new equipment for $365,000, FOB shipping point

  Determine a newspaper or magazine even online and select an

determine a newspaper or magazine even online and select an article relating to the use of governmental funds by state

  Compute the project profitability index

Compute the project profitability index for each proposal and rank the proposals in terms of preference.

  Evaluate the distribution of the proceeds

The liquidation value for the total assets is $4 million, $1.2 million of which was received for plant and equipment. Bankruptcy costs were $150,000. Determine the distribution of the proceeds.

  Abc wines company is considering the acquisition of a new

abc wines company is considering the acquisition of a new irrigation system for its extensive vineyards. the system

  You are an accountant for the flower shoppe your supervisor

you are an accountant for the flower shoppe. your supervisor has asked you to help her prepare the year-end financial

  Write an explanatory essay on capital the essay should not

write an explanatory essay on capital. the essay should not exceed two typed pages. be sure to follow an essay format

  Part-11 assume that the managers of fort winston hospital

part-11 assume that the managers of fort winston hospital are setting the price on a new outpatient service. here are

  Compute service revenue and operating expenses

Compute service revenue and operating expenses - Side Kicks has year-end account balances of Sales Revenue $808,900; Interest Revenue $13,500;

  Compute the total unit cost for the national retailer order

Compute the unit cost for each department. Compute the total unit cost for the national retailer order. Compute the prime costs and conversion costs per unit for each department.

  How much would net income before taxes in 2012 be different

depreciation method had on net income for 2012 compared to the straight-line method. By how much would net income before taxes in 2012 be different if the straight-line method had been used for the entire time?

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