Question

In: Accounting

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 million. The expected rate of return on assets and the actuary’s discount rate were 10%, and the average remaining service life of the active employee group is 10 years.

Required:

1. Fill in the missing amounts.
2. to 4. Prepare all the necessary journal entries for 2018            

Fill in the missing amounts. (Enter your answers in millions (i.e., 10,000,000 should be entered as 10). Enter credit amounts with a minus sign and debit amounts with a positive sign.)

( )s indicate credits; debits otherwise
($ in millions) PBO Plan Assets Prior Service Cost–AOCI Net Loss-AOCI Pension Expense Cash Net Pension (Liability) / Asset
Balance, Jan. 1, 2018 (970) 870 25 107 (100)
Service cost 98
Interest cost
Expected return on assets
Adjust for:
Loss on assets (6)
Amortization of:
Prior service cost
Net loss
Loss on PBO (27)
Prior service cost
Cash funding 92
Retiree benefits
Bal., Dec. 31, 2018 (970) 805 25 107 98 (35)

                                                                                                                                                                                                    

Prepare all the necessary journal entries for 2018. (If no entry is required for a transaction/event, select "No journal entry required" in the first account field. Enter your answers in millions (i.e., 10,000,000 should be entered as 10).)

Journal entry worksheet

Transaction Index :

Record pension expense.

Record any 2018 gains and losses.

Record new prior service cost in 2018.

Record the cash contribution to plan assets.

Record payment of retiree benefits.

Note: Enter debits before credits.

Event General Journal Debit Credit
1

+

Solutions

Expert Solution

$ in millions PBO Plan Assets Prior Service Cost - AOCI Net Loss - AOCI Pension Expenses Cash Net pension (liability) / Asset
Balance, Jan 1, 2018 -$970 $870 $25 $107 -$100
Service Cost -$98 $98 -$98
InterestCost -$97 $97 -$97
Expensted return on assets $87 -$87 $87
Adjust for:
Loss on assets -$6 $6 -$6
Amortization of:
Prior Service cost -$6 $6
Net Loss -$1 -$1
loss on PBO -$27 27 -$27
Prior Service cost -$40 $40 -$40
Cash Funding $116 -$116 $116
Retiree benefits $262 -$262
Balance, Dec 31, 2018 -$970 $805 $59 $139 $113 -$116 -$165
Corridor Amortization $1 ($107-$970*10%)/10
event General journal debit Credit
1 record pension expense
Pension expenses $115
Plan Asset $87
To PBO $195
To Net loss - AOCI $1
To Prior service cost - AOCI $6
(Being Pension expense recorded)
2 record gain/losses
Net Loss - AOCI $33
To Plan Assets $6
To PBO $27
(Being loss recorded)
3 Record new prior service cost
Prior service cost - AOCI $40
To PBO $40
(Being prior service cost recorded)
4 Record cash contribution
Paln asset $116
to cash $116
(being cash contribution recordeed)
5 record payment to retiree
PBO $262
To olan assets $262
(Being payment to retiree recorded)

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...
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...
. 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...
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 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