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

  Analyse the corporate culture at enron

Analyse the corporate culture at Enron and its management's behaviour. Include in your analysis, the normative theory of ethics which you would consider most relevant in driving the decision making at Enron.

  Can we say that manager has done good job in controlling

The total actual variable costs for the period were $72,000. Can we say that the plant manager has done a good job in controlling these costs if actual production was 80 percent of budgeted production

  Question jill accardo md maintains the accounting records

question jill accardo m.d. maintains the accounting records of accardo clinic on a cash basis. in 2007 dr. accardo

  Project to yield an acceptable return on investment

Smith Corporation produces bucket loader assemblies for the tractor industry. The product has a long-term life expectancy. Smith has decided to implement a JIT inventory system. Smith is deciding whether to use ABC Co. or XYZ Co. as the supplier. The..

  Compute gain-mickey must recognize as result of transaction

Mickey, Ray, and Debra decide to create UNA Corporation to manufacture and sell fireplaces. Mickey and Ray contribute the following assets to the corporation on January 1, 2016: Individual Property Adjusted Basis Fair Market Value Mickey Equipment $3..

  Prepare journal entries to record transactions

During the current month, a company that uses job order costing incurred a monthly factory payroll of $194,500. Of this amount, $50,000 is classified as indirect labor and the remainder as direct. Prepare journal entries to record these transactions.

  Report showing schools revenue and spending variances

Poljak Tech is a for-profit vocational school. The school bases its budgets on two measures of activity (i.e., cost drivers), namely student and course. The school uses the following data in its budgeting: Prepare a report showing the school's revenu..

  The fells point companys plant asset and accumulated

the fells point companys plant asset and accumulated depreciation accounts had the following balances on december 31

  Stuebe manufacturing produces and sells teddy bears

Stuebe Manufacturing produces and sells Teddy Bears for $6.50 each. A foreign retailer has offered to purchase 20,000 Teddy Bears for $4.00 per Teddy.

  Compute unrealized net gain on available-for-sale securities

JPMorgan Chase carries portfolios of both trading securities and available-for-sale securities. At the end of 2012 and 2011, the trading securities were valued at $450.0 billion, respectively; and the available-for-sale securities were valued at $371..

  Calculate the discount rate used by the lender

Calculate the discount rate used by the lender and calculate the effective interest rate (APR) on the loan and use the horizontal model (or write the journal entry) to show the effects

  How much overhead would be applied to production

Scottso Corporation applies overhead using a normal costing approach based upon machine-hours. Budgeted factory overhead was $286,500, budgeted machine-hours were 19,100. Actual factory overhead was $320,125, actual machine-hours were 19,700. How muc..

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