please fill out using information

4) Complete the Pension Worksheet based on the following data: Use the following data to fill out the embedded pension worksheets that follow. You just double click on the embedded Excel object to activate it. Data Beginning balance in Plan Assets Ending Balance in Plan Assets Beginning balance in PBO Annual Service Cost Interest Cost Contributions Benefits Paid Prior Service Costs added in Year 1 350,000 383,000 350,000 27,000 30,000 24,000 21,000 240,000 Pension Worksheet (Debits are positive amounts and Credits are negative amounts) Other Comprehensive Income Annual Pension Prior Service Pension Expense Cash Costs Gains/Losses Asset/Liability Memo Record Projected Benefit Plan Assets Obligation (FVPA) Beginning Balance Prior Service Costs Service Cost Interest Cost Actual Retur Amortization of PSC Contributions Benefits Paid Journal Entry end of Year 1 Balance End of Year 1 Number 40 Prior Service Cost Data Employee group 1 Employee group 2 Employee group 3 Employee group 4 Expected Retirement Year 1 Year 2 Year 3 Year 4 20 40 50 150 Group 1 Group 2 Group 3 Year 1 Group 4 Total Year 2 Year 3 Year 4 Totals Total Service Years Cost Per Service Year! Annual Amortization Year 1 Year 2 Year 3 Year 4 $240,000 / 400 4) Complete the Pension Worksheet based on the following data: Use the following data to fill out the embedded pension worksheets that follow. You just double click on the embedded Excel object to activate it. Data Beginning balance in Plan Assets Ending Balance in Plan Assets Beginning balance in PBO Annual Service Cost Interest Cost Contributions Benefits Paid Prior Service Costs added in Year 1 350,000 383,000 350,000 27,000 30,000 24,000 21,000 240,000 Pension Worksheet (Debits are positive amounts and Credits are negative amounts) Other Comprehensive Income Annual Pension Prior Service Pension Expense Cash Costs Gains/Losses Asset/Liability Memo Record Projected Benefit Plan Assets Obligation (FVPA) Beginning Balance Prior Service Costs Service Cost Interest Cost Actual Retur Amortization of PSC Contributions Benefits Paid Journal Entry end of Year 1 Balance End of Year 1 Number 40 Prior Service Cost Data Employee group 1 Employee group 2 Employee group 3 Employee group 4 Expected Retirement Year 1 Year 2 Year 3 Year 4 20 40 50 150 Group 1 Group 2 Group 3 Year 1 Group 4 Total Year 2 Year 3 Year 4 Totals Total Service Years Cost Per Service Year! Annual Amortization Year 1 Year 2 Year 3 Year 4 $240,000 / 400