Question: Hi, I need help with a homework question please. We have to fill out the remaining spaces in the excel spreadsheet. The Question is in
Hi, I need help with a homework question please. We have to fill out the remaining spaces in the excel spreadsheet. The Question is in shown below. Thank you.


Exercise 17-36 Preparing a Pension Work Sheet The following information relates to the defined benefit pension plan of Mascare Company. Grenit le ded January 1, 2015: WA abolisq map Led sWOPBO . FVPF . . . . $9,000 $11,000 Expected return on plan assets ..... 8% Obligation discount rate......... 10% Ingo One eshelse ate For the year ended December 31, 2015: Bise bris goodin the Service cost ......... $1,200 Benefit payments to retirees ........ . . . . . 500 Contributions to pension fund. 100 Actual return on plan assets . ....... . 1,500 Prepare a pension work sheet for Mascare Company for 2015. ElavonA17-36 Name: Enter the appropriate amounts/formulas in the blue-shaded cells. For the purposes of this work sheet, positive amounts are debits and negative amounts are credits. The word \"Wrong\" will appear to the left of incorrect entries. MASCARE COMPANY Pension Work Sheet for 2015 Financial Statement Accounts Net Pension Expense Balance, January 1, 2015 (a) Service cost (b) Interest cost (c) Actual return on assets (d) Benefits paid (e) Deferred gain (f) Pension contribution Balance, December 31, 2015 Cash Prepaid/ Accrued Pension Cost Detailed Accounts Accumulated Other Comprehensive Income 0 Pension Asset/Liability Fair Projected Value of Benefit Pension Obligation Items (9,000) 11,000 1,200 (1,500) 500 (100) (100) 100 AOCI Deferred Pension (Gain)/ Loss 0
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
