Key Financial Ratios
|Average Receivable Collection Period||365/(5175/200.9)||14.17||365/(4749.4/157.3)||12.09|
|Average Number of Days Inventory||365/(3604/472.1)||47.81||365/(3334.9/423.8)||46.38|
|Average Number of Days Payable||365/(3604/1219.6)||123.52||365/(3334.9/1116.9)||122.24|
|Long Term Debt to Equity||389.5/328.3||1.19||352.1/243.1||1.45|
|Operating Profit Margin||233.8/5175||4.52%||232.50/4749.4||4.90%|
|Net Profit Margin||211/5175||4.08%||206.60/4749.4||4.35%|
|Return on Total Assets||211/(991.6+1135)||9.92%||206.60/(858.1+974.5)||11.27%|
|Return on Equity||211/328.3||64.27%||206.60/243.1||84.99%|
|Earnings per Share||0.157||0.1570||0.1534||0.1534|
|Price Earnings Ratio||3.4/0.157||21.66||3.62/0.1434||25.24|
The financial ratio analysis presented in the table above reflects that the liquidity position of the company had improved in 2006 due to the improvement in the cash position of the company and the increase in the company’s receivables. The efficiency ratios indicate weaknesses. The company took more days to collect receivables in 2006 as compared to 2005. Moreover, it experienced delays in the conversion of inventory into sales as it held inventory for a longer period in 2006. Similarly, in 2006, the company took more days than 2005 to settle its creditors’ accounts. The company’s profitability improved in 2006 as compared to 2005 and it remained satisfactory. The company was able to generate high gross profit margins by lowering its cost of sales and charging high price premiums to its customers for its products.
However, it incurred high administrative, selling, and distributions expenses in both years, which lowered its operating profits. The company earned a low net profit margin of just 4.08% in 2006 and 4.35% in 2005. However, the company generated a significantly high ROE that was favorable for shareholders. The EPS remained above 15p that generated a P/E of 21.66 in 2006. The shareholders would have experienced an increase in the company’s share price in the future periods due to high P/E multiples. A major concern raised regarding the company’s performance was related to its long-term debt to equity ratio. The company had excessively high debt as compared to its equity. Despite efforts by the company to reduce its borrowing, the ratio value remained above 1.19 in 2006. The company paid small dividends to its shareholders in 2006 and 2005 that led to a dividend yield of 2.76% and 2.35% respectively.
Common Size Statements
|Consolidated Profit and Loss Account.|
|Cost of Sales||(3,604.00)||-69.64%||(3,334.90)||-70.22%|
|Other Operating Income||13.70||0.26%||32.00||0.67%|
|Selling and Distribution Costs||(1,155.20)||-22.32%||(1,034.80)||-21.79%|
|Administration and Other Operating Expenses||(195.70)||-3.78%||(179.20)||-3.77%|
|Net Financing Charges||(6.00)||-0.12%||(9.40)||-0.20%|
|Share of Results of Associates and Joint Ventures||27.70||0.54%||28.50||0.60%|
|Profit Before Tax||255.50||4.94%||251.60||5.30%|
|Profit for the Year||211.00||4.08%||206.60||4.35%|
|Consolidated Balance Sheet.|
|Net Operating Assets|
|Associates and Joint Ventures||113.90||5.36%||106.60||5.82%|
|Deferred Tax Assets||9.40||0.44%||7.00||0.38%|
|Other Non-Current Assets||62.20||2.92%||54.30||2.96%|
|Debtors and Prepayments||200.90||9.45%||157.30||8.58%|
|Current Tax Assets||5.00||0.24%||2.10||0.11%|
|Non-Current Assets Classified as held for sale||0.50||0.02%||2.20||0.12%|
|Creditors and Accruals||(1,219.60)||62.11%||(1,116.90)||62.05%|
|Current tax Liabilities||(33.70)||1.72%||(31.80)||1.77%|
|Liabilities directly associated with non-current assets classified as held for sale||(0.10)||0.01%||(0.50)||0.03%|
|Net Current Liabilities||(165.40)||8.42%||(210.60)||11.70%|
|Deferred tax Liabilities||(41.30)||2.10%||(34.90)||1.94%|
|Other Non-Current Liabilities||(67.10)||3.42%||(17.40)||0.97%|
|Share Premium and Capital Reserves||27.80||8.47%||26.10||10.74%|
|Revenue and other Reserves||221.50||67.47%||123.50||50.80%|
The common size profit and loss statement reasserts findings of the ratio analysis suggesting that the major expense factor was selling, administration, and distribution expenses. The company needed to control its expenses in order to increase its net earnings. Moreover, the company was not efficient in managing payments to its suppliers. High creditors amount added to the concerns related to the company’s solvency position. There was also a sharp increase in the company’s other non-current liabilities. Furthermore, the company increased its revenue and other reserves that allowed the company to invest in other companies.
Consistency of Financial Information
The management report included in the annual report of the company provided business information that was consistent with the financial information presented in the consolidated financial statements. One area of concern that could be highlighted is related to the information provided by management pertaining to the company’s investments in different markets. These new stores or acquisitions have not contributed much to the company’s profits as they just indicated a small increase in 2006. The company might have been experiencing problems in managing its new stores (e.g., difficulties in paying creditors) that are not reflected in the information supporting financial statements. Furthermore, the analysis indicated that there are small differences in the values of KPIs provided in the annual report. For example, PBIT to sales ratio for the year 2005 as provided in the annual report is 4.70%; whereas, the ratio analysis based on the financial information indicated a ratio value of 4.90%.
The company had shown improvement in its earnings in 2006, but it did not justify the expansion in the company’s business operations. The company increased its number of stores and also, invested funds to increase its holdings in associated businesses. The company expected that its strategy of expansion in new emerging Asian markets would put the company in a competitive position. It planned to open up new stores and also, refurbish its existing stores to attract customers. Furthermore, the company’s P/E ratio indicated possible growth in the share value that could generate capital gains for shareholders. Based on the analysis, the company was expected to perform better in the future.
Comparison with Tesco and Sobey’s
- The layout of the balance sheets of Tesco and Dairy Farm is the same as both companies are listed on LSE and report according to IFRS. However, the layout of Sobey’s is different.
- Based on financial ratio analysis, it is clear that Dairy Farm had a better liquidity position than Tesco. However, the current and quick ratios of Sobey’s indicated a comparatively stronger position in 2006 and 2005. Dairy Farm had operational inefficiencies as compared to the other two companies in terms of a longer period required for collection of receivables and payments to inventory suppliers and creditors. Overall profitability of Dairy Farm remained stronger as compared to Sobey’s.
- In comparison to Tesco and Sobey’s, Dairy Farm had a longer collection period. Moreover, it took more days to convert its inventory into sales and settle accounts of its creditors. In 2006, Dairy Farm’s gross profit margin was higher than Tesco, but Tesco had a higher operating profit margin. The reason for this sharp reduction in profits was higher administrative, selling, and distribution expenses incurred by Dairy Farm. In terms of ROA and ROE, Dairy Farm was a better performer than Tesco and Sobey’s. There was also a significant difference in ROE of all three companies. Dairy Farm had the highest ROE of 64.27% as compared to 17.60% of Tesco and 10.90% of Sobey’s.
- Based on comparative analysis, it could be suggested that Dairy Farm performed similarly well as Tesco in 2005 and 2006. However, due to the size of Tesco’s operations and its ability to overtake its competitors, I would prefer investing in its shares. I have major concerns regarding Dairy Farm’s aggressive borrowing and delays in payments. I feel that if the company does not improve its operational efficiency in the future that it could face major difficulties and possibly take over the move by its competitors.