RIORDAN INDUSTRIES BALANCE SHEET AND INCOME STATEMENT ANALYSIS
I need the followinng calculated Access the information contained in your selected organizationâs balance sheet and income statement to calculate the...
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 |
I need the followinng calculated
Access the information contained in your selected organization’s balance sheet and income statement to calculate the following:
- Liquidity ratios
- Current ratio
- Acid-test, or quick, ratio
- Receivables turnover
- Inventory turnover
- Profitability ratios
- Asset turnover
- Profit margin
- Return on assets
- Return on common stockholders’ equity
- Solvency ratios
- Debt to total assets
- Times interest earned
Show your calculations for each ratio.
Create a horizontal and vertical analysis for the balance sheet and the income statement.
12 years ago
Purchase the answer to view it
vertical_analysis.docx- ratios_analysis.xlsx
