1.(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,009Other 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,921Required: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.