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.

($ in millions PBO	Plan Assests	Prior Service Cost - AOCI	Net Gain - AOCI	Pension Expense	Net Pension (liabilty)/Asset
Balance Jan 1 2016
Service Cost
Interest cost, 5%
Expected return on assets
Adjust for:
Loss on assets
Amortization of:
Prior service cost
Net gain
Gain on PBO
Cash funding
Retiree benefits
Balance , Dec 31, 2016	$	$	$	$	$

Beale Management has a noncontributory, defined benefit pension plan. On December 31, 2018 (the end of Beale's fiscal year), the following pension-related data were available:

Projected Benefit Obligation	($ in millions)
Balance, January 1, 2018	$	480
Service cost		82
Interest cost, discount rate, 5%		24
Gain due to changes in actuarial assumptions in 2016		(10	)
Pension benefits paid		(40	)
Balance, December 31, 2018	$	536

Plan Assets	($ in millions)
Balance, January 1, 2018	$	500
Actual return on plan assets		40
(Expected return on plan assets, $45)
Cash contributions		70
Pension benefits paid		(40	)
Balance, December 31, 2016	$	570

January 1, 2018, balances:	($ in millions)
Pension asset	$	20
Prior service costAOCI (amortization $8 per year)		48
Net gainAOCI (any amortization over 15 years)		80