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

please type the answer from the excel Prepare Pension Worksheet & Journal Entrie

ID: 2433120 • Letter: P

Question

please type the answer from the excel

Prepare Pension Worksheet & Journal Entries for YE's2xx1 2xx2 2xx3 ClassCo Inc. for year 2xx1 2xx2 2xx3 2xx4 Beginning projected benefit obligation [PBO] 3,63,000 Beginning plan assets 3,14,000 3,42,000 3,60,000 3,85,000 Service cost 22,000 23,000 26,000 Settlement rate = expected rate of return 5.8% 5.8% 5.8% benefits paid 29,000 29,000 29,000 Contribution [Funding] 34,000 36,000 40,000 actual return - compute prior service costs-in 2xx1 amendment generated PSC, use S/L-8 yrs 48,000 Amortization of PSC Change in assumptions: NEW YE PBO 4,20,000

Explanation / Answer

Year 2xx1 2xx2 2xx3 2xx4 Beginning PBO 363000 Beginning plan assets 314000 342000 360000 385000 Service cost 22000 23000 26000 Settlement rate of return 5.8% 5.8% 5.8% Benefits paid 29000 29000 29000 Contribution 34000 36000 40000 Actual return 251000 277000 291000 Prior service cost Amortisation of PSC Change in assumptions New year PBO 420000