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.)
|
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) |
ekkarill92 answered 2 years agoRelated 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
Latest Questions
- which one is more nucleophilic: hydroxide ion (OH) , or ammonia (NH3)? Explain why
- A sample mixture of ethyl benzoate (bp 212 C) and dodecane (bp 216.2 C) is injected...
- Consider the markets for fossil fuels (oil, coal, natural gas) and alternative energy sources (solar, wind,...
- Which notion from below best explains people's decision-making process from an economic perspective? People's behavior reflects...
- 1)The histone proteins of nucelosomes are often abnormally modified in cancer cells, leading to _____. a....
- The files provided contain syntax and/or logic errors. In each case, determine and fix the problem,...
- I need an analysis and a complete description of the physics of the mass and magnet...
ADVERTISEMENT