1. Prepare a 10 column worksheet using an excel spreadsheet format. The worksheet should be in good form. Follow the format of the example worksheet provided for Uptown Cabinet Corp. The list of accounts given in the instructions are the accounts that will be listed in your trial balance columns. These accounts will need to be put in Chart of Account order on your worksheet. Chart of Account order is Asset, Liabilities, Stockholder's Equity, Revenue, and Expenses. You may want to go through and label the accounts before you start your worksheet. The debit and credit columns, of course, must balance. . Make sure you number your adjusting entries on your worksheet as also shown on the example in the adjustment columns. Your income statement and balance sheet columns will not total until you account for the income taxes and net income. 2. Tips to the adjusting entries: You will need to add accounts to prepare some of the adjusting entries. These accounts can be added below the trial balance accounts, just as done in the example. Adjusting entry #1 : Handle the adjusting entry as the example worksheet shows. Beginning inventory is brought over to the adjusted trial balance and income statement columns as debits. Ending inventory is brought over to the income column as a credit and to the balance sheet columns as a debit, Beginning and ending inventory are both listed in the income statement columns because they are both used in the Cost of Good Sold computation when using the periodic inventory system. (Which this company uses.) Ending inventory is also . statement