Year 1 Year 2 Year 1 Year 2 Year 1 Year 2 Revenue 5674 5446 176896 158859 179083 209270 COGS 3442 3303 144924 130147 144249 168564 Gross Profit 2232 2142 31972 28712 34834 40705 EBITDA 1470 934 7962 9810 15990 30526 Taxes 510 407 6522 3352 4309 22892 Net Income 960 526 1440 6458 11681 7633 Total Assets 5255 5043 275936 247801 244587 285816 Equity 3084 3417 13442 41893 89999 140910 Current Assets 3145 2200 62923 84672 91387 214342 Current Liabilities 873 380 $3604 18316 I 85373 64023 Inventory 221 959 10271 28932 13799 160742 Lang-Term Debt 1298 1245 208890 187591 69215 80882 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 (Questions on next page) I 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 27 (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 1's ROA in Year 17 (ROA is represented as percentage) 9. What is company 2's ROA in Year 27 (ROA is represented as percentage) 10. Which company has the highest gross margin in Year 2? (This is a percentage) 11. What is company 1's quick ratio in Year 2? 12. What is company 2's current ratio in Year 27 13. What is company 3's net margin in Year 27 (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 17