tco a below you will find selected information in millions from coca cola co s 2012 501254

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; 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 . (TCO B) The following selected data was retrieved from the Wal-Mart, Inc. financial statements for the year ending January 31, 2013:

Accounts Payable $38,080
Accounts Receivable 6,768
Cash 7,781
Common Stock 3,952
Cost of Goods Sold 352,488
Income Tax Expense 7,981
Interest Expenses 2,064
Membership Revenues 3,048
Net Sales 466,114
Operating, Selling and Administrative Expenses 88,873
Retained Earnings 72,978
Required:

Using the information provided above:
1. Prepare a multiple-step income statement
2. Calculate the Profit Margin, and Gross profit rate for the company. Be sure to provide the formula you are using, show your calculations, and discuss your findings/results.
(Points : 36)