Ratio Analysis on Debenhams and Sainsbury

Introduction

Profitability ratios measure a firm’s ability in generating profit from its operations and assets. Operating profit margin considers the percentage of sales that form earnings before interest and taxes. Operating profit margin shows that Debenhams’ efficiency is declining at a higher rate than Sainsbury’s. Return on investment shows that Debenhams generates more profit from its assets than Sainsbury. Debenhams generated more earnings for shareholders than Sainsbury. Liquidity ratios show the firms’ ability to settle short-term debts.

Both firms would have problems meeting their debt obligations if all short-term creditors were to demand payment at the same time. Sainsbury manages inventory more efficiently than Debenhams. One of the weaknesses of ratio analysis is that it cannot be used to compare companies in different industries. Ratio analysis may fail to indicate changes caused by the external environment.

Profitability Ratios

Net profit margin

Net profit margin = (net income/ net sales) X 100 (Horner & Mott 2013, p. 339).

Tables 1. Debenhams’ ratios.

Net profit margin Amount in millions
Year ended 1-Sep-2013 31-Aug-2012 2-Sep-2011
Net profit £127.9 £125.3 £117.2
Sales £2,282.2 £2,229.8 £2,209.8
Net profit margin 5.60% 5.62% 5.30%

Sainsbury’s ratios.

Net profit margin Amount in millions
Year ended 16-Mar-2013 17-Mar-2012 17-Mar-2011
Net profit £614 £598 £640
Sales £23,303 £22,294 £21,102
Net profit margin 2.63% 2.68% 3.03%
Debenhams vs. Sainsbury
Net profit margin
Year ended 2013 2012 2011
Debenhams 5.60% 5.62% 5.30%
Sainsbury 2.63% 2.68% 3.03%

Sources of data: Debenhams (2013, p. 85 & 87), Debenhams (2012, p. 11 & 13), Sainsbury (2013, p. 73 & 75) and Sainsbury (2012, p. 68 & 70).

Net profit margin
Graph 1. Net profit margin.

Tables 1 and graph 1 show that Debenham is more profitable than Sainsbury. Debenham earns a higher amount of profit from a dollar of sales than Sainsbury. Sainsbury needs to increase its efficiency to match the competitor. Debenham generates more value for shareholders.

Gross profit margin

Gross profit margin = (gross profit/ net sales) X 100 (Horner & Mott 2013, p. 338).

Gross profit margin shows the firms’ efficiency in obtaining goods for resale. Gross profit margin can be affected by changes in selling prices, costs of goods and intensity of competition (Horner & Mott 2013, p. 338).

Tables 2. Debenhams’.

Gross profit margin Amount in millions
Year ended 1-Sep-2013 31-Aug-2012 2-Sep-2011
Gross profit £310.1 £302.3 £296.7
Sales £2,282.2 £2,229.8 £2,209.8
Gross profit margin 13.59% 13.56% 13.43%

Sainsbury’s.

Gross profit margin Amount in millions
Year ended 16-Mar-2013 17-Mar-2012 17-Mar-2011
Gross profit £1,277 £1,211 £1,160
Sales £23,303 £22,294 £21,102
Gross profit margin 5.48% 5.43% 5.50%

Debenhams against Sainsbury.

Gross profit margin
Year ended 2013 2012 2011
Debenhams 13.59% 13.56% 13.43%
Sainsbury 5.48% 5.43% 5.50%
Gross profit margin
Graph 2. Gross profit margin.

Tables 2 and graph 2 show that Sainsbury has a higher cost of goods sold than Debenham. Sainsbury needs to find out whether Debenhams is using lower cost of goods sold or higher selling prices.

Operating profit margin

Operating profit margin = (operating profit/ sales revenue) X 100 (Horner & Mott 2013, p. 338).

Tables 3. Debenhams’.

Operating profit margin Amount in millions
Year ended 1-Sep-2013 31-Aug-2012 2-Sep-2011
Operating profit £168.0 £175.0 £183.7
Sales £2,282.2 £2,229.8 £2,209.8
Operating profit margin 7.36% 7.85% 8.31%

Sainsbury’s.

Operating profit margin Amount in millions
Year ended 16-Mar-2013 17-Mar-2012 17-Mar-2011
Operating profit £887 £874 £851
Sales £23,303 £22,294 £21,102
operating profit margin 3.81% 3.92% 4.03%

Debenhams against Sainsbury.

Operating profit margin
Year ended 2013 2012 2011
Debenhams 7.36% 7.85% 8.31%
Sainsbury 3.81% 3.92% 4.03%
Operating profit margin
Graph 3. Operating profit margin.

Tables 3 show that Debenham is run more efficiently than Sainsbury. Graph 2 shows that Debenhams’ efficiency is declining at a higher rate than Sainsbury’s. It could be an indication of increasing competition which lowers the selling price. It could also be a higher cost of goods sold.

Return on investment

Return on investment = net earnings/ total assets

Return on investment measures a firm’s efficiency and effectiveness in using assets to generate net income (Horner & Mott 2013, p. 337).

Tables 4. Debenhams’.

Return on investment (ROI) Amount in millions
Year ended 1-Sep-2013 31-Aug-2012 2-Sep-2011
Net earnings £127.3 £125.3 £117.2
Total Assets £2,132.8 £2,091.2 £2,018.2
ROI 5.97% 5.99% 5.81%

Sainsbury’s.

Return on investment (ROI) Amount in millions
Year ended 16-Mar-2013 17-Mar-2012 17-Mar-2011
profit after tax £614 £598 £640
Total assets £12,695 £12,340 £11,399
ROI 4.84% 4.85% 5.61%

Debenhams against Sainsbury.

Return on investment
Year ended 2013 2012 2011
Debenhams 5.97% 5.99% 5.81%
Sainsbury 4.84% 4.85% 5.61%
Return on investment
Graph 4. Return on investment.

Tables 4 show that Debenhams generates more profit from its assets than Sainsbury. Graph 4 shows that Sainsbury’s ROI declined when Debenhams’ has remained stable.

Return on equity

Return on equity = net earnings/ stockholders’ equity (Horner & Mott 2013, p. 337).

Tables 5. Debenhams’.

Return on equity (ROE) Amount in millions
Year ended 1-Sep-2013 31-Aug-2012 2-Sep-2011
Profit after tax £127.9 £125.3 £117.2
Equity £744.4 £661.0 £659.6
ROE 17.18% 18.96% 17.77%

Sainsbury’s.

Return on equity (ROE) Amount in millions
Year ended 16-Mar-2013 17-Mar-2012 17-Mar-2011
Profit after tax £614 £598 £640
Equity £5,733 £5,629 £5,424
ROE 10.71% 10.62% 11.80%

Debenhams against Sainsbury.

Return on equity
Year ended 2013 2012 2011
Debenhams 17.18% 18.96% 17.77%
Sainsbury 10.71% 10.62% 11.80%
Return on equity
Graph 5. Return on equity.

Tables 5 indicate that Debenhams generated more earnings that could be shared by shareholders than Sainsbury. Both firms show a decline in returns.

Liquidity Ratios

Current ratio

The current ratio measures a firm’s ability to honour the demands of short-term creditors about settling their debts.

Current ratio = current liabilities/ current liabilities (Horner & Mott 2013, p. 348).

Tables 6. Debenhams’.

Current ratio Amount in millions
Year ended 1-Sep-2013 31-Aug-2012 2-Sep-2011
Current assets £470.5 £459.5 £423.6
Current liabilities £741.9 £727.0 £715.6
current ratio 0.63 0.63 0.59

Sainsbury’s.

Current ratio Amount in millions
Year ended 16-Mar-2013 17-Mar-2012 17-Mar-2011
Current assets £1,901 £2,032 £1,708
Current liabilities £3,113 £3,136 £2,942
Current ratio 0.61 0.65 0.58

Debenhams against Sainsbury.

Current ratio
Year ended 2013 2012 2011
Debenhams 0.63 0.63 0.59
Sainsbury 0.61 0.65 0.58

Sources of data: Debenhams (2013, p. 85 & 87), Debenhams (2012, p. 11 & 13), Sainsbury (2013, p. 73 & 75) and Sainsbury (2012, p. 68 & 70).

Current ratio
Graph 6. Current ratio.

The current ratio tables show that both firms maintain similar levels of liquidity. A current ratio less than 1.0 shows that the firms would have problems meeting their debt obligations if all short-term creditors were to demand payment at the same time. Graph 6 shows that the firms’ current ratios improved then declined.

Quick ratio

Quick ratio = current assets – inventory/ current liabilities (Horner & Mott 2013, p. 348)

Tables 7. Debenhams’.

Quick ratio Amount in millions
Year ended 1-Sep-2013 31-Aug-2012 2-Sep-2011
current assets £470.5 £459.5 £423.6
Less inventory £357.9 £332.3 £321.3
Current Assets – Inventory £112.6 £127.2 £102.3
Current liabilities £741.9 £727.0 £715.6
Quick ratio 0.15 0.17 0.14

Sainsbury’s.

Quick ratio Amount in millions
Year ended 16-Mar-2013 17-Mar-2012 17-Mar-2011
Current assets £1,901 £2,032 £1,708
Less inventory £987 £938 £812
Current assets – inventory £914 £1,094 £896
Current liabilities £3,113 £3,136 £2,942
Quick ratio 0.29 0.35 0.30

Debenhams against Sainsbury.

Quick ratio
Year ended 2013 2012 2011
Debenhams 0.15 0.17 0.14
Sainsbury 0.29 0.35 0.30
Quick ratio
Graph 7. Quick ratio.

Tables 7 show that Sainsbury has a better quick ratio than Debenham. It also shows that Debenham relies a lot on inventory for its liquidity than Sainsbury.

Trade receivables days

Trades receivable days = (trade receivables/ credit sales) X 365 days (Horner & Mott 2013, p. 345).

Trades receivable days show the average number of days that a firm has to wait to collect cash from debtors (Britton & Waterston 2006, p. 197).

Tables 8. Debenhams’.

Trade receivables days Amount in millions
Year ended 1-Sep-2013 31-Aug-2012 2-Sep-2011
Receivables £78.3 £75.4 £72.1
Sales £2,282.2 £2,229.8 £2,209.8
Trade receivables days 12.5 12.3 11.9

Sainsbury’s.

Trade receivables Amount in millions
Year ended 16-Mar-2013 17-Mar-2012 17-Mar-2011
Trade receivables £306 £286 £343
Sales £23,303 £22,294 £21,102
Trade receivable days 4.8 4.7 5.9

Debenhams against Sainsbury.

Trade receivables days
Year ended 2013 2012 2011
Debenhams 12.5 12.3 11.9
Sainsbury 4.8 4.7 5.9
Trade receivables days
Graph 8. Trade receivables days.

The fewer the trade receivables days, the better for the firms. Graph 8 shows Debenhams’ average days in receivables increased when Sainsbury declined. Sainsbury has a better performance.

Trade payables

Trades payable days = (trades payable/ credit purchases) X 365 days (Horner & Mott 2013, p. 345)

Tables 9. Debenhams’.

Trade payables days Amount in millions
Year ended 1-Sep-2013 31-Aug-2012 2-Sep-2011
Payables £545.8 £525.4 £489.1
Sales £2,282.2 £2,229.8 £2,209.8
Trade payables days 87.3 86.0 80.8

Sainsbury’s.

Trade payables days Amount in millions
Year ended 16-Mar-2013 17-Mar-2012 17-Mar-2011
Trade payables £2,726 £2,740 £2,597
Sales £23,303 £22,294 £21,102
Trade payables days 42.7 44.9 44.9

Debenhams against Sainsbury.

Trade payables days
Year ended 2013 2012 2011
Debenhams 87.3 86.0 80.8
Sainsbury 42.7 44.9 44.9
Trade payables
Graph 9. Trade payables.

The longer a firm makes creditors to wait, the less cash it will require for operations. Tables 9 show that Debenham has a better arrangement with suppliers.

Average stock days

Average stock days = (average stock/ cost of goods sold) X 365 days (Britton & Waterston 2006, p. 197).

Tables 10. Debenhams’.

Average stock days Amount in millions
Year ended 1-Sep-2013 31-Aug-2012 2-Sep-2011
Average stock £357.9 £332.3 £321.3
Cost of goods sold £1,972.1 £1,927.5 £1,913.1
Average stock days 66.2 62.9 61.3

Sainsbury’s.

Average stock days Amount in millions
Year ended 16-Mar-2013 17-Mar-2012 17-Mar-2011
Average stock £987 £938 £812
Cost of goods sold £22,026 £21,083 £19,942
Average stock days 16.4 16.2 14.9

Debenhams against Sainsbury.

Average stock days
Year ended 2013 2012 2011
Debenhams 66.2 62.9 61.3
Sainsbury 16.4 16.2 14.9
Average stock days
Graph 10. Average stock days.

The firm that keeps stock longer may incur higher costs of maintaining inventory. Tables 10 show that Sainsbury manages inventory more efficiently than Debenhams. Graph 10 shows Sainsbury’s efficiency remained fairly constant when Debenhams’ declined.

Weaknesses of ratio analysis

One of the weaknesses of ratio analysis is that it cannot be used to compare companies in different industries. Different industries provide different rates of return and different levels of risk (Chapter 13: Financial statement analysis n.d., p. 693). Sainsbury and Debenhams are comparable because they fall under the variety stores industry.

Ratio analysis may fail to indicate changes caused by the external environment such as inflation and national consumption.

Accounting practices may affect the ability to compare financial performance accurately (Chapter 13: Financial statement analysis n.d., p. 693). The firms above cannot be compared accurately because their financial statements are compiled for different periods of the year. Debenhams’ financial statements cover years that end in August and Sainsbury’s cover years that end in mid-March. It is also difficult to calculate trade receivable days and trade payable days because firms do not disclose the amount they sell on credit.

Conclusion

Debenhams performed better than Sainsbury in all profitability ratios. Debenhams needs to improve on the operating profit margin, trade receivables, average stock days and ROE. Sainsbury performance is better than Debenhams in managing inventory, trade payables and the quick ratio. Both firms do not keep the required level of the current ratio. Their current liabilities are more than current assets by a big margin. Ratio analysis cannot be used to compare companies in different industries. It may be difficult to compare companies in the same industry if they are based in different countries because of different accounting practices. The two firms are based in the same country but have different periods in which their calendar ends. Debenhams’ financial statements cover years that end in August. Sainsbury’s covers years that end in mid-March. It creates a weakness in analyzing the financial statements.

Recommendations

Similar trends among firms in ratio analysis should be followed by an analysis of the external environment to determine the influence of external factors.

Both firms need to improve their current ratio towards a ratio of 1.0.

Sainsbury needs to check its efficiency in generating profits to match Debenhams.

Debenhams is a better choice for an investor than Sainsbury based on the level of profitability.

Reference List

Britton, A & Waterston, C 2006. Financial accounting, 4th edn, Pearson Education. Harlow.

Chapter 13: Financial statement analysis n.d., Web.

Debenhams. 2013. A leading international multichannel brand: Debenhams plc annual report and accounts 2013. Web.

Debenhams. 2012. Debenhams plc: Full year results 2012. Web.

Horner, D & Mott, G. 2013. Accounting for non-accountants, 9th edn, Kogan Page, Philadephia.

Sainsbury. 2013. J Sainsbury plc annual report and financial statements 2012. Web.

Sainsbury. 2012. J Sainsbury plc annual report and financial statements 2012. Web.

Cite this paper

Select style

Reference

BusinessEssay. (2022, November 27). Ratio Analysis on Debenhams and Sainsbury. https://business-essay.com/ratio-analysis-on-debenhams-and-sainsbury/

Work Cited

"Ratio Analysis on Debenhams and Sainsbury." BusinessEssay, 27 Nov. 2022, business-essay.com/ratio-analysis-on-debenhams-and-sainsbury/.

References

BusinessEssay. (2022) 'Ratio Analysis on Debenhams and Sainsbury'. 27 November.

References

BusinessEssay. 2022. "Ratio Analysis on Debenhams and Sainsbury." November 27, 2022. https://business-essay.com/ratio-analysis-on-debenhams-and-sainsbury/.

1. BusinessEssay. "Ratio Analysis on Debenhams and Sainsbury." November 27, 2022. https://business-essay.com/ratio-analysis-on-debenhams-and-sainsbury/.


Bibliography


BusinessEssay. "Ratio Analysis on Debenhams and Sainsbury." November 27, 2022. https://business-essay.com/ratio-analysis-on-debenhams-and-sainsbury/.