Question: J. Using the Income Statement vertical Analysis prepared In Excel workbook, conduct Income Statement comparative analysis to the industry benchmarks included in Table 1 and

 J. Using the Income Statement vertical Analysis prepared In Excel workbook,

J. Using the Income Statement vertical Analysis prepared In Excel workbook, conduct Income Statement comparative analysis to the industry benchmarks included in Table 1 and Table 2 of the Appendix. Comment on how the business is performing comparing to the industry. Include comments on Revenue, Cost of sales (excluding personnel costs), Personnel costs, unallocated Operating costs and Total costs proportions. Make recommendations on areas which need improvements or further investigation, based on the results of your comparative analysis. 4. Using the results of the Ratio Analysis in Excel workbook, comment on Profitability, Efficiency, Liquidity and Solvency of the business. With reference to the industry data provided, make recommendations where appropriate. 5. There are additional industry specific performance indicators and benchmarks that the hotel could use when comparing itself to the industry. Conduct a research and recommend 3 additional industry specific benchmarks the hotel could use in their comparative analysis. Include a brief explanation of each benchmark you are recommending including formula where appropriate

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!