Aristocrat
Leisure Ltd
Horizontal
Analysis of Income statement for Five years 2013 -2017:
We
have performed horizontal
analysis of income statement for 5 years 2013 to 2017. We have taken
year 2013 as base year and calculated percentages sales and expenses
etc. on the basis of year 2013.
So
If see at the revenue, Company has increased its sale over 5 years.
In 2013 Where revenue was $ 808,682 (‘000) which has been increased
by 5% in Year 2014, 95% in year 2015, 163% in year 2016 and 203% in
year 2017.
Hence Company is able to increase its sale in 5 years.
Company’s
operating expenses are
increasing in line with increase in sales. In year 2014 it was
reduced but after that it is increased in line with sale.
To
increase the sale, Company needed to install more fixed assets,
intangible assets like patents, copyrights hence company’s
depreciation expense is also increased in last 5 years.
In
year 2016, company repaid loan of 359 million dollars because of
which in year 2017, company’s interest expenses are decreased in
compare to year 2016.
Company’s
profits are also going good as profit before tax are increased by 49%
in Year 2014, 109% in year 2015, 279% in year 2016 and 443% in year
2015.
Due
to increase in profits, shareholders’ equity and wealth are in safe
side they are getting higher dividend and earning per share is being
increased every year. In year 2017 shareholders are getting 78 $ per
share where as in year 2016 shareholders were getting 55 $ per share
as earning per share. In year 2017, directors proposed dividend of 20
cents where as in year 2016 15 cents was paid, in year 2015 it was 9
cents, in 2014 it was 8 cents and in year 2013 it was 7.5 cents per
share.
|
Horizontal Analysis |
||||||||||
|
Percentage (Base Year -2013) |
||||||||||
| Item | 09/13 | 09/14 | 09/15 | 09/16 | 09/17 | 2013 | 2014 | 2015 | 2016 | 2017 |
|
Operating Revenue |
808,682,000 | 847,554,000 | 1,576,061,000 | 2,128,700,000 | 2,453,800,000 | 100% | 105% | 195% | 263% | 303% |
|
Other Revenue |
1,787,000 | 709,000 | 17,714,000 | 1,300,000 | 400,000 | 100% | 40% | 991% | 73% | 22% |
|
Total Revenue Excluding Interest |
810,469,000 | 848,263,000 | 1,593,775,000 | 2,130,000,000 | 2,454,200,000 | 100% | 105% | 197% | 263% | 303% |
|
Operating Expenses |
-627,428,000 | -601,801,000 | -1,077,931,000 | -1,253,600,000 | -1,389,700,000 | 100% | 96% | 172% | 200% | 221% |
| EBITDA | 183,041,000 | 246,462,000 | 515,844,000 | 876,400,000 | 1,064,500,000 | 100% | 135% | 282% | 479% | 582% |
| Depreciation | -34,924,000 | -39,856,000 | -84,142,000 | -115,600,000 | -111,600,000 | 100% | 114% | 241% | 331% | 320% |
| Amortisation | -7,915,000 | -4,200,000 | -77,242,000 | -163,700,000 | -171,700,000 | 100% | 53% | 976% | 2068% | 2169% |
|
Depreciation and Amortisation |
-42,839,000 | -44,056,000 | -161,384,000 | -279,300,000 | -283,300,000 | 100% | 103% | 377% | 652% | 661% |
| EBIT | 140,202,000 | 202,406,000 | 354,460,000 | 597,100,000 | 781,200,000 | 100% | 144% | 253% | 426% | 557% |
|
Interest Revenue |
10,702,000 | 11,368,000 | 14,919,000 | 10,300,000 | 9,600,000 | 100% | 106% | 139% | 96% | 90% |
|
Interest Expense |
-16,904,000 | -14,043,000 | -89,858,000 | -100,200,000 | -62,700,000 | 100% | 83% | 532% | 593% | 371% |
|
Net Interest Expense |
-6,202,000 | -2,675,000 | -74,939,000 | -89,900,000 | -53,100,000 | 100% | 43% | 1208% | 1450% | 856% |
|
PreTax Profit |
134,000,000 | 199,731,000 | 279,521,000 | 507,200,000 | 728,100,000 | 100% | 149% | 209% | 379% | 543% |
|
Tax Expense |
-26,800,000 | -36,142,000 | -88,065,000 | -156,700,000 | -233,000,000 | 100% | 135% | 329% | 585% | 869% |
|
Net Profit after Tax Before Abnormals |
107,200,000 | 163,589,000 | 191,456,000 | 350,500,000 | 495,100,000 | 100% | 153% | 179% | 327% | 462% |
| Abnormals | 0 | -133,100,000 | -51,000,000 | 0 | 0 | 100% | 100% | 100% | 100% | 100% |
|
Abnormals Tax |
0 | -1,400,000 | 16,200,000 | 0 | 0 | 100% | 100% | 100% | 100% | 100% |
|
Net Abnormals |
0 | -134,500,000 | -34,800,000 | 0 | 0 | 100% | 100% | 100% | 100% | 100% |
|
Reported NPAT After Abnormals |
107,200,000 | -16,429,000 | 186,430,000 | 350,500,000 | 495,100,000 | 100% | -15% | 174% | 327% | 462% |
|
Shares Outstanding at Period End |
551,418,047 | 630,022,253 | 637,119,632 | 637,119,632 | 638,544,150 | 100% | 114% | 116% | 116% | 116% |
|
Weighted Average Number of Shares |
550,396,128 | 566,801,580 | 632,332,667 | 636,383,164 | 637,565,360 | 100% | 103% | 115% | 116% | 116% |
|
EPS Adjusted (cents/share) |
19 | 29 | 30 | 55 | 78 | 100% | 149% | 155% | 283% | 399% |
|
EPS After Abnormals (cents/share) |
19 | -3 | 29 | 55 | 78 | 100% | -15% | 151% | 283% | 399% |
| Ratios | Formulas | 2013 | 2014 | 2015 | 2016 | 2017 |
|
Return on Total Assets |
EBIT / Total Net Assets |
18% | 20% | 16% | 19% | 25% |
|
rate of return on ordinary equity |
Profit After tax / Shareholders Equity |
39% | -4% | 26% | 38% | 46% |
|
Operating profit margin |
Operating Profit / Net Sale |
17% | 24% | 22% | 28% | 32% |
|
Gross Profit Margin |
Gross Profit / Net Sale |
22% | 29% | 32% | 41% | 43% |
|
Inventories turnover period |
365 * Average Inventory / Average Net Sales |
30 | 30 | 21 | 19 | 18 |
|
Settlement period for debtors |
365 * Average debtors / Average Net Sales |
137 | 147 | 89 | 75 | 70 |
|
Current ratio |
Current Assets / Current Liabilities |
2.1 | 1.9 | 2.0 | 1.6 | 1.8 |
|
Quick ratio (acid test ratio) |
Quick Assets / Current Liabilities |
1.8 | 1.7 | 1.8 | 1.4 | 1.6 |
|
Debt to assets ratio |
Total Liabilities / Total Assets |
0.57 | 0.37 | 0.71 | 0.64 | 0.59 |
|
Interest cover ratio (Times interest earned) |
EBIT / Interest Expense |
8.3 | 14.4 | 3.9 | 6.0 | 12.5 |
|
Assets turnover |
Sales / Average Total assets |
0.8 | 0.4 | 0.5 | 0.7 | 1.5 |
|
Earnings per share |
Net income attributable to equity share holders / Weighted average number of shareholders |
0.19 | -0.03 | 0.29 | 0.55 | 0.78 |
|
Price-earnings ratio |
Market Value per share / EPS |
23.72 | -201.48 | 29.20 | 28.71 | 27.04 |
|
Dividend yield |
Dividend paid / Price per share |
3% | 3% | 2% | 2% | 2% |
Discussion
over company’s profitability, efficiency, liquidity, and financial
gearing and investment ratios on the basis of calculated ratios:
-
Profitability Ratio: Profitability
ratios include gross profit margin, operating profit margin etc.
Company’s gross profit margin has been increased in last 5 years.
In year 2013, company’s gross profit margin was 22% where as it
was increased to 29% in Year 2014, 32% in year 2015, 41% in year
2016 and 43% in year 2017. Further operating profit margin ratio is
also increased in last 5 years from 22% to 43% in year 2017. Hence
we can say that company’s profitability ratio is sound and in line
with increase in sale. -
Efficiency Ratio: Efficiency ratios include
Inventory turnover ratio, debtors’ turnover ratio, creditor
turnover ratio, inventory velocity, debtors’ velocity, asset
turnover ratio etc. These ratios analyze
company’s efficiency of operating business and operations
effectively. We calculated Inventories turnover period, Settlement
period for debtors and asset turnover ratio. For Inventories
turnover period, ratio will be good as it will be less because this
ratio depicts that how many days company takes to sell its
inventory. In our calculation we can see
that company’s period has been decreased in last 5 years.
In 2013 company used to take 30 days to sell its inventories but in
year 2017 it has been decreased to 18 days.
For Settlement period for debtors also, this ratio
should be less because this ratio depicts that how many days company
take to receive its due from debtors. In Year 137, it was 137 days
whereas it has been decreased to 70 days which shows company’s
efficiency in operating business. Like this company’s asset
turnover ratio is also increased which shows company is earning very
well to recover investment amounts which it made in fixed assets.
-
Liquidity ratio:
In Liquidity ratio, we check company’s
ability to pay off its current and short term debts. Company must
have arrangements to pay its short term debt as and when these are
called for repayment. This ratios include current ratio, quick ratio
(acid test ratio) etc. Current assets is calculated by dividing the
current assets by current liabilities. Idea current ratio is 2:1
which means company must have current assets which are 2 times of
current liabilities. For our company analysis, company had current
ratio 2:1 in year 2013, 1.9:1 in year 2014, 2:1 in year 2015, 1.6:1
in year 2016 and 1.8: 1 in year 2017. So we can see that company’s
current ratio is facing many fluctuations. In 2017, company’s
current ratio is near to ideal ratio but company should try to meet
this ideal situation. Company’s current ratio was ideal in year
2014 in which it has 2:1 current ratio. Further in current assets,
there are some current assets which we cannot convert into cash
easily so if we will include these assets in current ratio
calculation this will not show actual position of the company hence
we calculate quick assets ratio in which we consider quick assets
instead of current liabilities. Quick assets includes cash and cash
equivalents, trade receivable and marketable securities. In our
company analysis, company’s quick acid ratio is 1.6 in year 2017
and it was 1.8 in year 2013. Company’s acid ratio is well managed
to pay its short term debt. Company can recover trade receivables in
approx. 70 days and can recover money by selling marketable
securities in 3 months and can use cash to pay its trade receivables
or bank loan on demand. -
Financial Gearing Ratios: Financial
Gearing ratios are used to analyze company’s ability to operate
the business at major level. These ratios are related to company’s
debt and assets ratio, interest payment coverage ratio etc.
Company’s debt to asset ratio is 0.57 in year 2013, 0.37 in year
2014, 0.71 in 2015, 0.64 in 2016 and 0.59 in 2017. Debt asset ratio
analyze that whether company is able to pay off its all liabilities
by selling its total assets.
This ratio must be less than 1 because if it would be more than 1 it
would mean company’s liabilities are more than company’s
liabilities and company won’t be able to pay its liabilities.
Interest coverage ratio calculates that how many times company is
earning profit to pay its interest expenses. Company is able to bear
interest expenses or not. In our analysis, company’s is earning
12.5 times of its interest expenses in year 2017. In year 2013
company it was 8.3, 14.4 in year 2014, 3.9 in year 2015, 6 in year
2016. Hence company is earning sound to pay its interest expenses. -
Investment ratios: These
ratios are related to investors like equity shareholders. These
include return on total assets, return on ordinary shares, Earning
per share, dividend yield, price earnings ratio etc. company is
providing 46% return on equity shares to its shareholders in year
2017 which was 39% in year 2013, (4%) in year 2014, 26% in year
2015, 38% in year 2016. Company’s earnings per share is 0.78 in
year 2017 which has been increased in last 5 years. In year 2013 it
was 0.19, -0.03 in year 2014, 0.29 in year 2015, 0.55 in year 2016
and 0.78 in year 2017. Company’s price earnings ratio is decreased
in year 2017 in compare to year 2016. In year 2016 company’s price
earnings ratio was 28.70 where as in 2017 it is 27.04. In 2013 it
was 23.72 but in 2014 it was abnormally decreased and it was
-201.48. Company tried to improve this in 2015 and PE ratio was
29.20 in year 2015, 28.71 in year 2016 and 27.04 in year 2017.
Company’s dividend yield ratio describes the percentage of return
shareholders/ investors will get on the basis of market price at
year end. Company’s dividend yield ratio is 2% in last three years
which is decreased as it was 3% in year 2013 and 2014.
Hence
overall company’s performance is investment worthy and it can give
proper returns in long term basis. Company is earning well to pay off
its short term and long term debts.
REFERENCE:
-
2013 Annual report,
https://aristocratleisurelimited.gcs-web.com/static-files/fab83cc2-d657-4d77-bd66-b72c418f2bf3,
[Online], [Accessed on 12-08-2018] -
2015 Annual report,
https://aristocratleisurelimited.gcs-web.com/static-files/b9f34e34-014b-485e-a2eb-7ac383fa108e
[Online], [Accessed on 12-08-2018] -
2017 Annual report,
https://aristocratleisurelimited.gcs-web.com/static-files/8a63b725-9d18-403b-a6cb-ae3b6af43acc
[Online], [Accessed on 12-08-2018]
ASSESSOR’s Notes
The
right table figures are computed by the assessor and compared with
the student’s calculations using the same data [CITATION Mor18 l 3081 ].
The post Horizontal Analysis of Income statement appeared first on My Assignment Online.