Question 1.1. (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 | 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 the Current Ratio and Return on common stockholders equity. |