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