Required information

Problem $17-16($Algo$)$ Comprehensive$-$reporting a pension plan; pension spreadsheet; financial

statement effects; two years $[$L$017-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

$2024$:

Prior service cost at January $1,2024,$ from plan amendment at the beginning of

$2022($amortization: $$5$ million per year$)$

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

Average remaining service life of the active employee group

Actuary's discount rate

$$39$ million

$47$ million

$10$ years

$10\%$

$($$ in millions$)$

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

during $2025$:

$($$ in millions$)$

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

Prepare a pension spreadsheet to assist you in determining end of $2025$ balances in the PBO, plan assets, prior service cost$-$AO

the net loss$-$ AOCl, and the pension liability.

Note: Enter your answers in millions rounded to $1$ decimal place $($i$.$e$.,5,500,000$ should be entered as $5\mathrm{.}5).$ Enter credit amounts

with a minus sign and debit amounts with a positive sign.

Answer is not complete.