1. Solid Service has hired you to update the transactions for the month of June. The opening balances of its accounts at May 31, ______ are shown below in an alphabetical order: ( 20 marks )

Account Title	Opening Balance
Accounts Payable	12,400
Accounts Receivable	5,500
Bank Loan	0
Cash	24,000
Equipment	22,000
Hill, Capital	36,100
Prepaid Insurance	0
Unearned Service Revenue	21,000

During June, the business engaged in the following transactions:

1.	Borrowed $15,000 cash from the bank.
2.	Prepaid $3,600 cash for insurance for one year.
3.	Provided services to customers and received $7,500 cash.
4.	Hill withdrew $6,000 cash from the business for personal use.
5.	Received a telephone bill for $400 which will be paid next month.
6.	Paid employee salary with $4,300 cash.
7.	Recognized $300 for one month of prepaid insurance as an expense.
8.	Paid $3,500 cash to reduce the principal portion of the loan.

Required:

Record the opening balances in the T-accounts

Record the transactions from above in the T-accounts

(Make sure to calculate the balance of each account at the end of posting)

Please upload an excel file / word file to show t accounts .