1. Net income, $137,400 PR 4-1A SHOW ME HOW EXCEL TEMPLATE Beacons Company maintains and repairs warning lights, such as there found on radiocomberi Nighthouses, Beacons Company prepared the wingend or period preadsheet at December 31, O 1.2.3 20YS, the end of the fiscal year Beacons Company End-of-Period Spreadsheet For the Year Ended December 31, 2015 Unadjusted Adjusted Account Title Trial Balance Adjustments Trial Balance Dr. Dr. CA 8 Cash 10.800 Accounts Receivable 10.000 10 Prepaid Insurance 38,900 9,100 48.000 4,200 11 Supplies 3,150 1.000 2.730 12 Land 2,180 550 98.000 30.000 13 Building 400,000 400.000 14 Accum. Depr. --Building 205,300 12.000 15 Equipment 217.00 101.000 101.000 16 Accum. Dopr. -Equipment 85,100 4,000 89,900 17 Accounts Payable 15,700 15,700 18 Salaries & Wages Payable 5.000 5.000 19 Unearned Rent 2,100 1.000 20 Common Stock 75,000 75,000 21 Retained Earnings 128,100 128,100 22 Dividends 10,000 10,000 23 Fees Earned 363,700 9.100 372,800 24 Rent Revenue 1,100 25 Salaries & Wages Expense 158,100 5,000 163,100 26 Advertising Expense 21,700 21,700 27 Utilities Expense 16,400 16,400 28 Depr. Exp. --Building 12,000 12,000 29 Repairs Expense 8,850 8,850 30 Depr. Exp.-Equipment 4,800 4,800 3,150 3,150 31 Insurance Expense 2,180 2,180 32 Supplies Expense 4,320 33 Misc. Expense 4,320 875.000 875,000 37330 37330 34 905,900 905.900 35 1,100 1,100 ter 4 The Accounting Cycle Instructions 1. Prepare an income statement for the year ended December 31, 2045. 2. Prepare a statement of stockholders' equity for the year ended December 31, 2045. During the year, common stock of $25,000 was issued. 3. Prepare a balance sheet as of December 31, 2045. 4. Based upon the end-of-period spreadsheet, journalize the closing entries. 5. Prepare a post-closing trial balance