...The Spartan Hotel is a full service 260 room property which is in the process of...

Transcribed Image Text:

...The Spartan Hotel is a full service 260 room property which is in the process of being purchased by a group of private investors. The property has been fully renovated with the exception of the hotel's restaurant which in the process of construction and will be open in January 2021 at a cost of $780,000. The hotel has historically had an average room rate of $160 per night with an average occupancy rate of 88% annually. The total food and beverage revenues for 2021 are expected to be unchanged at $860,000 for the year. The hotel's food and beverage department has traditionally had an 80% to 20% mix of food to beverage revenues. Other income generated mostly from in-room services and is equal to 3% of the hotel's total rooms revenue. Cost of sales percentage will remain constant for the 4 years. After meeting with the investors, management and the controller of the hotel you have been given the following infomation and forecasted figures in order to prepare the 2021-2024 pro forma income statement and the 2021-2024 pro forma balance sheet. Assume all expense percentages remain constant except where increases are noted. Ingnore the fact that 2024 is a leap year. 2022 Rooms revenues will increase by 3.5% over 2021 Food and Beverage revenues will increase by $4400 per day over 2021 Other income will increase by 1.25% over 2021 Salaries, wages and benefits will increase by 0.6% over 2021 Ulilities expenses will increase by 0.4% over 2021 2023 Rooms revenues will increase by 5% over 2022 Food and Beverage revenues will increase by 12% over 2022 Other income will increase by 1.0% over 2022 Salaries, wages and benefits will increase by 0.8% over 2022 Direct operating expenses will increase by 0.4% over 2022 Ulilities expenses will increase by 0.4% over 2022 2024 Rooms revenues will increase by 5% over 2023 Food and Beverage revenues will increase by 10% over 2023 Other income will decrease by 1.5% over 2023 Salaries, wages and benefits will increase by 0.4% over 2023 Direct operating expenses will increase by 0.3% over 2023 General & Administartive expenses will increase by 0.4% over 2023 Ulilities expenses will increase by 0.5% over 2023 Occupancy costs will increase by 0.7% over 2023 NOTE: For all years assume the that food to beverage revenues mix remains 80% to 20% Round all figures after calculating to the nearest dollar (no cents) and percentages to the nearest 0.1% (i.e. 23.441 = 23.4) 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 (2022 - 2024) Return on Assets Return on Equity Debt ratio Debt to Equity ratio Current ratio Profit margin ...The Spartan Hotel is a full service 260 room property which is in the process of being purchased by a group of private investors. The property has been fully renovated with the exception of the hotel's restaurant which in the process of construction and will be open in January 2021 at a cost of $780,000. The hotel has historically had an average room rate of $160 per night with an average occupancy rate of 88% annually. The total food and beverage revenues for 2021 are expected to be unchanged at $860,000 for the year. The hotel's food and beverage department has traditionally had an 80% to 20% mix of food to beverage revenues. Other income generated mostly from in-room services and is equal to 3% of the hotel's total rooms revenue. Cost of sales percentage will remain constant for the 4 years. After meeting with the investors, management and the controller of the hotel you have been given the following infomation and forecasted figures in order to prepare the 2021-2024 pro forma income statement and the 2021-2024 pro forma balance sheet. Assume all expense percentages remain constant except where increases are noted. Ingnore the fact that 2024 is a leap year. 2022 Rooms revenues will increase by 3.5% over 2021 Food and Beverage revenues will increase by $4400 per day over 2021 Other income will increase by 1.25% over 2021 Salaries, wages and benefits will increase by 0.6% over 2021 Ulilities expenses will increase by 0.4% over 2021 2023 Rooms revenues will increase by 5% over 2022 Food and Beverage revenues will increase by 12% over 2022 Other income will increase by 1.0% over 2022 Salaries, wages and benefits will increase by 0.8% over 2022 Direct operating expenses will increase by 0.4% over 2022 Ulilities expenses will increase by 0.4% over 2022 2024 Rooms revenues will increase by 5% over 2023 Food and Beverage revenues will increase by 10% over 2023 Other income will decrease by 1.5% over 2023 Salaries, wages and benefits will increase by 0.4% over 2023 Direct operating expenses will increase by 0.3% over 2023 General & Administartive expenses will increase by 0.4% over 2023 Ulilities expenses will increase by 0.5% over 2023 Occupancy costs will increase by 0.7% over 2023 NOTE: For all years assume the that food to beverage revenues mix remains 80% to 20% Round all figures after calculating to the nearest dollar (no cents) and percentages to the nearest 0.1% (i.e. 23.441 = 23.4) 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 (2022 - 2024) Return on Assets Return on Equity Debt ratio Debt to Equity ratio Current ratio Profit margin

Answer rating: 100% (QA)

Here are the calculations for the pro forma income statement and balance sheet for the Spartan Hotel for 20212024 along with the requested financial ratios 2021 Pro Forma Income Statement Rooms Revenu... View the full answer