Reference no: EM131191349
Melanie Vail Corp. sponsors a defined benefit pension plan for its employees. On January 1, 2015, the following balances relate to this plan.
Plan assets
|
$480,000
|
Projected benefit obligation
|
625,000
|
Accumulated OCI (PSC)
|
100,000
|
As a result of the operation of the plan during 2015, the following additional data are provided by the actuary.
Service cost for 2015
|
$90,000
|
Settlement rate
|
9%
|
Actual return on plan assets in 2015
|
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 2015
|
99,000
|
Benefits paid retirees in 2015
|
85,000
|
Download the Excel Template linked at the bottom of this page, 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 2015. You need to prepare journal entries for only #1 above.
4. Indicate the reporting of the 2015 pension amounts in the income statement and balance sheet using the spreadsheet Pensions. You need to show financial statements' presentations for only #1 above.
Attachment:- Excel_Template.xlsx
Multiple benefits that loyal customers
: Create a report that describes and critically analyzes at least 5 contemporary best practices to improve customer loyalty in a healthcare organization
|
Analyzes how pathos is used to connect to its audience
: Study the picture and Write a short essay that analyzes how pathos is used to connect to its audience (How would an audience respond emotionally?
|
Transport problems in the south pacific
: Argue the merit of introducing low cost carriers and discuss how an open skies policy can address transport problems in the South Pacific?
|
Professor critique and coments
: Post your initial final project here for professor's critique and coments. Project name is Shangri La Hotel in Ulaanbaatar?
|
Prepare journal entry using the spreadsheet journal entries
: Prepare the journal entry using the spreadsheet Journal Entries to record pension expense in 2015. You need to prepare journal entries for only #1 above.
|
Creating an outline of your lecture notes
: For this assignment you will be (1) creating an outline of your lecture notes and (2) a narrative description of your lecture presentation. The lecture outline must include the following information: Graphic representation and Procedural directions
|
Analyze your communication behaviors and patterns
: The following outline presents a method for making such a communication change. In short: First, analyze your communication behaviors and patterns. Second, identify a specific communication behavior or pattern that you feel you need to change or impr..
|
Determining the four phase cycle
: In Thriving Chapter 5, the idea of the "four phase cycle" of organizations is introduced. How does the idea of "complex thinking" (and strategy) relate to the four phases that organizations go through?
|
Developing your global know how
: Find the article : "Developing Your Global Know How" and read the article. (Link to the article : https://hbr.org/2011/03/developing-your-global-know-how)
|