(TCO A) Below you will find selected information (in millions) from Coca-Cola Co.’s 2012 Annual Report:Income Taxes Payable $471Short-term Investments and Marketable Securities 8,109Cash 8,442Other non-current Liabilities 10,449Common Stock 1,760Receivables 4,812Other Current Assets 2,973Long-term Investments 10,448Other Non-current Assets 3,585Property, Plant and Equipment 23,486Trademarks 6,527Other Intangible Assets 20,810Allowance for Doubtful Accounts 53Accumulated Depreciation 9,010Accounts Payable 8,680Short Term Notes Payable 17,874Prepaid Expenses 2,781Other Current Liabilities 796Long-Term Liabilities 14,736Paid-in-Capital in Excess of Par Value 11,379Retained Earnings 55,038Inventories 3,264Treasury Stock 35,009
Other information taken from the Annual Report:
Sales Revenue for 2012 $48,017Cost of Goods Sold for 2012 19,053Net Income for 2012 9,019Inventory Balance on 12/31/11 3,092Net Accounts Receivable Balance on 12/31/11 4,920Total Assets on 12/31/11 79,974Equity 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,080Accounts Receivable 6,768Cash 7,781Common Stock 3,952Cost of Goods Sold 352,488Income Tax Expense 7,981Interest Expenses 2,064Membership Revenues 3,048Net Sales 466,114Operating, Selling and Administrative Expenses 88,873Retained Earnings 72,978Required:
Using the information provided above:1. Prepare a multiple-step income statement2. 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)

(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.