Guetza has a defined benefit pension plan. At the end of the year 20X0, plan assets are $3,450,000, and the defined benefit obligation is $3,120,000. There is an asset ceiling that caps the net defined benefit asset at $140,000. The market yield rate for high-quality corporate bonds of similar term and identical currency is 5% at the end of the year. On 1 July 20X0, Guetza contributed $403,000 to the plan. Benefit payments of $144,000 were paid to pensioners evenly throughout the year.

Required:
Prepare a spreadsheet for 20X0 that determines pension expense and also the closing net defined benefit asset or liability account and accumulated OCI assuming.