Ans Doc358Y


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 8109
Cash 8442
Other non-current Liabilities 10449
Common Stock 1760
Receivables 4812
Other Current Assets 2973
Long-term Investments 10448
Other Non-current Assets 3585
Property, Plant and Equipment 23486
Trademarks 6527
Other Intangible Assets 20810
Allowance for Doubtful Accounts 53
Accumulated Depreciation 9010
Accounts Payable 8680
Short Term Notes Payable 17874
Prepaid Expenses 2781
Other Current Liabilities 796
Long-Term Liabilities 14736
Paid-in-Capital in Excess of Par Value 11379
Retained Earnings 55038
Inventories 3264
Treasury Stock 35009

Other information taken from the Annual Report:
Sales Revenue for 2012 48017
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

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)