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

A partially completed pension spreadsheet showing the relationships among the elements that comprise the defined benefit pension plan of Universal Products is given below. The actuary's discount rate is $5\backslash \%.$ At the end of $2019,$ the pension formula was amended, creating a prior service cost of $\backslash (\backslash$$ $320,000\backslash ).$ The expected rate of return on assets was $\backslash (8\backslash \%\backslash ),$ and the average remaining service life of the active employee group is $20$ years in the current year as well as the previous two years.

Required:

Fill in the missing amounts. $($Enter your answers in thousands rounded to $1$ decimal place.$)$

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

$\backslash$hline & & & Prior & & & & Net Pension $\backslash \backslash$

$\backslash$hline & & Plan & Service & Net Loss & Pension & & $($Liability$)\backslash \backslash$

$\backslash$hline $(\backslash$$ in thousands$)$ & PBO & Assets & Cost$-$AOCI & $-$ AOCI & Expense & Cash & $/$ Asset $\backslash \backslash$

$\backslash$hline Balance, Jan. $1,2021$ & $\backslash$$ $(880\mathrm{.}0)$ & $\backslash$$ $620\mathrm{.}0$ & $\backslash$$ $304\mathrm{.}0$ & $\backslash$$ $88\mathrm{.}0$ & & & $\backslash$$ $(260\mathrm{.}0)\backslash \backslash$

$\backslash$hline Service cost & & & & & $108\mathrm{.}0$ & & $\backslash \backslash$

$\backslash$hline Interest cost, $5\backslash \%$ & $\backslash ((44\mathrm{.}0)\backslash )$ & & & & & & $\backslash \backslash$

$\backslash$hline Expected return on assets & & & & & $(49\mathrm{.}6)$ & & $\backslash \backslash$

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

$\backslash$hline Loss on assets & & & & $18\mathrm{.}0$ & & & $\backslash \backslash$

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

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

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

$\backslash$hline Net loss & & & & & & & $\backslash \backslash$

$\backslash$hline Gain on PBO & & & & & & & $32\mathrm{.}0\backslash \backslash$

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

$\backslash$hline Cash funding & & & & & & $(92\mathrm{.}0)$ & $\backslash \backslash$

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

$\backslash$hline Balance, Dec. $31,2021$ & $\backslash$$ $(950\mathrm{.}0)$ & & $\backslash$$ $288\mathrm{.}0$ & & & & $\backslash \backslash$

$\backslash$hline

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