At January 1, 2012, Beaty Company had plan assets of $290,200 and a projected benefit obligation of the same amount. During 2012, service cost was $32,060, the settlement rate was 10%, actual and expected return on plan assets were $27,000, contributions were $25,090, and benefits paid were $20,300.

Prepare a pension worksheet for Beaty Company for 2012.