Below is a balance sheet and income numebers for three companies. Please help me to answer the questions below! Questions and instructions in the pictures! Unique number is 9!

Revenue COGS Gross Profit EBITDA Taxes Net Income Total Assets Equity Current Assets Current Liabilities Inventory Long-Term Debt Year 1 5674 3442 2232 1470 510 960 5255 3084 3145 873 221 1298 Year 2 7019 4258 2761 2288 1895 392 6501 4172 5386 723 4463 1605 Year 1 176896 144924 31972 7962 6522 1440 275936 13442 62923 53604 10271 208890 Year 2 148603 121745 26858 7014 1831 5182 231803 42323 60539 13999 15810 175480 Year 1 179083 144249 34834 15990 4309 11681 244587 89999 91387 85373 13799 69215 3 Year 2 188698 151994 36704 21473 12562 8910 257719 134842 150773 49945 88207 72931 Rules of Play The balance sheet items may not balance perfectly (they may be out -$1) due to rounding error. USE EXCEL to calculate the solutions and do the math-calculators may throw off your rounding. You will be asked to submit the sheet you used to solve the homework. If you don't submit an excel sheet that has the problem set in it, it will not be graded. If you use Google Sheets - download the file as an Excel attachment and submit that. Do not submit a Google Shheet - they can be changed after submission which creates grading transparency problems. Submit percentages as the percentage followed by two decimals. A number that appears as .04567 in Excel should be submitted as 4.57%. Responses will be marked correct if they are within 5% of the answer I calculated in Excel 1. Which company has the best liquidity (highest current ratio) in Year 2? 2. Which company does the best job generating profits for shareholders in Year 2? (ROE is represented as percentage) 3. Which company does the best job generating profits with its total investment in Year 2? (ROA is represented as percentage) 4. Which company is the most leveraged (high long-term debt to equity) in Year 2? 5. Which company has the biggest current threat of being illiquid (lowest current ratio) in Year 2? 6. Which company saw the biggest increase in its net profit margin from Year 1 to Year 2 (or smallest decrease if NI all negative)? 7. What is company 3's ROA in Year 2? (ROA is represented as percentage) 8. What is company I's ROA in Year 1? (ROA is represented as percentage) 9. What is company 2's ROA in Year 2? (ROA is represented as percentage) 10. Which company has the highest gross margin in Year 2? (This is a percentage) 11. What is company I's quick ratio in Year 2? 12. What is company 2's current ratio in Year 2? 13. What is company 3's net margin in Year 2? (This is represented as percentage) 14. What is company I's inventory turnover in Year 2? 15. What is company 3's long-term debt to assets ratio in Year 1