Problem $17-16($Algo$)$ Comprehensive$-$reporting a pension plan; pension spreadsheet; determine changes in balances; two years $[$LO$17-3,17-4,17-5,17-6,17-7,17-8]$

$[$The following information applies to the questions displayed below.$]$

Actuary and trustee reports indicate the following changes in the PBO and plan assets of Lakeside Cable during $2021$:

Assume the following actuary and trustee reports indicating changes in the PBO and plan assets of Lakeside Cable during $2022$:

$(\backslash$$ in millions$)$

Problem $17-16($Algo$)$ Part $3$

$3.$ Prepare a pension spreadsheet to assist you in determining end of $2021$ balances in the PBO, plan assets, prior service cost$-$AOCI, the net loss$-$AOCI, and the pension liability. $($Enter your answers in millions $($i$.$e$.,10,000,000$ should be entered as $10).$ Enter credit amounts with a minus sign and debit amounts with a positive sign.$)$