(TCO A) 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 the Current Ratio and Return on common stockholders’ equity ratio. (Make sure to show all your work).