P$17-15$

Sned

Problem $17-15($Algo$)$ Comprehensive$-$pension elements; spreadsheet $[$LO$17-8]$

The following pension$-$related data pertain to Metro Hecreation's noncontrbutory. defined beneft permsoe plan for $2024$:

$\backslash$table$[[,$imwary in$,$Decenter $71],[$Projected benefit obligation,$53,700,\%5,$see$],[$Accamlated benefit ebligation,$3,795,4,110],[\backslash$table$[[$plan assets $($ foi ir veluen$)],[$Intersst $($discoont$)$ rete, in$]],6,910,7,37],[$Interest $($discount$)$ rete, $71$ tepected return on plan esvets, $3$ en$,,],[$Priser service cost$-$AcCI $($froe Orcester $31,2693,$ seendent$),1,000,],[$Aet less$-$noci,n$3,],[$Average remainise service $1$ifei $10$ years,,$],[$Cain dor to changes in actuarial assuptions,,$3],[$Contributions to pension fund $($end of yese$),,2$ee$],[$Pensios lienefits paid $($end of yaur$),,$ess$]]$

Aequired:

Prepare a peesion spreadsheet that shows the relationships among the various perision balancex. shows the changes in those balances, and computes persion expense for $2024.$

Note: Emer credit amounts with a minus sign and debit amounts with a positive sign. Enter your answers in thousands f$.$e$.200,000$ shevild be entered as $200).$

$\backslash$table$[[(1)$ in thocrends$),$P$00,$Plan Amets,Prior Serven Cont$-$A$0$ci$,$Net LontADCI,Penstion Exp nse,Cash,Net Feraion $[$Liabity$)$ or Asset$],[$Balarice$,$ Januay $1,2024,,,,,,,],[$Service cont,,,,,,,$],[$Interest cost$,,,,,,,],[$Expecked return an avsets,,,,,,,$],[$Adjuit for,,,,,,,$],[$Less on assets,,,,,,,$],[$Amontrabon ot$,,,,,,,],[$Pror service cont,,,,,,,$],[$Net lons,,,,,,,$],[$Gain on P$90,,,,,,,],[$Cesh funding,,,,,,,$],[$Aetree benetis,,,,,,,$],[$Balasce$,$ Decomber $$1,7024,,,,,,,]]$