Beale Management has a noncontributory, defined benefit pension plan. On December $31,2024($the end of Beale's fiscal year$),$ the following pension$-$related data were avallable:

$\backslash$begin$\{$tabular$\}\{$lc$\}$

Projected Benefit Obligation & $(\backslash$$ in millions$)\backslash \backslash$

Balance, January $1,2024$ & $\backslash (\backslash$$ $620\backslash )\backslash \backslash$

Service cost & $64\backslash \backslash$

Interest cost, discount rate, $5\backslash \%$ & $31\backslash \backslash$

Gain due to changes in actuarial assumptions in $2024$ & $(15)\backslash \backslash$

Pension benefits paid & $\backslash ((31)\backslash )\backslash \backslash$

Balance, December $31,2024$ & $\backslash (\backslash$$ $669\backslash )\backslash \backslash$

$\backslash$hline $\backslash$hline

$\backslash$end$\{$tabular$\}$

$\backslash$begin$\{$tabular$\}\{$lc$\}$

Plan Assets & $(\backslash$$ in millions$)\backslash \backslash$

$\backslash$hline Balance, January $1,2024$ & $\backslash (\backslash$$ $650\backslash )\backslash \backslash$

Actual return on plan assets & $41\backslash \backslash$

$($Expected return on plan assets, $\backslash$$$46)$ & $82\backslash \backslash$

Cash contributions & $\backslash ((31)\backslash )\backslash \backslash$

Pension benefits paid & $\backslash (\backslash$$ $742\backslash )\backslash \backslash$

Balance, December $31,2024$ &

$\backslash$end$\{$tabular$\}$

$\backslash$begin$\{$tabular$\}\{$lc$\}$

January $1,2024,$ balances: & $(\backslash (\backslash$$ $\backslash )$ in millions$)\backslash \backslash$

$\backslash$hline Pension asset & $\backslash (\backslash$$ $30\backslash )\backslash \backslash$

Prior service cost$-$AOCI $($amortization $\backslash (\backslash$$ $8\backslash )$ per year$)$ & $40\backslash \backslash$

Net gain$-$AOCI $($any amortization over $10$ years$)$ & $115$

$\backslash$end$\{$tabular$\}$

Required:

Prepare a pension spreadsheet to show the relationship among the PBO, plan assets, prlor service cost, the net gain, pension expense, and the net pension asset.

Note: Enter credit amounts with a minus sign and deblt amounts with a positive sign. Enter your answers in millions $($l$.$e$.,\backslash (10,000,000\backslash )$ should be entered as $10).$

$\backslash$begin$\{$tabular$\}\{|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|\}$

$\backslash$hline $(\backslash$$ in millions$)$ & PBO & & Plan Assets & Prior Service Cost$-$AOCl & Net GainAOCl & Pension Expense & Cash & Net Pension $($Liability$)/$ Asset $\backslash \backslash$

$\backslash$hline Balance, January $1,2024$ & & & & & & & & $\backslash \backslash$

$\backslash$hline Service cost & & & & & & & & $\backslash \backslash$

$\backslash$hline Interest cost, $5\backslash \%$ & & & & & & & & $\backslash \backslash$

$\backslash$hline Expected return on assets & & & & & & & & $\backslash \backslash$

$\backslash$hline Adjust for: & & & & & & & & $\backslash \backslash$

$\backslash$hline Loss on assets & & & & & & & & $\backslash \backslash$

$\backslash$hline Amortization of: & & & & & & & & $\backslash \backslash$

$\backslash$hline Prior service cost & & & & & & & & $\backslash \backslash$

$\backslash$hline Net gain & & & & & & & & $\backslash \backslash$

$\backslash$hline Gain on PBO & & & & & & & & $\backslash \backslash$

$\backslash$hline Cash funding & & & & & & & & $\backslash \backslash$

$\backslash$hline Retiree benefits & & & & & & & & $\backslash \backslash$

$\backslash$hline Balance, December $31,2024$ & $\backslash$$ & $0$ & $\backslash$$ $0$ & $\backslash$$ $0$ & $\backslash$$ $0$ & $\backslash$$ & & $\backslash$$ $0\backslash \backslash$

$\backslash$hline

$\backslash$end$\{$tabular$\}$