70.2K

Verified Solution

Link Copied!

please help- I need a pension worksheet containing collums with pension expense, cash, OCI-PSC, OCI-gain/loss, pension asset/liability, PBO, and plan assets

On January 1,2025, Sandhill Company has the following defined benefit pension plan balances. The interest (settlement) rate applicable to the plan is 10%. On January 1,2026, the company amends its pension agreement so that prior service costs of $508,000 are created. Other data related to the pension plan are as follows: \begin{tabular}{|c|c|c|c|c|c|} \hline \begin{tabular}{l} sion Asset/ \\ Siability \end{tabular} & & \begin{tabular}{l} Projected Benefit \\ Obligation \end{tabular} & & \begin{tabular}{l} Plan \\ Assets \end{tabular} & \\ \hline & & 45555000 & c.. & 4250000 & DR. \\ \hline i & & 151000 & a0. & i & \\ \hline B & & 455500 & a.v & 1 & \\ \hline (1) & & (1) & & 255000 & x= \\ \hline 1 & & 1 & & 236000 & x= \\ \hline i & & 203000 & & 203000 & aa= \\ \hline & & & & & \\ \hline 115500 & G & 1 & & 1 & \\ \hline 115500 & a. & 4958550 & a1. & 45350000 & ax. \\ \hline & & 500800 & a. & & \\ \hline \end{tabular} Balance, vec. S1; U3 Additional PSC, 1/1/2026 Balance, Jan, 1, 2026 \begin{tabular}{|c|c|c|c|} \hline Service cost & & 100000 & Dr. \\ \hline Interest cost & & 546650 & Dr. \\ \hline Actual return & & 257000 & Cr: \\ \hline Unexpected loss & & & \\ \hline Amortization of PSC & & 90000 & Dr. \\ \hline Contributions: & & i & \\ \hline Benefits & & i & \\ \hline Journal entry for 2026 & $ & 559650 & Dr. \\ \hline \end{tabular} Accumulated OCI, Dec. 31, 2025

Answer & Explanation Solved by verified expert

See Answer