Required information Problem 17-16 Comprehensive-reporting a pension plan; pension spreadsheet; determine changes in balances; two years [LO17-3, 17-4, 17-5, 17-6, 17-7, 17-8] [The following information applies to the questions displayed below.) Actuary and trustee reports indicate the following changes in the PBO and plan assets of Lakeside Cable during 2018: Prior service cost at Jan. 1, 2018, from plan amendment at the beginning of 2016 (amortization: $6 million per year) Net loss-pensions at Jan.1, 2018 (previous losses exceeded previous gains) Average remaining service life of the active employee group Actuary's discount rate $42 million $ 60 million 10 years 8% ($ in millions) PBO Plan Assets $ 200 15 Beginning of 2018 Service cost Interest cost, 8% Loss (gain) on PBO Less: Retiree benefits End of 2018 $400 Beginning of 2018 58 Return on plan assets, 32 7.5% (10% expected) (3) Cash contributions (37) Less: Retiree benefits $450 End of 2018 72 (37) $250 Problem 17-16 Part 3 3. Prepare a pension spreadsheet to assist you in determining end of 2018 balances in the PBO, plan assets, prior service cost-AOCI, the net loss-AOCI, and the pension liability. (Enter your answers in millions (.e., 10,000,000 should be entered as 10). Enter credit amounts with a minus sign and debit amounts with a positive sign.) ($ in millions) PBO Plan Assets Prior Service Cost-AOCI Net Loss -AOCI Pension Expense Cash Net Pension (Liability) Asset Bal., Jan. 1, 2018 Service cost Interest cost, 8% Expected return on assets Loss on assets Amortization of: D D D D D D Prior service cost-AOCI Net loss-AOCI Gain on PBO Cash contributions Retiree benefits Bal., Dec. 31, 2018 00000