COMPLETE THE FOLLOWING FOR McDonald's Corp. (the fast food chain) IN AN EXCEL SPREADSHEET:

Choose a publicly traded company and perform an expanded analysis on the financial statements. Please use the most current annual statements in finance.yahoo.com http://finance.yahoo.com.

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 Altmans 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). *label each ratio, showing all work.