Need a vertical and horizontal analysis for a balance sheet and income statement created

riordan_financial_statement_and_balance_sheet.xlsx

Sheet1

Riordan Industries
Balance Sheet
000 Omitted
	2011	2010	2009
Assets
Current Assets
Cash	$325,478	$265,009	$132,505
Accounts Receivable	$125,220	$123,369	$ 61,685
Inventory	$ 87,654	$ 67,426	$ 33,713
Other Current Assets		$ 2,791	$ 1,396
Total Current Assets	$538,352	$458,595	$229,299
Long-Term Assets
Long-Term Assets	$186,151	$161,870	$ 80,935
Accumulated Depreciation	$ 22,338	$ 20,466	$ 10,233
Total Long-Term Assets	$163,813	$141,404	$ 70,702
Total Assets	$702,165	$599,999	$300,001
Liabilities
Current Liabilities
Accounts Payable	$ 33,634	$ 30,301	$ 18,181
Current Borrowing	$ 246
Other Current Liabilities	$ 930	$ 1,860
Total Current Liabilities	$ 34,810	$ 32,161	$ 18,181
Total Long-Term Liabilities	$ 5,901	$ 7,684	$ 3,842
Total Liabilities	$ 40,711	$ 39,845	$ 22,023
Stockholders' Equity
Common Stock	$ 9,652	$ 9,303	$ 4,652
Retained Earnings	$407,139	$318,050	$182,380
Capital Surplus	$244,663	$232,801	$ 90,946
Total Stockholders' Equity	$661,454	$560,154	$277,978
Total Liabilities & Stockholders' Equity	$702,165	$599,999	$300,001

Riordan Industries
Income Statement
000 Omitted
(Unaudited)
	2011	2010	2009
Income
Sales	$633,932	$549,144	$411,858
Direct Cost of Goods Sold	$129,539	$111,604	$ 83,703
	$504,393	$437,540	$328,155
Expenses
Payroll	$109,620	$104,400	$ 83,520
Sales, Marketing & Other Expenses	$ 33,199	$ 27,666	$ 20,750
Depreciation	$ 5,846	$ 4,176	$ 2,671
Quality Assurance	$ 13,311	$ 13,050	$ 9,788
Research & Development	$ 25,120	$ 18,270	$ 13,703
General & Administrative	$ 19,073	$ 18,165	$ 15,655
Machining & Systems	$ 14,056	$ 11,484	$ 8,312
Payroll Taxes	$ 16,443	$ 15,660	$ 11,745
Total Operating Expenses	$236,668	$212,871	$166,144
Profit Before Interest & Taxes	$267,725	$224,669	$162,011
Interest Expense	$ 768	$ 1,301
Taxes Incurred	$ 67,652	$ 56,772	$ 48,930
Net Profit	$199,305	$166,596	$113,081
Net Profit/Sales	$0.31	$0.30	$0.27