please answer asap

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: ($ in millions) $480 82 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 24 (10) (40) ($ in millions) $500 40 Plan Assets Balance, January 1, 2021 Actual return on plan assets (Expected return on plan assets, $45) Cash contributions Pension benefits paid Balance, December 31, 2021 70 (40) $570 January 1, 2021, balances: Pension asset Prior service cost-AOCI (amortization $8 per year) Net gain-AOCI (any amortization over 15 years) (s in millions) $28 48 80 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 your answers in millions. Enter credit amounts with a minus sign and debit amounts with a positive slgn.) 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 your answers in millions. Enter credit amounts with a minus sign and debit amounts with a positive sign.) Answer is not complete. Prior Pension (Liability) Plan Pension Service Cost Net Gain- (5 in millions) Expense Cash Asset AOCI A $ ssets 5005 AOCI (80) PBO (480) (82) (24) 20 (82) 24 Balance, Jan 1, 2021 Service cost Interest cost, 5% Expected return on assets Adjust for: Loss on assets Amortization of (24) 45 (45) Prior service cost Net gain (70) Gain on PBO . Cash funding Retiree benefits Balance, Dec 31, 2021 (536) S 570