Data Home Insert Draw Formulas Page Layout II X 11 VA A Calibri (Body) BIU Pasto a. A Office Update To koop up-to-date with security updates, fixes, and impr K11 4 x fx 8 6 7 8 9 Populate the Worksheet for each temas appropriate 1 This is the start of a new calendar year for this unnamed company The company's pension plan begins the year with a. 300,000 in Plan Asset b. 350,000 in Plan Obligations c. after you record these two Rems record the net Pension Asset or Liability 2 At the very start of the year, the company changes the pension plan for All its retirees and exiting workers. As a result of this change the Company must recognize a Prior Service Cost of 50,000 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 12 33 34 35 3 The current period expense or current year Service Cost is estimated by the actuary to be 45000 4 The actuary uses a settlement rate of 4%. Please use it to estimate the interest cost on Pension Obications for this year 5 The Pension Trustee Informs the company at the end of the year that the actual return on plan assets was NEGATIVE SX due to the Covid-13 crus The company informs its outside autor KPMG, that it has decided to use an Estimated Rate of Retum for pension accounting purposes of 4%, a reduced rate from Historical levels because of the government intervention in the capital markets. This rate is vied to estimate and record an Esimated retur 17 39 40 41 7 The company makes a contribution of 135,000 to the pension 44 & The Pension Trustee makes total pension payments to retrees of 90000 COVER SHEET Pension Worksheet Pension Fillin Ready Data Home Insert Draw Formulas Page Layout II X 11 VA A Calibri (Body) BIU Pasto a. A Office Update To koop up-to-date with security updates, fixes, and impr K11 4 x fx 8 6 7 8 9 Populate the Worksheet for each temas appropriate 1 This is the start of a new calendar year for this unnamed company The company's pension plan begins the year with a. 300,000 in Plan Asset b. 350,000 in Plan Obligations c. after you record these two Rems record the net Pension Asset or Liability 2 At the very start of the year, the company changes the pension plan for All its retirees and exiting workers. As a result of this change the Company must recognize a Prior Service Cost of 50,000 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 12 33 34 35 3 The current period expense or current year Service Cost is estimated by the actuary to be 45000 4 The actuary uses a settlement rate of 4%. Please use it to estimate the interest cost on Pension Obications for this year 5 The Pension Trustee Informs the company at the end of the year that the actual return on plan assets was NEGATIVE SX due to the Covid-13 crus The company informs its outside autor KPMG, that it has decided to use an Estimated Rate of Retum for pension accounting purposes of 4%, a reduced rate from Historical levels because of the government intervention in the capital markets. This rate is vied to estimate and record an Esimated retur 17 39 40 41 7 The company makes a contribution of 135,000 to the pension 44 & The Pension Trustee makes total pension payments to retrees of 90000 COVER SHEET Pension Worksheet Pension Fillin Ready