The unadjusted trial balance of Trendy Consulting Pty Ltd is as follows: Credit TRENDY CONSULTING PTY LTD Unadjusted Trial Balance as at 30 June 2020 Account Debit Cash at bank $ 22 070 Office supplies 7 260 GST Receivable 1 400 Prepaid insurance 1 725 Office equipment 92 800 Accumulated depreciation GST Payable Bank loan payable Share capital Retained earnings Services revenue Salaries expense 83 250 Advertising expense 2 450 Repairs expense 2 160 Sundry expense 7 520 Electricity expense 4 405 Motor vehicle running expenses 8 790 Telephone expense 2 620 Interest expense 1 350 $ 27 840 2 460 50 000 10 000 12 500 135 000 237 800 237 800 The following additional information should be taken into account: 1. Salaries accrued but unrecorded on 30 June 2020 were $2,690 2. An electricity bill has been received but not yet recorded of $990 (GST included) 3. Insurance unexpired at 30 June 2020 was $450. 4. Office equipment is to be depreciated using straight line depeciation. The useful life is 4 years and it has a residual value of $18,560. 5. Office supplies unused at 30 June amounted to $1,540 6. On 30 June, the Directors declared a Dividend to be paid to shareholders in July, 2020 totalling $5 000. 7. Interest to be accrued on the bank loan at 30 June is $210. Required: Prepare a 10-column worksheet for the year ended 30 June 2020