RATIO ANALYSIS OF INCOME STATEMENT AND BALANCE SHEET

 These are tools for analyzing (i.e.: calculating percentages and ratios) and interpreting (i.e.: comparing percentages and ratios to determine the meaning and significance of the analysis) the financial soundness of a hospitality company.

 For ratios to be meaningful, they shall be compared against:

  • Prior-period percentages and ratios
  • Industry and trade association percentages and ratios
  • Budgeted percentages and ratios

I-Ratio Analysis of the Income Statement:

  1. Profit Margin Ratio:

The Profit Margin Ratio is used as a Measure of Profitability. Moreover, it can be computed for revenue generators as well as the hotel in general

Profit Margin Ratio = Hotel (or Departmental) Income / Net Sales

  • Rooms Division Department: (692,261 / 897,500) * 100 = 77.13 %
  • Food & Beverage Department: (87,377 / 518,170) * 100 = 16.86 %
  • Telephone Department: (-27,623 / 51,140) * 100 = - 54.01 %
  • Hotel Doro: (60,544 / 1,597,493) * 100 = 3.79 %
  1. Labor Cost Percentage:

The Labor Cost Percentage is used as a measure of Operating Efficiency. Moreover, it can be computed for each department or for the hotel in General

Labor Cost Percentage = Total Payroll and Related Expenses / Net Sales

  • Rooms Division Department: (143,100 / 897,500) * 100 = 15.94 %
  • Food & Beverage Department: (204,180 / 518,170) * 100 = 39.40 %
  • Telephone Department: (17,132 / 51,140) * 100 = - 33.50 %
  • Hotel Doro: (568,102 / 1,597,493) * 100 = 35.56 %
  1. Food (or Beverage) Cost Percentage:

Food (or Beverage) Cost Percentage = Cost of Food (or Beverage) Sold / Net Food (or Beverage Sold)

  • Food Cost Percentage: (135,200 / 358,300) * 100 = 37.73 %
  • Beverage Cost Percentage: (40,510 / 159,870) * 100 = 25.34 %
  • Food & Beverage Cost Percentage: (175,710 / 518,170) * 100 = 33.91 %
  1. Prime Cost Percentage:

Refers to the Total Labor and Materials used in the Production or Selling Process

Prime Cost Percentage = Total Cost of Sales + Total Payroll and Related Expenses / Net Sales

  • Rooms Division Department: ((0 + 143,140) / (897,500)) * 100 = 15.94 %
  • Food & Beverage Department: ((175,710 + 204,180) / (518,170)) * 100 = 73.31 %
  • Telephone Department: ((60,044 + 17,132) / 51,140) * 100 = 150.91 %
  • Hotel Doro: ((248,701 + 568,102) / 1,597,493) * 100 = 51.13 %
  1. Average Food (or Beverage) Check:

Represents the Average Sales per cover

Average Food (or Beverage Check) = Net Food (or Beverage) Sales / Covers

  • Average Food Check* = 358,300 / 14,332 = $ 25.00
  • Average Beverage Check** = 159,870 / 4,000 = $ 39.97
  • Avergae Food & Beverage Check = 518,170 / (14,332 + 4,000) = $ 28.27

(*): Assume total Food Covers is 14,332

(**): Assume total Beverage Covers is 4,000

  1. Return On Equity Ratio:

The Return On Equity Ration measures the Profits after Taxes of the Hospitality Company relative to the Equity of its Owners (I.e. Shareholders)

Return On Equity Ratio = Net Income / Average Equity

Where Average Equity = (Equity at the Beginning of the Year + Equity at the End of the Year) / 2

  • Hotel Doro (19X2) : (60,544 / ((1,068,662 + 1,028,118) / 2)) * 100 = 5.77 %
  1. Return On Assets Ratio:

The Return On Assets Ratio measures how productively the Assets have been to generate Net Income

Return On Assets Ratio = Net Income / Average Total Assets

  • Where Average Total Assets = (Total Assets at the Beginning of the Year + Total Assets at the End of the Year) / 2
  • Hotel Doro (19X2) : (60,544 / ((3,247,412 + 3,292,371) / 2)) * 100 = 1.85 %
  1. Occupancy Percentage:

The Occupancy Percentage measures Room Sales in terms of the Hotel’s Capacity to generate Rooms Sold

Occupancy Percentage = (Total Number of Rooms Occupied / Total Number of Rooms Available for Sale) * 100

II-Ratio Analysis of the Balance Sheet:

1.Liquidity Ratios:

Show the company’s ability to pay its current liabilities.

 Current Ratio = Current Assets / Current Liabilities

 Quick Ratio = (Cash + Marketable Securities + Net Receivables) / Current Liabilities

  • Current Ratio (19X1) : 147,654 / 139,253 = 1.06
  • Current Ratio (19X2) : 147,888 / 123,750 = 1.20
  • Quick Ratio (19X1) : (147,654 – (10,143 + 12,165)) / 139,253 = 0.90
  • Quick Ratio (19X2) : (147,888 – (11,000 + 13,192) / 123,750 = 1.00

2.Asset Management Ratios:

Show how a company effectively and efficiently manages its assets.

 Accounts Receivable Turnover Ratio = Net Revenue / (Net Average Accounts Receivable)

 Average Collection Period Ratio = 365 / (Accounts Receivable Turnover Ratio)

 Inventory Turnover Ratio = (Cost of Goods Used) / (Average Goods Inventory)

 Inventory Turnover Period = 365 / (Inventory Turnover Ratio)

Where:

  • Net Average Accounts Receivable = (Net Accounts Receivable at the Beginning of the Year + Net Accounts Receivable at the End of the Year) / 2
  • Average Goods Inventory = (Goods Inventory at the Beginning of the Year + Goods Inventory at the End of the Year) / 2
  • A/R Turnover Ratio (19X2) = (1,597,493 / ((40,196 + 38,840) / 2) = 40.42 times
  • Average Collection Period (19X2) = 365 / 40.42 = 9.03 days
  • Inventory Turnover Ratio* (19X2) = (248,701 / ((7,500 + 8,000) / 2) = 32.09 times
  • Inventory Turnover Period (19X2) = 365 / 32.09 = 11.37 days

(*): Assume Goods inventory amounted $ 7,500 & $ 8,000 at the end of 19X1 & 19X2 respectively.

3.Debt Management Ratios:

Measure Company’s solvency (i.e.: company’s ability to meet its long-term obligations)

 Debt-to-Equity Ratio = (Total Liabilities) / (Total Equity)

 Assets-to-Liabilities Ratio = (Total Assets) / (Total Liabilities)

  • Debt-to-Equity Ratio (19X1) = 2,264,253 / 1,028,118 = 2.20
  • Debt-to-Equity Ratio (19X2) = 2,178,750 / 1,068,662 = 2.04
  • Assets-to-Liabilities Ratio (19X1) = 3,292,371 / 2,264,253 = 1.45
  • Assets-to-Liabilities Ratio (19X2) = 3.247,412 / 2,178,750 = 1.49