Question

Required information Problem 17-16 Comprehensive-reporting a pension plan; pension spreadsheet; determine changes in balancesProblem 17-16 Part 3 3. Prepare a pension spreadsheet to assist you in determining end of 2018 balances in the PBO, plan asse

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

PBO

Plan Assets

Prior service cost - AOCI

Net loss - AOCI

Pension expense

Cash

Net pension (liability)/Asset

Bal., Jan. 1, 2018

(400)

200

42

60

(200)

Service cost

(58)

58

(58)

Interest cost, 8%

(32)

32

(32)

Expected return on assets

20

(20)

20

Loss on assets

(5)

5

(5)

Amortization of:

Prior service cost – AOCI

(6)

6

Net loss – AOCI

(2)

2

Gain on PBO

3

(3)

3

Cash contributions

72

(72)

72

Retiree benefits

37

(37)

Bal., Dec. 31, 2018

(450)

250

36

60

78

(200)

400*8% = 32

200*10% = 20

Loss on assets = 20-15=5

Net loss – AOCI = (60-40)/10 years = 2

Corridor = 10% of greater of PBO or plan assets

Add a comment
Know the answer?
Add Answer to:
Required information Problem 17-16 Comprehensive-reporting a pension plan; pension spreadsheet; determine changes in balances; two years...
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
  • 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...

  • Check my work Actuary and trustee reports indicate the following changes in the PBO and plan...

    Check my work 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) Average remaining service life of the active employee group Actuary's discount rate $40 mi11ion $58 million 10 years 101 ($ in millions) Pla PBO Ass $380 Beginning of...

  • Required information [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 durin...

    Required information [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) $ 46 million Net loss–pensions at Jan.1, 2018 (previous losses exceeded previous gains) $ 64 million Average remaining service life of the active employee group 10 years Actuary’s discount rate...

  • 14 Check my work The following information applies to the questions displayed below Actuary and trustee...

    14 Check my work The following information applies to the questions displayed below Actuary and trustee reports indicate the following changes in the P8O and plan assets of Lakeside Cable during 2018: art 3 of 7 Prior service cost at Jan. 1, 2018, from plan anendment at the beginning of 2016 (amortization: $6 million per year) Net loss-pensions at Jan.1, 2018 (previous losses exceeded previous gains) Average remaining service life of the active employ Actuary's discount rate $40 million $58...

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

  • The following incomplete (columns have missing amounts) pension spreadsheet is for Old Tucson Corporation (OTC). Prior...

    The following incomplete (columns have missing amounts) pension spreadsheet is for Old Tucson Corporation (OTC). Prior Net ($ in millions) debit (Credit) Beginning balance Service cost Interest cost Plan PBO Assets (520) Service (Gain) Pension Net Pension Expense Cash (Liability)/Asset Cost Lss 64 68 Expected return on assets Gain/loss on assets (25) (4) Amortization of: Prior service cost Net gain/ loss (8) Loss on PBO Contributions to fund (27) 27 (62) Retiree benefits paid (47) 47 84 (598) (298) 300...

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

  • Beale Management has a noncontributory, defined benefit pension plan. On December 31, 2021 (the end of...

    Beale Management has a noncontributory, defined benefit pension plan. On December 31, 2021 (the end of Beale's fiscal year), the following pension-related data were available: Projected Benefit Obligation ($ in millions) Balance, January 1, 2021 $ 780 Service cost 80 Interest cost, discount rate, 5% 39 Gain due to changes in actuarial assumptions in 2021 (23 ) Pension benefits paid (39 ) Balance, December 31, 2021 $ 837 Plan Assets ($ in millions) Balance, January 1, 2021 $ 820 Actual...

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

  • The following incomplete (columns have missing amounts) pension spreadsheet is for Old Tucson Corporation (OTC). Plan...

    The following incomplete (columns have missing amounts) pension spreadsheet is for Old Tucson Corporation (OTC). Plan assets Prior Net service (Gain) cost loss 44 Pension Expenses Net Pension (Liability)/ Asse PBO (430) Cash 41 (16) (1) ($ in millions) debit (credit) Beginning Balance Service cost Interest cost Expected return on assets Gain/loss on assets Amortization of: Prior service cost Net gain loss Loss on PBO Contribution to funds Retiree benefits paid Ending balance (4) (18) 18 (35) 29 (495) (29)...

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