'

Make a 10 column worksheet in this format. Thank you

The business has the following opening balances: Cash At Bank Account Receivable Motor Vehicle Account Payable Bank Loan (due 2022) Medical Equipment Office Supplies Medical Supplies Capital $18,078 $15,510 $38,102 $8,037 $24.853 $35,992 $684 $1,539 ? 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) Medical equipment useful life (years) Medical equipment scrap value ($) Closing stock of office supplies on 30/6 ($) Closing stock of medical supplies on 30/6 ($) Staff work a 14 day fortnight and are paid on the 15th day. 9 4 2,908 3 3 2,250 502 1,997 Date Transactions: Description 1-Jun Paid General Insurance 3-Jun Rent of Business Premises 5-Jun Advertising Expense - Account 8-Jun Cash Withdrawals by Owner 11-Jun Pet consultation - Cash 15-Jun Vaccination - Account 17-Jun Vaccination - Account 21-Jun Pet consultation - Cash 22-Jun Payment to Account Payable 23-Jun Payment to Account Payable 24-Jun Pet consultation - Account 25-Jun Desexing - Cash 26-Jun Sundry Expenses 29-Jun Staff Wages Amount $2,001 $3,534 $1,146 $841 $1,501 $806 $1,143 $1,902 $671 $1,301 $1,336 $2,260 Date Description 1-Jun Pet consultation - Account 3-Jun Receive Payment from Account Customers 6-Jun Desexing - Cash 9-Jun Receive Payment from Account Customers 14-Jun Purchase office supplies - Account 15-Jun Staff Wages 17-Jun Motor Vehicle Expenses 21-Jun Purchase medical supplies - Account 22-Jun Vaccination - Cash 24-Jun Vaccination - Cash 24-Jun Additional cash contributed by owner 25-Jun Purchase medical supplies - Cash 29-Jun Advertising Expense - Cash Amount $1,463 $1,698 $2,385 $1,077 $963 $2,942 $238 $652 $1,480 $1,252 $3,866 $316 $792 $381 $2,942 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 pet consultation, vaccination and desexing fees. 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. Date Account Title 1-Jun Prepaid Insurance Cash Debit Credit 2,001 2,001 963 1,301 14-Jun Office Supplies Accounts Payable 23-Jun Account Payable Cash 963 1,301 1,463 806 1,252 *Account Receivable Pet consultation 15-Jun Accounts Receivable Vaccination 24-Jun Cash * Vaccination 1,463 806 1,252 3,534 2,942 1,336 3-Jun Prepaid Rent Cash Wage expense Cash Accounts Receivable Pet Consultation 3,534 2,942 1,336 1,698 1,143 3,866 Cash Accounts Receivable 17-Jun Accounts Receivable Vaccination Cash Owner Capital 1,698 1,143 3,866 1,146 238 2,260 5-Jun Advertising Expense Accounts Payable 17-Jun Motor Vehicle Exp Cash 25-Jun Cash * Desexing 1,146 238 2,260 2,385 1,902 316 6-Jun Cash Desexing 21-Jun Cash * Pet Consultation Medical Supplies Cash 2,385 1,902 316 841 652 381 8-Jun Owner Drawings Cash Medical Supplies Accounts Payable 26-Jun Sundry Expenses Cash 841 652 381 1,077 671 792 9-Jun Cash Account Receivable 22-Jun Account Payable Cash 29-Jun Advertising Expense Cash 1,077 671 792 1,501 Cash * 1,480 2,942 11-Jun Cash Pet Consultation Wages Expense Cash 1,501 Vaccination 1,480 2,942 Account Unadjusted Trial Baland Debit Credit Adjustments Debit Credit Adjusted Trial Balance Debit Credit Income Statement Debit Credit Balance Sheet Debit Credit Cash at Bank Account Receivable Motor Vehicle Prepaid Rent Prepaid Insurnace Office Supplies Medical Supplies Medical Equipment Acc. Depn. - Medical equipment Acc. Depn. - Motor Vehicle Accounts payable Wages Payable Interest Payable Bank Loan (due 2022) Capital Owner Drawing Vaccination Service fees Pet Consultation Service fees Desexing Service fees Advertising expense Books & Magazines Depn. Exp - medical equipment Depreication exp-motor vehicle Office Supplies expense Insunrace expense Interest Expense Motor Vehicle expense Rent expense Sundry Expense Medical Supplies Expense Wages expesne Profit/Loss Totals