Analysis: (use Excel to complete this section) COMPANY: General Mills INC.
- Provide common-size analysis of your companys income statement and balance sheet for the 2 most recent years (must be done using Excel with formulas).
- Provide horizontal analysis of your companys income statement and balance sheet, showing the dollar amount and percent of change using the 2 most recent years (you must use an Excel spreadsheet with formulas).
- Perform ratio analysis on your company using the ratios listed in Exhibit 13.16 on page 505 of your text (these must be in an Excel spreadsheet, using formulas to calculate the ratios). You should present them in a similar format as the text: group by category, list name of ratio, formula in words, and the ratio calculation. Give a short explanation of your conclusions about your company after each category of ratios (i.e. How liquid is your company? How efficiently is it using its assets? etc.).
Odata cold-2F1770 1975340909519702304393794.22%5Bdstawid 7400264258322246111ables a A G EXHIBIT 13.16 Financial Statement Analysis Ratios Formula Measure of Ratio Liquidity and Efficiency Current ratio Acid-test ratio Accounts receivable turnover Inventory turnover Current assets Short-term debt-paying ability Current liabilities Cash + Short-term investments + Current receivables Immediate short-term debt- Current liabilities paying ability Net sales Efficiency of collection Average accounts receivable, net Cost of goods sold Efficiency of inventory Average inventory management Accounts receivable, net Liquidity of receivables Net sales Ending inventory Liquidity of inventory Cost of goods sold Net sales Efficiency of assets in Average total assets producing sales Days' sales uncollected X 365 Days' sales in inventory X 365 Total asset turnover Solvency Debt ratio = Creditor financing and leverage Owner financing Equity ratio = Total liabilities Total assets Total equity Total assets Total liabilities Total equity Income before interest expense and income Debt versus equity financing Debt-to-equity ratio Protection in meeting interest earned 197020304993797524%2F25Bdata wid7e4b0e0626462983da2224611 Debt ratio Equity ratio Creditor financing and leverage Owner financing Debt-to-equity ratio Total liabilities Total assets Total equity Total assets Total liabilities Total equity Income before interest expense and income Interest expense Debt versus equity financing Times interest earned Protection in meeting interest payments Profitability Profit margin ratio Gross margin ratio Net income in each sales dollar Gross margin in each sales dollar Overall profitability of assets Return on total assets Return on common stockholders' equity Book value per common share Net income Net sales Net sales Cost of goods sold Net sales Net income Average total assets Net income Preferred dividends Average common stockholders' equity Shareholders' equity applicable to common shares Number of common shares outstanding Net income Preferred dividends Weighted-average common shares outstanding Profitability of owner investment Liquidation at reported amounts Net income per common share Basic earnings per share Market Prospects Price-earnings ratio Market price per common share Earnings per share Annual cash dividends per share Market price per share Market value relative to earnings Cash return per common share Dividend yield Odata cold-2F1770 1975340909519702304393794.22%5Bdstawid 7400264258322246111ables a A G EXHIBIT 13.16 Financial Statement Analysis Ratios Formula Measure of Ratio Liquidity and Efficiency Current ratio Acid-test ratio Accounts receivable turnover Inventory turnover Current assets Short-term debt-paying ability Current liabilities Cash + Short-term investments + Current receivables Immediate short-term debt- Current liabilities paying ability Net sales Efficiency of collection Average accounts receivable, net Cost of goods sold Efficiency of inventory Average inventory management Accounts receivable, net Liquidity of receivables Net sales Ending inventory Liquidity of inventory Cost of goods sold Net sales Efficiency of assets in Average total assets producing sales Days' sales uncollected X 365 Days' sales in inventory X 365 Total asset turnover Solvency Debt ratio = Creditor financing and leverage Owner financing Equity ratio = Total liabilities Total assets Total equity Total assets Total liabilities Total equity Income before interest expense and income Debt versus equity financing Debt-to-equity ratio Protection in meeting interest earned 197020304993797524%2F25Bdata wid7e4b0e0626462983da2224611 Debt ratio Equity ratio Creditor financing and leverage Owner financing Debt-to-equity ratio Total liabilities Total assets Total equity Total assets Total liabilities Total equity Income before interest expense and income Interest expense Debt versus equity financing Times interest earned Protection in meeting interest payments Profitability Profit margin ratio Gross margin ratio Net income in each sales dollar Gross margin in each sales dollar Overall profitability of assets Return on total assets Return on common stockholders' equity Book value per common share Net income Net sales Net sales Cost of goods sold Net sales Net income Average total assets Net income Preferred dividends Average common stockholders' equity Shareholders' equity applicable to common shares Number of common shares outstanding Net income Preferred dividends Weighted-average common shares outstanding Profitability of owner investment Liquidation at reported amounts Net income per common share Basic earnings per share Market Prospects Price-earnings ratio Market price per common share Earnings per share Annual cash dividends per share Market price per share Market value relative to earnings Cash return per common share Dividend yield
