Please use 10 column worksheet to solve that problem and i also need income and balance sheet

2.281 The business has the following opening balances: Cash At Bank Account Receivable Motor Vehicle Account Payable Bank Loan due 2022) Gym Equipment Stationery Supplies Capital $13,017 $21,772 538 207 $7.908 $23,803 $24,087 $477 ? 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) Gym equipment useful life (years) Gym equipment scrap value (S) Closing stock of stationery supplies on 30/6 (5) Staff work a 14 day fortnight and are paid on the 15th day. 4 4,581 749 Transactions: Date Description 1-Jun Paid General Insurance 6-Jun Advertising Expense - Account 10-Jun Sundry Expenses 12-Jun Payment to Account Payable 13-Jun Cash Withdrawals by Owner 15-Jun Gym fees - Account 16-Jun Payment to Account Payable 19-Jun Membership fees - Cash 23-Jun Squash fees - Account 24-Jun Advertising Expense - Cash 26-Jun Membership fees - Cash 28-Jun Receive Payment from Account Customers 29-Jun Equipment hiring expense - Account 29-Jun Staff Wages Amount $2,162 $1,064 $373 $1,358 $923 $1,046 $1,207 $2,978 $1,337 $712 $2,234 $1,781 $636 $2,186 Date Description 3-Jun Rent of Business Premises 8-Jun Purchase stationery Supplies 11-Jun Receive Payment from Account Customers 13-Jun Gym fees - Account 15-Jun Staff Wages 16-Jun Squash fees - Cash 18-Jun Equipment hiring expense - Cash 21-Jun Squash fees - Cash 23-Jun Gym fees - Cash 25-Jun Squash fees - Account 26-Jun Additional cash contributed by owner 29-Jun Gym fecs - Cash 29-Jun Motor Vehicle Expenses Amount $3,992 $918 $1,281 $948 $2,186 $2,155 S466 $1,578 $1,235 $1,348 $3,718 $1,643 S425 June. 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 gym fees, squash fees and membership fees. All revenues relate to the month of - 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 2.281 The business has the following opening balances: Cash At Bank Account Receivable Motor Vehicle Account Payable Bank Loan due 2022) Gym Equipment Stationery Supplies Capital $13,017 $21,772 538 207 $7.908 $23,803 $24,087 $477 ? 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) Gym equipment useful life (years) Gym equipment scrap value (S) Closing stock of stationery supplies on 30/6 (5) Staff work a 14 day fortnight and are paid on the 15th day. 4 4,581 749 Transactions: Date Description 1-Jun Paid General Insurance 6-Jun Advertising Expense - Account 10-Jun Sundry Expenses 12-Jun Payment to Account Payable 13-Jun Cash Withdrawals by Owner 15-Jun Gym fees - Account 16-Jun Payment to Account Payable 19-Jun Membership fees - Cash 23-Jun Squash fees - Account 24-Jun Advertising Expense - Cash 26-Jun Membership fees - Cash 28-Jun Receive Payment from Account Customers 29-Jun Equipment hiring expense - Account 29-Jun Staff Wages Amount $2,162 $1,064 $373 $1,358 $923 $1,046 $1,207 $2,978 $1,337 $712 $2,234 $1,781 $636 $2,186 Date Description 3-Jun Rent of Business Premises 8-Jun Purchase stationery Supplies 11-Jun Receive Payment from Account Customers 13-Jun Gym fees - Account 15-Jun Staff Wages 16-Jun Squash fees - Cash 18-Jun Equipment hiring expense - Cash 21-Jun Squash fees - Cash 23-Jun Gym fees - Cash 25-Jun Squash fees - Account 26-Jun Additional cash contributed by owner 29-Jun Gym fecs - Cash 29-Jun Motor Vehicle Expenses Amount $3,992 $918 $1,281 $948 $2,186 $2,155 S466 $1,578 $1,235 $1,348 $3,718 $1,643 S425 June. 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 gym fees, squash fees and membership fees. All revenues relate to the month of - 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