When using balance sheet items to calculate ratios

Assignment Help Business Economics

Reference no: EM13772509

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. (Nike and Under Armour)

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.

Create a single Excel file for your entire assignment.

You may obtain financial information and the companies' latest annual reports on the web directly from MSN Money or Yahoo Finance or Morningstar. 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.

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

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

Questions Cloud

Question regarding the innovative organizations : In a two- to three-page paper (not including the title and reference pages), research an organization you consider innovative. Describe the elements that make the organization innovative. Explain how innovation has contributed to the organization'..

Use nontariff barriers to distort natural trade patterns : While tariffs and quotas have declined drastically under GATT and the WTO, nontariff barriers have been on the rise. Why would countries use nontariff barriers to distort natural trade patterns? Are there situations when the use of nontariff barriers..

Strengths and weakness of various criminological theories : The purpose of this assignment is to critically assess the strengths and weakness of various criminological theories

Mobility of people between countries : Globalization has caused extensive shifts in the mobility of people between countries. Economics, political shifts, and increased opportunities for travel have made migration and immigration pervasive.

When using balance sheet items to calculate ratios : 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. One of your two companies can be the same compa..

Discuss the reasons why people use drugs : Discuss the reasons why people use drugs. Explain how we as a society should best deal with those who develop problematic use issues with drugs and alcohol

Interplay between drug trafficking and insurgent terrorists : Discuss the interplay between drug trafficking and insurgent terrorists. What evidence exists for supporting a link with the FARC and drug trafficking

Contractionary policies stimulate the economy : The deficit is the sum of yearly government debts. If the macroeconomic equilibrium is above the full employment equilibrium, the economy is in an inflationary situation. Autonomous consumption changes with the amount of a household’s income. Contrac..

The purpose and philosophy of quality improvement : Explain how this milestone relates to the purpose and philosophy of quality improvement.

User Account

All Pages