Compare two major competitors in the same industry

Assignment Help Financial Management

Reference no: EM13976270

Assignment:

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:

Pick any two U.S. public companies in the same industry.

One of your two companies can be the same company you used in Week 2.

Select the 10 most important financial ratios for your two companies and calculate each for the last 2 fiscal years using Excel. Explain why you selected these ratios.

Create a comparison chart for these 10 ratios for 2 years for each company. Explain how you calculated each ratio. Explain what each ratio should mean to management.

There is an example posted in the file attached in the Week 3 Conference for the Drugstore Chains example. The "Compare" worksheet shows comparison of ratios, however it does not include the required words about how the ratios were calculated nor does it include what the numbers mean for management.

The "W", "C", "Profiles" and "Z Score" worksheets are not required, and nor is the Dupont Analysis. You will note that the W and C worksheets are used to calculate average balance sheet numbers. These are useful when there are large year to year changes on the balance sheet. You may use year end numbers for balance sheet items to simplify calculations if you like. This example is more complex than you need and includes added information that is nice to know but not required.

If you obtain data from the SEC web site "Interactive Data, then you can copy and paste into Excel. If you use data from other web sites, it may not allow excel to calculate ratios.

Create a single Excel file for your entire assignment. Spend time to understand what you are trying to do and simplify your format, your calculations and approach. Think about which ratios are important and WHY?

You may obtain financial information and the companies' latest annual reports on the web directly from MSN Money or Yahoo Finance or Morningstar. However, it may be necessary to enter the numbers by hand into excel to allow Excel to calculate ratios. For additional information, look for the SEC Form10-K link from one of the MSN Money, or Morningstar, or Yahoo Finance financial sites.

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

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

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.

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: EM13976270

Questions Cloud

The market value of the forklift decreases : A forklift can be purchased for $30,000. The market value of the forklift decreases by 20% of the previous year’s value for 2 years, and then by 15% in years 3 through 10. Maintenance is $400 in years 1 and 2, and then jumps to $750 in year 3. After ..

What is the net new long-term debt : Suppose Raines Umbrella Corp. paid out $59,000 in cash dividends. Is this possible? If spending on net fixed assets and net working capital was zero, and if no new stock was issued during the year, what is the net new long-term debt?

Saving for the college education of your two children : You are saving for the college education of your two children. They are two years apart in age; one will begin college 14 years from today and the other will begin 16 years from today. You estimate your children’s college expenses to be $38,000 per y..

Formulate the linear programming model for the problem : Semicond is a small electronics company that manufactures tape recorders and radios. The per-unit labor costs, raw materials, and selling price of each product are given in Table 1. On December 1, 1997, Semicond has available raw material that is suf..

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. What can you tell from your analysis? What are ..

Mortgage with monthly payments : You are buying a house and the mortgage company offers to let you pay a "point" (1% of the total amount of the loan) to reduce your APR from 6.5% to 6.25% on your $400,000, 30 year mortgage with monthly payments. If you plan to be in the house for at..

What is your return on investment for each of these for year : You invest $1,000 in Xenon Corporation stock (10 shares at $100 per share) and another $1,000 in a Xenon Corporation bond (1 bond with a $1,000 face value) that pays 8% interest annually. Xenon has a phenomenal year and distributes $5 per share to it..

Would an income-multiple approach result : Gwen is a single parent who earns $40,000 per year. Her household expense are $28,000 per year. If she were to die, she estimates that the costs of her death would be $10,000. Would an income-multiple approach result in Gwen's purchase of sufficient ..

When net income is converted to cash flow from operations : Explain why equity in on come of investees appears as a subtraction when net income is converted to cash flow from operations?

User Account

All Pages