Using the EXCEL template provided, complete the pension spreadsheet showing the relationships among the various pension balances, shows the changes in those balances, and computes pension expense for 2017.

Pension Spreadsheet Assignment The following pension-related data pertain to Shepard Company's defined benefit plan: (S in 000s) an. Dec. 31 4,100 $ 3,715 4,530 4,380 3,950 4,975 Projected benefit obligation Accumulated benefit obligation Plan assets (fair value) Interest (discount) rate, 7% Expected return on plan assets, 10% Prior service cost-AOCI (from Dec. 31, 2016 840 amendment) 477 Net loss-AOCI Average remaining service life: 12 years Gain due to chan ges in actuarial assumptions Contributions to pension fund (end of year) 340 Pension benefits paid (end of year) 295 Required Using the EXCEL template provided, complete the pension spreadsheet showing the relationships among the various pension balances, shows the changes in those balances, and computes pension expense for 2017 Pension Spreadsheet Assignment The following pension-related data pertain to Shepard Company's defined benefit plan: (S in 000s) an. Dec. 31 4,100 $ 3,715 4,530 4,380 3,950 4,975 Projected benefit obligation Accumulated benefit obligation Plan assets (fair value) Interest (discount) rate, 7% Expected return on plan assets, 10% Prior service cost-AOCI (from Dec. 31, 2016 840 amendment) 477 Net loss-AOCI Average remaining service life: 12 years Gain due to chan ges in actuarial assumptions Contributions to pension fund (end of year) 340 Pension benefits paid (end of year) 295 Required Using the EXCEL template provided, complete the pension spreadsheet showing the relationships among the various pension balances, shows the changes in those balances, and computes pension expense for 2017