Spreadsheet containing horizontal and vertical analysis and 8 ratios.

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.