ALL OF THIS MUST BE DONE VIA EXCEL
Company name: General Mills Competitor: Kellogg’s
General Mills is the company. You must obtain the financials for the most recent three-year period. Based on the company financials
- Prepare a Horizontal Analysis for all 3 financial statements
- Prepare a Vertical Analysis for the Balance Sheet and Income Statement
- Prepare a Ratio Analysis for each of the following:
a. Current ratio
b. Acid-test ratio
c. Receivable turnover
d. Inventory turnover
e. Profit margin
f. Asset turnover
g. Return on Assets
h. Return on Common Stockholder’s Equity
i. EPS (Earnings Per Share)
j. Debt to total Assets ratio
k. Times Interest Earned
The financial statements for General Mills can be retrieved at their website or at sec.gov. You must use the most recent 2 years for your analysis. Their competitor is Kellogg’s. You will also create a ratio analysis for Kellogg’s and compare them to General Mills
Your analysis should include a comparative analysis that is Intracompany (Horizontal & Vertical analysis for 2 years) and Intercompany (by way comparison of Ratios to a Major Competitor for the most recent year). Possible explanations for major differences should be provided. You must use a formula for all numbers that require a calculation (ratio, total, difference, etc.)
ALL OF THIS MUST BE DONE VIA EXCEL
