need vertical and horizontal analysis balance sheet and income statement created

I need a vertical and horizontal analysis for the balance sheet and income statement below created on a excel spreadsheet for 2010 and 2011 only

 

 

 

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

 

 

Create a horizontal and vertical analysis for the balance sheet and the income statement.