Beale Management has a noncontributory, defined benefit pension plan. On December the end of Beale's fiscal year the following pensionrelated data were available:
Projected Benefit Obligation $ in millions
Balance, January $
Service cost
Interest cost, discount rate,
Gain due to changes in actuarial assumptions in
Pension benefits paid
Balance, December $
Plan Assets $ in millions
Balance, January $
Actual return on plan assets
Expected return on plan assets, $
Cash contributions
Pension benefits paid
Balance, December $
January balances: $ in millions
Pension asset $
Prior service costAOCI amortization $ per year
Net gainAOCI any amortization over years
Required: Prepare a pension spreadsheet to show the relationship among the PBO, plan assets, prior service cost, the net gain, pension expense, and the net pension asset.
