Formula: Subtract, Multiply. Divide: Cell Referencing Student Work Area - BE20.7 Required: Provide input into cells shaded in yellow in this template. Use mathematical formulas with cell references to the Problem area. BE20.7 Using Excel to Account for Pensions PROBLEM 5 Shin Corporation provided the following information concerning its pension 6 plan 7 Projected benefit obligation, January 1, 2020 $ 3,100,000 Plan assets, January 1, 2020 3,300,000 10 Net actuarial loss in accumulated OCH 465,000 Average remaining service period of Shin's 12 employees 18 Compute Shin's minimum amortization of the actuarial loss 7.5 years Corridor Minimum amortization 14 17 18 20 20 Formula: Subtract, Multiply, Divide; Cell Referencing BE20.7 - Using Excel to Account for Pensions PROBLEM Shin Corporation provided the following information concerning its pension plan. Projected benefit obligation, January 1, 2020 Plan assets, January 1, 2020 Net actuarial loss in accumulated OCI Average remaining service period of Shin's employees $ 3,100,000 3,300,000 465,000 7.5 years Student Work Area - BE20.7 Required: Provide input into cells shaded in yellow in this template. Use mathematical formulas with cell references to the Problem area. Compute Shin's minimum amortization of the actuarial loss. Corridor Minimum amortization Formula: Subtract, Multiply. Divide: Cell Referencing Student Work Area - BE20.7 Required: Provide input into cells shaded in yellow in this template. Use mathematical formulas with cell references to the Problem area. BE20.7 Using Excel to Account for Pensions PROBLEM 5 Shin Corporation provided the following information concerning its pension 6 plan 7 Projected benefit obligation, January 1, 2020 $ 3,100,000 Plan assets, January 1, 2020 3,300,000 10 Net actuarial loss in accumulated OCH 465,000 Average remaining service period of Shin's 12 employees 18 Compute Shin's minimum amortization of the actuarial loss 7.5 years Corridor Minimum amortization 14 17 18 20 20 Formula: Subtract, Multiply, Divide; Cell Referencing BE20.7 - Using Excel to Account for Pensions PROBLEM Shin Corporation provided the following information concerning its pension plan. Projected benefit obligation, January 1, 2020 Plan assets, January 1, 2020 Net actuarial loss in accumulated OCI Average remaining service period of Shin's employees $ 3,100,000 3,300,000 465,000 7.5 years Student Work Area - BE20.7 Required: Provide input into cells shaded in yellow in this template. Use mathematical formulas with cell references to the Problem area. Compute Shin's minimum amortization of the actuarial loss. Corridor Minimum amortization