Purchase Solution

Financial Statement Analysis for U.S Public Company

Not what you're looking for?

Ask Custom Question

Financial Statement Analysis

Our purpose this week: learning 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. ( I WANT TO USE DELTA AIRLINES AND SOUTHWEST AIRLINES)

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.

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. (YEAR 2014 AND 2013)

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.

Purchase this Solution

Solution Summary

The expert examines learning how to measure the performance of companies by analyzing their financial statements. The response addresses the query is posted in the excel file attached.

Solution provided by:
Education
  • MBA (IP), International Center for Internationa Business
  • BBA, University of Rajasthan
Recent Feedback
  • "Thank You so much! "
  • "Always provide great help, I highly recommend Mr. Sharma over others, thanks again. "
  • "great job. I will need another help from you. "
  • "first class!"
  • "Thank you for your great notes. Will you be willing to help me with one more assignment? "
Purchase this Solution


Free BrainMass Quizzes
Six Sigma for Process Improvement

A high level understanding of Six Sigma and what it is all about. This just gives you a glimpse of Six Sigma which entails more in-depth knowledge of processes and techniques.

MS Word 2010-Tricky Features

These questions are based on features of the previous word versions that were easy to figure out, but now seem more hidden to me.

SWOT

This quiz will test your understanding of the SWOT analysis, including terms, concepts, uses, advantages, and process.

Marketing Research and Forecasting

The following quiz will assess your ability to identify steps in the marketing research process. Understanding this information will provide fundamental knowledge related to marketing research.

Business Processes

This quiz is intended to help business students better understand business processes, including those related to manufacturing and marketing. The questions focus on terms used to describe business processes and marketing activities.