Use the select data (tab 1) from most of the DOW 30 companies (excluding some financial and other companies) to calculate liquidity, activity, profitability and coverage ratios. (Reminder, do this on

1. Use the select data (tab 1) from most of the DOW 30 companies (excluding some financial and other companies) to calculate liquidity, activity, profitability and coverage ratios. (Reminder, do this on tab 2-Ratios- Student Submission)

Use Tab 3 (Graphs and Short Answers) to submit your graphs and answers to the short answer questions below.

1. Create a bar graph that compares asset turnover ratios.
   • Which types of companies tend to have higher rates of asset turnover?
2. Use column W to divide inventory/total assets. (Ratios- Student Submission)

• Add this measure to your bar graph.
  • What do you notice? Which company doesn’t seem to fit with the others?

1. Pick two other ratios to conduct similar analysis as above. Feel free to create new ratios as we did with the inventory/total assets.
   • What trends do you notice among related industries? Does anything surprise you?