Maple Construction Corp. has a defined benefit pension plan. Information concerning the 20X7 and 20X8 fiscal years is presented below:

From the Plan Actuary:

• Current service cost in 20X7 is $440,000 and in 20X8 is $513,000.
• Defined benefit obligation is $5,025,000 at the beginning of 20X7.
• New past service cost in 20X8 is $50,000, a reduction in benefits.
• Accumulated OCI amounts are losses at the beginning of 20X7, amounting to $792,000.
• Benefits paid to retireesat end of year, $240,000 in 20X7, and $300,000 in 20X8.
• Actuarial revaluation in 20X7 showed a $411,000 increase in the obligation due to changes in mortality. Revaluations take place every four years.

From the Plan Trustee:

• Plan assets at market value at the beginning of 20X7 were $3,730,000.
• 20X7 contributions at end of year were $515,000 and in 20X8, $535,000.
• Actual earnings were $286,000 in 20X7 and $85,000 in 20X8.

Other Information:

• Yield on long-term debt, stable in 20X7 and 20X8, 6%.
• The opening net defined benefit liability on the SFP is the opening net amount of the defined benefit obligation and opening fund assets.

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