International College of Management, Sydney
Subject Title | Accounting for Management Decisions |
Subject Code | ACC601 |
Assessment | Group Assignment |
Assessment total | 25% |
ACCOUNTING FOR MANAGEMENT DECISIONS – ACC601
Group Assignment – Date due: End of Week 12 Financial Statement Analysis
This assignment involves analysing the financial statements and other information relating to a number of Australian public companies. These companies are listed below.
Your group of a minimum of 3 and no more than 6 students must allocate these companies within the group to a group member and that group member is responsible for the calculations and analysis of that individual company. Some group members may be responsible for more than one company if you have less than 6 people in your group.
The assignment is divided into several tasks, some of which must be completed individually, that is, each member of the team is responsible for drafting an answer in respect of at least one of the listed companies. Other tasks require that the team come together to analyse the results provided by individual group members on each of the listed companies to provide a group answer.
Please note: it is a group assignment - so prior to submission - it is the responsibility of every member of the team to confirm that they agree with the answers provided by the team in relation to all companies. This provides an opportunity for all team members to help each other develop some analytical and interpretative skills.
Stock Code | Initial to confirm that you contributed a fair share to this assignment and agree with all answers provided. | |||
API Limited | API | |||
Retail Food Group Limited | RFG | |||
JB Hi Fi Limited | JBH | |||
The Reject Shop Limited | TRS | |||
Super Retail Group Ltd | SUL | |||
Blackmores Limited | BKL |
TASKS
Accounting for Management Decisions
Group Assignment
ACC601
Financial Statement Analysis
Introduction
This Financial Analysis Report analysis the financial statements of six listed companies of ASX. The financial reports for the year ending 2015-16, 2016-17 and 2017-18 have been used to perform the three year ratio analysis on these six companies. The ratios are then analyzed and compared to each other to comment on the following things:
The six companies used for calculation and comparisons are as follows:
The companies belong to a variety of industries like food and beverages, pharmaceuticals, electrical appliances, variety store chain, and nutritional supplements. Thus the trends can be compared across the industries to observe the market wide trend.
Calculation of Ratios:
API Limited | Year 1 | Year 2 | Year 3 | |
Ratio | 2015/16 (Ending 31 Aug 2016) | 2016/17 (Ending 31 Aug 2017) | 2017/18 (Ending 31 Aug 2018) | |
a. | The Net Profit Margin | 1.35% | 1.29% | 1.20% |
b. | Current Ratio | 1.34 | 1.32 | 1.33 |
c. | Inventory Turnover | 8.64 | 8.77 | 8.88 |
d. | Asset Turnover Ratio | 2.75 | 2.80 | 2.73 |
e. | Leverage ratio | 0.63 | 0.62 | 0.67 |
f. | Return on Equity | 9.92% | 9.60% | 5.99% |
g. | Return on Total assets | 6.07% | 6.16% | 5.57% |
h. | Earnings Per Share (EPS) | 0.11 | 0.11 | 0.10 |
i. | Net Debt to Equity Ratio | 1.70 | 1.62 | 2.03 |
j. | Total Return to Shareholders | 12.96% | -12.99% | 30.95% |
Retail Food Group Limited | Year 1 | Year 2 | Year 3 | |
Ratio | 2015/16 (Ending 30 June 2016) | 2016/17 (Ending 30 June 2017) | 2017/18 (Ending 30 June 2018) | |
a. | The Net Profit Margin | 32.13% | 25.19% | -103.01% |
b. | Current Ratio | 1.92 | 1.48 | 0.36 |
c. | Inventory Turnover | 5.41 | 7.61 | 8.25 |
d. | Asset Turnover Ratio | 0.22 | 0.29 | 0.39 |
e. | Leverage ratio | 0.50 | 0.50 | 0.74 |
f. | Return on Equity | 14.51% | 14.72% | -98.42% |
g. | Return on Total assets | 0.12 | 0.12 | -0.48 |
h. | Earnings Per Share (EPS) | 0.32 | 0.36 | -1.70 |
i. | Net Debt to Equity Ratio | 1.00 | 1.00 | 2.80 |
j. | Total Return to Shareholders | 6.91% | -9.63% | -88.51% |
JB Hi Fi Limited | Year 1 | Year 2 | Year 3 | |
Ratio | 2015/16 (Ending 30 June 2016) | 2016/17 (Ending 30 June 2017) | 2017/18 (Ending 30 June 2018) | |
a. | The Net Profit Margin | 3.85% | 3.06% | 3.40% |
b. | Current Ratio | 1.57 | 1.32 | 1.32 |
c. | Inventory Turnover | 6.03 | 6.26 | 6.15 |
d. | Asset Turnover Ratio | 4.19 | 3.27 | 2.77 |
e. | Leverage ratio | 0.59 | 0.65 | 0.62 |
f. | Return on Equity | 40.70% | 27.40% | 25.90% |
g. | Return on Total assets | 0.24 | 0.16 | 0.14 |
h. | Earnings Per Share (EPS)($) | 1.54 | 1.54 | 2.03 |
i. | Net Debt to Equity Ratio | 1.45 | 1.87 | 1.63 |
j. | Total Return to Shareholders | 28.85% | 1.87% | 2.01% |
The Reject Shop Limited | Year 1 | Year 2 | Year 3 | |
Ratio | 2015/16 (Ending 3 July 2016) | 2016/17 (Ending 2 July 2017) | 2017/18 (Ending 1 July 2018) | |
a. | The Net Profit Margin | 2.14% | 1.55% | 2.07% |
b. | Current Ratio | 1.49 | 1.63 | 1.96 |
c. | Inventory Turnover | 4.65 | 4.78 | 4.62 |
d. | Asset Turnover Ratio | 3.49 | 3.53 | 3.54 |
e. | Leverage ratio | 0.41 | 0.38 | 0.35 |
f. | Return on Equity | 12.67% | 9.13% | 11.59% |
g. | Return on Total assets | 0.11 | 0.08 | 0.11 |
h. | Earnings Per Share (EPS) | 0.59 | 0.43 | 0.57 |
i. | Net Debt to Equity Ratio | 0.70 | 0.62 | 0.54 |
j. | Total Return to Shareholders | 138.70% | -64.66% | 44.95% |
Super retail Group Limited | Year 1 | Year 2 | Year 3 | |
Ratio | 2015/16 (Ending 2 July 2016) | 2016/17 (Ending 1 July 2017) | 2017/18 (Ending 30 June 2018) | |
a. | The Net Profit Margin | 2.39% | 4.07% | 4.94% |
b. | Current Ratio | 1.70 | 1.68 | 1.38 |
c. | Inventory Turnover | 2.72 | 2.78 | 2.76 |
d. | Asset Turnover Ratio | 1.54 | 1.58 | 1.55 |
e. | Leverage ratio | 0.47 | 0.52 | 0.55 |
f. | Return on Equity | 7.74% | 8.87% | 11.03% |
g. | Return on Total assets | 6.80% | 10.08% | 11.67% |
h. | Earnings Per Share (EPS) | 0.32 | 0.52 | 0.65 |
i. | Net Debt to Equity Ratio | 1.14 | 1.07 | 1.21 |
j. | Total Return to Shareholders | -2.29% | -1.20% | 4.76% |
BlackMores Limited | Year 1 | Year 2 | Year 3 | |
Ratio | 2015/16 (Ending 30 June 2016) | 2016/17 (Ending 30 June 2017) | 2017/18 (Ending 30 June 2018) | |
a. | The Net Profit Margin | 16.71% | 10.51% | 11.52% |
b. | Current Ratio | 1.53 | 1.81 | 1.73 |
c. | Inventory Turnover | 2.76 | 2.35 | 2.46 |
d. | Asset Turnover Ratio | 1.63 | 1.29 | 1.37 |
e. | Leverage ratio | 0.59 | 0.57 | 0.58 |
f. | Return on Equity | 64.28% | 33.17% | 25.55% |
g. | Return on Total assets | 27.64% | 20.16% | 23.17% |
h. | Earnings Per Share (EPS) | 5.81 | 3.43 | 4.06 |
i. | Net Debt to Equity Ratio | 1.46 | 1.30 | 1.40 |
j. | Total Return to Shareholders | 80.01% | -25.00% | 51.87% |
Effect of Bank Loan of $200 million on the companies’ Return on Equity and Net Debt To Equity Ratios
Assuming that the Loan of $200 million is taken from bank at the end of 2018 and the amount is investing in purchase of plant of equipment, the total assets and total liabilities of the companies will increase by $200 million. Since the purchase is made at the end of the year there wil be no immediate effect on sales and net profit. The return on Equity will not change as there will be no change in net profit after tax as well as net equity of the companies. The debt to equity ratios of the company will increase as the liabilities will increase by $200 million but there will be no increase in Equity. The new ratios will be as follows:
Year ending 2018 After Loan | Year ending 2018 Before Loan | |||
Return on equity | Net Debt To Equity Ratio | Return on equity | Net Debt To Equity Ratio | |
1. API Limited – API | 5.99% | 2.44 | 5.99% | 2.03 |
2. Retail Food Group Limited – RFG | -98.42% | 4.07 | -98.42% | 2.80 |
3. JB Hi Fi Limited – JBH | 25.90% | 1.84 | 25.90% | 1.63 |
4. The Reject Shop Limited – TRS | 11.59% | 1.868 | 11.59% | 0.54 |
5. Super Retail Group Ltd – SUL | 11.03% | 1.46 | 11.03% | 1.21 |
6. Blackmores Limited - BKL | 25.55% | 2.44 | 25.55% | 1.40 |
Comparison of the financial performance of the companies
The review of the financial ratios calculated above of the six companies shows that the profitability of five companies is showing a declining trend over the last three years. Except for the Super Retail group the Net profit Margin and Return on equity of all other five companies have decreased over the period. The return on total assets has also declined. This shows that the companies are not able to utilize their assets properly. Also there is increase in the total assets of the companies. This means that companies are expanding their operations and assets base and it will take some time for them to bring the new assets to utilization. It is expected that gradually the revenues and profit of the companies will increase with the expansion of operations. However there has been observed very less increase in total assets of Super Retail Group and hence the revenues and profit of the group has increased slightly showing a slow growth. The total assets of Reject Shop Limited declined in 2016-17 from previous year and increased in 2017-18 again. The Net profit margin and Return on equity and return on assets shows that similar trend. The profitability ratios decrease in 2016-17 from previous year and again increase in 2017-18.
It is concluded form the above observation that when the assets of the companies are increased there is sudden decline in profitability ratios and increase in the debt equity ratios because the liabilities and assets are increased however the revenues and profit do not increase proportionally over the short period of time. If the Assets are funded form equity as well the return on equity are reduced due to issue of new capital.
Review of Total return to shareholders of the six companies
The total return to shareholders measures the capital gain on increase in share price of the stock as well as the short term gain on distribution of dividends to the shareholders. The total return to shareholders of the six companies shows large variations as follows:
Total Return to Shareholders | |||
Year 1 | Year 2 | Year 3 | |
1. API Limited – API | 12.96% | -12.99% | 30.95% |
2. Retail Food Group Limited – RFG | 6.91% | -9.63% | -88.51% |
3. JB Hi Fi Limited – JBH | 28.85% | 1.87% | 2.01% |
4. The Reject Shop Limited – TRS | 138.70% | -64.66% | 44.95% |
5. Super Retail Group Ltd – SUL | -2.29% | -1.20% | 4.76% |
6. Blackmores Limited - BKL | 80.01% | -25.00% | 51.87% |
It is observed that the returns to shareholders of all the companies have decreased except for Super Retail Group Limited. The decline is due to the decrease in the share price of the shares in year 2 i.e. 2016-17. The share prices of Super Retail Group Limited have also decreased but the decline in share price in each following year is less than the previous year and hence the increase in the Return to shareholders.
It can be concluded that the decrease in profitability ratios due to the increase in liabilities and interest cost the expectations of the investors were not met and they started selling the shares resulting in decline in share price of the companies. Since the profitability ratios of Super Retail Group increased marginally, the share price of the company also started to increase gradually resulting in higher returns to the shareholders. It can be concluded that share price and returns to shareholders bear the relationship with the profitability of the company. The investors are hopeful of better returns if the company shows increasing trend in profitability ratios and hence the prices of the stock increases increasing the returns to the shareholders and vice-versa.
Current market value of the companies
The Current market value of the companies is observed form the SX stock exchange website and information.
Company | Market Capitalization | Net Equity (in Books) ending F. year 2018 |
API | $662.46 million | $536.7 million |
RFG Limited | $30.15 million | $158 million |
JBH Limited | $3.07 billion | $.947billion |
TRS Limited | $59.84 million | $151million |
SUL | $1.82 billion | $799 million |
BKL | $17.36million | $193million |
Comparing the market capitalization of the six companies with the net equity value in the books for the financial year ending 2018, it is observed the market value of Super Retail Group JB Hi Fi limited and API are more than the book value while the other three companies it is less than the book value. If we recollect the profitability and returns trend it was observed that profitability ratios of Super Retails group and JB Hi Fi and API limited has shown positive trends and revival in the third year after decline in second year, while the other three companies the return declined in the third year as well.
The market value of SUL (Super Retail group) is highest which did not show any decline in profits and had a slow and steady growth. It can be concluded from this that companies showing steady but slow improvement are preferred by investors more than the company which show sharp decline or change in their performance.
Conclusion
The ratio analysis of the six companies belonging to various industries over the period of three years shows that the company profitability ratios of the company decreases when it invests in the assets of the company and plans expansion. The increase in liabilities without the immediate increase in revenues and profit leads to low profitability and hence the decline in returns to the shareholders. On the other hand the companies showing slow and steady growth without making huge investment in expansion of operations or assets are viewed as more stable companies and the return to shareholders show increasing trend. The low profitability over this short term reduced the short term returns of the investors and hence causes panic and reduction in market price of the stock. Thus the investors prefer the equity investment which provide them slow and regular returns as compared to fluctuating returns.