INDIVIDUAL LEARNING PROJECT INSTRUCTIONS This project will allow you the opportunity to explore a companys annual report and become familiar with the items it contains. Choose a company from the list below for the subterm in which you are enrolled. Locate the most recent annual report, either from the Liberty University librarys access to Capital IQ NetAdvantage (S&P) database, the EDGAR database (SEC Website), or the companys website. Once located, open Individual Learning Project Questions document and add your answers underneath each question. Do not delete the questions. Questions 5052 must be answered in Microsoft Excel and your answers must include formulas. Both documents (Word and Excel) must be uploaded into the Assignment link.

I chose General Mills as my company.

Analysis: (use Excel to complete this section)

1. 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).
2. 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).
3. 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?

Below is Exhibit 13.16 from my textbook

Please include all formulas/calculations for Excel so I can learn what it is supposed to be.

EXHIBIT 13.16 Financial Statement Analysis Ratics 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 363 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 Interest expense Debt-to-equity ratio Times interest earned Debt versus equity financing 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 Nut income - Preferred dividends Average common stockholders' cquity Shareholders' equity applicable to calon shares Number of common shares outstanding Net income - Preferred dividends Weighted average common shares outstanding Market price per common share Famings per share Antual cash dividende per share Market price per share Profitability of owner investment Liquidation at reported amounts Net income per common share Basic earnings per share Market Prospects Price-earnings ratio Market value relative to earnings Cash return per common share Dividend yield EXHIBIT 13.16 Financial Statement Analysis Ratics 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 363 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 Interest expense Debt-to-equity ratio Times interest earned Debt versus equity financing 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 Nut income - Preferred dividends Average common stockholders' cquity Shareholders' equity applicable to calon shares Number of common shares outstanding Net income - Preferred dividends Weighted average common shares outstanding Market price per common share Famings per share Antual cash dividende per share Market price per share Profitability of owner investment Liquidation at reported amounts Net income per common share Basic earnings per share Market Prospects Price-earnings ratio Market value relative to earnings Cash return per common share Dividend yield