Marriot International Inc. is considered the most important hotel chain in the world with 3400 hotels and resorts including 750 thousand rooms. Table 1 shows the revenues by sales and net income of the company from 2009 to 2015.
Each variable, sales revenues and net income are independent variables that depend on of the independent variable which is the year. Both sales revenues and net income have a relation where the net income is always lower than the sales revenues, according to finance administration theories. In Figure 1 it is possible to plot both variables related to the year.
Figure 1: Scatterplot of Marriot International Inc. Net income and sales revenues
The performance of the company is compared with two competitors in the hospitality industry: Whyndham Worldwide Inc. and Hilton International Inc. Wyndham Hotels has 7300 hotels worldwide. Table 2 shows the revenues by sales and net income of the company from 2009 to 2015.
The sales revenues and net income of Wyndham has a similar behavior that the same variables of Marriot. Both have negative net incomes in the year 2009 due to the consequences of the financial crisis of 2008. In Figure 2 it is possible to plot both variables related to the year.
Figure 2: Scatterplot of Whyndham Worldwide Inc. Net income and sales revenues
The third competitor is Hilton Worldwide Inc. which has 540 hotels in 78 countries. Table 3 shows the revenues by sales and net income of the company from 2009 to 2015.
The sales revenues and net income of Hilton Worldwide Inc. has a similar behavior that the same variables of Marriot and Wyndham. The three companies have negative net incomes in the year 2009 due to the consequences of the financial crisis of 2008. In Figure 3 it is possible to plot both variables related to the year.
Figure 3: Scatterplot of Whyndham Worldwide Inc. Net income and sales revenues
In several cases, the use of sparklines is necessary, because there is no need to develop a graph, as are shown in Figure 1, 2 or 3. Sparklines creates a graph in a single cell giving the reader information about the trend and behavior of the variables without a graph with higher area and storage space. The representation of the previous data, with the use of sparklines, is in Image 4.
Image 4: Sparklines (Line Format) of Net Income and Sales Revenues
The sparklines can be configured with a column format (View Image 5) to evaluate the positive or negative values of the data series. In this example, the three hotels have negative values in net income in the year 2009.
Image 5: Sparklines (Column Format) of Net Income and Sales Revenues
The sparklines can be configured with a Candle or Win-Loss format (View Image 6) to evaluate the growth or decrease of the data compared to previous year.
Image 6: Sparklines (Win-Loss Format) of Net Income and Sales Revenues
Reference List
Hilton. (2016). Hilton SEC Fillings. Retrieved from Hilton: http://ir.hiltonworldwide.com/financial-reporting/sec-filings
Marriot. (2016). 10-K. Retrieved from Marriot SEC Fillings: http://investor.shareholder.com/MAR/sec.cfm?view=all
Whyndham. (2016). Whyndham SEC Fillings. Retrieved from Whyndham: https://www.sec.gov/Archives/edgar/data/1361658/000136165815000004/wyn-20141231x10k.htm
