The accountant for Vaden Corporation has developed the following information for the

company$$s defined benefit pension plan for $2023$:

Service cost $$570,000$

Actual return on plan assets $325,000$

Annual contribution to the plan $375,000$

Amortization of prior service cost $35,000$

Benefits paid to retirees $165,000$

Settlement rate $6\%$

Expected rate of return on plan assets $5\%$

Balances at January $1,2023$ were Pension Asset$/$Liability of $$300,000($Cr$)$; Projected

Benefit Obligation $-$$$8,050,000($Cr$)$; Plan Assets $-$ $$7,750,000($Dr$)$; Other

Comprehensive Income $-$ Prior Service Costs $-$ $$165,000($Dr$).$

Required:

a$.$ Complete the pension work sheet in Excel for $2023.$

b$.$ Prepare the journal entry to reflect the accounting for the company$$s pension plan for

the year ending December $31,2023.$

Show formulas in excel format