| RATIO ANALYSIS SPREADSHEET | | | | | = Pos,Neu,Neg |
| Company | | General Electric Company |
| | | | 2017 | | 2016 | | 2015 | | Industry |
| | | | | | | | | | Average |
| BALANCE SHEET RATIOS: Stability (Staying Power) | | | | | | | | | Access csimarket.com and query by stock symbol |
| 1 | Current | | | | | | | | | Ability to meet current obligations |
| | | Current Assets | 119,096,000 | 1.92 | 131,436,000 | 1.87 | 280,896,000 | 2.03 |
| | | Current Liabilities | 61,893,000 | | 70,364,000 | | 138,270,000 |
| 2 | Debt-to-Equity | | | | | | | | | Margin of Safety to Creditors |
| | | Total Liabilities | 292,560,000 | 4.55 | 284,667,000 | 3.75 | 389,961,000 | 3.97 |
| | | Equity | 64,257,000 | | 75,822,000 | | 98,268,000 |
| INCOME STATEMENT RATIOS: Profitability (Earning Power) |
| 3 | Gross Margin | | | | | | | | | Gross Profit expressed as a % of Sales |
| | | Gross Profit | 14,874,000 | 12.3% | 25,655,000 | 21.3% | 25,723,000 | - |
| | | Sales | 121,252,000 | | 120,273,000 |
| 4 | Operating Profit Margin | | | | | | 115,834,000 | | | Operating Profit expressed as a % of Sales |
| | | Operating Profit | (225,000) | | 10,443,000 | | 9,396,000 |
| | | Sales | 121,252,000 | -0.2% | 120,273,000 | 8.7% | - 0 | - |
| 5 | Net Margin | | | | | | | | | Net Profit expressed as a % of Sales |
| | | Net Income | (5,786,000) | -4.8% | 8,831,000 | 7.3% | (6,126,000) | - |
| | | Sales | 121,252,000 | | 120,273,000 | | - 0 |
| ASSET MANAGEMENT RATIOS: Overall Efficiency Ratios |
| 6 | Earnings Quality | | | | | | | | | Measures cash generated from sales; higher % the better |
| | | Cash flow from Operations | 10,426,000 | -180% | (244,000) | -3% | 19,891,000 | -325% |
| | | Net Income | (5,786,000) | | 8,831,000 | | (6,126,000) | | n/a |
| 7 | Return on Assets | | | | | | | | | Measures the profitability of using the assets |
| | | Net Income | (5,786,000) | -1.5% | 8,831,000 | 2.4% | (6,126,000) | -1.2% |
| | | Total Assets | 377,945,000 | | 365,183,000 | | 493,071,000 |
| 8 | Return on Equity | | | | | | | | | Measures the profitability of the stockholders investment |
| | | Net Income | (5,786,000) | -9.0% | 8,831,000 | 11.6% | (6,126,000) | -6.2% |
| | | Equity | 64,257,000 | | 75,822,000 | | 98,268,000 |
| ASSET MANAGEMENT RATIOS: Working Capital Cycle Ratios |
| 9 | Inventory Turnover | | | | | | | | | Measures the efficiency of moving the inventory |
| | | Cost of Revenue/Goods Sold | 106,378,000 | 5 | 94,618,000 | 4 | 90,111,000 | 4 |
| | | Inventory | 21,923,000 | | 22,354,000 | | 22,515,000 |
| 10 | Inventory Turn-Days | | | | | | | | | Average # of days it takes to move inventory |
| | | 360 | 360 | 74.19 | 360 | 85.05 | 360 | 89.95 |
| | | Inventory Turnover | 5 | | 4 | | 4 | | - |
| 11 | Accounts Receivable Turnover | | | | | | | | | Measures the efficiency of collecting Accounts Receivable |
| | | Sales | 121,252,000 | 4.96 | 120,273,000 | 5.00 | - 0 | - 0 |
| | | Accounts Receivable | 24,438,000 | | 24,076,000 | | 43,013,000 |
| 12 | Accounts Receivable Turn-Days | | | | | | | | | Average # of days it takes to collect Accounts Receivable |
| | | 360 | 360 | 73 | 360 | 72 | 360 | - |
| | | Accts. Rec. Turnover | 5 | | 5 | | - 0 | | - |
| 13 | Accounts Payable Turnover | | | | | | | | | Measures the efficiency of paying Accounts Payable |
| | | Cost of Revenue/Goods Sold | 106,378,000 | 7.02 | 94,618,000 | 6.55 | 90,111,000 | 6.59 |
| | | Accounts Payable | 15,153,000 | | 14,435,000 | | 13,680,000 | | n/a |
| 14 | Average Payment Period | | | | | | | | | Average # of days it takes to pay Accounts Payable |
| | | 360 | 360 | 51 | 360 | 55 | 360 | 55 |
| | | Accts. Pay. Turnover | 7 | | 7 | | 7 |
1nj0h4783i9
302assignemnt12excel.xls
