1
EDITH COWAN UNIVERSITY
FBL5030
FUNDAMENTALS OF VALUE CREATION IN BUSINESS
Semester 182
ASSIGNMENT - ACCOUNTING
Requirements
1. The following is a list of companies from the latest ASX. These companies are
carefully chosen to suit this project and the learning outcomes of the unit.
ASX code Company
GICS sector: Health care
RHC Ramsay Health Care
SHL Sonic Healthcare Limited
PRY Primary Health Care Limited
GICS sector: Information technology
XRO Xero Ltd
IRE Iress Ltd
IRI Integrated Research Ltd
GICS sector: Consumer discretionary
WEB Webjet Limited
FLT Flight Centre Travel Group Limited
2. You are pre-assigned with a company by your teaching lecturer. If you are working in
a group, and each member is assigned with a different company, you must choose
only one company for your group.
3. If you choose to complete the assignment in a group, please observe that the
maximum number of members in a group is 4.
4. Download the company financial data from DatAnalysis (also known as Morning Star)
for your analysis. The data shall include items from balance sheet, income
statement, cash flow statements and relevant ratios for the latest 6 years. Note that
https:
www.asx.com.au/products/gics.htm
https:
www.asx.com.au/products/gics.htm
https:
www.asx.com.au/products/gics.htm
http:
datanalysis.morningstar.com.au.ezproxy.ecu.edu.au/af/dathome?xtm-licensee=datpremium
2
you will have to download 1 year extra to be able to run a 5-year analysis. You may
want to refer to DatAnalysis data download guide in this document.
5. You are encouraged to analyse the company beyond the reported financial figures. It
is advisable, but not limited, to look for further information on ASX (e.g., from
www.asx.com.au and http:
www.marketindex.com.au), the company’s annual
eports, and other credible sources including the company’s official website.
Tasks
1. For the latest 5-year period, analyse the following aspects of the companies:
Ratio categories Example of ratios to analyse
Profitability e.g., 1. Return on equity (ROE), and 2. Net profit
margin.
Liquidity e.g., 1. Cu
ent ratio, and 2. Acid test (also
known as quick ratio).
Solvency e.g., 1. Debt ratio, and 2. Net interest cover.
Note: Each ratio does not sit in a vacuum. One ratio is interlinked with other ratios of
different categories. Therefore, you may need to draw in more than 2 ratios in each
category to provide substantive reasons and discussions. Industry average and
competitors’ data also form a good platform to put your discussion into perspective. For
example, a large difference between cu
ent ratio and quick ratio can be explained by
inventory build-up. This can be confirmed by looking at inventory turnover (in days)
which is longer compared to its competitors or the industry average. In that case, it
could mean the company has difficulties to attract customers, which can also explain
why it provides a longer credit term (receivable turnover).
You may need to calculate more than 2 ratios to provide substantive reasons and
discussions for the trend captured in a ratio. For example, a steady increase in revenue
over a 5-year period can be explained by a rapid expansion of the company. However,
evenue per store indicates a negative growth which can be detrimental for the
company (see Dick Smith case here). This revenue per store is a ratio that is not readily
available and will have to be calculated manually.
2. Present your analyses in a form of a professional report for a manager of a company.
Charts and tables are encouraged. Your report should have the following sections
(maximum possible marks are in the parentheses). The total possible marks are 35.
2.1. Cover sheet which clearly identify all group members, class/campus, and your
teaching lecturer.
http:
www.asx.com.au
http:
www.marketindex.com.au
http:
www.news.com.au/finance
usiness
etail/mcgrathnicol-releases-dick-smith-report/news-story/c2897a8cf8023b3f7490b7f16c2781c2
3
2.2. Executive summary (2 marks).
2.3. Introduction (3 marks).
2.4. Profitability analysis (8 marks).
2.5. Liquidity analysis (8 marks).
2.6. Solvency analysis (8 marks).
2.7. Conclusion (2 marks).
2.8. There are also 2 marks (maximum) for gramma
spelling/sentence structure;
and 2 marks (maximum) for presentation/formatting.
3. Other criteria for the report:
3.1. Must not exceed 4000 words, excluding table of content, references and
appendices, but inclusive of item 2.2 to 2.7. The report will be graded on the first
4000 words of item 2.2 to 2.7.
3.2. Line spacing: 1.5.
3.3. Font-face and size: Cali
i, Arial, or Times New Roman with 12-point (for body).
3.4. Citations and referencing style: APA 6th Edition. See ECU Li
ary Guide for APA 6th
eferencing style.
4. Submission:
4.1. Via Turnitin on Blackboard.
4.2. Only one copy of the report should be submitted for every group.
http:
ecu.au.libguides.com
eferencing
4
DatAnalysis data download guide
1. Go to http:
www.ecu.edu.au/centres/li
ary-services/overview
2. Choose Databases.
3. Select D and select DatAnalysis.
4. Log in with your ECU credentials.
http:
www.ecu.edu.au/centres/li
ary-services/overview
5
5. Enter the company names or its ASX code in the search field; and click search icon. The
company, in this case it’s JB Hifi, is listed in the search result. Click the company name or
code.
6. The company profile is displayed. Click Financial Data to start downloading the data file.
6
7. Enter the Year Range. In this example, it’s from 2011 to 2017. You will need to analyse the
latest 5-year period. However, it is advisable to download the data with an extra 1 year prior
to the start of the 5-year period, as some ratios, e.g., return on asset (ROA) requires an
average which takes the opening plus closing balances divided by 2. The opening balance of
year 1 is the closing balance of year 0.
8. Click Go.
9. Click Download Spreadsheet.
Make sure
it’s set to
Annual.
Categories of items that
will be downloaded as a
CSV file – it’s defaulted to
your Excel.
The PDF containing links to
company’s annual reports,
summary of company
presentations to shareholders.
Semester 182
Requirements
Tasks
DatAnalysis data download guide