Limited Offer Get 25% off — use code BESTW25
No AI No Plagiarism On-Time Delivery Free Revisions
Claim Now
Prices start at $5 per page · plagiarism-free papers · free revisions for 14 days 24/7 support: support@bestwriters.com
Uncategorized

Horizontal Analysis of Income statement

  • Posted
  • Authoradmin
  • Length1,566 words
  • Reading time7 min
Write My Assignment FREE

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.

Plagiarism Free Assignment Help

Expert Help With This Assignment — On Your Terms

✓ Native UK, USA & Australia writers ✓ Deadline from 3 hours ✓ 100% Plagiarism-Free — Turnitin included ✓ Unlimited free revisions ✓ Free to submit — compare quotes

admin

Academic writer and editor at BestWriters.

Get your paper off your plate tonight

Post your instructions for free. Prices start at $5 per page.

Place an order