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.

Thanks for installing the Bottom of every post plugin by Corey Salzano. Contact me if you need custom WordPress plugins or website design.