RE-DUE Financial Analysis
barkersbaseball
ratio.xlsxRatio Analysis
| Description | Nordstrom | Macy's | ||||
| 2012 | 2013 | 2014 | 2012 | 2013 | 2014 | |
| Sales and Revenues | 10,860.00 | 12,134.00 | 12,540.00 | 26,405.00 | 27,686.00 | 27,931.00 |
| Cost of Sales | 6,545.00 | 7,368.00 | 7,656.00 | 15,738.00 | 16,538.00 | 16,725.00 |
| Gross Profit | 4,087.00 | 4,550.00 | 4,674.00 | 10,667.00 | 11,148.00 | 11,206.00 |
| Net Income | 683.00 | 735.00 | 734.00 | 1,256.00 | 1,335.00 | 1,486.00 |
| Current Assets | 5,560.00 | 5,081.00 | 5,228.00 | 8,777.00 | 7,876.00 | 8,688.00 |
| Current liabilities | 2,575.00 | 2,226.00 | 2,541.00 | 6,263.00 | 5,075.00 | 5,726.00 |
| Total Liabilities | 6,535.00 | 6,176.00 | 6,494.00 | 16,162.00 | 14,940.00 | 15,385.00 |
| Working Capital=Current Assets-Current Liabilities | 2,985.00 | 2,855.00 | 2,687.00 | 2,514.00 | 2,801.00 | 2,962.00 |
| Total Equity | 1,956.00 | 1,913.00 | 2,080.00 | 5,933.00 | 6,051.00 | 6,249.00 |
| Total Assets | 8,491.00 | 8,089.00 | 8,574.00 | 22,095.00 | 20,991.00 | 21,634.00 |
| Ratio Analysis | ||||||
| Verizon Co | AT&T | |||||
| 2012 | 2013 | 2014 | 2012 | 2013 | 2014 | |
| Liquidity Ratios | ||||||
| Current Ratio=Current Assets/Current Liabilities | 2.16 | 2.28 | 2.06 | 1.40 | 1.55 | 1.52 |
| Profitibility Ratios | ||||||
| Gross Profit Margin | 37.63% | 37.50% | 37.27% | 40.40% | 40.27% | 40.12% |
| Net Profit Margin | 6.29% | 6.06% | 5.85% | 4.76% | 4.82% | 5.32% |
| Return on assets= Net profit/ Total assets | 8.04% | 9.09% | 8.56% | 5.68% | 6.36% | 6.87% |
| Solvency Ratios | ||||||
| Debt/Equity=Total Liabilities/Equity | 3.34 | 3.23 | 3.12 | 2.72 | 2.47 | 2.46 |
Sheet2
| Description | ADMS | IPXL | ||
| 2012 | 2013 | 2012 | 2013 | |
| Liquidity Ratios | ||||
| Current Ratio | 1.67 | 20.39 | 3.75 | 4.29 |
| Profitibility Ratios | ||||
| Operating Profit Margin | 53.24% | 80.20% | 14.27% | -1.25% |
| Net Profit Margin | 47.33% | 71.62% | 14.32% | 28.73% |
| Return on assets | 27.58% | 67.66% | 0.70% | 0.55% |
| Solvency Ratios | ||||
| Interest coverage | 48.97 | 593.18 | 132.82 | 351.69 |
| ADMS | IPXL | |||
| 2012 | 2013 | 2012 | 2013 | |
| Liquidity Ratios | ||||
| Current Ratio | 1.67 | 20.39 | 3.75 | 4.29 |
| ADMS | IPXL | |||
| 2012 | 2013 | 2012 | 2013 | |
| Operating Profit Margin | 53.24% | 80.20% | 14.27% | -1.25% |
| Net Profit Margin | 47.33% | 71.62% | 14.32% | 28.73% |
