Need a vertical and horizontal analysis for a balance sheet and income statement created
edadmiI 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.
- 10 years ago
- 20
Purchase the answer to view it
- vertical_analysis.docx
- ratios_analysis.xlsx
Purchase the answer to view it
- riordan_financial_statement_and_balance_sheet.xlsx
- accounting questions and exercises
- Describe how energy is lost or gained during changes of state
- Business Research Analysis
- jake savings account has a balances of 5000$.if jake has not made a withdrawn or deposited any mony since opening...
- Objective: Determine what software and hardware should be purchased for one of the family unites below and prepare a presentation...
- essay
- Which fraction has a value between 1.5 and 1.75
- accguru
- the first people to settle in the british colonies built communities and farms to the eastern coast or by...
- FINANCE DISCUSSION