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:

Account Title			Opening Balance
Accounts Payable			13,400
Accounts Receivable			4,500
Bank Loan			0
Cash			34,000
Equipment			12,000
Hill, Capital			26,100
Prepaid Insurance			0
Unearned Service Revenue			11,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 .