A$19-22$ Pension Spreadsheet $($LO $19-3,19-4,19-6)$

JSolutions Ltd$.$ sponsors a defined benefit pension plan for its employees. At the beginning of $20$X$3,$ there is an accrued SFP pension liability of $$154,700,$ as follows:There are also actuarial losses of $$72,800$ in accumulated OCl with respect to the pension plan.

$\backslash$table$[[$Current service cost,$20\backslash$times $3,20\backslash$times $4],[$Yield rate on long$-$term corporate bonds,$$52,000,$$$47,000],[$Actual return $($loss$)$ on plan assets,$5\%,5\%],[$Annual funding contributions, at year$-$end,$74,000),23,000],[$Benefits paid to retirees, at end of year,$72,000,93,000],[$Increase in defined benefit obligation due to changes in$,55,000,105,000],[$actuarial assumptions as of $31$ December each year,$81,000,34,000]]$

Required:

Prepare a spreadsheet that summarizes relevant pension data for $203$ and $204.$ As part of the spreadsheet, calculate pension expense, the net defined benefit accrued benefit asset$/$liability$,$ and accumulated OCl for $20$X$3$ and $20$X$4.$

$\backslash$table$[[,\backslash$table$[[$Pension$],[$Obligation$]],$Plan Assets,$\backslash$table$[[$Pension$],[$Expense$]],\backslash$table$[[$Net defined$],[$benefit Asset$],[($Liab$)]],\backslash$table$[[$Accumulated$],[$OCl$]],],[20\backslash$times $3],[$Opening balance,,,,,,dr$.],[$CSC$],[$Net interest $^(*)],[$Actuarial gains $/$ losses: interest$],[$Assumptions$,,,,,,$dr$.],[$Funding$],[$Benefits paid$],[,,,,,,$dr $.],[20\backslash$times $4],[$CSC$],[$Net interest $^(***)],[$Actuarial gains $/$ losses: interest$],[$Assumptions$,,,,,,$dr$.],[$Funding$],[$Benefits paid$],[,,,,,,],[,,,,,,$dr $.]]$