Complete the adjusting entries of this business.

How do you prepare a 10-column worksheet, income statement and balance sheet for this?

Proprietor: Ms. Nicole Coffeur Name: Teenage Style Bag Description: Hair and Beauty Salon The business has the following opening balances: Cash At Bank Account Receivable Motor Vehicle Account Payable Bank Loan (due 2022) Hair Styling Equipment Hair Styling Supplies Capital $12.201 $19.099 $31.025 $7.559 $25.142 $15,387 $791 11 3 5.176 2 Additional Information: Bank loan interest rates (% per year) Motor vehicle useful life (years) Motor vehicle scrap value ($) Insurance paid for months) Rent paid for months) Hair styling equipment useful life (years) Hair styling equipment scrap value (8) Closing stock of hair styling supplies on 30/6 ($) Staff work a 14 day fortnight and are paid on the 15th day. 3 3.221 480 Amount $1.104 $1.860 Transactions: Date Description 1-Jun Paid General Insurance 3-Jun Rent of Business Premises 6-Jun Manicure services - Cash 9-Jun Manicure services - Cash 11-Jun Motor Vehicle Expenses 14-Jun Advertising Expense - Account 14-Jun Sundry Expenses 15-Jun Purchase hair styling supplies - account 17-Jun Manicure services - Account 18-Jun Hair styling fees - Cash 19-Jun Payment to Account Payable 24-Jun Advertising Expense - Cash 24-Jun Receive Payment from Account Customers 29-Jun Staff Wages Amount $2,826 $3.859 $987 $847 $574 $1.524 $438 $601 $1.147 $1.364 $879 $618 $1.634 $2.614 Date Description 3-Jun Hair styling fees - Cash 4-Jun Hair styling fees - Account 6-Jun Receive Payment from Account Customers 9-Jun Manicure services - Account 11-Jun Payment to Account Payable 14-Jun Cash Withdrawals by Owner 14-Jun Hair styling fees - Account 15-Jun Staff Wages 17-Jun Purchase books and magazines 18-Jun Facial services fees - Cash 20-Jun Facial services fees - Cash 24-Jun Additional cash contributed by owner 28-Jun Facial services fees - Cash $1.250 $1,342 $567 $986 $1.757 $2.614 $100 $1.573 $1.380 $4.319 $1.741 Comments: - Assume that this assignment involves an existing business that was purchased by the new owner on 1 June 2019. - Note the list of transactions is in date order, left to right, line by line. - Use three separate ledger accounts for revenue, namely hair styling services, manicure services and facial services. All revenues relate to the month of June. - Transactions involve cash unless specified as Account. - Record payments for rent and insurance in prepaid accounts initially. - Information relevant to complete adjusting entries can be found in the top right section of this page. - The periods to which the rent and insurance apply commence on 1 June. - Round your calculations to the nearest dollar