...The Spartan Hotel is a full service 260 room property which is in the process of...
Fantastic news! We've Found the answer you've been seeking!
Question:
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
Expert Answer:
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
Related Book For
Posted Date:
Students also viewed these accounting questions
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
The following trial balance was drawn from the records of Havel Company as of October 1, 2018: Required a. Divide the class into groups, each with four or five students. Organize the groups into...
-
Write a static method lg() that takes an int argument n and returns the largest integer not larger than the base-2 logarithm of n. Do not use the Math library.
-
On January 1, 2011, Lennon Corporation acquires 100% of Ono Inc. for $220,000 in cash. The condensed balance sheets of the two corporations immediately following the acquisition are as follows....
-
The use of off-road recreational vehicles may double in the next 20 years. Enthusiasts would like increased access to government-owned deserts like the one shown in Figure 24.1A. Some argue that...
-
In a certain state lottery, people select eight numbers in advance of a random drawing of six numbers. If someone's selections include the six drawn, they receive a large prize, but this prize is...
-
Compute key ratios and other financial measures for Crazy Eddie during the period 19841987. Identify and briefly explain the red flags in Crazy Eddies financial statements that suggested the firm...
-
If I threw a 1 . 0 kg text book up into the air with a speed of 5 . 0 km / s , what maximum height would it reach? The mass of the Earth is 5 . 9 8 x 1 0 ^ 2 4 kg and its radius is 6 . 3 8 1 0 ^ 6...
-
B52 Skate Training prepares adjustments annually and showed the following on its June 30, 2020, year-end: Additional information available at year-end: a. The Prepaid Arena Rental of $182,000 was...
-
The arrival of the passengers at the airport for airplane A will be a Poisson process with the intensity l4 ( the average number of arriving passengers per unit interval). The airplane A will take...
-
How would you go about changing the culture of an organization to improve the level of cooperation and communication?
-
How can Catherine Keogh best leverage the sponsorship of the Games to achieve the market development and sales growth objectives of Alltech?
-
Should Pearse Lyons have used a more extended process of decision-making in making the decision to act as sponsor?
-
What do you believe would be the best way to get a finance-oriented CEO to support marketing and its efforts to get silos to work together on offerings, brands, and mar keting programmes?
-
What skills, resources, or competencies did HTC bring to the branded mobile phone market? If a board member, would you have supported IITCs initial move to sell branded phones? Why? Ww hy not?
-
If Dr. Evil out that holding the earth ransom for $10,000,000 in 2017 is the same thing as demanding $1,000,000 in 1967, approximately what rate of inflation was he using to make that assumption? You...
-
Presented below are income statements prepared on a LIFO and FIFO basis for Kenseth Company, which started operations on January 1, 2024. The company presently uses the LIFO method of pricing its...
-
Five advertising companies jointly buy a jet aircraft. They enter into an agreement whereby each party has the right to use the aircraft for its own purposes some days each year. The parties may...
-
Aries Inc. holds a 90% interest in Sharatan Ltd., a corporation based in France. The functional currency of Sharatan (self-sustaining subsidiary) is the euro. Aries's interest in Sharatan was...
-
Why would a company present its financial statement in a currency that is different than its functional currency?
-
Who was Phar-Mors flamboyant Chief Executive Officer?
-
Which of the following generally is not considered something of value? 1. Cash, money or checks 2. Airline miles or hotel credits associated with frequent activity (e.g., frequent flier miles) 3. An...
-
Which of the following is not one of the five major categories of fraudulent disbursements? 1. Payroll schemes 2. Expense reimbursement schemes 3. Shell company schemes 4. Billing schemes
Study smarter with the SolutionInn App