hey guys

I was just needed help with the questions that I have attached. I have also attached the excel template that we are meant to be using.

TAFE) DIGITAL Task 4 5 marks From the following account balances prepare a Trial Balance and determine the missing Capital amount. Trial Balance Particulars $ Cash at bank 7,350 Inventory 12,660 Motor vehicle 35,000 Computers 10,500 Office equipment 9,500 Accounts Receivable Control 18,500 Accounts Payable Control 11,520 GST Receivable 2,525 GST Payable 1,256 Capital Sales 85,730 Cost of Goods Sold 20,400 Rent paid 30,000 Wages 22,500 Add header Task 4: Extract a Trial Balance Trial Balance Particulars Debit Credit Cash at bank Inventory Motor vehicle Computers Office equipment Accounts Receivable Control Accounts Payable Control GST Receivable GST Payable Capital Sales Cost of Goods Sold Rent paid Wages