Spartan Hotel Information You have been assigned to prepare and analyze pro forma financial statements for the Spartan Hotel. The Spartan Hotel is a full service 280 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 2023 at a cost of $780,000. The hotel has historically had an average room rate of $180 per night with an average occupancy rate of 86% annually. The total food and beverage revenues for 2022 are expected to be unchanged at $890,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 2.5% 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 information and forecasted figures in order to prepare the 2022-2025 pro forma income statement and the 2022-2025 pro forma balance sheet. Assume all expense percentages remain constant except where increases are noted. Ingnore the fact that 2024 is a leap year. 2023 Rooms revenues will increase by 3.75% over 2022 Food and Beverage revenues will increase by $4500 per day over 2022 Other income will increase by 1.5% over 2022 Salaries, wages and benefits will increase by 0.7% over 2022 Ulilities expenses will increase by 0.5% over 2022 2024 Rooms revenues will increase by 6% over 2023 Food and Beverage revenues will increase by 14% over 2023 Other income will increase by 1.0% over 2023 Salaries, wages and benefits will increase by 1.0% over 2023 Direct operating expenses will increase by 0.4% over 2023 Ulilities expenses will increase by 0.5% over 2023 2025 Rooms revenues will increase by 6% over 2024 Food and Beverage revenues will increase by 12% over 2024 Other income will decrease by 1.5% over 2024 Salaries, wages and benefits will increase by 0.5% over 2024 Direct operating expenses will increase by 0.4% over 2024 General & Administrative expenses will increase by 0.3% over 2024 Ulilities expenses will increase by 0.6% over 2024 Occupancy costs will increase by 0.7% over 2024 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 (2023 - 2025) Return on Assets Return on Equity Debt ratio Debt to Equity ratio Current ratio Profit margin

NAME: \begin{tabular}{l} Spartan Hotel \\ Balance Sheet \\ \hline \end{tabular} \begin{tabular}{|c|} \hline 31Dec22 Dollars \\ \hline \end{tabular} \begin{tabular}{|c|} \hline 31-Dec-23 Dollars \\ \hline \end{tabular} \begin{tabular}{|c|} \hline 31-Dec-24 Dollars \\ \hline \end{tabular} \begin{tabular}{|c|} \hline 31-Dec-25 \\ Dollars \\ \hline \end{tabular} TOTAL ASSETS $18,651,090 $19,430,890 \begin{tabular}{|l|} \hline$19,200,600 \\ \hline \end{tabular} $20,155,650 LIABILITIES \& OWNER'S EQUITY \begin{tabular}{l} \hline Current Liabilities \\ \hline Long-Term Liabilities \\ \hline Investors' Equity \\ \hline \end{tabular} NAME: \begin{tabular}{l} Spartan Hotel \\ Balance Sheet \\ \hline \end{tabular} \begin{tabular}{|c|} \hline 31Dec22 Dollars \\ \hline \end{tabular} \begin{tabular}{|c|} \hline 31-Dec-23 Dollars \\ \hline \end{tabular} \begin{tabular}{|c|} \hline 31-Dec-24 Dollars \\ \hline \end{tabular} \begin{tabular}{|c|} \hline 31-Dec-25 \\ Dollars \\ \hline \end{tabular} TOTAL ASSETS $18,651,090 $19,430,890 \begin{tabular}{|l|} \hline$19,200,600 \\ \hline \end{tabular} $20,155,650 LIABILITIES \& OWNER'S EQUITY \begin{tabular}{l} \hline Current Liabilities \\ \hline Long-Term Liabilities \\ \hline Investors' Equity \\ \hline \end{tabular}