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 Balance, January 1, 2021 Service cost Interest cost, discount rate, 5% Gain due to changes in actuarial assumptions in 2021 Pension benefits paid Balance, December 31, 2021 ($ in millions) $ 460 48 23 (14) (23) $ 494 ($ in millions) $ 520 33 Plan Assets Balance, January 1, 2021 Actual return on plan assets (Expected return on plan assets, $38) Cash contributions Pension benefits paid Balance, December 31, 2021 74 (23) $ 684 January 1, 2021, balances: Pension asset Prior service cost-AOCI (amortization $7 per year) Net gain-AOCI (any amortization over 10 years) ($ in millions) $ 60 49 92 Required: Prepare a pension spreadsheet to show the relationship among the PBO plan assets, prior service cost, the net gain, pension expense, and the net pension asset. (Enter credit amounts with a minus sign and debit amounts with a positive sign. Enter your answers in millions.) Answer is complete but not entirely correct. Prior Plan Pension Net Pension (Liability) Asset (S in millions) PBO Assets Net Gain- AOCI s (92) Expense Service Cost- AOCI $ 49 0 Cash Balance, Jan. 1. 2021 IS 520 IS 0 IS 0 $ 60 Service cost 0 0 48 0 48 $ (460) (48) (23) 0 0 0 0 23 0 SIS Interest cost. 5% Expected return on assets Adjust for: >> 23 38 38 0 0 (38) > 0 0X 0 11 X (11) 0 X 0 0 (6) 0 0 x x Oo 0 0 0 0 X 6 X 0 0 Loss on assets Amortization of Prior service cost Net gain Gain on PBO Cash funding Retiree benefits Balance, Dec. 31, 2021 0 14 0 0 (14) 0 0 0 79 X 0 0 0 (79) 0X OO 23 0 0 0 (23) 814 0 28 $ (494) s IS 43 Is (95) s IS 169