Reference no: EM131131593
Financial Statement Analysis
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.
|
Bloom taxonomy and granello article
: What does synthesize mean within the context of Bloom's Taxonomy and Granello's article?- What patterns have you started to identify from reading your research articles so far?
|
|
Explain how the multiplier effect works
: Any change in the economy's total expenditures would be expected to translate into a change in GDP that was larger than the initial change in spending. This phenomenon is known as themultiplier effect. Explain how the multiplier effect works
|
|
Identify the controversy
: You might find it useful to read your local newspaper, browse through your textbook, or search online for an environmental controversy that you wish to research throughout the rest of the course. Once you have determined an issue, write a brief, 1..
|
|
Determine equilibrium price and quantity under free trade
: Consider a competitive market served by many domestic and foreign firms. The domestic demand for these firms' product is Qd = 600 - 2.5P. Determine the equilibrium price and quantity under free trade
|
|
Explain what each ratio should mean to management
: 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.
|
|
What is the intensity across the room at a distance of 2.5 m
: The intensity of light from a lightbulb is 12 W/m2 at a distance of 0.45 m from the bulb. What is the intensity across the room at a distance of 2.5 m?
|
|
Evaluate projections for each of the available projects
: Examples of opportunities include taking on new customers, capitalizing on supplier discounts, and reducing inventory.
|
|
Does a stem cell have the same status as a human
: Does a stem cell have the same status as a human? What should be done with the embryos that are left over at in vitro fertilization (IVF), clinics? Advocates argue that the medical benefits of stem cell research would be enormous. Opponents argue ..
|
|
What is the meaning of the coase theorem
: What is the meaning of the Coase theorem can't understand how it leads to efficient allocation of resources, any tutor who can explain
|