Question

In: Accounting

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

. 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 actuary’s 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 2019 pension spreadsheet.

2019 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, 2019

(25,000)

20,000

100

4,500

(5,000)

Service cost

(800)

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

7000

Cash funding

(1,000)

Retiree benefits

950

Bal., Dec. 31, 2019

22,450

290

(3,100)

1,510

Solutions

Expert Solution


Related Solutions

A partially completed pension spreadsheet showing the relationships among the elements that constitute Carney, Inc.’s defined
A partially completed pension spreadsheet showing the relationships among the elements that constitute Carney, Inc.’s defined benefit pension plan follows. Six years earlier, Carney revised its pension formula and recalculated benefits earned by employees in prior years using the more generous formula. The prior service cost created by the recalculation is being amortized at the rate of $5 million per year. At the end of 2021, the pension formula was amended again, creating an additional prior service cost of $40...
A partially completed pension spreadsheet showing the relationships among the elements that constitute Carney, Inc.’s defined...
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...
A partially completed pension spreadsheet showing the relationships among the elements that constitute Carney, Inc.’s defined...
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...
3. A partially completed pension spreadsheet showing the relationships among the elements that constitute Carney, Inc.’s...
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...
A partially completed pension spreadsheet showing the relationships among the elements that constitute Carney, Inc.’s defined...
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...
A partially completed pension spreadsheet showing the relationships among the elements that constitute Carney, Inc., defined...
A partially completed pension spreadsheet showing the relationships among the elements that constitute Carney, Inc., defined benefit pension plan follows. Six years earlier, Carney revised its pension formula and recalculated benefits earned by employees in prior years using the more generous formula. The prior service cost created by the recalculation is being amortized at the rate of $6 million per year. At the end of 2018, the pension formula was amended again, creating an additional prior service cost of $40...
A partially completed pension spreadsheet showing the relationships among the elements that comprise the defined benefit...
A partially completed pension spreadsheet showing the relationships among the elements that comprise the defined benefit pension plan of Universal Products is given below. The actuary's discount rate is 5%. At the end of 2016, the pension formula was amended, creating a prior service cost of $180,000. The expected rate of return on assets was 8%, and the average remaining service life of the active employee group is 20 years in the current year as well as the previous two...
A partially completed pension spreadsheet showing the relationships among the elements that comprise the defined benefit...
A partially completed pension spreadsheet showing the relationships among the elements that comprise the defined benefit pension plan of Universal Products is given below. The actuary's discount rate is 5%. At the end of 2019, the pension formula was amended, creating a prior service cost of $100,000. The expected rate of return on assets was 8%, and the average remaining service life of the active employee group is 20 years in the current year as well as the previous two...
Partially Completed Spreadsheet The following partially completed spreadsheet has been prepared for Perrin Company's 2016 statement...
Partially Completed Spreadsheet The following partially completed spreadsheet has been prepared for Perrin Company's 2016 statement of cash flows: Balances Change Worksheet Entries Account Titles 12/31/15 12/31/16 Increase (Decrease) Debit Credit Debits Cash 800 1,540 Noncash Accounts: Accounts Receivable 1,500 2,180 Inventory 3,100 6,055 Investments in Stock — 2,800 Land 6,000 9,200 Buildings 20,000 20,000 Office Equipment 4,000 6,100 Delivery Equipment 3,000 5,900 Treasury Stock — 2,000 Totals 38,400 55,775 ? Credits Accumulated Depreciation 7,000 8,500 Accounts Payable 3,300 3,695...
Use the spreadsheet and partially completed Income Summary Account shown. Balloons and Baubbles End-of-Period Spreadsheet For...
Use the spreadsheet and partially completed Income Summary Account shown. Balloons and Baubbles End-of-Period Spreadsheet For the Year Ended December 31, 20-1 1 ACCOUNT TITLE TRIAL BALANCE DEBIT TRIAL BALANCE CREDIT ADJUSTMENTS DEBIT ADJUSTMENTS CREDIT ADJUSTED TRIAL BALANCE DEBIT ADJUSTED TRIAL BALANCE CREDIT 2 Cash 18,000.00 18,000.00 3 Accounts Receivable 12,600.00 12,600.00 4 Merchandise Inventory 67,500.00 (b) 76,500.00 (a) 67,500.00 76,500.00 5 Estimated Returns Inventory 2,880.00 (e) 3,870.00 (d) 2,880.00 3,870.00 6 Supplies 7,200.00 (f) 4,230.00 2,970.00 7 Prepaid Insurance...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT