Solution 12.10
 
 

a) Calculate 12 key ratios for each company for the year ended 31 December 2004, under the headings of; profitability, efficiency, operations, liquidity and gearing

 

 

 

 

 

Faraway
 

Getaway

 

Profitability

 

 

 

€000s

 

€000s

 

Return on

 

Operating profit

 

7,350

14.3%

6,100

17.6%

Capital employed

Capital employed

 

51,230

 

34,680

 

 

 

 

 

 

 

 

 

 

Operating margin

Operating profit

 

7,350

29.1%

6,100

31.6%

 

 

      Turnover

 

25,250

 

19,280

 

 

 

 

 

 

 

 

 

 

Return on Equity

Prof before tax

 

5,990

19.4%

5,050

25.9%

 

 

Cap and reserves

 

30,830

 

19,480

 

 

 

 

 

 

 

 

 

 

Gross Profit

Gross Profit

 

18,880

74.8%

14,640

75.9%

    Margin

 

   Turnover

 

25,250

 

19,280

 

 

 

 

 

 

 

 

 

 

Property exp %

Property expenses

 

2,080

8.2%

1,550

8.0%

 

 

       Turnover

 

25,250

 

19,280

 

or

 

 

 

 

 

 

 

 

Wages and Sal %

Wages and sal exp

 

7,550

29.9%

5,380

27.9%

 

 

       Turnover

 

25,250

 

19,280

 

 

 

 

 

 

 

 

 

 

Efficiency

 

 

 

 

 

 

 

Capital employed turnover

   Turnover

 

25,250

0.493

19,280

0.556

 

 

Capital empl

 

51,230

 

34,680

 

or

 

 

 

 

 

 

 

 

Fixed asset

        Turnover

 

25,250

0.494

19,280

0.549

turnover

 

Fixed assets at NBV

 

51,130

 

35,150

 

 

 

 

 

 

 

 

 

 

Debtor Days

Debtors x 365

 

2,100

30.4

1,280

24.2

 

 

     Sales

 

 

25,250

 

19,280

 

Liquidity

 

 

 

 

 

 

 

Acid test

 

Current assets less stock

2,760

0.67

2,130

0.59

 

 

     Current liabilities

 

4,110

 

3,640

 

 

 

 

 

 

 

 

 

 

Gearing

 

 

 

 

 

 

 

Debt to equity

Long-term loans

 

20,400

0.66

15,200

0.78

 

 

Capital and reserves

 

30,830

 

19,480

 

 

 

 

 

 

 

 

 

 

Interest

 

Operating profit

 

7,350

5.4

6,100

5.8

Cover

 

Interest charge

 

1,360

 

1,050

 

 

 

 

 

 

 

 

 

 

Operations

 

 

 

 

 

 

 

Sales Mix -

Rooms revenue

 

14,800

58.6%

14,300

74.2%

Rooms

 

Total revenue

 

25,250

 

19,280

 

 

 

 

 

 

 

 

 

 

Occupancy

Rooms occupied

 

350

71.4%

320

78.0%

rate

 

Rooms available

 

490

 

410

 

 

 

 

 

 

 

 

 

 

Aver room rate

Rooms revenue x 1000

14,800

€ 115.9

14,300

€ 122.4

achieved (daily)

Rooms occupied x 365

127,750

 

116,800

 

or

 

 

 

 

 

 

 

 

Rev per available

Rooms revenue x 1000

14,800

€ 82.8

14,300

€ 95.6

room (daily)

Rooms avail x 365

 

178,850

 

149,650

 

 

 

 

 

 

 

 

 

 

Annual revenue

Total revenue x 1000

 

25,250

€ 56,111

19,280

€ 62,194

per employee

   No. of employees

 

450

 

310

 

or

 

 

 

 

 

 

 

 

Operating profit

 

Oper profit x 1000

 

7,350

€ 16,333

6,100

€ 19,677

per employee

 

No. of empl

 

450

 

310

 

 

 

 

 

 

 

 

 

 

                                                                                                                                               

b) From the information available to you, including the ratios calculated in part (a) of the question, write a report comparing the performance of the two companies for 2004      

Comments on Performance of Faraway and Getaway for 2004          

Based on the return on capital employed, the primary measure of performance, Getaway was the more successful company, with a high return of 17.6% compared to 14.3% for Faraway. There were two main factors causing this.

Getaway’s operating margin on sales was 31.6% compared to 29.1% for Faraway. Getaway’s higher margins were due to relatively lower costs, higher room rates, and rooms revenue being a higher proportion of total revenue (see operating ratios below).

In addition, Getaway was more efficient than Faraway in generating turnover from assets employed, at 0.556 times, compared to 0.493 for Faraway.

The difference in the pre-tax return on equity was considerable, with Getaway earning 25.9% compared to 19.4% for Faraway. These are higher than the ROCE above. Getaway’s return on its capital of 17.6% was greater than the interest rate payable on its long-term loans debt of 6.9% (1,050/15,200), and this boosted its return on equity. Faraway’s return on its capital of 14.3% was also greater than the interest rate payable on its loans, of 6.7% (1,360/20,400) 

Getaway’s gross margin of 75.9% was greater than Faraway’s, for the same reasons as the operating margin. Getaway’s payroll costs of 28% of turnover compared to 30% for Faraway, while its property costs amounted to 8% of turnover compared to 8.2% for Faraway. Getaway was more efficient in these areas, enhancing its margins. 

Getaway generated a higher level of sales from its fixed assets, at 0.549 compared to 0.494 for Faraway. It also exercised tighter credit control, with a debtor collection period of 24 days, compared to 30 days for Faraway. 

However Getaway was in a weaker liquidity situation at the year-end. Its acid test ratio of 0.59 was lower than Faraway’s ratio of 0.67. However both ratios are adequate for a hospitality business. 

In the area of gearing, Getaway was more highly geared. It had a somewhat high debt to equity ratio of 0.78, compared to 0.66 for Faraway. However Getaway had a

slightly higher interest cover of 4.2, compared to 4.0 for Faraway. These ratios are adequate and neither company should have difficulty in meeting interest payments. 

Operating Data show that the more profitable rooms revenue as a percent of total revenue was 74% for Getaway and 59% for Gresham. 

Getaway’s rooms occupancy rate was a high 78% compared to 71% for Faraway. These were above average occupancy rates for the hotel industry in 2004. Getaway achieved a higher average room rate of €122 per night, compared to €116 for Faraway. Its revenue per available room was €95.6 compared to €82.80 for Faraway. 

Getaway’s employees are more efficient. Annual sales revenue per employee was €62,194 for Getaway, 11% higher than the €56,111 for Faraway. Getaway’s operating profit per employee was 21% higher than Faraway’s, at €19,677 compared to €16,333. 

In conclusion, overall in 2004, Getaway did better than Faraway based on profitability, efficiency and operations, but was not as good in liquidity.