Please make the response detailed and easy to read, show all formula calculations in excel please. THANK YOU!!!

a) Prepare the journal entries related to the defined pension plan for 2020 assuming a discount rate of 8%. Amortize Accumulated OCI - Pension Gain/Loss using the straight-line method over 15 years.

b) Prepare a partial income statement for the year ended December 31, 2020 showing the effects of the pension plan.

c) Prepare a partial classified balance sheet as of December 31, 2020 showing the effects of the pension plan. Do not include cash

The following data relate to a pension plan for ISPN Inc. Account Balances Jan. 1, 2020 Activity 2020 Projected Benefit Obligation. Plan Assets.. Accumulated OCI-Pension Gain/Loss .. Accumulated OCIPrior Service Cost... $30,000 Cr. 30,000 Dr. 5,000 Cr. 8,000 Dr. Service cost .... $7,000 Contributions ... 9,000 Prior service cost amortization ... 1,000 Expected return on plan assets .. 2,000 Actual return on plan assets..... 3,000 The following data relate to a pension plan for ISPN Inc. Account Balances Jan. 1, 2020 Activity 2020 Projected Benefit Obligation. Plan Assets.. Accumulated OCI-Pension Gain/Loss .. Accumulated OCIPrior Service Cost... $30,000 Cr. 30,000 Dr. 5,000 Cr. 8,000 Dr. Service cost .... $7,000 Contributions ... 9,000 Prior service cost amortization ... 1,000 Expected return on plan assets .. 2,000 Actual return on plan assets..... 3,000