This is a little lengthy, but I know there are similar solutions online. I need 100% sure answers, otherwise the excel sheet wont accept the answers. I need the tables done in the format I am going to post under the photo of the question. Need this done ASAP plz. Thanks in advance.

FORMAT OF ALL SPREADSHEET:

PR 4-1A Financial Statements and Closing Entries Obj. 1, 2, 3 Beacons Company maintains and repairs warning lights, such as those found on radio towers and lighthouses. Beacons Company prepared the following end-of-period spreadsheet at December 31, 2045, the end of the fiscal year: F G TBTC D E Beacons Company End-of-Period Spreadsheet For the Year Ended December 31, 2045 Unadjusted Trial Balance Adjustments Dr. Cr. Dr. Cr. Adjusted Trial Balance Dr. Cr. 6 Account Title 9,100 10,800 38,900 4,200 2,730 98,000 400,000 3,150 2,180 10.800 48,000 1,050 550 98,000 400,000 205,300 12,000 217,300 101,000 101,000 4,800 85,100 15,700 5,000 8 Cash 9 Accounts Receivable 10 Prepaid Insurance 11 Supplies 12 Land 13 Building 14 Accum. Depr.Building 15 Equipment 16 Accum. Depr.-Equipment 17 Accounts Payable 18 Salaries & Wages Payable 19 Uneamed Rent 20 Common Stock 21 Retained Earnings 22 Dividends 23 Fees Earned 24 Rent Revenue 25 Salaries & Wages Expense 26 Advertising Expense 27 Utilities Expense 28 Depr. Exp.-Building 29 Repairs Expense 30 Depr. Exp.-Equipment 31 Insurance Expense 32 Supplies Expense 33 Misc. Expense 89,900 15,700 5,000 1,000 75,000 128,100 1,100 2,100 75,000 128, 100 10,000 10,000 363.700 9,100 1,100 372,800 1,100 5,000 158, 100 21,700 16,400 12,000 8,850 163.100 21,700 16,400 12,000 8,850 4,800 3,150 2,180 4,320 905,900 4,800 3,150 2,180 34 4,320 875.000 875.000 37,330 37,330 905,900 35 Instructions 1. Prepare an income statement for the year ended December 31, 2045. Answer Check Figure: Net income, $137,400 2. Prepare a statement of stockholders' equity for the year ended December 31, 20Y5. 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. Beacons Company Income Statement For the Year Ended December 31, 2045 Revenues: Total revenues Expenses: Total expenses Net income (loss) Total Beacons Company Statement of Stockholders' Equity For the Year Ended December 31, 2045 Common Retained Stock Earnings Balances, January 1, 2045 Issued common stock Net income Dividends Balances, December 31, 2045 Beacons Company Balance Sheet December 31, 2045 Assets Current assets: Total current assets Property, plant, and equipment: Book value - building Book value-equipment Total property, plant, and equipment Total assets Liabilities Current liabilities: Total liabilities Stockholders' Equity Total stockholders' equity Total liabilities and stockholders' equity JOURNAL Debit Credit Date 20Y5 Dec. 31 Description Closing Entries Miscellaneous Expense 31 Beacons Company Post-Closing Trial Balance December 31, 2045 Debit Balances Credit Balances Cash Accounts Receivable Prepaid Insurance Supplies Land Building Accumulated Depreciation - Building Equipment Accumulated Depreciation - Equipment Accounts Payable Salaries & Wages Payable Uneamed Rent Common Stock Retained Eamings