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

Required:
Fill in the missing amounts. (Enter your answers in thousands rounded to 1 decimal place.)

Prior Net Pension
Plan Service Net Loss Pension (Liability)
($ in thousands) PBO Assets Cost – AOCI – AOCI Expense Cash / Asset
Balance, Jan. 1, 2021 $(700.0) $400.0 $95.0 $70.0 $(300.0)
Service cost 86.0
Interest cost, 5% (35.0)
Expected return on assets (32.0)
Adjust for:
Loss on assets 7.0
Amortization:
Prior service cost
Amortization:
Net loss
Gain on PBO 10.0
Prior service cost
Cash funding (70.0)
Retiree benefits
Balance, Dec. 31, 2021 $(761.0) $400.0 $90.0 $77.0 $54.0 $(290.0)

Solutions

Expert Solution

Prior Net pension
Plan service Net Pension (Liability) /
($ in thousands) PBO Assets Cost - AOCI Loss - AOCI Expense Cash Assets
Balance, Jan. 1, 2021 -$700.0 $400.0 $95.0 $70.0 $0.0 $0.0 -$300.0
Service cost -$86.0 $86.0 -$86.0
Interest cost, 5% -$35.0 $35.0 -$35.0
Expected return on assets $32.0 -$32.0 $32.0
Adjust for:
Loss on Assets -$7.0 $7.0 -$7.0
Amortization
Prior service cost -$5.0 $5.0
Amortization
Net loss $0.0 $0.0
Gain on PBO $10.0 -$10.0 $10.0
Prior service cost $0.0 $0.0 $0.0
Cash funding $70.0 -$70.0 $70.0
Retiree benefits $50.0 -$50.0
Balance., Dec. 31, 2021 -$761.0 $445.0 $90.0 $67.0 $94.0 -$70.0 -$316.0
Workings :
Computation of net loss amortization :
Net loss–AOCI $             70
10% of $700 PBO (greater than $400 Plan assets) $             70
Amount to be amortized $             -  

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