HI5002 Finance for Business: Financial Analysis of Coca-Cola Amatil

This report provides a comprehensive financial analysis of Coca-Cola Amatil, an Australian beverage company. It covers the company's overview, ownership and governance structure, key financial ratios for 2016 and 2017 (including current ratio, debt-equity ratio, fixed asset turnover, ROA, and EPS), and a graphical presentation of its share price compared to the All Ords Index. The report also discusses significant company announcements, calculates the required rate of return using the Capital Asset Pricing Model (CAPM), determines the weighted average cost of capital (WACC), evaluates the company's debt ratio, and examines its dividend policy. A letter of recommendation is included, suggesting areas for improvement. The analysis utilizes financial data and market information to assess Coca-Cola Amatil's financial health and investment potential.

HI5002: Finance for business
1

Table of Contents
Introduction......................................................................................................................................3
1. Overview of company..............................................................................................................4
2. Ownership and governance structure of company...................................................................5
5. Research with the help of business publication and internet.................................................11
6. Calculation of required rate of return....................................................................................12
7. Calculation of weighted cost of capital.................................................................................13
8.. Evaluation on basis of debt ratio..........................................................................................15
9. Dividend policy.....................................................................................................................16
10. Letter of Recommendation..................................................................................................17
Conclusion.....................................................................................................................................18
References......................................................................................................................................19
2

Introduction
In the carrying out of the activities in business, it is required that all the requirements in respect
of finance shall be met inappropriate manner. For this, the company will have to undertake a
proper analysis in which all the aspects which are related to it will be discussed in this report the
same will be done in context with Coca-cola Amatil. The governance structure will be identified
and also the ratios will be calculated so that evaluation of the financial position of the company
will be made. The graphical presentation of the share price will be made and the cost of capital
and return rate will be calculated. The capital structure of the company will also be checked and
the policy which is followed for the dividend will also be identified.
3

1. Overview of company
Coca-cola Amatil is the Australian company which is dealing with the beverages and
manufactures alcoholic as well as non-alcoholic beverages. This is one of top five companies.
The company was founded in 1904and is listed on ASX. The headquarter of the company is in
New South Wales. The areas in which the services of the company are provided include New
Zealand, Australia, Fiji, Indonesia, Samoa and Papua New Guinea (Coca-Cola Amatil, 2017).
There are various products which are provided by it and they are Diet Coke, Fanta, Baked beans
and many others. There are large numbers of consumers which are associated with the company
and it still has the opportunity to expand more.
4

2. Ownership and governance structure of the company
i) Main substantial shareholders
Having more than 20% shareholding: It is required that all the substantial shareholders of the
company shall be identified (Coca-Cola Amatil, 2017). They are the ones who hold more than 20
percent of the total shares. In the company, there are two holders who lie in this category and
they involve:
Name No. of shares % of holding
Coca-Cola Holdings (Overseas)
Limited
223,049,276 30.81
HSBC Custody Nominees 176,629,541 24.40
Having more than 5%: The company has some of the shareholders which are having the share
capital of more than 5% and they will have to be disclosed inappropriate manner. The ones
which are present in coca cola Amatil are as follows:
Name No. of shares % of holding
JP Morgan Nominees Australia
Limited
74,989,468 10.36
Citicorp Nominees Pty Limited 70,561,548 9.75
5

ii) Main people who are involved in the governance of the firm.
Designation Name
Chairman Ilana Atlas
Managing Director Alison M. Watkins
Director Krishnakumar Thirumalai
Director John Borghetti, Ao
Director Catherine Brenner
Director Julie Coates
Director Martin Jansen
Director Mark Johnson
Director Paul O'Sullivan
All the members who are involved in the governance of the company are not included in those
who have a substantial interest in the company. So, there is no aspect due to which the company
can be treated as the family company.
6

3. Calculation of key ratios
Calculation of the ratios depending upon the various categories is as follows:-
In the evaluation of the performance it will be required that all the aspects shall be covered and
for that ratio, the calculation is the best technique. The calculation of the same is provided below:
Particular 2017 ($
Million)
2016 ($
Million)
Total Asset 6056.90 6475.30
Total Liability 4176.60 4201.10
Ordinary Equity 1880.30 2274.20
EBIT 678.40 466.10
NPAT 461.00 257.30
Current Liability 1838.80 1843.10
Net Sales 4933.80 5077.70
Current Asset 2799.60 3104.80
Fixed Asset 1864.80 1948.90
Debt 1929.50 1959.50
Gross profit 1865.90 1911.10
EPS 59.80 32.20
Particulars Formula 2017 2016
Current Ratio Current
Asset/
Current
Liability
1.52 1.68
Debt Equity ratio Debt/
Equity
1.03 0.86
Fixed Asset
Turnover Ratio
sales /
Fixed assets
2.65 2.61
ROA Net
Income /
Total Asset
0.08 0.04
Gross Profit
Margin Ratio
Gross profit
/ Sales
0.38 0.38
Earnings per
share
59.80 32.20
7

Current Ratio – The liquidity of the company will be determined with the help of this. In this,
the standard is set at 2:1. By this, the level of the current assets and liabilities is identified. The
ability of the company to meet its liabilities will be determined with the help of it. In the given
case it is at 1.68 and then declined to 1.56.
Debt Equity Ratio – The Company is required to maintain the proper balance between the debt
and equity of the company. By this, the cost of the company can be controlled. There is an
increase in this which has been noted from 0.86 to 1.03. this is within the required level and
company is maintaining its debt position.
Fixed Asset Turnover ratio – this is the ratio by the help of which it will be ascertained that
company is earning the proper value on the fixed assets or not. It can be noted that there is the
good value which is made with the help of them and the company is utilizing the assets in best
possible manner.
Gross profit margin ratio – The profit which is company earns from its operations is identified
under this and then the ratio of that is calculated (Basu, 2018). In this given case it is 0.38 and
this is same for both the years (Coca-Cola Amatil, 2017). Company
ROA – The earnings which are made with the help of the total assets is determined under this.
There shall be proper earnings which are to be made. There is an increase in this which is from
0.04 to 0.08 which is positive for any company.
EPS – The company makes the earnings and then they are to be properly allocated. This is the
ratio which is calculated by making the allocation of the earnings in all the shares so that the
return on each share can be determined. This has also risen from 32.2 in 2016 to 59.8 in 2017
(Coca-Cola Amatil, 2017).
8

4. Presentation of share price on a graph and then its interpretation by comparing with
index
(i) The share price of the Company for 2 Years
Figure: Market price of shares for two years)
(Source: Reuters, 2018)
Comparison of the share price with All Ords Index
(Figure – Share price comparison of Company with All Ords Index)
(Source – Market index, 2018)
9

Introduction
The share price of any company keep on changing and it is required that they shall be properly
evaluated so that the deviation in them can be calculated. This will be covered in the report
below.
Content
This can be noted from the graphs which are presented above that there is the change in the share
price and this is regularly fluctuating. In the April 2017, there was highest share price in the
company and after which the decline started. The prices kept on falling at a fast pace and there
was the low level which was faced by the company. The least prices were noted in December
after which the company again started to make the improvements and prices started to rise. In
comparison to the all ordinaries index there are very much deviations and so it can be said that
the volatility in the company will be more. The prices of the shares in the company are very
much lower than that of the index as they are above the price chart of the company.
Conclusion
In the report above the relation among the price of the company and the all ordinary index have
been ascertained and on the basis of that volatility is determined. All of the changes are
identified which took place in the company.
10

5. Research with the help of business publication and internet.
In the company, there are various announcements which are made and it will be required that
they are taken into account. They shall be noted so that all the changes are identified. Some of
the major among them are as follows:
 The announcement was made on 16th may 2018 in relation to the election of the Jorge
Garduno in the board of the company. He was appointed as the president of the Coca-cola
Japan. He is also the representative director of this branch. He has worked for over a
period of 25 years in this and now he is interested in engaging in the board decisions
(Coca-Cola Amatil, 2017). He was involved in the leadership roles from the 1992 and so
was experienced in this field. They will be managing various functions such as planning,
commercial leadership, and many others.
 On 21 February 2018, there was appointment which was made to the board of the
company and the name is Julie Coates. She was appointed as the non-executive director
of the company. She is currently in the Goodman Fielder and is working as the Managing
director. There are various other companies also in which she was involved in the past.
11

6. Calculation of required rate of return
i) In the company rate of return is required to be calculated and for that, it is necessary that the
company shall identify the beta which is involved as by that the risk which is involved is
ascertained. In the present case, it is at 0.83.
ii) The company uses various sources of capital and one of them is equity on which it is required
that proper return shall be made. This is to be determined so that the investors which are
interested can make the decisions on the basis of that (Fama & French, 2014). Due to this capital
asset pricing method will be used as that provides the best results. The formula which will be
used in this is as follows:
Rate of return = Rf + (β) (Rm-Rf)
Rate of return = 4% + 0.83 *6%
=8.98%
iii) In the company, there are various investments which are made and it shall be identified that
whether they are conservative or not. The ones in which there is less amount of the risk involved
are considered as the conservative in nature. For that risk which is involved is required to be
taken into consideration. In the company, there is the rate of return which is 8.98 and as this is
low so it can be said that the risk which will be present will also be low and due to that this is
taken as the conservative investment.
12