Question

In: Accounting

Ms. Brown apparently wasn't up on pension accounting because the plan file contains only the following...

Ms. Brown apparently wasn't up on pension accounting because the plan file contains only the following note: Remember to tell boss that I need help with accounting for these things! -C.B.

It takes a couple of days to assemble the information you need, but you finally get it all together and summarize it as follows:

Pension Plan

2014

2015

Projected Benefit Obligation

65,000

Plan Assets (fair value), January 1

41,000

Pension asset/liability January 1 (credit)

24,000

Prior service cost, January 1

16,000

Service cost

4,000

5,900

Settlement rate

10%

10%

Expected rate of return

10%

10%

Actual return on plan assets

3,600

6,100

Amortization of prior service cost

7,000

5,500

Annual contributions

7,200

8,100

Benefits paid to retirees

3,150

5,400

Increase in pension benefit obligations due to actuarial assumptions

8,700

0

Accumulated benefit obligations at December 31

72,180

78,900

Average service life of all employees

20 years

Vested benefit obligation—December 31

46,400


Tasks:

  • Prepare a pension worksheet using Microsoft Excel for both years 2014 and 2015 and the necessary computations and amortization of the loss (2015), using the corridor approach.
  • Prepare in the same worksheet the journal entries to reflect all pension plan transactions and events at December 31 of each year.
  • For 2015, indicate (in the same worksheet) the pension amounts to be reported in the financial statements.
  • Explain alternative measures for valuing the pension obligation. What would you advise for Panache?

Solutions

Expert Solution


Related Solutions

The following information relates to the defined benefit pension plan of the Kraemerica Company. Only a...
The following information relates to the defined benefit pension plan of the Kraemerica Company. Only a single employee is covered by the plan. That employee has worked for Kraemerica since 1-1-2014 and she has earned pension benefits since 1-1-2014. Additional informa­tion is provided below.                   1)   Benefit formula: Upon retirement and upon reaching age 65, the employee will receive a pension payment annually (payments to be made as long as employee lives).                          The first check will be issued one...
The following information relates to the defined benefit pension plan of the Kraemerica Company. Only a...
The following information relates to the defined benefit pension plan of the Kraemerica Company. Only a single employee is covered by the plan. That employee has worked for Kraemerica since 1-1-2014 and she has earned pension benefits since 1-1-2014. Additional informa­tion is provided below.                   1)   Benefit formula: Upon retirement and upon reaching age 65, the employee will receive a pension payment annually (payments to be made as long as employee lives).                          The first check will be issued one...
Question 2. Go to the Blackboard and download the MS excel file, ‘stock_return.xlsx’. It contains a...
Question 2. Go to the Blackboard and download the MS excel file, ‘stock_return.xlsx’. It contains a year of monthly stock price data of Amazon, Pfizer, and S&P 500 (Market Index). Using the data, answer the following questions. (50 points) (1) Compute the monthly return of Amazon and Pfizer. You should get 12 monthly returns for each. To get a monthly return, you need to use previous month’s stock price. For example, Amazon’s stock return of 2018-01 will be [(Stock price...
You are asked to review the file of Ms. Jane Foley, the niece and only surviving...
You are asked to review the file of Ms. Jane Foley, the niece and only surviving heir of the late Ron Foley. Mr. Foley had a $1,000,000 life insurance policy that named his former business partner William Hill as the beneficiary. Ms. Foley believes that Mr. Hills has no right to collect from any insurance policy of her late uncle and she should get the proceeds. Write an interoffice memo
You are asked to review the file of Ms. Jane Foley, the niece and only surviving...
You are asked to review the file of Ms. Jane Foley, the niece and only surviving heir of the late Ron Foley. Mr. Foley had a $1,000,000 life insurance policy that named his former business partner William Hill as the beneficiary. Ms. Foley believes that Mr. Hills has no right to collect from any insurance policy of her late uncle and she should get the proceeds. Write an interoffice memo
1. A bowl contains 9 M&Ms identical in every respect except color. There are 6 brown...
1. A bowl contains 9 M&Ms identical in every respect except color. There are 6 brown M&Ms, 1 blue M&M, and 2 yellow M&Ms. You draw one M&M from the bowl, note its color, and then eat it before drawing the second M&M and noting its color. . A. Find the probability of drawing two M&Ms and getting at least one brown M&M. B. Find the probability of drawing two M&Ms and getting two M&Ms of different colors.
1. A bowl contains 9 M&Ms identical in every respect except color. There are 6 brown...
1. A bowl contains 9 M&Ms identical in every respect except color. There are 6 brown M&Ms, 1 blue M&M, and 2 yellow M&Ms. You draw one M&M from the bowl, note its color, and then eat it before drawing the second M&M and noting its color. . A. Find the probability of drawing two M&Ms and getting at least one brown M&M. B. Find the probability of drawing two M&Ms and getting two M&Ms of different colors.
If the file circuit.txt contains the following data
Exercise 2: If the file circuit.txt contains the following data 3.0             2.1 1.5             1.1 2.6             4.1 The first column is voltage and the second column is the electric current. Write program that reads the voltages and currents then calculates the electric power (P) based on the equation: Voltage     Current        Power 3.0             2.1              (result) 1.5             1.1              (result) 2.6             4.1              (result)                         P = v * i Write your output to the file results.txt with voltage in the first, current in the second...
How does the IFRS criteria for accounting for a pension plan curtailment differ from the U.S....
How does the IFRS criteria for accounting for a pension plan curtailment differ from the U.S. GAAP criteria?
How to count the number of words that only show up once in a text file,...
How to count the number of words that only show up once in a text file, and replace those words with a character '(unique)' using Python? Without list is better.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT