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

Prior service cost at January $1,2024,$ from plan amendment at the beginning of $2022($amortization: $$6$ million per year$)$ $ $45$ million

Net loss$-$pensions at January $1,2024($previous losses exceeded previous gains$)$ $ $63$ million

Average remaining service life of the active employee group $10$ years

Actuary$$s discount rate $10\%$

$($$ in millions$)$

PBO Plan Assets

Beginning of $2024$ $ $430$ Beginning of $2024$ $$300$

Service cost $61$

Interest cost, $10\%43$ Return on plan assets, $9\mathrm{.}0\%(10\%$ expected$)27$

Loss $($gain$)$ on PBO $(2)$ Cash contributions $75$

Less: Retiree benefits $(52)$ Less: Retiree benefits $(52)$

End of $2024$ $ $480$ End of $2024$ $$350$

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

$($$ in millions$)$

PBO Plan Assets

Beginning of $2025$ $ $480$ Beginning of $2025$ $ $350$

Service cost $51$

Interest cost, $10\%48$ Return on plan assets, $14\%(10\%$ expected$)49$

Loss $($gain$)$ on PBO $7$ Cash contributions $43$

Less: Retiree benefits $(29)$ Less: Retiree benefits $(29)$

End of $2025$ $ $557$ End of $2025$ $ $413$

$1.$ Prepare a pension spreadsheet to assist you in determining end of $2024$ balances in the PBO, plan assets, prior service cost$$AOCI$,$ the net loss$$AOCI$,$ and the pension liability.

$2.$ Using T$-$accounts, determine the balances at December $31,2025,$ in the net loss$$AOCI and prior service cost$$AOCI$.$

$3.$ Prepare a pension spreadsheet to assist you in determining end of $2025$ balances in the PBO, plan assets, prior service cost$$AOCI$,$ the net loss$$AOCI$,$ and the pension liability.

Note: 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. Enter your answers in millions rounded to $1$ decimal place $($i$.$e$.,5,500,000$ should be entered as $5\mathrm{.}5).$

Answer is not complete.