basic accounting/finance problem! please help!

Net Sales COGS Net Income Accounts Receivable Inventory Current Assets Fixed Assets Total Assets Current Liabilities Long-Term Debt Total Liabilities Shareholder's Equity Number of Shares Outstanding Your Unique ID is: 2 1 2 9850 3987 2364 2591 2984 29 3572 296 1 52 8266 250 1444 1218 9710 1468 4438 326 312 320 4750 646 4960 822 8384 26 (Questions on Next Page) 266 108 10 19 12 69 18 87 24 2 26 61 17 Questions 1. What company has the highest gross margin? 2. What company has the highest ROA? 3. What company has the lowest ROE? 4. What company has the highest EPS? 5. What company has the lowest current ratio? 6. What company has the highest quick ratio? 7. What company collects its receivables the slowest? 8. What company is holding the most days of inventory? 9. What company has the highest level of long-term liabilities relative to its shareholder equity? 10. Does company I have a liquidity problem? 11. Does company 3 appear to be highly leveraged? 12. Extra Credit: Take a look at the gross margin, relative size and asset configuration: These three companies are: An international shipping company, a regional beer company and an international software company. Which company is number 2? Note: No, they will not match up to the financials you find online. Notes 1. A company has a liquidity problem if its current ratio is less than 2 or its quick ratio is less than 1. A company is considered "highly" leveraged if its ratio of long-term liabilities to total equity is greater than 1. 2. The Google form will require an Excel spreadsheet. That sheet needs to include solutions to problems 1 through 11, in short, the calculations need to be figured up in the Excel sheet. If your sheet isn't solving the problems, the submission will not receive full credit