BA problem analysis paper
mkahim
kohls_corporation-2.xlsxIncome Statement
| Income Statement | |||
| 2011 | 2012 | 2013 | |
| Net sales | 18,804 | 19,279 | 19,031 |
| % Growth | 2.53% | -1.29% | |
| Cost of merchandise sold | 11,625 | 12,289 | 12,087 |
| Gross margin | 7,179 | 6,990 | 6,944 |
| % Growth | -2.63% | -0.66% | |
| Operating expenses: | |||
| Selling, general and administrative | 4,243 | 4,267 | 4,313 |
| Depreciation and amortization | 778 | 883 | 889 |
| Operating income | 2,158 | 1,840 | 1,742 |
| % Growth | -14.74% | -5.33% | |
| Interest expense, net | 299 | 329 | 338 |
| Income before income taxes | 1,859 | 1,511 | 1,404 |
| % Growth | -18.72% | -7.08% | |
| Provision for income taxes | 692 | 575 | 515 |
| Net income | 1,167 | 936 | 889 |
| % Growth | -19.79% | -5.02% |
Historical Price
| Historical Prices | 2013 | 2012 | ||||
| High | Low | Dividend | High | Low | Dividend | |
| Fourth Quarter | 58.47 | 49.97 | 0.35 | 55.11 | 41.81 | 0.32 |
| Third Quarter | 57.04 | 49.84 | 0.35 | 53.77 | 49.72 | 0.32 |
| Second Quarter | 54.16 | 47.00 | 0.35 | 51.25 | 43.13 | 0.32 |
| First Quarter | 49.32 | 45.21 | 0.35 | 52.19 | 45.56 | 0.32 |
Competitive Analysis
| Kohl's Coproration | JC Penney | Target Corp | The TJX | Indstry | |
| Market Cap: | 11.57B | N/A | 37.43B | 41.85B | 5.20B |
| Employees: | 31,000 | 1,160,001 | 366,000 | 191,000 | 18.70K |
| Qtrly Rev Growth (yoy): | -0.01 | N/A | 0.02 | 0.07 | 0 |
| Revenue (ttm): | 18.86B | 12.98B1 | 73.23B | 28.20B | 3.78B |
| Gross Margin (ttm): | 0.37 | N/A | 0.29 | 0.28 | 0.33 |
| EBITDA (ttm): | 2.59B | N/A | 5.69B | 4.01B | 221.33M |
| Operating Margin (ttm): | 0.09 | N/A | 0.05 | 0.12 | 0.05 |
| Net Income (ttm): | 868.00M | N/A | 1.51B | 2.18B | N/A |
| EPS (ttm): | 4.1 | N/A | 2.37 | 3.04 | 0.13 |
| P/E (ttm): | 13.78 | N/A | 24.95 | 19.9 | 19.5 |
| PEG (5 yr expected): | 2.3 | N/A | 1.55 | 1.68 | 1.03 |
| P/S (ttm): | 0.61 | N/A | 0.51 | 1.47 | 1.47 |
