Below 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)