Urgent task to be done soon in few hours
Reet4
IHGplcratiostoaccompanyassignment12.xlsxCover
| U50039 Semester 1 18/19 |
| IHG plc 2017 & 2016 |
| There are 4 tabs in this worksheet. |
FS
| IHG plc 2017 & 2016 | |||
| Financial statements $m | |||
| GROUP INCOME STATEMENT | 2017 | 2016 | % change |
| Revenue | 1,784 | 1,715 | 4% |
| Cost of sales | (608) | (580) | 5% |
| Administrative expenses | (379) | (352) | 8% |
| Others | (34) | (105) | -68% |
| Operating profit | 763 | 678 | 13% |
| Finance income | 4 | 6 | -33% |
| Finance expense | (89) | (93) | -4% |
| Profit before tax | 678 | 591 | 15% |
| Tax | (85) | (174) | -51% |
| Profit for the year | 593 | 417 | 42% |
| STATEMENT OF FINANCIAL POSITION | 2017 | 2016 | (AEDm) |
| Non current assets | |||
| PPE | 425 | 419 | 1% |
| Goodwill and other intangible assets | 1,467 | 1,292 | 14% |
| Investment in associates and joint ventures | 141 | 111 | 27% |
| Other non-current assets | 303 | 327 | -7% |
| 2,336 | 2,149 | 9% | |
| Current assets | |||
| Inventories | 3 | 3 | 0% |
| Trade and other receivables | 551 | 472 | 17% |
| Other current assets | 117 | 97 | 21% |
| Cash and cash equivalents | 168 | 206 | -18% |
| 839 | 778 | 8% | |
| TOTAL ASSETS | 3,175 | 2,927 | 8% |
| Equity | |||
| Share capital | 154 | 141 | 9% |
| Other reserves | (2,410) | (2,292) | 5% |
| Retained earnings | 1,405 | 1,392 | 1% |
| -851 | -759 | 12% | |
| Non-current liabilities | |||
| Loans and other borrowings | 1893 | 1606 | 18% |
| Other NCL | 829 | 946 | -12% |
| 2,722 | 2,552 | 7% | |
| Current liabilities | |||
| Loans and other borrowings | 126 | 106 | 19% |
| Trade and other payables | 768 | 681 | 13% |
| Others | 410 | 347 | 18% |
| 1,304 | 1,134 | 15% | |
| Total liabilities | 4,026 | 3,686 | 9% |
| TOTAL EQUITY AND LIABILITIES | 3,175 | 2,927 | 8% |
| Trade receivables (note 16) | 452 | 368 | 23% |
| Trade payables (note 18) | 81 | 94 | -14% |
Ratios
| IHG plc 2017 & 2016 | |||
| Ratios | |||
| Data | 2017 | 2016 | |
| Debt (1) | 2,019 | 1,712 | |
| CE (2) | 1,168 | 953 | |
| Interest payable | 89 | 93 | |
| Profitability | |||
| Finance Expenses % | 5% | 5% | |
| Administrative expenses% | 21% | 21% | |
| Operating Profit% | 43% | 40% | |
| Asset Turnover | 1.5 | 1.8 | |
| ROCE | 65% | 71% | |
| Liquidity | |||
| Current | 0.6 | 0.7 | |
| Quick/Acid | 0.6 | 0.7 | |
| Efficiency | |||
| Inventory | 2 | 2 | |
| Trade receivables | 92 | 78 | |
| Trade payables | 49 | 59 | |
| Cash conversion cycle | 46 | 21 | |
| Gearing | |||
| Gearing | 173% | 180% | |
| Interest cover | 8.6 | 7.3 | |
| (1) Debt: this has been calculated as the total of the current and non-current borrowing. | |||
| (2) Capital Employed: this has been calculated as the total debt (given above) plus equity | |||
CFS
| IHG plc 2017 & 2016 | ||
| Cash Flow Information AEDm | ||
| 2017 | 2016 | |
| OPERATING CASH FLOWS | ||
| Net cash flows from operating activities | 634 | 752 |
| INVESTING CASH FLOWS | ||
| Purchase of property, plant and equipment | (44) | (32) |
| Purchase of intangible assets | (229) | (175) |
| Other cash inflows | 10 | (9) |
| Net cash flows used in investing activities | (263) | (216) |
| FINANCING CASH FLOWS | ||
| Issue of long-term bonds | 0 | 459 |
| Repayments of bonds | (315) | |
| Other borrowings (see note 20) | 147 | 93 |
| Dividends paid | (593) | (1,693) |
| (446) | (1,456) | |
| CASH BALANCES | ||
| Net cash increase/(decrease) in year | (75) | (920.0) |
| Cash at beginning of year | 117 | 1,098.0 |
| Effect of exchange rate fluctuations on cash held | 16 | (61) |
| Cash at end of year | 58 | 117 |
