Journal Entry: Pension Accounting for Pensions and Postretirement Benefits, accounting homework help

Respond to the following. Submit journal entries in an Excel
Template, linked at the bottom of this page. Any written segments should
be included in Excel’s comments function. Do not submit two separate
documents, as only one document can be accepted. For written answers,
make sure your responses are well written, formatted per APA REQUIRMENTS 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.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.Compute the same items as in (#1), assuming that the settlement rate is now 7% and the expected rate of return is 10%.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.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.
journal_entry_pension_exceltemplate.xlsx

Unformatted Attachment Preview

General Journal Entries
Items
Balance, Jan. 1, 2015
Service cost
Interest cost
Actual Return
Expected Return
Amortization of PSC
Contributions
Benefits
Liability increase
Journal entry for 2015
Accumulated OCI, Dec. 31, 2014
Balance, Dec. 31, 2015
Annual
Pension
Expense
Cash
OCI—Prior
Service Cost
OCI—
Gain/Loss
Pension
Asset/Liability
Memo Record
Projected
Benefit
Obligation
Plan assets
Prepare the journal entries to record the following.
Date
Account Title
Account Title
Amount
Amount
Provide a one line explanation for the reason why the journal entry has been made.
Date
Account Title
Account Title
Amount
Amount
Provide a one line explanation for the reason why the journal entry has been made.
Date
Account Title
Account Title
Amount
Amount
Provide a one line explanation for the reason why the journal entry has been made.
Date
Account Title
Account Title
Amount
Amount
Provide a one line explanation for the reason why the journal entry has been made.
Date
Account Title
Account Title
Amount
Amount
Provide a one line explanation for the reason why the journal entry has been made.
Date
Account Title
Account Title
Amount
Amount
Provide a one line explanation for the reason why the journal entry has been made.
…
Purchase answer to see full
attachment