Compare two major competitors in the same industry

Assignment Help Corporate Finance
Reference no: EM13200834

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.

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

Follow the same format as in the examples posted in the file attached in the Week 3 Conference for the Drugstore Chains example. Use the "Compare" worksheet. The "W", "C", "Profiles" and "Z Score" worksheets are not required, and nor is the Dupont Analysis.

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. 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.

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

DrugstoreChains.xls. contains a comprehensive analysis of the financial statements of two large drugstore chains. It also shows how to predict bankruptcy with reasonable accuracy by using financial ratios. In addition, there is optional material in the attached DrugstoreChains.xls file that:

a) Illustrates and explains how different companies succeed by focusing on different key ratios like Net Income/Sales, or Sales/Total Assets (asset turnover) or Total Assets/Common Equity (leverage).

c) Shows the source for every number on every Excel worksheet: just click on any number in any Excel worksheet and you will see where it comes from. Showing the source for every number on every Excel worksheet is very important and helpful to readers, and you should do this on all of your Excel spreadsheets.

These assignments are designed to help you to develop your analytical ability and your ability to explain your analysis in words. There are many uses for financial statement ratio analysis, especially in business strategy - for an example, see the "Strategic Control Map" developed by McKinsey & Company, the well-known international strategy consulting firm.

Reference no: EM13200834

Questions Cloud

Course of action to raise revenue : A firm is currently producing in the elastic portion of its demand curve. What course of action do you recommend for it assuming it wants to raise revenue.
Explain distribution approximated by a normal curve : A company installs 5,000 light bulbs, each with an average life of 500 hours, standard deviation of 100 hours, and distribution approximated by a normal curve
What is the value of the levered firm : What is the value of the levered firm and what would happen if debt went down by 20%?
To determine how many resources the firm will employ : When you are given the units of resource, total product, and marginal product. what do you need to find to determine how many resources the firm will employ.
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 are the conditions necessary for a stable cartel : It has been suggested that regulations established to save lives can actually cause a reduction in lives. The theory suggests that regulation increases the costs of goods and services to lower-income groups and as a result of this increase.
Describe criticism incentive contract plan : Suppose you decide to elicit high CEO effort when and if good luck occurs by paying the bonus for $1 billion outcomes only. what criticism can you see with this incentive contract plan.
Do the field with both oil and gas have greater difficulties : Some fields have large enough quantities of both oil and natural gas that coordination must be achieved for the production of both, rather than oil a in our examples. Will fields with both oil and gas have greater difficulties in unitization.
Derive the equation for output : Derive the equation for output per effective worker y = Y/EN = f(k), where k equals the amount of capital per effective worker. or calculate the steady state levels for each.

Reviews

Write a Review

 

Corporate Finance Questions & Answers

  Create liquidators final statement of account

The various assets realized Rs.1,30,000 (excluding securities with secured creditors). Prepare the liquidator's final statement of account.

  Find the present value

Determine the present value if $5,800 received at the end of first year, $6,400 received at the end of second year, and $8,700 at the end of third year.

  Calculation of standard deviation

The following are the historic returns for Chelle Computer Corporation. Determine the correlation coefficient between Chelle Computer and General Index and also calculate the standard deviation.

  Evaluate what is the net income for the year

Common stock increased by $197 and retained earnings decreased by $123 and evaluate what is the net income for the year

  Financial capital in the selected firm as a shareholder

The financial analysis report must be written properly. They must include a title page, a table of contents, and a reference page. For both midterm and final report, information sources from the web, etc. must be cited properly, using APA style.

  Current state of valuing intellectual property

Discuss this issue and prepare a 3-4 page management brief for Acme's upper management group on the current state of valuing intellectual property.

  What is the payback period - the discounted payback period

What is the payback period for the following set of cash flows and what is the discounted payback period for these cash flows if the initial cost is $7,500?

  What is the break-even lease payment

The market value of the car isexpected to depreciate 48% in four years. What is the break-even lease payment? Assumetaxes are irrelevant to this problem

  What is the future value of these cash flows

If the company uses an 8 percent discount rate and what is the future value of these cash flows at the end of year 4?

  Create a table for key financial data

Create a table for a period of three (3) years showing some key financial data for the two firms listed above. Include 4 items from the balance sheet.

  How the deferred taxes will appear on the balance sheet

Prepare the journal entries to record the income tax expense, deferred income taxes, and the income taxes payable for 2012, 2013, and 2014. No deferred income taxes existed at the beginning of 2012.

  Find the yield to maturity on the issue

Suppose Venture Healthcare sold bonds that have a ten year maturity, a 12 percent coupon rate with yearly payments, and a $1,000 par value. Suppose that two years after the bonds were issued, the required interest rate fell to 7%.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd