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

Proprietor: Ms. Nicole Coffeur Name: Teenage Style Bag Description: Hair and Beauty Salon 8 2 5,220 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,533 $21,608 $31,009 $8,539 $21,754 $17,286 $711 ? 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 ($) Closing stock of hair styling supplies on 30/6 ($) Staff work a 14 day fortnight and are paid on the 15th day. 2 3,438 727 Transactions: Date Description 1-Jun Sundry Expenses 2-Jun Manicure services - Account 4-Jun Receive Payment from Account Customers 6-Jun Hair styling fees - Account 6-Jun Cash Withdrawals by Owner 8-Jun Purchase hair styling supplies - account 9-Jun Hair styling fees - Cash 11-Jun Manicure services - Account 14-Jun Hair styling fees - Account 16-Jun Purchase books and magazines 21-Jun Facial services fees - Cash 21-Jun Manicure services - Cash 23-Jun Receive Payment from Account Customers 29-Jun Staff Wages Amount $541 $1,106 $1,203 $1,952 $851 $956 $1,174 $1,215 $1,647 $100 $1,413 $1,103 $1,281 $2,556 Date Description 1-Jun Paid General Insurance 3-Jun Rent of Business Premises 4-Jun Payment to Account Payable 6-Jun Hair styling fees - Cash 7-Jun Manicure services - Cash 8-Jun Advertising Expense - Cash 9-Jun Advertising Expense - Account 11-Jun Facial services fees - Cash 15-Jun Staff Wages 18-Jun Facial services fees - Cash 21-Jun Motor Vehicle Expenses 23-Jun Payment to Account Payable 25-Jun Additional cash contributed by owner Amount $2,846 $3,257 $860 $1,385 $1,041 $696 $1,572 $1,791 $2,556 $1,513 $480 $952 $2,774 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 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