Select two companies and perform an in-depth financial statement analysis using annual data for the past 5
Question:
Select two companies and perform an in-depth financial statement analysis using annual data for the past 5 years. One must be a blue chip company listed in the Dow Jones Industrial Average. Data can be found at http://finance.yahoo.com and/or
Your discussion and analysis of each company should include:
• Company background
• Industry outlook
• Analysts’ forecasts
• Revenue, price, and income trend analysis
• Financial ratio analysis (uses the Ratio Analysis Table; note that you will need to complete two charts, one for each company)
• Altman’s Z-score calculation for at least three years
• Discussion of any ethical concerns about this and explanation of what could be done to improve or promote ethical behavior Analyze the financial health of each company and make recommendations on whether or not each company would be a good buy and why. Your paper should meet the following requirements:
• Include Excel spreadsheets with computations, using clearly labeled separate worksheets for each analysis (i.e. ratio analysis, trend analysis, Altman’s Z-score, etc.); these spreadsheets should be embedded in the Word document as an appendix after your analysis and explanations.
Mathematical Applications for the Management Life and Social Sciences
ISBN: 978-1305108042
11th edition
Authors: Ronald J. Harshbarger, James J. Reynolds