Crystal Hotel Pty Ltd is a privately owned 3.5 stars hotel located in Sydney. The Hotel consists… 1 answer below »

Crystal Hotel Pty Ltd is a privately owned 3.5 stars hotel located in Sydney. The Hotel consists of

160 rooms with maximum capacity of 350 guests, a restaurant with capacity of 150 guests, a

function room with maximum capacity of 250 guests and a conference room with maximum

capacity of 200 guests. The average price per room per night is $150.

While the hotel is located in a very popular location, close proximity to a river and in the city

centre, it is becoming quite out-dated. The owners rely heavily on their corporate clientele. Clients

usually use the hotel for their expat employees. Due to long-term contracts, they pay on credit

with invoices being issued at the end of each month. The hotel is often faced with outstanding

invoices. The owners have so far tolerated it as it usually occurs with their long-term clients.

Additionally, to the accommodation services, they often use hotel facilities for their functions and


The hotel is constantly having difficulties retaining a good quality staff as they always get junior

personnel, which once gaining experience will usually leave for better opportunities in hotels with

higher ratings. The biggest issue is to retain high quality personnel in the hotel restaurant, especially

a chef.

The owners would like to increase the hotel star rating by renovating or refurbishing the hotel and

improving their services. They are thinking about building a Wellness Centre on the rooftop of the

hotel, which would include a massage treatment room, gym, spa, sauna and an outdoor pool.

As new plans will require quite extensive capital investment, the owners

would like to know where they stand financially before making any

major decisions. You have been appointed to analyse their financial

statements and to give them an insight on which areas should be

improved and analysed further.

You are expected to conduct the financial statement analysis in an Excel

workbook and then use your findings in creating a business report to be

submitted to the client.