Compare two major competitors in the same industry

Assignment Help Financial Management

Reference no: EM131250925

Financial Statement Analysis
Learn how to measure the performance of companies by analyzing their financial statements. Show us that you have read and understood the required readings, links and attached files - quote them where appropriate.

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. Manufacturing companies are often the least complicated. Service companies more complicated and banks the most difficult. (WALMART & TARGET)

One of two companies can be the same company. We recommend that you use the company. Professor may provide a list of companies that you may choose from.

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 Sample Answer. This compares Southwest Airlines and Jet Blue Airlines. The "Comparison of Ratios" worksheet shows comparison of ratios, however it does not include the required words about how the ratios were calculated. For example, ROE is defined as Net Income / Total Common Stockholder Equity. It does it include what the numbers mean for management. Please include both in your work.

The tabs or sheets for Income Statement, Balance Sheet and Cash Flow Statement were copied from SEC Interactive Data. Just click on "View Excel Document" to get Excel sheets for each.

We strongly recommend that 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? Please tell us why you picked each ratio.
You may also obtain financial information and the companies' latest annual reports or 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. Please be aware that some financial sites may omit some numbers rather than change the standard format.

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.

We recommend against using banksFinance 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.

Attachment:- Sample-.rar

Reference no: EM131250925

Questions Cloud

Find the cournot equilibrium output and profit per firm : Using the information from parts (a) and (b), construct a 2 × 2 payoff matrix where the strategies available to each of two players are to produce the Cournot equilibrium quantity or half the monopoly quantity.

What is the deadweight loss : a. What is the deadweight loss that would result if the government were to institute a price cap of 20 in this market? b. What is the deadweight loss that would result if the government were to institute a price cap of 30 in this market?

Explain steps and procedures involved in assessment activity : Explain Steps and procedures involved in assessment activity. Details on student engagement in collecting, reflecting, and presenting their learning. Evaluation tool that measures student learning.

Does either student have any dominated strategies : Suppose that Jack and Jill each could borrow money from the other students in the class, so that each of them had a total of $11 to bid. Would ($11, $11) be a Nash equilibrium?

Compare two major competitors in the same industry : Using ratio analysis, compare two major competitors in the same industry. - Pick any two U.S. public companies in the same industry.

Is there a mixed strategy nash equilibrium in this game : Restrict attention again to pure strategies, but now focus on a sequential-move game in which Sony chooses its strategy first. What is (are) the Nash equilibrium (equilibria) of this game?

Enhance environmental assets that need water : There are four basic policy choices to re-allocating water away from extractive use to enhance environmental assets that need water.

Explain relationship between acculturation and biculturalism : Explain the relationship between acculturation, assimilation and biculturalism. Does language play a role in these processes?

Provide a detailed analysis of the play and chosen elements : The "points-to-make" list should include at least THREE statements, expressed in full sentences that indicate the main ideas you need to make in the rest of the essay in order to support the thesis. What does the paper have to develop and analyze ..

User Account

All Pages