should focus on interpreting each ratio number for each company and support your comments with the numbers found in the ratios. 4. The Summary and Conclusions worksheet tab which is an overall comparison of how each company compares in terms of the major category of ratios (Liquidity, Profitability, and Solvency). 5. The Bibliography worksheet tab must contain at least your textbook as a reference. Any other information you use to profile the companies should also be cited as a reference. Required Ratios for Final Project Submission: 1. Earnings per Share 2. Current Ratio 3. Gross Profit Rate 4. Profit Margin Ratio 5. Inventory Turnover Ratio 6. Days in Inventory 7. Receivables Turnover Ratio 8. Average Collection Period 9. Asset Turnover Ratio 10. Return on Assets Ratio 11. Debt to Total Assets Ratio 12. Times Interest Earned Ratio 13. Payout ratio 14. Return on Common Stockholders' Equity Ratio 15. Free Cash Flow 16. Current Cash Debt Coverage Ratio 17. Cash Debt Coverage Ratio 18. Price/Earnings Ratio [For the purpose of this ratio, use the market price per share on June 1, 2007 for each company] The Excel files uploaded to the Dropbox should not include any unnecessary numbers or information (such as previous years' ratios, ratios that were not specifically asked for in the project, etc.). Please upload your final submission to the Dropbox by the end of Week 7. See Syllabus/"Due Dates for Assignments & Exams" for due date information. For the Draft: