The statement of profit or loss figures for the past five years for Grand Hotel are presented below.

Using the information:

a. Prepare a trend analysis and comment on the trends

b. Prepare a vertical analysis (using revenue as the base amount) and comment on the trends

c. Identify other non-financial ratios that would be of interest to the management of Grand Hotel.

Transcribed Image Text:

Revenue Interest received Total revenue Expenses Cost of food Advertising expense Insurance expense Rent expense Utilities expense Depreciation Wages and salaries Interest expense Total expenses Profit Grand Hotel Statement of profit or loss for the period 2013 to 2017 2013 $000 $320 800 2 500 323 300 142 000 28200 15500 25 000 1700 12 000 60 000 3400 287 800 $ 35500 2014 $000 $376000 2900 378 900 181 800 36400 17 000 29 500 2200 12 000 71600 5200 355 700 $ 23200 2015 $000 $400 400 3010 403 410 185 200 40 900 17 600 31 800 2 240 12 000 73 300 5600 368 640 $ 34770 2016 $000 $414500 2950 417 450 198900 45 400 17 600 34 100 2330 15000 76 100 800 5 395 230 $ 22220 2017 $000 $422 600 2900 425 500 204 500 45 400 22 700 36400 2390 15 000 78400 5900 410690 $ 14810