Show all calculations used (equations used in calculating each). Use excel workbook (worksheet) 1. Liquidity Analysis: Selected financial statement data for MMA forment 2012 2011 Select income statement information Sales 51.800.000 $1,700.000 Cost of goods sold 1,200,000 1.120,000 Select balance sheet information Cash $ 300,000 5 290,000 Temporary investments 100.000 100,000 Accounts receivable ineti 200,000 T60,000 Inventory 160.000 T 40.000 Accounts payable 400.000 350,000 Based on these data, calculate the following liquidity measures for 2012, and explain how each of the ratio is used: a. Current ratio b. Quick ratio Accounts receivable turnover Number of Days Sales in Receivables e. Inventory turnover . Number of day sales in inventory 2. Horizontal and Vertical Analyses Select income statement data for Baker Company for two recent years ended December 31 are as follows: 2012 2011 Sales 52,200,000 52.000.000 Cost of goods sold 1.337,500 250.000 Gross profit 5 862,500 $ 750.000 Selling general, and administrative expenses 440.000 400.000 Income from operations $422.500 $ 350.000 Prepare horizontal and vertical analysis of Baker's income statement. (Round percentages to one decimal place and explain what each cant 3. Solvency Analysis: The following are select balance sheet and income statement data for OMMA Inc. for a recent Year Dec.31.2013 Anet Curre 160.000 Property, plant and 400.000 Totalanes Curities $180.000 Long ter 400 000 Totalbes 556000 Stockholders' Equity Common stock 55 par 1.200.000 sind aminos 1.300.000 Tettstocht SLOT Yet bien sockholders equity STO Select income statement information $ 100.000 Income before inceta 200.000 Based on these data, calculate the following schemes, de wachte means 1. Ratio of fedts to long-term biti 2. Ratio of toiles to stockholders 3. Time interest earned 4. Profitability Analysis: The following data were taken from the financial statements of road Street for rent year Shares of common stock outstanding 20,000 Sales $2,400,000 Interest expense 40.000 Net Income 250,000 Market price per share of common stock at year-end 120.00 Dividends per share of common stock 3.00 Average total assets fexduding long-term investments) 1,600,000 Average total assets 2.000.000 Average total stockholders' equity 1,000,000 Based on these data, determine the following prayers and chain what each meand 1. Asset tumover 2. Return on total 1. Return on stockholders equity 4. Earnings per than 5. Price-camins ratio E Dividend Vield