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 $448,000 and in 20X8 is $533,000. Defined benefit obligation is $5,065,000 at the beginning of 20X7. New past service cost in 20X8 is $54,000, a reduction in benefits. Accumulated OCl amounts are losses at the beginning of 20X7, amounting to $796,000. Benefits paid to retirees-at end of year, $244,000 in 20X7, and $304,000 in 20X8. Actuarial revaluation in 20X7 showed a $415,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,750,000. 20X7 contributions at end of year were $519,000 and in 20x8, $543,000. Actual earnings were $294,000 in 20X7 and $89,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. 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. Pension Obligation Plan Assets Pension Expense Net pension Asset (Liab) Accumulated 20X7 Opening CSC Net interest Actual return versus expected Revaluation Benefits paid Funding 20X8 Opening CSC Net interest Actual return versus expected PSC - reduction in liability and expense Benefits paid Funding Prev 1 of 42 Moyt