Sheet1Pension Spreadsheet ProblemsThis template can be used to complete pension spreadsheet problems. Use formulas to calculate totals.It would be helpful to make debit entries positive (+)...

Help with pension spreadsheet


Sheet1 Pension Spreadsheet Problems This template can be used to complete pension spreadsheet problems. Use formulas to calculate totals. It would be helpful to make debit entries positive (+) and credit entries negative (-). General Journal EntriesMemo Record Other Comprehensive Income Annual Pension ExpenseCashPrior Service CostGains / LossesPension Asset / LiabilityProjected Benefit ObligationPlan Assets Sheet1 Complete the following pension spreadsheet:Name: Copy the data and enter formulas (instead of just typing the numbers) into the spreadsheet. Properly label and format all parts of the worksheet. At January 1, 2022, the account balances (for both Gen Ledger and Memo Record accounts) related to the company's pension plan are as follows: Projected Benefit Obligation, 1/11,200,000 Plan Assets(Mkt Related Value), 1/1790,000 Pension asset/liability, 1/1(410,000) Additional Information:20222023 On 1/1/22, through plan amendments grants prior service benefits having present value of 320,000 Service cost110,000118,000 Settlement rate10%10% Expected rate of return10%10% Actual rate of return79,000122,000 Amortization of prior service cost140,000100,000 Annual contributions194,000162,000 Benefits paid retirees63,000108,000 The Increase in the PBO due to changes in actuarial assumptions174,000 General Journal EntriesMemo Record Other Comprehensive Income Annual Pension ExpenseCashPrior Service CostGains / LossesPension Asset / LiabilityProjected Benefit ObligationPlan Assets King, Suzanne: King, Suzanne: Sheet2 Sheet3