3. A partially completed pension spreadsheet showing the relationships among the elements that constitute Carney, Inc.’s defined...

60.1K

Verified Solution

Question

Accounting

3. A partially completed pension spreadsheet showing therelationships among the elements that constitute Carney, Inc.’sdefined benefit pension plan follows. At theend of 2018, Carney revised its pensionformula and incurred a prior service cost of $100 million. At theend of 2019, the pension formula wasamended again, creating an additional prior service cost of $200million. At the beginning of 2020, $400million prior service cost was incurred. At thebeginning of 2021, $300 million priorservice cost was incurred. In 2018 - 2021, the actuary’s discountrate remained 10%, and the average remaining service life of theactive employee group remained 10 years. The expected rate ofreturn on assets was 10% in 2019, and increased by 1% eachyear.

  1. Fill in blanks in the 2021 pension spreadsheet.

2021 Pension spreadsheet ($ in millions)

(PBO)

Plan Assets

Prior Service Cost–AOCI

Net Loss (Gain) –AOCI

Pension Expense

Cash

Net Pension (Liability) / Asset

Balance, Jan. 1, 2021

2,224

Service cost

(1,095)

Interest cost

Prior Service Cost

Expected return on assets

Adjust for: Gain (loss) on assets

Amortization of: "Prior service cost-AOCI"

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

Gain (Loss) on PBO

Cash funding

1,300

Retiree benefits

1,200

(1,200)

Bal., Dec. 31, 2021

442

3,176

2020 Spreadsheet

2020 Pension spreadsheet ($ in millions)(PBO)Plan AssetsPrior Service Cost–AOCINet Loss (Gain) –AOCIPension ExpenseCashNet Pension (Liability) / Asset
Balance, Jan. 1, 2020-2055022450290-31001,900
Service cost-900900-900
Interest cost-20952095-2095
Prior Service Cost-400400-400
Expected return on assets2,470-2,4702,470
Adjust for: Gain (loss) on assets449-449449
Amortization of: "Prior service cost-AOCI"-2929
Amortization of: "Net Loss (Gain)-AOCI"-105105
Gain (Loss) on PBO-400400-400
Cash funding1200-1,2001,200
Retiree benefits1,100-1100
Bal., Dec. 31, 2020-2324525469661-32546592,224

Answer & Explanation Solved by verified expert
4.0 Ratings (451 Votes)
    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students