Description
Complete the following questions. In addition to answering the items below, you must submit an analysis of the assignment. Analyze the specific outcomes and write an analysis directed toward the team at Melanie Vail Corp. describing what the numbers mean and how they relate to the business. Submit journal entries in an Excel file and written segments in an MS Word document. For written answers, please make sure your responses are well-written, formatted per CSU-Global Guide to Writing and APA and have proper citations, if applicable.
Melanie Vail Corp. sponsors a defined benefit pension plan for its employees. On January 1, 2017, the following balances relate to this plan.
Plan assets | $480,000 |
Projected benefit obligation | 625,000 |
Accumulated OCI (PSC) | 100,000 Dr. |
Accumulated OCI (Gain/Loss) | 85,000 Cr. |
As a result of the operation of the plan during 2017, the following additional data are provided by the actuary:
Service cost for 2017 | $90,000 |
Settlement rate | 9% |
Actual return on plan assets in 2017 | 57,000 |
Expected return on plan assets | 10% |
Unexpected loss from change in projected benefit obligation, due to change in actuarial predictions | 76,000 |
Contributions in 2017 | 99,000 |
Benefits paid retirees in 2017 | 85,000 |
Avg. remaining service life (all employees) | 12 years |
Click the link below to download an Excel workbook containing the spreadsheets you will need for this exercise.
- 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.
- Prepare the journal entry using the spreadsheet Journal Entries to record pension expense in 2017.
- Indicate the reporting of the 2017 pension amounts in the income statement and balance sheet using the spreadsheet Pensions.
- What is the amount of deferred pension gain or loss that the company will carry forward to 2018?
- Compute the same items as in (#1), assuming that the expected rate of return is 14% and the Accumulated OCI (Gain/Loss) is a Debit balance at January 1, 2017.
Unformatted Attachment Preview
Purchase answer to see full attachment
Explanation & Answer
Hey buddy!Attached is the complete assignment.Please have a look at it and feel free to seek any further clarification. If
there's no further work to be done. I'd really appreciate if you could
leave a 5 star⭐ ⭐ ⭐ ⭐ ⭐ feedback for me on Studypool. This would be so helpful in
me securing further work and continue to tutor.Thanks. 😉I'm very sorry for the late submission.
Journal Entry: Pension
Name
Instructor
Course Title
Date
Option #1: Journal Entry: Pension
A pension plan is an agreement where an organization provides benefits to its workers
after they retire for services they offered (Kieso, Weygandt, & Warfield, 2016). As required by
GAAP, a pension program has its accounts, separate from the organization's accounts. As noted
by Bragg (2018), accounting for pensions can be quite complicated especially regarding defined
benefit plans. In this type of program, employees receive a pre-determined periodic payment
from their employees after retirement.
From Melanie Vail Corporation’s pension plan, two key things can be noted;
•
Pension expense refers to the cost that is related to pension plans and is recorded on the
company’s income reports (Weygandt, Kieso & Kimmel, 2013). For Melanie, the pension
expense is slightly high when the expected retur...