Make a 10 Column Worksheet

9 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 (S) Insurance paid for (months) Rent paid for months) Medical equipment useful life (years) Medical equipment scrap value (8) Closing stock of office supplies on 30/6 (S) Closing stock of medical supplies on 30/6 ($) Staff work a 14 day fortnight and are paid on the 15th day. 2,908 3 3 3 2,250 502 1,997 Transactions: Date 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 $381 $2,942 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 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