Question

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 years. Required: Fill in the missing amounts. (Enter credit amounts with a minus sign and debit amounts with a positive sign.)

1 0
Add a comment Improve this question Transcribed image text
Answer #1

Net Pension Prior Service Cost AOCI Net LosS Pension (Liability Plan AoCI Expense Cash Assets PBO Assets $ in 000 Balance inWorking Note: Prior service cost Average Service life Amortization per year (280,000/20) 280,000 20 14,000 Amortization of Ne

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.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
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 2016, the pension formula was amended, creating a prior service cost of $120,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 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...

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

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

  • Please help with this Accounting problem- this is all of the information given A partially completed...

    Please help with this Accounting problem- this is all of the information given 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...

  • 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,800 $ 5,080 Accumulated benefit obligation 3,750 4,020 Plan assets (fair value) 5,580 6,025 Interest (discount) rate, 7% Expected return on plan assets, 10% Prior service cost?AOCI (from Dec. 31, 2017, amendment) 910 Net loss?AOCI 578 Average remaining service life: 10 years Gain due to changes in actuarial assumptions 52 Contributions to pension fund...

  • 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 200s) Jan. 1 Dec. 31 $4,900 $5,180 3,755 4,030 5,730 6,175 Projected benefit obligation Accumulated benefit obligation Plan assets (fair value) Interest (discount) rate, 8% Expected return on plan assets, 10% Prior service cost-AOCI (from Dec. 31, 2017, amendment) Net loss-AOCI Average remaining service life: 10 years Gain due to changes in actuarial assumptions Contributions to pension fund (end of year) Pension benefits...

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