I need to do a 10-column worksheet

Account	Unadjusted		Adjustments		Adjusted		Income Statement		Balance Sheet
	DR	CR	DR	CR	DR	CR	DR	CR	DR	CR
Subtotals
						Net Income
						Totals

Required:

Complete a 10-column worksheet for your business (template on D2L).

Complete an Income Statement for your business (in MS word).

Complete a Balance Sheet for your business (in MS word).

Submit all three statements above before the due date (as shown in D2L drop-box). Insert the number of your key on the 10-column worksheet so that I can match your answer with the solution.

Check that you have done the following before submitting your assignment.

You have treated the rent and insurance before adjustments as prepaid expenses (i.e., assets rather than as expenses).

Your adjustments (e.g., depreciation) are for one month only and not for the whole year.

You have included two days of accrued wages as an adjustment.

All individual amounts in the Income Statement and Balance Sheet exactly match their corresponding amounts in the worksheet (e.g., net income).

All amounts in the worksheet, Income Statement and Balance Sheet are rounded to the nearest dollar.

You have not included $ signs in your worksheet.

The worksheet fits on one page.

Your name is showing on each page (as a header).

Your project number is showing on your excel spreadsheet.

Your assignment/project is stapled.

Indiana University of Pennsyvania Department of Accounting Assignment, Dr Tickell ACCT304- Assignment Copitat Amount $248 Date Description ans action Proprietor: Ms. Yuni Verse ral Description: Gymnasiu The business has the following opening balances: Account Receivable 1-Jun Sundry Expenses 2-Jun Paid General Insurance 3-Jun Equipment hiring expense - Cash 4-Jun Motor Vehicle Expenses 4-Jun Rent of Business Premises 5-Jun Gym fees - Cash S4,445 $1,581 Asset TCash At Bank S13,373 5-Jun Squash fes-Account $1,914 Dr ash 6-Jun Squas 6-Jun Cash Withdrawalsb Motor Vehicle S35,214 $511 $435 quipiment hiring expense - Account Bank Loan (due 2010) $1,300 19,151 8-Jun Staff Wages 9-Jun Purchase stationery Supplies 0-Jun Motor Vehicle Expenses 11-Jun Cash Withdrawals by Owner 13-Jun Gym fees - Account 15-Jun Squash fces- Cash 15-Jun Sundry Expenses 15-Jun Staff Wages 16-Jun Payment to Account Payable 16-Jun Receive Payment from Account Customers 18-Jun Payment to Account Payable 18-Jun Advertising Expense - Account 18-Jun Advertising Expense - Cash 19-Jun Squash foes - Cash 19-Jun Purchase stationery Supplies 20-Jun Equipment hiring expensc - Account 20-Jun Gym fees - Account 21-Jun Squash fees - Account 21-Jun Receive Payment from Account Customers 22-Jun Staff Wages 23-Jun Additional cash contributed by owner 25-Jun Membership fees-Cash 25-Jun Advertising Expense- Cash 25-Jun Membership fees - Cash 27-Jun Gym fees - Cash 29-Jun Staff Wages 29-Jun Advertising Expense - Account ssets Gym Equipment tationery Supplies $256 $479 $987 opmg Additional Information: Bank loan interest rates (% per year) 5208 S1,300 $626 Motor vehicle useful life (years) Motor vehicle scrap value (S) austmen 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 (S) $493 602 $2,227 $451 Comment This business was purchased on I June You are required to prepare a general joumal entry to incorporate the opening balances into the current period, including the balancing Capital $1,032 $1,375 $1282 $1,300 $3,223 - You will need to refer to the Additional Information section for your Balance Day Adjustments. S2,185 The rent and insurance period start on I June. S314 $2,117 $1,554 -Show three types of revenue, namely gym fees, squash fees and membership fees. All revenues received were for the month of June. -Unless otherwise indicated, all transactions are on a cash basis. Use one general Account Receivable 20 for all debtors and one general Account Payable for all creditors. - Your B/S should show asset and liability divided into current and non-current. Staff work a 7-day week and are paid on the 8th day Indiana University of Pennsyvania Department of Accounting Assignment, Dr Tickell ACCT304- Assignment Copitat Amount $248 Date Description ans action Proprietor: Ms. Yuni Verse ral Description: Gymnasiu The business has the following opening balances: Account Receivable 1-Jun Sundry Expenses 2-Jun Paid General Insurance 3-Jun Equipment hiring expense - Cash 4-Jun Motor Vehicle Expenses 4-Jun Rent of Business Premises 5-Jun Gym fees - Cash S4,445 $1,581 Asset TCash At Bank S13,373 5-Jun Squash fes-Account $1,914 Dr ash 6-Jun Squas 6-Jun Cash Withdrawalsb Motor Vehicle S35,214 $511 $435 quipiment hiring expense - Account Bank Loan (due 2010) $1,300 19,151 8-Jun Staff Wages 9-Jun Purchase stationery Supplies 0-Jun Motor Vehicle Expenses 11-Jun Cash Withdrawals by Owner 13-Jun Gym fees - Account 15-Jun Squash fces- Cash 15-Jun Sundry Expenses 15-Jun Staff Wages 16-Jun Payment to Account Payable 16-Jun Receive Payment from Account Customers 18-Jun Payment to Account Payable 18-Jun Advertising Expense - Account 18-Jun Advertising Expense - Cash 19-Jun Squash foes - Cash 19-Jun Purchase stationery Supplies 20-Jun Equipment hiring expensc - Account 20-Jun Gym fees - Account 21-Jun Squash fees - Account 21-Jun Receive Payment from Account Customers 22-Jun Staff Wages 23-Jun Additional cash contributed by owner 25-Jun Membership fees-Cash 25-Jun Advertising Expense- Cash 25-Jun Membership fees - Cash 27-Jun Gym fees - Cash 29-Jun Staff Wages 29-Jun Advertising Expense - Account ssets Gym Equipment tationery Supplies $256 $479 $987 opmg Additional Information: Bank loan interest rates (% per year) 5208 S1,300 $626 Motor vehicle useful life (years) Motor vehicle scrap value (S) austmen 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 (S) $493 602 $2,227 $451 Comment This business was purchased on I June You are required to prepare a general joumal entry to incorporate the opening balances into the current period, including the balancing Capital $1,032 $1,375 $1282 $1,300 $3,223 - You will need to refer to the Additional Information section for your Balance Day Adjustments. S2,185 The rent and insurance period start on I June. S314 $2,117 $1,554 -Show three types of revenue, namely gym fees, squash fees and membership fees. All revenues received were for the month of June. -Unless otherwise indicated, all transactions are on a cash basis. Use one general Account Receivable 20 for all debtors and one general Account Payable for all creditors. - Your B/S should show asset and liability divided into current and non-current. Staff work a 7-day week and are paid on the 8th day