I am having trouble preparing a multiple-step income statement on the proper worksheet.

Then I need to prepare a Statement of Stockholders Equity.

Then I need to prepare a journal entry form the closing entries for Hullie & Oates at the end of 12/31/11.

Next I must prepare a Classified Balance Sheet on the proper worksheet as of 12/31/11.

Lastly, I need to create a section about the Ratios, Working Capital, and Current Ratios. I am unsure how to figure those out.

Thank you for your help! Here is the information I have.

Hullie & Oates Company
End of Period Worksheet
For the Year Ended December 31, 2011
	Unadjusted				Adjusted
Account Title	Trial Balance		Adjustments		Trial Balance
	DR	CR	DR	CR	DR	CR
Cash	36,000	-			36,000
Accounts Receivable	72,850	-			72,850
Allowance for Doubtful Accounts		2,000		7,695		9,695
Interest Receivable	-		840		840
Merchandise Inventory	160,500	-			160,500
Prepaid Insurance	18,000	-		13,500	4,500
Prepaid Advertising	48,000			24,000	24,000
Prepaid Rent	-		8,500		8,500
Store Supplies	4,250	-		3,850	400
Office Supplies	-	-	1,500		1,500
Note Receivable	24,000				24,000
Store Equipment	175,000	-			175,000
Accumulated Depreciation - Store Equipment	-	40,050		16,800		56,850
Office Equipment	80,000	-			80,000
Accumulated Depreciation - Office Equipment	-	17,200		15,000		32,200
Accounts Payable	-	85,200				85,200
Salaries Payable	-	-		11,000		11,000
Interest Payable	-	-		8,030		8,030
Unearned Rent	-	20,000	6,000			14,000
Note Payable (final payment due 2017)	-	146,000				146,000
Common Stock	-	60,000				60,000
Retained Earnings	-	110,500				110,500
Dividends	25,000	-			25,000
Sales	-	788,350				788,350
Sales Returns and Allowances	11,700	-			11,700
Sales Discounts	7,200	-			7,200
Cost of Goods Sold	457,200	-			457,200
Sales Salaries Expense	94,650	-	6,200		100,850
Advertising Expense		-	24,000		24,000
Depreciation Expense - Store Equipment	-	-	16,800		16,900
Store Supplies Expense	-	-	3,850		3,850
Miscellaneous Selling Expense	2,600	-			2,600
Office Salaries Expense	34,000	-	4,800		38,800
Rent Expense	10,200	-		8,500	1,700
Insurance Expense	-	-	13,500		13,500
Depreciation Expense - Office Equipment	-	-	15,000		15,000
Office Supplies Expense	6,500	-		1,500	5,000
Miscellaneous Administrative Expense	1,650	-			1,650
Rent Revenue	-	-		6,000		6,000
Interest Revenue				840		840
Interest Expense	-	-	8,030		8,030
Bad Debt Expense	-	-	7,695		7,695
	1,269,300	1,269,300	116,715	116,715	1,328,765	1,328,665

Hullie & Oates Company
Adjusting Journal Entries
For the Year Ended December 31, 2011
Account Titles		DR	CR
Insurance Expense (18000/12)*9months		$ 13,500
Prepaid Insurance			$ 13,500
(To record Insurance Expense)
Advertising Expenses (48000/2)		$ 24,000
Prepaid Advertising			$ 24,000
(To record Advertising Expense)
Prepaid Rent		$ 8,500
Rent Expense (10200/12*10)			$ 8,500
(To record Prepaid Rent)
Store Supplies Expense		$ 3,850
Store Supplies Expense			$ 3,850
(To record Supplies Expense)
Office Supplies		$ 1,500
Office Supplies Expense			$ 1,500
(To record Ending Supplies)
Interest Receivable		$ 840
Interest Revenue (24000*7)*6/12			$ 840
(To record Interest Accrual)
Depreciation Expense - Store Equipment (175000-7000)/10		$ 16,800
Accumulated Depreciation - Store Equipment			$ 16,800
Depreciation Expense - Office Equipment (80000-5000)/5		$ 15,000
Accumulated Depreciation - Office Equipment			$ 15,000
(To record the Depreciation Expense)
Office Salaries Expense		$ 4,800
Sales Salaries Expense		$ 6,200
Salaris Payable			$ 11,000
(To record the Accrual of Salaries Expense)
Unearned Rent		$ 6,000
Rent Revenue (20000/10*3)			$ 6,000
(To record the Rent Revenue)
Interest Expense		$ 8,030
Interest Payable (146000*5.5%)			$ 8,030
(To record theInterest Expense)
Bad Debt Expenses (788350-11700-7200)*1%		$ 7,695
Allowance for Doubtful Accounts			$ 7,695
(To record the Bad Debts Expense)