Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

A partially completed pension spreadsheet showing the relationships among the el

ID: 2531762 • Letter: A

Question

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 $8 million per year. At the end of 2018, the pension formula was amended again, creating an additional prior service cost of $50 million. The expected rate of return on assets and the actuary's discount rate were 10%, and the average remaining service life of the active employee group is 10 years. Required 1. Fill in the missing amounts 2. to 4. Prepare all the necessary journal entries for 2018 Complete this question by entering your answers in the tabs below Req 1 Req 2 to 4 Fill in the missing amounts. (Enter your answers in millions (i.e., 10,000,000 should be entered as 10). Enter credit amounts with a minus sign and debit amounts with a positive sign.) s indicate credits; debits otherwise Prior Net Pension Net Loss Pension Expense Liability) / Asset S in millions) ??? Plan Assets Service Cash AOCI Cost-AOCI (990) (102) 910 35 109 (80) (102) Balance, Jan. 1, 2018 Service cost Interest cost Expected return on assets Adjust for: 102 Loss on assets Amortization of. Prior service cost Net loss Loss on PBO Prior service cost Cash funding Retiree benefits Bal., Dec. 31, 2018 (29) 94 (1,092) 815 35 109 102 (117)

Explanation / Answer

Answer: Requirement 1 Prior Net Pension Plan Service Net Loss Pension (Liability) ($ in 000s) PBO Assets Cost – AOCI – AOCI Expense Cash / Asset Balance, Jan. 1, 2018 ($990) $910 $35 $109 ($80) Service cost -102 102 -102 (0-102) Interest cost, 10% ($99) $99 -99 (0-99) Expected return on assets $91 ($91) 91 (91-0) Adjust for: Loss on assets -8 8 -8 (0-8) Amortization: Prior service cost -8 8 0 Net loss -1 1 Loss on PBO ($123) $123 ($123) (0-123) Prior service cost -50 50 -50 (0-50) Cash funding 94 -94 94 (94-0) Retiree benefits $272 ($272) 0 Balance, Dec. 31, 2018 ($1,092) $815 $77 $239 $119 ($94) ($277) Note: Interest cost =-990*10% ($99) Expected return on assets =910*10% $91 1 Retiree benefit =815-(910+91-8+94) $                 (272) 2 Loss on PBO =-1092-(-990-102-99-50+272) $                 (123) 3 Pension Expense =102+99-91+8+1 $                   119 4 Net loss =(109-99)/10 years $                        1 5 Net pension asset/liabilities =-80-102-99+91-8-123-50+94 $                 (277) Requirement 2 General Journal Debit Credit 1 Pension expense $119 Plan asset $91 Amortization of net gain-OCI $                  1.00 Amortization of prior service cost-OCI $                  8.00 PBO $             201.00 (119+91-1-8) (To record pension expense) Requirement 3 Loss-OCI $                     8.00 Plan asset $                  8.00 (To record loss on asset) Requirement 4 Plan assets $                  94.00 Cash $                94.00 (To record contribution made) 4 PBO $272 Plan Asset $272 (To record retiree benefit)

Hire Me For All Your Tutoring Needs
Integrity-first tutoring: clear explanations, guidance, and feedback.
Drop an Email at
drjack9650@gmail.com
Chat Now And Get Quote