Question

Below you will find selected information (in millions) fromCoca-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 BalanceSheet. Separate the current assets from non-current assets andprovide a total for each. Also, separate the current liabilitiesfrom the non-current liabilities and provide a total foreach.
2: Using the Balance Sheet from your answer above, calculate theCurrent Ratio and Return on common stockholders’ equity.