Create a:

- 10-column worksheet

- properly classified income statement for the month ended 30 June 2019

- properly classified balance sheet as at 30 June 2

Transcribed Image Text:

The business has the following opening balances: Cash At Bank Account Receivable Motor Vehicle Account Payable Bank Loan (due 2022) Furniture Promotional Material Supplies Capital Transactions: Date Description 1-Jun Paid General Insurance 4-Jun Auction commission - Account 4-Jun Payment to Account Payable 6-Jun Rental commission - Account 8-Jun Receive Payment from Account Customers 9-Jun Rental commission - Account 12-Jun Payment to Account Payable 14-Jun Receive Payment from Account Customers 15-Jun Advertising placement fees - Cash 17-Jun Cash Withdrawals by Owner 20-Jun Advertising placement fees - Account 22-Jun Auction commission - Cash 25-Jun Advertising Expense - Account 29-Jun Staff Wages $14,329 $17,198 $31,774 $8,113 $29,270 $21,488 $546 ? Amount $2,544 $908 $1,093 $1,249 $1,278 $1,402 $906 $1,032 $922 $960 $1,114 $1,871 $1,146 $2,395 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) Furniture useful life (years) Furniture scrap value ($) Closing stock of promotional materials 30/6 ($) Staff work a 14 day fortnight and are paid on the 15th day. Date Description 3-Jun Rent of Business Premises 4-Jun Motor Vehicle Expenses 6-Jun Rental commission - Cash 7-Jun Advertising placement fees - Account 8-Jun Rental commission - Cash 11-Jun Advertising Expense - Cash 12-Jun Advertising placement fees - Cash 15-Jun Staff Wages 16-Jun Auction commission - Cash 18-Jun Auction commission - Account 21-Jun Purchase promotional materials 24-Jun Additional cash contributed by owner 27-Jun Sundry Expenses 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 rental commission, auction commission and advertisement placement 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. 9 ANO+Mmo Amount 2 3,040 3 3 785 $4,038 $382 $1,529 $872 $1,692 $731 $930 $2,395 $1,873 $1,052 $625 $3,771 $294 The business has the following opening balances: Cash At Bank Account Receivable Motor Vehicle Account Payable Bank Loan (due 2022) Furniture Promotional Material Supplies Capital Transactions: Date Description 1-Jun Paid General Insurance 4-Jun Auction commission - Account 4-Jun Payment to Account Payable 6-Jun Rental commission - Account 8-Jun Receive Payment from Account Customers 9-Jun Rental commission - Account 12-Jun Payment to Account Payable 14-Jun Receive Payment from Account Customers 15-Jun Advertising placement fees - Cash 17-Jun Cash Withdrawals by Owner 20-Jun Advertising placement fees - Account 22-Jun Auction commission - Cash 25-Jun Advertising Expense - Account 29-Jun Staff Wages $14,329 $17,198 $31,774 $8,113 $29,270 $21,488 $546 ? Amount $2,544 $908 $1,093 $1,249 $1,278 $1,402 $906 $1,032 $922 $960 $1,114 $1,871 $1,146 $2,395 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) Furniture useful life (years) Furniture scrap value ($) Closing stock of promotional materials 30/6 ($) Staff work a 14 day fortnight and are paid on the 15th day. Date Description 3-Jun Rent of Business Premises 4-Jun Motor Vehicle Expenses 6-Jun Rental commission - Cash 7-Jun Advertising placement fees - Account 8-Jun Rental commission - Cash 11-Jun Advertising Expense - Cash 12-Jun Advertising placement fees - Cash 15-Jun Staff Wages 16-Jun Auction commission - Cash 18-Jun Auction commission - Account 21-Jun Purchase promotional materials 24-Jun Additional cash contributed by owner 27-Jun Sundry Expenses 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 rental commission, auction commission and advertisement placement 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. 9 ANO+Mmo Amount 2 3,040 3 3 785 $4,038 $382 $1,529 $872 $1,692 $731 $930 $2,395 $1,873 $1,052 $625 $3,771 $294