The list of ratios to be included are as follows. They should be grouped under the headings, as shown: COCA-COLA

1)Liquidity Ratios *Current Ratio *Quick Ratio

2) Leverage Ratios o Debt to Total Assets Ratio o Debt Equity Ratio o Long-Term Debt to Equity o Times Interest Earned Ratio

3) Activity Ratios o Inventory Turnover o Fixed Assets Turnover o Total Assets Turnover o Accounts Receivable Turnover o Average Collection Period

4) Profitability Ratios o Gross Profit Margin o Operating Profit Margin o Net Profit Margin o Return on Total Assets (ROA) o Return on Stockholders Equity (ROE) o Earnings Per Share (EPS) o Price Earnings Ratio

5) Calculate the ratios for Coca-Cola for the last three years, linking the ratio calculations back to the historical financial statement tabs using formulas.

*Calculate the ratios for each of your companys competitors (most recent year only), linking the ratio calculations for Coca-Colas financial statements shown in Tabs 5-10 using formulas. * Using the internet, locate the industry averages for the ratios listed above, and include them in the final column of the ratio tab. Include a footnote on the tab to identify the source of the industry averages