Coca Cola

1. Do trend analysis of the following income statement and balance sheet items over the last five-year period:

Income Statement
Sales, Cost of Sales (Cost of Goods Sold), Gross Margin (Gross Profit), Operating Income (income from continuing operations, combined foreign and domestic).
Sales: There have been remarkable increase in Sales.
Cost of Sales: There have been remarkable increase in it.
Gross Profit: There have been remarkable increase in it.
Operating   Profit: There have been increase in it.



Balance Sheet
Cash, Accounts (Trade) Receivables, Inventories, Working Capital, Total Current Assets, Total Assets, Total Current Liabilities, Total Long Term Liabilities and Current Liabilities Combined.
Cash: There have been remarkable increase in Cash.
Receivables : There have been remarkable increase in it.
Inventory : There have been remarkable increase in it.
Working Capital: There is adequate working capita
Current Assets : There have been remarkable increase in it.
Total Assets : There have been remarkable increase in it.
Total Current Liabilities: There have been remarkable increase in it.

Total Long Term Liabilities and Current Liabilities Combined: There have been remarkable increase in it.


4.   Calculate the ratios outlined in Exhibit 15-6 for the 2011 year only.
Please see the attached excel file.


5.   Prepare a report that includes the following:   (1) a brief discussion of the trend analysis of the income statement,
There has been good growth in sales and profitability indicating increase in efficiency.
(2) a brief discussion of the trend analysis of the balance sheet,
There has been increase in assets and liabilities increase in expansion of business.

(3) a brief discussion of the ratios you have computed, including a comparison with industry averages.   Include who would be most interested in each ratio (common stockholders, short-term creditors, and/or long-term creditors).   Include all calculations....