Complete Myers Home Supply Companys worksheet. In the first worksheet tab, at the bottom of the Excel workbook, is the beginning of a worksheet. You are given the trial balance portion. You need to enter the adjustments below in the adjustment columns and then complete the remainder of the worksheet through the adjusting trial balance columns. 2. After doing the year-end count of inventory, Myers determined that there was $53,200 in ending inventory. 6. The $34,000 in unearned revenue was for orders that were paid for in advance. At year end, 1/2 of the prepaid orders were fulfilled. 7. Wages that have accrued for the year but have not been paid yet totaled $12,000. This should be split evenly between Sales Salaries and Office Salaries. - When completing the adjusted trial balance, all numbers need to be brought over using formulas. In the adjusted trial balance columns, no number should be entered manually. Also the totals of the adjusted trial balance should be formulas using the SUM function. The spreadsheet needs to be set up so if there is a change in one of the adjustments, all balances in the adjusted trial balance will be correct. - When inputting the adjusting entries, the Salaries Payable account is not listed on the trial balance. You need to insert a row below Accounts Payable and add in a row for Salaries Payable. - Be sure that all of the numbers are formatted the same. The numbers should not show any cents. Remember to have a dollar sign on the first number in the column and on the total of the column, just like the trial balance columns. - Use the thick underline border underneath the last item of the column and Use the double underline border underneath the total of the column.

Prepare the multi-step income statement, statement of retained earnings, and the classified balance sheet for Myers Home Supply Company for the year ended December 31, 2020. Each statement should be done on the appropriate Excel spreadsheet tab (worksheet). Make sure each statement is prepared in the proper format with proper headings and proper use of underlines and dollar signs. Each report should use formulas for each of the numbers. The numbers for the reports should be linked to the adjusted trial balance. So each number should be brought over from the adjusted trial balance using a formula. Numbers cannot just be entered manually

Meyer's Home Supply Company Worksheet December 31, 2020 Trail Balance Adjustments Adjusted Trial Balance Account Debit Credit Debit Credit Debit Credit Cash $ 39,000 Accounts Receivable 45,000 Office Supplies 1,300 Prepaid Store Insurance 2,400 Inventory 55,500 Store Equipment 130,000 Accumulated Depreciation - Store Equipment $ 60,000 Office Equipment 88,000 Accumulated Depreciation - Office Equipment 32,500 Accounts Payable 38,300 Unearned Revenue 34,000 Note Payable (Due in 3 years) 50,000 Common Stock 60,000 Retained Earnings 50,700 Dividends 10,000 Sales 885,200 Sales Returns and Allowances 36,000 Cost of Goods Sold 510,000 Advertising Expense 36,000 Depriciation Expense - Office Equipment - Depreciation Expense - Store Equipment - Sales Salaries Expense 78,500 Office Salaries Expense 120,000 Sells Department Rent Expense 32,000 Administration Rent Expense 27,000 Store Insurance Expense -

Office Supplies Expense - $ 1,210,700 $ 1,210,700