Compare two major competitors in the same industry

Reference no: EM13820077

You are the assistant to the CEO of a major company. Your CEO keeps an eye on the competition, and asks you to do the following. Using ratio analysis, compare two major competitors in the same industry.

Instructions:

The two companies that I chose Apple and Microsoft

Select the 10 most important financial ratios for your two companies and calculate each for the last 2 fiscal years using Excel. Please see attached assignment format Excel you should use this format to provide the answers.

1. Create a single Excel file for your entire assignment.

2. You may obtain financial information and the companies' latest annual reports on the web directly from MSN Money or Yahoo Finance. For additional information, look for the SEC Form10-K link from one of the MSN Money or Yahoo Finance financial sites.

3. You should calculate, and comment upon, all 10 financial ratios for the last 2 fiscal years.

4. All calculations should be shown, and all answers should be thoroughly explained.

5. It is useful to compare financial ratios for a company with financial ratios of its industry. Industry financial ratios can be found on Morningstar.com, Yahoo Finance and MSN Money

6. Whenever you use balance sheet items to calculate ratios, for each year be sure to average the beginning-of-year and end-of-year amounts to get the average for that year.

7. What can you tell from your analysis? What are the strengths and weaknesses of each company? Which is the stronger competitor? Give your reasons.

Reference no: EM13820077

Questions Cloud

Analysis of the two capital investment alternatives : As a financial analyst at Glencolin International (GI) you have been asked to revisit your analysis of the two capital investment alternatives submitted by the production department of the firm. (Detailed discussion of these alternatives is in the..

What role does customer relationship management play : What role, if any, does customer relationship management play when dealing with difficult buyers like Mr. Logan? Should Marilyn do like most salespeople who "win" orders from Mr. Logan-simply cut back on product quality?

Program on java functional testing : Java functional testing

Legal questions that may be asked during the interview : Prepare an advertisement for that position that complies with federal law. Prepare 10 illegal questions that must not be asked. For each question, be sure to justify your reasoning. Prepare 10 legal questions that may be asked during the interview. F..

Compare two major competitors in the same industry : You are the assistant to the CEO of a major company. Your CEO keeps an eye on the competition, and asks you to do the following. Using ratio analysis, compare two major competitors in the same industry.

Create a business plan for a fictitious : Based on the information we have discussed in class and the research you have done, create a business plan for a fictitious "for profit" company or Franchise

What action would be necessary to prevent a cave-in : Describe four key elements with process and the safety significance of the professional engineering - Review the OSHA Standard Interpretations for Crane Operator Qualification, and include your thoughts for operator testing.

Whats the difference between a filter and a query : Whats the difference between a filter and a query

Can any moral issue be resolved without scrapping bruce : Does this situation present any moral dilemmas for Bruce or his supervisor? Explain. Can any moral issue be resolved without scrapping Bruce's organizational plan completely?

User Account

All Pages