Hello, I was wondering if a tutor can help me with this pension plan worksheet I have to do for my accounting class. I have already completed most of the chart on excel and uploaded the file, I am just confused about what to put for the Net Gain and Loss on PBO. Can anyone help?

()s indicate Prior credits' debits Plan Service Net otherwise Assets PBO Cost Gain Balance, 1/1 $ 1,500,000.00 $(2,100,000.00) $ 150,000.00 Service cost $ (300,000.00) Interest cost 8% $ (168,000.00) EROA 10 $ 150,000.00 AROA 8% Actual-Expected Return on Assets -2% $ (30,000.00) $ 30,000.00 Amortization: Prior service cost 10 $ (15,000.00) Net Gain 10 Loss on PBO Prior service cost Cash funding $ 450,000.00 Retiree benefits $ (225,000.00) $ 225,000.00 balance, 12/31 Pension Expense Cash $ 300,000.00 $ 168,000.00 $(150,000.00) Net Pension (Liability)/ Asset $(600,000.00) $(300,000.00) $(168,000.00) $ 150,000.00 $ (30,000.00) $ 15,000.00 $(450,000.00) 450000 $(225,000.00) f. / . I; I", a? [7 if; - L 4" V '1 . . - . V\\ \"-11, , (Z) L\\,, _/?/ '5 (/IC(}c 1\" fix\" V \"C' ' L 7 f ' /ZL( ./ *\"\"/' / ;/ . .41 M . Acctg334 Lecture Note CWLSOAmCBA. SDSU S2017@GJoh J C \"i Irw/ t? /~ ~ (\"i " The Round Rock Company has prodded the following information pgrtalnlng to ,, f .: its dened benet plan: (- { \\1 t n r: m 1 13C gm , ,W' o The projected benet obligation was $2,100,000 on January 1, 2016. 0 Recognition of prior service cost during 2016 was $150, 000. 0 Service cost for 2016 was $300,000. 0 Plan assets on January 1, 2016 totaled $1,500,000. 0 The expected return on plan assets was 10%. o The actual return on plan assets was 8%. o The settlement/discount rate was 8%. o The December 31, 2016 contribution to the plan asset fund was $450,000. 0 Benets paid to retirees during 2016 totaled $225,000. Required: 1. Determine Round Rock's pension expense for 2016. 2. Determine the projected benet obligation (PBO) as of December 31, 2016. 3. Prepare the journal entry to record pension expense and the funding for the year ended December 31, 2016. 4. Determine the balance of the pension plan assets. 5. What should be reported on the December 31, 2016 balance sheet with respect to the funded status of the dened benet pension plan