Spartan Hotel Information
2018
Rooms revenues will increase by 3.5% over 2017
Food and Beverage revenues will increase by $4400 per day over 2017
Other income will increase by 1.25% over 2017
Salaries, wages and benefits will increase by 0.6% over 2017
Ulilities expenses will increase by 0.4% over 2017
2019
Rooms revenues will increase by 5% over 2018
Food and Beverage revenues will increase by 12% over 2018
Other income will increase by 1.0% over 2018
Salaries, wages and benefits will increase by 0.8% over 2018
Direct operating expenses will increase by 0.4% over 2018
Ulilities expenses will increase by 0.4% over 2018
2020
Rooms revenues will increase by 5% over 2019
Food and Beverage revenues will increase by 10% over 2019
Other income will decrease by 1.5% over 2019
Salaries, wages and benefits will increase by 0.4% over 2019
Direct operating expenses will increase by 0.3% over 2019
General & Administartive expenses will increase by 0.4% over 2019
Ulilities expenses will increase by 0.5% over 2019
Occupancy costs will increase by 0.7% over 2019
Balance Sheet Information -
Use the Balance Sheet information to calculate the pro forma ratios.
Calculate the following ratios for the Spartan Hotel's financial analysis (2018 - 2020)
- Return on Assets
- Return on Equity
- Debt ratio
- Debt to Equity ratio
- Current ratio
- Profit margin
Attachment:- Assignment File.rar