Exercise $17-20($Algo$)$ Pension spreadsheet $[$LO$17-8]$

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 available:

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.

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