Below you will find selected information (in millions) from Coca-Cola Co.’s 2012 Annual Report:
bestwritterBelow you will find selected information (in millions) from Coca-Cola Co.’s 2012 Annual Report:
Income Taxes Payable | $471 |
Short-term Investments and Marketable Securities
| 8,109 |
Cash | 8,442 |
Other non-current Liabilities | 10,449 |
Common Stock | 1,760 |
Receivables | 4,812 |
Other Current Assets | 2,973 |
Long-term Investments
| 10,448 |
Other Non-current Assets
| 3,585 |
Property, Plant and Equipment
| 23,486 |
Trademarks | 6,527 |
Other Intangible Assets
| 20,810 |
Allowance for Doubtful Accounts | 53 |
Accumulated Depreciation
| 9,010 |
Accounts Payable
| 8,680 |
Short Term Notes Payable
| 17,874 |
Prepaid Expenses
| 2,781 |
Other Current Liabilities | 796 |
Long-Term Liabilities
| 14,736 |
Paid-in-Capital in Excess of Par Value
| 11,379 |
Retained Earnings
| 55,038 |
Inventories
| 3,264 |
Treasury Stock
| 35,009 |
Other information taken from the Annual Report:
Sales Revenue for 2012
| $48,017
|
Cost of Goods Sold for 2012
| 19,053
|
Net Income for 2012
| 9,019
|
Inventory Balance on 12/31/11
| 3,092
|
Net Accounts Receivable Balance on 12/31/11
| 4,920
|
Total Assets on 12/31/11
| 79,974
|
Equity Balance on 12/31/11
| 31,921
|
Required:
1. Using the information provided prepare a Balance Sheet. Separate the current assets from non-current assets and provide a total for each. Also separate the current liabilities from the non-current liabilities and provide a total for each.
2. Using the Balance Sheet from your answer above calculate; Current Ratio, Days in Inventory, Average Collection Period, Return on Assets Ratio, Debt to Total Assets and Return on common stockholders’ equity ratio. (Make sure to show all your work)
13 years ago
Purchase the answer to view it
coca_cola_co_2012_update_solution.xlsx
