Hi can i get help from this please?

please hse excel format

B.Prepare the pension journal entry for they year Dr CR

Rollo Company maintains a defined benefit pension plan with First Cranston Trust. Below are the balances reported by First Cranston on January 1, 2020. At the beginning of 2020, First Cranston Trust informed Rollo that due to amending the program for prior service for new employees, they need to deposit $200,000. Other matters for 2020 were: The settlement rate is 10%. Current service cost is $50,000. Expected earnings are 10% on beginning of the year Plan Assets. Actual earnings are $72,000. Prior service cost amortization is $25,000. First Cranston Trust paid retirement benefits of $35,000. Rollo funded the plan $130,000. Assuming a beginning debit balance of $320,000 in OCI Prior Service Costs and a beginning debit balance of $45 in OCl Other Gains and Losses, prepare a pension worksheet below: 2020 Beginning Balance Service Cost Interest Cost Actual Return Contrilbutions Benefits Paid by Offsite Ending Balance Summary Pension Expense 2021 Beginning Balance Prior Service Cost Service Cost Interest Cost Actual Return Amortization PSC Contributions Benefits Paid by Offsite Ending Balance Summary i 2022 ; Beginning Balance 3 + Service Cost ) Interest Cost I Actual Return :Unexpected Loss 3 Amortization PSC + Liability Increase Prior Service Cost Service Cost Interest Cost Actual Return Amortization PSC Contributions Benefits Paid by Offsite Ending Balance Summary Beginning Balance 1 7 Service Cost ) Interest Cost 1 Actual Return 3. Unexpected Loss 1 Amortization PSC 1 Liability Increase Contributions Benefits Paid by Offsite Ending Balance Summary Beginning Balance Service Cost Interest Cost Actual Return Unexpected Gain Amortization PSC Amortization of Loss Contributions Benefits Paid by Offsite Ending Balance Summary