You will need to login to www.statcrunch.com The username an…

You will need to login to www.statcrunch.com The username and password is the same as your MyStatLab account where your homework is located. (If you can’t click on the yellow “Open StatCrunch” button, try using the https://www.statcrunch.com/app/index.php  )   If you were successful in getting StatCrunch open, please select YES below.

You are Director of Rooms (DOR) who is responsible for cover…

You are Director of Rooms (DOR) who is responsible for covering the portion of Property Insurance relevant to Rooms Sales percentage out of Total Sales as shown below, Assuming that Insurance that the hotel should cover is $340,088. calculate property insurance expense that your Rooms Department should cover.  Sales – Q1 2023 Amount Revenue Share % Rooms $40,482,573 F&B $19,484,971 Convention Services $3,873,843 Rental $2,484,099 Total Sales $66,325,486 100%

The 160-room hotel, at 1001 Southwest Second Avenue, is owne…

The 160-room hotel, at 1001 Southwest Second Avenue, is owned by the entity Mary Brickell Village Hotel LLC, which is managed by Villar, president of Miami-based Sunview Companies. Completed in 2013, the hotel has assets totaling $34 million including Land and Building values of $12 and $15 million respectively. The remaining was Current Assets including $75,000 worth of Inventories. There was $16 million in Long-Term Liabilities in addition to $2 million in Account Payable. At the end of accounting period as the Balance Sheet was prepared, the hotel obtained a $153,000 EBITDA. Based on the statement above, build a simple balance sheet on a MS Excel spreadsheet and perform ratio analyses.   Liquidity Ratios Current Ratio Quick Ratio Working Capital Solvency Ratios Debt to Equity Ratio Debt to EBITDA Ratio

The 160-room hotel, at 1001 Southwest Second Avenue, is owne…

The 160-room hotel, at 1001 Southwest Second Avenue, is owned by the entity Mary Brickell Village Hotel LLC, which is managed by Villar, president of Miami-based Sunview Companies. Completed in 2013, the hotel has assets totaling $34 million including Land and Building values of $12 and $15 million respectively. The remaining was Current Assets including $75,000 worth of Inventories. There was $16 million in Long-Term Liabilities in addition to $2 million in Account Payable. At the end of accounting period as the Balance Sheet was prepared, the hotel obtained a $153,000 EBITDA.   Based on the statement above, build a simple balance sheet on a MS Excel spreadsheet and perform ratio analyses.   Liquidity Ratios Current Ratio Quick Ratio Working Capital Solvency Ratios Debt to Equity Ratio Debt to EBITDA Ratio