Financial Statement Analysis

 Pick any two U.S. public companies in the same industry.

One company must be Under Armour.

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.

you obtain data from the SEC web site "Interactive Data, then you can copy and paste into Excel.

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