Please help! Due soon!

Actuary and trustee reports indicate the following changes in the PBO and plan assets of Lakeside Cable during 2024:

Prior service cost at January 1, 2024, from plan amendment at the beginning of 2022 (amortization: $7 million per year)	$ 52	million
Net loss-pensions at January 1, 2024 (previous losses exceeded previous gains)	$ 65	million
Average remaining service life of the active employee group	10	years
Actuarys discount rate	8	%

($ in millions)

	PBO		Plan Assets
Beginning of 2024	$ 550	Beginning of 2024	$400
Service cost	68
Interest cost, 8%	44	Return on plan assets, 7.5% (10% expected)	30
Loss (gain) on PBO	(3)	Cash contributions	79
Less: Retiree benefits	(59)	Less: Retiree benefits	(59)
End of 2024	$ 600	End of 2024	$450

Assume the following actuary and trustee reports indicating changes in the PBO and plan assets of Lakeside Cable during 2025:

($ in millions)

	PBO		Plan Assets
Beginning of 2025	$ 600	Beginning of 2025	$ 450
Service cost	58
Interest cost, 8%	48	Return on plan assets, 18% (10% expected)	81
Loss (gain) on PBO	5	Cash contributions	50
Less: Retiree benefits	(36)	Less: Retiree benefits	(36)
End of 2025	$ 675	End of 2025	$ 545

7. Prepare a pension spreadsheet to assist you in determining end of 2025 balances in the PBO, plan assets, prior service cost-AOCI, the net loss-AOCl, and the pension liability. Note: Enter your answers in millions rounded to 1 decimal place (i.e., 5,500,000 should be entered as 5.5 ). Enter credit amounts with a minus sign and debit amounts with a positive sign