Financial Statement Analysis

Description

New solution updates


Question

Pick any two U.S. public companies in the same industry. ( I have chosen the 2 companies already) and the 10 financial ratio please see the spreadsheet attached) I computed the financial ratios for one company but I am not sure if they are correct. 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. Create a single Excel file for your entire assignment. 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. Attachments: WEEK-3.xlsx

 

Solution ID:565849 | This paper was updated on 26-Nov-2015

Price : $24
SiteLock