Question

A partially completed pension spreadsheet showing the relationships among the elements that comprise the defined benefit pens
0 0
Add a comment Improve this question Transcribed image text
✔ Recommended Answer
Answer #1

Answer :

Prior Net Pension
Plan Service Net loss Pension (Liability)
($ in 000s) PBO Assets Cost - AOCI -AOCI Expense Cash /Asset
Balance Jan 1.2018 -800 600 114 80 -200
Service cost -84 84 -84
Interest cost 5% -40 40 -40
Expected ROA 48 -48 48
Adjust for :
Loss on assets -6 6 -6
Amortization :
Prior service cost -6 6
Amortization
Net loss
Gain on PBO 12 -12 12
Prior service cost
Cash funding 68 -68 68
Retiree benefits 50 -50
Balance,Dec 31.2018 -862 660 108 74 82 -68 -202

Please Up -vote Thank You !!!

Add a comment
Know the answer?
Add Answer to:
A partially completed pension spreadsheet showing the relationships among the elements that comprise the defined benefit...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Similar Homework Help Questions
  • 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 $220,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...

  • Exercise 17-15 Pension spreadsheet [LO17-8] A partially completed pension spreadsheet showing the relationships among the elements...

    Exercise 17-15 Pension spreadsheet [LO17-8] 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 $280.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...

  • 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 $280,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 2016, the pension formula was amended, creating a prior service cost of $280,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.'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 $8 million per year. At the end of 2021, the pension formula was amended again, creating an additional prior service cost of $65...

  • 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 $35...

  • 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 $5 million per year. At the end of 2018, the pension formula was amended again, creating an additional prior service cost of $35...

  • Required information Problem 17-16 Comprehensive-reporting a pension plan; pension spreadsheet; determine changes in balances; two years...

    Required information Problem 17-16 Comprehensive-reporting a pension plan; pension spreadsheet; determine changes in balances; two years [LO17-3, 17-4, 17-5, 17-6, 17-7, 17-8] [The following information applies to the questions displayed below.) Actuary and trustee reports indicate the following changes in the PBO and plan assets of Lakeside Cable during 2018: Prior service cost at Jan. 1, 2018, from plan amendment at the beginning of 2016 (amortization: $6 million per year) Net loss-pensions at Jan.1, 2018 (previous losses exceeded previous gains)...

  • The following pension-related data pertain to Metro Recreation's noncontributory, defined benefit pension plan for 2018: ($...

    The following pension-related data pertain to Metro Recreation's noncontributory, defined benefit pension plan for 2018: ($ in 000s) Jan. 1 Dec. 31 Projected benefit obligation $ 4,400 $ 4,680 Accumulated benefit obligation 3,730 3,980 Plan assets (fair value) 4,980   5,425 Interest (discount) rate, 6% Expected return on plan assets, 10% Prior service cost−AOCI (from Dec. 31, 2017, amendment) 870 Net loss−AOCI 518 Average remaining service life: 10 years Gain due to changes in actuarial assumptions 44 Contributions to pension fund...

  • Prepare a pension spreadsheet to assist you in determining end of 2018 balances in the PBO,...

    Prepare a pension spreadsheet to assist you in determining end of 2018 balances in the PBO, plan assets, prior service cost—AOCI, the net loss—AOCI, and the pension liability. Actuary and trustee reports indicate the following changes in the PBO and plan assets of Lakeside Cable during 2018: Prior service cost at Jan. 1, 2018, from plan amendment at the beginning of 2016 (amortization: $7 million per year) Net loss-pensions at Jan.1, 2018 (previous losses exceeded previous gains) Average remaining service...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT