Question: 3. A partially completed pension spreadsheet showing the relationships among the elements that constitute Carney, Inc.s defined benefit pension plan follows. At the end of

3. A partially completed pension spreadsheet showing the relationships among the elements that constitute Carney, Inc.s defined benefit pension plan follows. At the end of 2018, Carney revised its pension formula and incurred a prior service cost of $100 million. At the end of 2019, the pension formula was amended again, creating an additional prior service cost of $200 million. At the beginning of 2020, $400 million prior service cost was incurred. At the beginning of 2021, $300 million prior service cost was incurred. In 2018 - 2021, the actuarys discount rate remained 10%, and the average remaining service life of the active employee group remained 10 years. The expected rate of return on assets was 10% in 2019, and increased by 1% each year.

  1. Fill in blanks in the 2020 pension spreadsheet.

2020 Pension spreadsheet ($ in millions)

(PBO)

Plan Assets

Prior Service CostAOCI

Net Loss (Gain) AOCI

Pension Expense

Cash

Net Pension (Liability) / Asset

Balance, Jan. 1, 2020

1,900

Service cost

(900)

Interest cost

Prior Service Cost

(400)

Expected return on assets

2,470

(2,470)

Adjust for: Gain (loss) on assets

449

Amortization of: "Prior service cost-AOCI"

Amortization of: "Net Loss (Gain)-AOCI"

Gain (Loss) on PBO

(400)

Cash funding

1,200

Retiree benefits

1,100

Bal., Dec. 31, 2020

2,224

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!