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.
- 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
Step: 1
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started