Can you make a 10 column worksheet, income statement and balance sheet and ledger accounts 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
Additional Information: Bank loan interest rates (% per year) 11 Motor vehicle useful life (years) 3 Motor vehicle serap value ($) 2,009 Insurance paid for (months) Rent paid for (months) Hair styling equipment useful life (years) Hair styling equipment scrap value ($) 3,143 Closing stock of hair styling supplies on 30/6 (S) 768 Staff work a 14 day fortnight and are paid on the 15th day.
$11,034 $21,713 S36,827 $8,636 $25,472 $17,660 $855 ?
Transactions: Date Description 1-Jun Paid General Insurance 3-Jun Rent of Business Premises 8-Jun Facial services fees - Cash 13-Jun Receive Payment from Account Customers 14-Jun Sundry Expenses 16-Jun Purchase books and magazines 17-Jun Manicure services - Cash 18-Jun Hair styling fees - Account 20-Jun Cash Withdrawals by Owner 23-Jun Advertising Expense - Account 25-Jun Manicure services - Cash 25-Jun Hair styling fees - Cash 28-Jun Facial services fees - Cash 29-Jun Staff Wages
Amount $2,982 $3,998 $1,378 $1,448 $226 $100 $1,120 $1,595 $1,055 $1,507 $1,099 $1,358 $1,435 $2,282
Date Description 3-Jun Facial services fees - Cash 5-Jun Hair styling fees - Account 13-Jun Advertising Expense - Cash 13-Jun Manicure services - Account 15-Jun Staff Wages 17-Jun Payment to Account Payable 18-Jun Purchase hair styling supplies - account 19-Jun Motor Vehicle Expenses 22-Jun Manicure services - Account 24-Jun Additional cash contributed by owner 25-Jun Payment to Account Payable
Amount $1,414 $1,824 $699 $1,228 $2,282 $762 $763 $499 $1,170 $2,549 $896 $1,020 $1,110
29-Jun Hair styling fees - Cash
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