HB 358 Individual assignment #2

.docx

School

Michigan State University *

*We aren’t endorsed by this school

Course

358

Subject

Finance

Date

Apr 3, 2024

Type

docx

Pages

4

Uploaded by ChancellorGrasshopperPerson997

Report
1 HB 358 Individual Assignment #2 Thursday - NAME: 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 320 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 is in the process of construction and will be open in January 2025 at a cost of $880,000. The hotel has historically had an ‘average room rate of $310 per night with an average occupancy rate of 86% annually. The total food and beverage revenues for 2024 are expected 10 be unchanged at $980,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 2024-2027 pro forma income statement and the 2024-2027 pro forma balance sheet. Assume all expense percentages remain constant except where increases are noted. Ingnore the fact that 2024 is a leap year. 2025 Rooms revenues will increase by 3.75% over 2024 Food and Beverage revenues will increase by $4500 per day over 2024 Other income will increase by 1.5% over 2024 Salaries, wages and benefits expenses willincrease by 0.7% over 2024 Ulilties expenses willincrease by 0.5% over 2024 2026 Rooms revenues will increase by 6% over 2025 Food and Beverage revenues will increase by 14% over 2025 Other income will increase by 1.0% over 2025 Salaries, wages and benefits expenses willincrease by 1.0% over 2025 Direct operating expenses will increase by 0.4% over 2025 Uliities expenses willincrease by 0.5% over 2025 2027 Rooms revenues will increase by 6% over 2026 Food and Beverage revenues will increase by 12% over 2026 Other income will decrease by 1.5% over 2026 Salaries, wages and benefits expenses will increase by 0.5% over 2026 Direct operating expenses vill increase by 0.4% over 2026 General & Administrative expenses willincrease by 0.3% over 2026 Ulilties expenses willincrease by 0.6% over 2026 Occupancy costs willincrease by 0.7% over 2026 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% (ie. 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 (2024 - 2027) Return on Assets Return on Equity Deb ratio Deb to Equity ratio Curent ratio Profit margin HB 358 Individual Assignment #2 Due Thursday 3/21/2043 NAME: [Spartan Hotel 2024 I 2025 I 2026 2027 | Pro Forma Income Statement Dolars | % | Dolars | % | Dolars | % Dolars | % | Revenues Rooms Food Beverage Other Total Reven: Cost of sales 29.0%) 29.0%) 29.0%)| 29.0%) Gross Profit Expenses Salaries, Wages and Benefits 33.0%)] Direct Operating Expenses 6.0%| Marketing 4.0%| Repair and Maintenance 6.0%| General and Administrative expenses 5.0%) Utilities 5.0%) Total Operating Expenses Occupancy Expense 5.0%] Property taxes 3.0%] Insurance 1.0%] Depreciation 5.0%] Interest 3.0%] Total Non-operating Expenses Total Expenses [ [ I I [ I Total Income (Loss) before Taxe [ I [ | [ [
NAME: |Spartan Hotel 31-Dec24 | 31-Dec-25 | 31-Dec-26 | 31-Dec-27 | [Balance Sheet Dollars__| Dollars__| Dollars__| Dollars__| |AsSETS [Current Assets 4,662,925 4,662,725 4,570,535| 5,720,525| |Fixed Assets 13,988,165 14,768,165 14,630,065 14,435,125 [ToTAL ASSETS 18,651,090 19,430,890 19,200,600 20,155,650| |LIABILITIES & OWNER'S EQUITY i |Current Liabilities 1,119,255 1,164,055| 1,246,035| 1,303,340| |Long-Term Liabilities 6,527,810| 7,297,810| 7,202,810] 7,127,810] [investors' Equity 11,004,025 10,969,025 10,751,755 11,724,500| [TOTAL LIABILITIES & OWNER'S EQUITY 18,651,090| 19,430,890 19,200,600] 20,155,650] NAME: Spartan Hotel 2024 2025 2026 2027 Ratio Analysis (2024-2027) Return on Assets Return on Equity Debit ratio Debt to Equity ratio Current ratio Profit margin
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help