USA: +1(669)289-8683 
Sign in
I have to create a Balance Sheet with the below information for an assignment due in a few hours.
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; 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)
