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.