A19-17 Pension Spreadsheet (LO 19-6)

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 $430,000 and in 20X8 is $488,000.

Defined benefit obligation is $4,975,000 at the beginning of 20X7.

New past service cost in 20X8 is $45,000, a reduction in benefits.

Accumulated OCI amounts are losses at the beginning of 20X7, amounting to $787,000.

Benefits paid to retireesat end of year, $235,000 in 20X7, and $295,000 in 20X8.

Actuarial revaluation in 20X7 showed a $406,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,705,000.

20X7 contributions at end of year were $510,000 and in 20X8, $525,000.

Actual earnings were $276,000 in 20X7 and $80,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.

IGNORE NUMBERS IN TABLE (PHOTO ONLY INSERTED FOR HELP WITH FORMATTING)

Pension Obligation Plan Assets Pension Expense Net pension Asset (Liab) Accumulated OCI 20X7 $ (787,000) Opening CSC 4,975,000 $ 430,000 298,500 3,705,000 $ 0 0 0 Net interest Actual return versus expected Revaluation 222,300 53,700 0 0 0 406,000 6,109,500 (235,000) 0 $ 1,270,000 $ 430,000 0 76,200 0 0 53,700 0 (406,000) 506,200 506,200 510,000 $ 53,700 0 Benefits paid Funding 3,981,000 $ (235,000) 510,000 4,256,000 0 510,000 (330,700) $ 5,874,500 $ 20x8 $ 5,874,500 $ 4,256,000 $ 0 Opening CSC Net interest Actual return versus expected PSC-reduction in liability and expense 488,000 45,000 352,470 255,360 630, 110 Benefits paid Funding