Question

In: Accounting

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

Required:
Fill in the missing amounts. (Enter credit amounts with a minus sign and debit amounts with a positive sign.)

Prior Net Pension
Plan Service Net Loss Pension (Liability)
($ in 000s) PBO Assets Cost – AOCI – AOCI Expense Cash / Asset
Balance, Jan. 1, 2018 $(620) $480 $171 $62 $(140)
Service cost 94
Interest cost, 5% (31)
Expected return on assets (39)
Adjust for:
Loss on assets 11
Amortization:
Prior service cost
Amortization:
Net loss
Gain on PBO 18
Prior service cost
Cash funding (78)
Retiree benefits
Balance, Dec. 31, 2018 $(677) $480 $162 $73 $55 $(122)

Solutions

Expert Solution

Answer:
Prior Net Pension
Plan Service Net Loss Pension (Liability)
($ in 000s) PBO Assets Cost – AOCI – AOCI Expense Cash / Asset
Balance, Jan. 1, 2018 ($620) $480 $171 $62 ($140)
Service cost -94 94 -94 (0-94)
Interest cost, 5% -31 31 -31 (0-31)
Expected return on assets 39 -39 39 (39-0)
Adjust for: 0
Loss on assets -11 11 -11 (0-11)
Amortization: 0
Prior service cost -9 9 0
Amortization: 0
Net loss 0
Gain on PBO 18 18 (18-0)
Prior service cost 0
Cash funding 78 -78 78 (78-0)
Retiree benefits 50 -50 0
Balance, Dec. 31, 2018 ($677) $536 $162 $73 $95 ($141)
Note:
1 Retiree benefit =(-620-94-31+18)-(-677) $                   (50)
2 Prior Service Cost Amortization =$171-162 $                        9
3 Pension Expense =94+31-39+9 $                     95
4 Plan Asset -Balance, Dec 31, 2018 =$480+39-11+78-50 $                   536
5 Net pension asset/liabilities =-140-94-31+39-11+18+78 $                 (141)

Related Solutions

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...
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 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...
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...
Please answer the following questions about defined benefit pension plans: a. Companies with defined benefit pension...
Please answer the following questions about defined benefit pension plans: a. Companies with defined benefit pension plans must recognize pension expenses each period. What are the five components of pension expense? Briefly describe each component. b. How does each component of pension expense affect pension expense during the period (increase, decrease, or uncertain)? c. What is the difference between the accumulated pension obligation and the projected pension obligation? d. What determines whether a pension plan is underfunded or overfunded
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT