Analysis

1. Chart the Revenue for all hotels over three years. What conclusions can you draw from this chart? Document your conclusion on the chart or on the sheet next to the chart.
2. Chart the Operating Income for all hotels over three years. What conclusions can you draw from this chart? Document your conclusion on the chart or on the sheet next to the chart.
3. Chart the Operating Cash Flow for all hotels over three years. What conclusions can you draw from this chart? Document your conclusion on the chart or on the sheet next to the chart.
4. Create a new sheet called Asset Turnover.
   1. Calculate Asset turnover for all companies for each of the three years. Use formulas with range names if youd like.
   2. Modify your formula to display 0 if assets are 0. Use conditional formatting on this range to identify asset turnover of 0.
   3. Create a chart that shows all hotels with three years of Asset turnover. What conclusions can you draw from this chart? Document your conclusion on the chart or on the sheet next to the chart.
   4. Create three more charts that show each year separately. What conclusions can you draw from these charts? Document your conclusion on the chart or on the sheet next to each chart.
5. Create a new sheet called ROA.
   1. Calculate ROA for all companies for each of the three years. Use formulas with range names if youd like.
   2. Modify your formula to display 0 if assets are 0. Use conditional formatting on this range to identify ROA of 0.
   3. Create a chart that shows all companies with three years of ROA. You will notice that if there is a huge range in these numbers the chart is difficult to read. Delete the chart.
   4. Make a copy of your ROA calculations and then modify the formulas to display 0% if it is <-25%.
   5. Write a statement next to the range of numbers that large negative numbers been changed to 0%.
   6. Use conditional formatting on this range to identify numbers <= 0
   7. Use functions to determine the highest and lowest values in the entire range.
   8. Recreate the chart to show all companies with three years of ROA.
   1. Change the minimum and maximum on the vertical (value) axis to improve readability of the chart.
   10. Change the Label position to improve the readability of the labels.
   11. What conclusions can you draw from this chart? Document your conclusion on the chart or on the sheet next to the chart.
   50. Create three more charts that show each year separately. Use functions to determine the highest and lowest values in each range. Change the minimum and maximum on the vertical (value) axis to improve readability of the charts. What conclusions can you draw from the charts? Document your conclusion on the chart or on the sheet next to each chart.
6. Create a new sheet called Profit Margin.
   1. Calculate Profit Margin for all companies for each of the three years. Use formulas with range names if youd like.
   2. Modify your formula to display 0 if revenue is 0. Use conditional formatting on this range to identify profit margin of 0.
   3. Create a chart that shows all companies with three years of profit margin. You will notice that if there is a huge range in these numbers the chart is difficult to read. Delete the chart.
   4. Make a copy of your profit margin calculations and then modify the formulas to display 0% if it is <-25%.
   5. Write a statement next to the range of numbers that large negative numbers have been changed to 0%.
   6. Use conditional formatting on this range to identify numbers <= 0
   7. Use functions to determine the highest and lowest values in the range.
   8. Recreate a chart that shows all companies with three years of profit margin.
   1. Change the minimum and maximum on the vertical (value) axis to improve readability of the chart.
   10. Change the Label position to improve the readability of the labels.
   11. What conclusions can you draw from this chart? Document your conclusion on the chart or on the sheet next to the chart.
   50. Create three more charts that show each year separately. Use functions to determine the highest and lowest values in each range. Change the minimum and maximum on the vertical (value) axis to improve readability of the charts. What conclusions can you draw from the charts? Document your conclusion on the chart or on the sheet next to each chart.