Analyzing Financial Statements: Horizontal and Vertical Analysis, Ratio Calculations

Horizontal Analysis of Income and Expenses

Using the information in the five year report please complete the following (templates are provided in answer booklet);
(a) From the income statements on page 71,
(i) Prepare a horizontal analysis of income and expenses that make up EBITDAFI for 2015, 2016, 2017 and 2018 using 2015 as the base year. Express the horizontal analysis in percentage and report your answers to one decimal place. Provide some short comments on the significant trends in income and expenses.
(ii) Prepare a vertical analysis of income and expenses that make up EBITDAFI (using total income as the base amount) and give some short comments on the relative significance of income and expense items and how they have changed over time. Report your answers to one decimal place.
(b) Using the information from page 71 and 73 of the downloaded document, calculate the  following ratios for 2015 and 2016 using the formulas on page 255 of the course book (please show all workings) and briefly comment on the calculations. Report your answers  to one decimal place. The figures for 2017 and 2018 have already been calculated in class.
(i) Debt to equity ratio
(ii) Interest coverage ratio
(iii) Profit margin
(iv) Asset turnover