accounting project 6

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

  1. Prepare a Horizontal Analysis for all 3 financial statements
  2. Prepare a Vertical Analysis for the Balance Sheet and Income Statement
  3. 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

 
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.

Buy Custom Nursing Papers