(d) Prepare a trial balance at July 31. CONCORD COMPUTER CONSULTANTS Trial Balances Debit Credit $ $ $ JUNE GUEUEZ, the end UTIS OSTREcentral year concoru computercursurtants post-CUSTI arance was a TOW Credit Debit $5,430 1,320 670 Cash Accounts receivable Supplies Accounts payable Unearned service revenue Common stock Retained earings $400 1.170 3,360 2.490 $7,420 $7,420 1 2 3 3 6 9 The company underwent a major expansion in July, New staff was hired and more financing was obtained. Concord conducted the Following transactions during July 2022, and adjusts its accounts monthly July Purchased equipment, paying $4.000 cash and signing a 2-year note payable for $20,000. The equipment has a 4- year useful life. The note has a 6% interest rate which is payable on the first day of each following month. Issued 19,000 shares of common stock for $47,500 cash. Paid $3,960 cash for a 12-month insurance policy effective July 1. Paid the first 2 (July and August 2022) months' rent for an annual lease of office space for $3,900 per month. Paid $3,600 for supplies. Visited client offices and agreed on the terms of a consulting project. Concord will bill the client, Connor Productions, on the 20th of each month for services performed. Collected $1,320 cash on account from Milani Brothers. This client was billed in June when Concord performed the service. Performed services for Fitzgerald Enterprises. This client paid $1.170 in advance last month. All services relating to this payment are now completed. Paid $400 cash for a utility bill. This related to June utilities that were accrued at the end of June. Met with a new client, Thunder Bay Technologies. Received $13,100 cash in advance for future services to be performed. Paid semi-monthly salaries for $11,200. Performed services worth $30,700 on account and billed customers. Received a bill for $2.400 for advertising services received during July. The amount is not due until August 15. Performed the first phase of the project for Thunder Bay Technologies. Recognized 59.000 of revenue from the cash advance received July 16. Received $15,000 cash from customers billed on July 20. 10 13 14 16 18 20 20 23 27