In: Accounting
Answer part B question d, please.
Pete Sandstrom is the CEO of WeRHere4U Ltd. He is speaking with you having shown you these financial statements for the years 2016 through 2019. He is extremely proud of his results; Net profit has steadily increased from $67,200 in 2017 to $73,500 in 2018 and in 2019, $83,300. He also highlights to you that the Return on Equity (ROE) at WeRHere4U Ltd has also improved substantially form 51% in 2017 to 62% in 2019. He is hoping that when these results are presented to the shareholders of WeRHere4U that he will be rewarded with a substantial bonus for all his good efforts. You decide to take a closer look at the performance of WeRHere4U using the techniques you have learnt in ACCT1101 by considering each of the questions below.
PART A:
You perform a “Common-size” analysis on the Statements of Financial Performance for each of the years 2017, 2018 and 2019. This is shown below.
COMMON SIZE ANALYSIS |
|||
2019 |
2018 |
2017 |
|
Sales |
100.00% |
100.0% |
100.0% |
Cost of Sales |
47.0% |
45.2% |
43.0% |
Gross Profit |
53.0% |
54.8% |
57.0% |
Other expenses |
16.2% |
18.0% |
20.0% |
Operating profit |
36.8% |
36.8% |
37.0% |
Interest |
4.6% |
2.9% |
1.5% |
Profit before Tax |
32.2% |
33.9% |
35.5% |
Tax expense |
9.6% |
10.2% |
10.7% |
Net Profit |
22.6% |
23.7% |
24.8% |
Required:
PART B:
You now use the information provided in the WeRHere4U’s financial statements to perform the following DuPont Analysis of the Return on Equity (ROE) for each of the years 2017, 2018 and 2019.
DU PONT ANALYSIS |
|||
2019 |
2018 |
2017 |
|
Return on Equity (ROE) |
0.6170 |
0.5444 |
0.5110 |
Return on Capital Employed (ROCE) |
0.5913 |
0.6000 |
0.6390 |
Operating Profit Margin |
0.3676 |
0.3677 |
0.3704 |
Capital Turnover |
1.6087 |
1.6316 |
1.7252 |
Tax and Interest ratio |
0.6125 |
0.6447 |
0.6720 |
Leverage |
1.7037 |
1.4074 |
1.1901 |
Required:
d) The claims that performance of WeRHere4U has been excellent over the last 3 years is completely baseless and utterly false. The company has failed in every major aspect possible. We see that the Operating profit margin has marginally declined over the years and also, the capital turnover ratio has fallen. This impliess a fall in both the Top line (sales) and the Bottom line (Margins/ Gross Profit) . Overall return on capital employed has also fallen sharply from the 63.9% to 59.13%. Amid all this negative outlooks and events, the company has significantly and quite frankly, unnecessarily, increased its leverage from 1.19 level to 1.70 level which has resulted in a higher debt burden on the company. It has resulted in a tax break and lower cost benefit on the borrowed amount, which ultimately lead to a higher ROE. This higher ROE is just an illusion an by no means has the company improved its performance. The higher ROE is just an example of unnecessary risk undertaken by the company to increase its ROE .