Prepare 10 column worksheet using excel spreadsheet.

List the account in trail balance columns

Number the Adjusting entries on the worksheet

INTERMEDIATE ACCOUNTING 1 CASE STUDY 1 Prepare a work sheet using the account balances taken from the ledger of Simpson Company as of December 31, 1996: (ALL ACCOUNTS HAVE NORMAL BALANCES) $86,000 L 92,800 A Accounts payable Accounts receivable Advertising expense Accumulated depreciation bldg Allowance for bad debts Building Common stock Cash Dividends declared Freight-in Insurance expense Interest expense Interest revenue Inventory (1/1/96) Land Long-term investments Mortgage payable Notes payable, short term Office expense Purchases Purchases discountS Real estate tax expense Retained earnings Salary expense Sales Sales discounts Sales returns Selling expense 8,000 21,000 1,700 210,000 300,000 30,500 8,000 7,000 1,400 3,530 890 69,900 52,000 8,100 29,000 16,000 19,200 347,420 8,100 12,870 9,130 50,200 490,000 16,500 9,600 12,500 2,300 upplies expense djustments on December 31 are required as follows: 1 Ending inventory is $90,610. urchages The allowance for doubtful accounts is to be increased to 3. The building is depreciated on a straight-line basis a balance of $3,500 based on a 20-year useful life. (no salvage value, record one full year) 4. Accrued salaries payable are $4,050 SSupplies on hand are $780 7. Unearned sales revenue should have a balance of $800. 8. Accrued real estate taxes are $700. 9. Accrued interest on the mortgage is $160 10. Income tax expense is estimated to be $3,850