1	Calculate common sized financial statement analysis (horizontal and vertical analysis) and dollar amount and percent changes.
	2	Calculate ratios in the ratios tab for 2011

		ABC Company Inc.
		Analytics - Assets	(1)	Common size:	Vertical analysis
		12.31.2011
	Income statement items are expressed as a percentage of revenue and Balance sheet items are expressed as a percentage of total assets
	Acct.	Account		12.31.2010	Common	12.31.2011	Common	Change
	#	Title		Balance	Size (1)	Balance	Size	Amount	Percentage
ASSETS
	10100	Cash on Hand		1,987.28		2,275.23
	10200	Regular Checking Acct.		198,116.52		532,125.92
	10300	Payroll Checking Acct.		0.00		0.00
	10400	Savings Account		3,044,958.13		3,670,599.15
	11000	Accounts Receivable		16,410,902.71		49,780,259.98
	11400	Other Receivables		0.00		1,000,000.00
	11500	Allow. For Doubtful		(1,262,819.88)		(1,254,009.75)
	12000	Inventory		18,825,205.24		67,424,527.50
	12300	Res. For Inv. Obsoles.		(3,012,000.00)		(867,000.00)
	14100	Prepaid Insurance		743,314.38		3,374,213.78
	14200	Prepaid Rent		200,000.00		0.00
	14300	Office Supplies		7,406.82		8,540.00
	14400	Notes Receivable - Curr		0.00		0.00
	14700	Other Current Assets		0.00		0.00
	15000	Land		117,000.00		117,000.00
	15100	Buildings & Land Improv.		623,905.92		674,313.92
	15200	Mach, Equip, O Furniture		433,217.10		2,929,097.13
	17000	Accum. Depreciation		(164,000.00)		(610,000.00)
	19000	Investments		612,691.08		2,038,780.39
	19900	Other Noncurrent Assets		13,840.59		13,840.59
		Total Assets		36,793,725.89	0.00%	128,834,563.84	100.00%	0.00	0.00%
					balance
	na	not applicable			check	128,834,563.84
	nm	not meaningful
						0.00
		Current assets		35,157,071.20		123,671,531.81		33,095,581.35	Ave AR

		ABC Company Inc.
		Analytics Income Stmt
		12.31.2011
Income statement items are expressed as a percentage of revenue and Balance sheet items are expressed as a percentage of total assets
					Change
	Acct.	Account		12.31.2010	Common	12.31.2011	Common	Change
	#	Title		Balance	Size	Balance	Size	Amount	Percentage
REVENUE
	40000	Sales		246,172,918.44		245,213,452.88
	41000	Sales Returns		4,497,583.20		13,600,220.89
	42000	Warranty Exp		1,100,281.48		1,158,128.47
		Net Sales		240,575,053.76	0.00%	230,455,103.52	0.00%	0.00	0.00%
EXPENSES
	50000	COGS		141,569,221.61		130,246,645.26
		Gross Margin		99,005,832.15	0.00%	100,208,458.26	0.00%	0.00	0.00%
					Change
	Acct.	Account		12.31.2010	Common	12.31.2011	Common	Change
	#	Title		Balance	Size	Balance	Size	Amount	Percentage
OPERATING EXPENSES
	57500	Freight		4,302,951.46		4,236,263.09
	60000	Advertising Expense		897,140.01		986,854.01
	61000	Auto Expenses		208,974.39		214,502.80
	62000	Research & Development		31,212,334.17		3,543,870.44
	64000	Depreciation Expense		133,000.00		446,000.00
	64500	Warehouse Salaries		4,633,383.82		4,720,715.56
	65000	Property Tax Expense		80,495.32		84,332.45
	66000	Legal & Professional Exp		3,605,133.96		1,902,224.45
	67000	Bad Debt Expense		1,622,425.99		0.00
	68000	Insurance Expense		853,942.65		36,106.92
	70000	Maintenance Expense		61,136.04		49,502.87
	70100	Utilities		135,642.99		137,332.18
	70110	Phone		76,373.78		52,599.02
	70120	Postal		128,033.21		77,803.61
	71000	Misc. Office Expense		17,023.27		24,891.82
	72000	Payroll Tax Expense		1,550,989.06		1,577,811.85
	73000	Pension/PS Plan Expense		3,000,000.00		3,300,000.00
	74000	Rent or Lease Expense		2,603,485.87		1,203,574.00
	77500	Administrative Wage Exp		16,875,305.98		16,197,225.43
		Total Operating Expenses		71,997,771.97	0.00%	38,791,610.50	0.00%	0.00	0.00%
		Net Income from Operations		27,008,060.18	0.00%	61,416,847.76	0.00%	0.00	0.00%
OTHER INCOME (EXPENSE)
	45000	Income from Investments		0.00		1,426,089.31
	46000	Interest Income		204,302.81		131,881.46
	47000	Misc. Income		0.00		2,145,000.00
	78000	Interest Expense		(875,000.00)		(2,591,736.50)
	80000	Loss on Legal Settlement		(19,172,000.00)		0.00
		Net Income before Tax		7,165,362.99		62,528,082.03		0.00	0.00%
	78500	Income Tax Exp - Federal		(2,365,000.00)		(10,000,000.00)
	78510	Income Tax Exp - State		(429,000.00)		(2,000,000.00)
		Net Income		4,371,362.99		50,528,082.03		0.00	0.00%
						check to B/S

		Apollo Shoes, Inc.
		Selected Ratios
		Dec-11		Calculate	Calculate
					Percentage
		Ratios	12/31/10	12/31/11	Change		Ratio Formula
	<1>	Current Ratio	2.4			<1>	Current assets/Current Liabilities
	<2>	Debt Ratio	0.40			<2>	Total Liabilities/Total Assets
	<3>	Debt-Equity Ratio	0.66			<3>	Total Liabilities/Shareholders Equity
	<4>	Asset Turnover	6.54			<4>	Sales Revenue/Total Assetss
	<5>	Days Sales in Inventory	48.5			<5>	Inventory/Cost of Sales X Number of Days
	<6>	Days Sales in AR	24.90			<6>	Ave A/R*/Sales X Number of days
	<7>	Net Working Capital	$20,481,829			<7>	Current Assets - Current Liabilities
	*	For 2010 use the Accounts Receivable Balance $16,410, 902
		for 2011 you should calculate the average Accounts Receivable balance
		Number of days is 365
		Assume all sales are credit sales