See description and attachment.
papchu
financial_ratios.xlsx
Financial Ratios
| Current Ratio | | | | | | 2016 | | | 2015 | | | |
| Year | Walmart | Sears | Target | | | Walmart | Sears | Target | Walmart | Sears | Target | | | |
| 2016 | 0.93 | 1.11 | 1.12 | Current Assets | | $ 60,239,000.00 | $ 6,045,000.00 | $ 14,130,000.00 | $ 63,278,000.00 | $ 5,863,000.00 | $ 13,624,000.00 |
| 2015 | 0.97 | 1.05 | 1.16 | Current Liabilities | | $ 64,619,000.00 | $ 5,438,000.00 | $ 12,622,000.00 | $ 65,253,000.00 | $ 5,595,000.00 | $ 11,736,000.00 |
| 2014 | 0.88 | 1.09 | 0.91 | Total Assets | | $ 199,581,000.00 | $ 11,337,000.00 | $ 40,262,000.00 | $ 203,490,000.00 | $ 13,185,000.00 | $ 41,172,000.00 |
| | | | | Total Equity | | $ 80,546,000.00 | $ (1,963,000.00) | $ 12,957,000.00 | $ 81,394,000.00 | $ (951,000.00) | $ 13,997,000.00 |
| Total Debt Ratio | | | | Cost of Goods Sold | | $ 360,984,000.00 | $ 19,336,000.00 | $ 51,997,000.00 | $ 365,086,000.00 | $ 24,049,000.00 | $ 51,278,000.00 |
| 2016 | 0.60 | 1.17 | 0.68 | Inventory | | $ 44,469,000.00 | $ 5,172,000.00 | $ 8,601,000.00 | $ 45,141,000.00 | $ 4,943,000.00 | $ 8,282,000.00 |
| 2015 | 0.60 | 1.07 | 0.66 | Net Income | | $ 14,694,000.00 | $ (1,129,000.00) | $ 3,363,000.00 | $ 16,363,000.00 | $ (1,682,000.00) | $ (1,636,000.00) |
| 2014 | 0.63 | 0.90 | 0.64 |
| Inventory Turnover Ratio | | | | | | 2014 |
| 2016 | 8.1176549956 | 3.7385924207 | 6.0454598303 | | | Walmart | Sears | Target |
| 2015 | 8.0876808223 | 4.8652640097 | 6.1914996378 | Current Assets | | $ 61,185,000.00 | $ 8,959,000.00 | $ 11,573,000.00 |
| 2014 | 7.9822774087 | 3.9000568666 | 6.0448175888 | Current Liabilities | | $ 69,345,000.00 | $ 8,185,000.00 | $ 12,777,000.00 |
| | | | | Total Assets | | $ 204,751,000.00 | $ 18,261,000.00 | $ 44,553,000.00 |
| Return on Assets Ratio | | | | Total Equity | | $ 76,255,000.00 | $ 1,739,000.00 | $ 16,231,000.00 |
| 2016 | 0.0736242428 | -0.2182907966 | 0.3910010464 | Cost of Goods Sold | | $ 358,069,000.00 | $ 27,433,000.00 | $ 50,039,000.00 |
| 2015 | 0.3624864314 | -0.3402791827 | -0.1975368269 | Inventory | | $ 44,858,000.00 | $ 7,034,000.00 | $ 8,278,000.00 |
| 2014 | 0.0782511441 | 0.2381009906 | 0.2381009906 | Net Income | | $ 16,022,000.00 | $ (1,365,000.00) | $ 1,971,000.00 |
| Price-earning Ratio |
| 2016 | 14.72 | 13.4 | N/A |
| 2015 | 15.91 | 16.2 | N/A |
| 2014 | 15.34 | 31.8 | N/A |
