The trial balance for Andrew's Slabs as at 30 June 2017 was: Trial Balance Details Cash at Bank Accounts receivable Inventory Equipment Debit $ Credit $ 10,700 52,000 20,000 45,000 Accumulated depreciation on equipment 10,000 Vehicles 50,000 Accumulated depreciation motor vehicles 6,250 Land 27,500 Accounts payable 25,000 Loan 85,000 Capital 181,430 Sales revenue 120,000 Interest revenue 2,000 Cost of goods sold 86,250 Salaries expense 30,000 Rates expense 1,500 800 Stationery expense Advertising expense Interest expense 1,900 300 Motor Vehicle expense 780 Repairs Expense 2,500 Insurance Expense Total 450 329,680 329,680 Complete the following activities: 1. Record the following balance day adjustments in the general journal below. Show your workings. a) Depreciation of equipment 10% using the straight-line method b) Depreciation of vehicles 12.5% using the diminishing balance method c) Rates paid in advance $600 d) Salaries owing $3,500 e) Interest revenue earned but not received $1,300 f) Create an allowance for doubtful debts equal to 5% of accounts receivable. g) Physical stocktake determined inventory at end 30 June 2017 was $18,800 4. Create an Excel Workbook. After the meeting, prepare each of the following as a separate Worksheet: a) Adjusted trial balance at 30 June 2017. b) Profit and loss statement for the year ending 30 June 2017 c) Balance sheet as at 30 June 2017