Reference no: EM132463574
Analyze the specific outcomes and put together an analysis directed toward the team at Scottsdale Corp. describing what the numbers mean and how they relate to the business. Enter journal entries in an Excel file. 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
Question 1: Use a spreadsheet to enter a pension worksheet. On a pension worksheet, compute pension expense, pension asset/liability, projected benefit obligation, plan assets, prior service cost, and net gain or loss.
Question 2: Enter the journal entry using a spreadsheet to record pension expense in 2017.
Question 3: Indicate the reporting of the 2017 pension amounts in the income statement and balance sheet using a spreadsheet.
Question 4: What is the amount of deferred pension gain or loss that the company will carry forward to 2018?
Question 5: Compute the same items , assuming that the expected rate of return is 14% and the Accumulated OCI (Gain/Loss) is a Debit balance at January 1, 2017.
|
Why depreciation recorded on company accounting record
: If real estate values are appreciating. respond to the owner explaining why depreciation must be recorded on the company's accounting records
|
|
Define patient safety program areas nurse manager consider
: Chapter 14, Medical Errors: An Ongoing Threat to Quality Health Care, A nurse manager is reviewing occurrence reports of medical errors over the last six month.
|
|
What degree do the US government and private banks
: To what degree do the U.S. government and private banks have a material interest in providing mortgages as a means of encouraging home ownership?
|
|
How would your communication and interview techniques differ
: With the information presented in Chapter 1 of Ball et al. in mind, consider the following: How would your communication and interview techniques for building.
|
|
What is the amount of deferred pension gain or loss
: Compute the same items , assuming that the expected rate of return is 14% and the Accumulated OCI (Gain/Loss) is a Debit balance at January 1, 2017.
|
|
Prepare a Marketing Plan Thor Electric UPS Truck
: Marketing Plan Assignment - Prepare a Marketing Plan Thor Electric UPS Truck. Your assessment should be an application of relevant marketing concepts
|
|
Probability that we get at least two socks of same color
: We reach into the drawer without looking to pull out four socks. What is the probability that we get at least two socks of the same color?
|
|
What is the probability that it rains all three days
: You are planning a camping trip for a few weeks away. currently, the weather forecast for the three days of your trip gives 20% chance of rain on each day.
|
|
Evaluating the proposed nursing intervention
: Develop a 1000-1250 written project that includes the following information as it applies to the problem, issue, suggestion, initiative, or educational need.
|