Perform an expanded analysis on the financial statements for McDonald’s Corp (the fast food chain). Please use the most current annual statements in finance.yahoo.com http://finance.yahoo.com.
Please complete the following for your chosen firm in an Excel spreadsheet:
1. Horizontal and vertical analysis of the Income Statements for the past three years (all yearly balances set as a percentage of total revenues for that year).
2. Horizontal and vertical analysis of the Balance Sheets for the past three years (all yearly balances set as a percentage of total assets for that year).
3. Ratio analysis (eight ratios of your choosing) for the past three years PLUS a measurement for the creditworthiness of your firm as measured by Altman’s Z-score. *Please use the four ratios from DuPont equation first then look at ratios related to the troublesome ratios that may be found to make up the 8 total (for example if the asset turnover is declining, do the inventory turnover rate since it is related).
**I found the McDonald’s Corp financial statements on financeyahoo.com for three years.
0 comments