Prepare  a 10-column worksheet  

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 Transactions: Date 1-Jun Paid General Insurance 3-Jun Rent of Business Premises 4-Jun Vaccination - Cash 10-Jun Payment to Account Payable 13-Jun Pet consultation - Account 13-Jun Sundry Expenses 15-Jun Desexing - Cash 16-Jun Receive Payment from Account Customers 17-Jun Vaccination - Account Description 18-Jun Cash Withdrawals by Owner 20-Jun Pet consultation - Account 22-Jun Purchase office supplies - Account 24-Jun Receive Payment from Account Customers 29-Jun Staff Wages $15,153 $18,006 $37,104 $7,325 $23,792 $35,347 $687 $1,723 ? Amount $2,807 $3,845 $1,271 $1,436 $1,421 $594 $2,317 $1,652 $1,104 $936 $1,127 $905 $1,697 $2,529 Additional Information: Bank loan interest rates (% per year) Motor vehicle useful life (years) Motor vehicle scrap value (S) Insurance paid for (months) Rent paid for (months) Medical equipment useful life (years) Medical equipment scrap value (S) Closing stock of office supplies on 30/6 (S) Closing stock of medical supplies on 30/6 (S) Staff work a 14 day fortnight and are paid on the 15th day. Description Date 3-Jun Pet consultation - Cash 4-Jun Purchase medical supplies - Account 5-Jun Vaccination - Account 13-Jun Advertising Expense - Cash 13-Jun Pet consultation - Cash 15-Jun Staff Wages 15-Jun Desexing - Cash 17-Jun Purchase medical supplies - Cash 18-Jun Advertising Expense - Account 18-Jun Motor Vehicle Expenses 22-Jun Payment to Account Payable 23-Jun Additional cash contributed by owner 25-Jun Vaccination - Cash 4,528 3 3 3 3,821 942 2,351 Amount $1,877 $538 $1,197 $715 $2,383 $2,529 $2,984 $400 $1,501 $306 $1,460 $2,926 $1,117