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 1 year 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
- Describe a time when someone did not really listen to or understand a point you were...
- Enumerations Create an advanced enumeration to represent months (JANUARY – DECEMBER) called enuMonths Add internal properties...
- What is the minimum size of the automorphism group of a simple directed graph having more...
- The birthday paradox says that the probability (chance) that two people in a room will have...
- #include <iostream> #include "lib.hpp" using namespace std; int main() { // declare the bool bool...
- Why do we compare means instead of individual scores? for comparing average SAT test scores across...
- NPV Your division is considering two projects with the following cash flows (in millions): 0...
ADVERTISEMENT