Introduction
This paper focuses on and calculation and discussion of Walmart’s financial performance in comparison with Target’s performance using financial ratios. In particular, 21 financial ratios are used to compare the companies’ performance in terms of profitability, liquidity, efficiency, and financial gearing. First, the paper provides calculations of ratios in a table format. After that, the paper focuses on the discussion of the probable causes of the differences in the performance.
Ratio Calculations
Table 1 below provides calculations of the financial ratios for Target and Walmart. The data was taken from the companies’ consolidated financial statements for the FY ended in January 2022.
Table 1. Ratio calculations (all numbers in millions except for ratios)
Ratio Analysis
Profitability
Walmart has a lower profitability measure in net profit margin with 2.41% in FY2021-2022 against Target’s 6.64% in net profit margin. The central reason for the difference is Target’s better ability to manage its costs. Target’s costs of goods sold (COGS) were 71.4% in FY2021-2022, while Walmart’s COGS were 75.56%, which negatively affected the company’s net profit margin. Similarly, Target’s selling, general, and administrative (SG&A) expenses were 18.88% in FY2021-2022, which is significantly lower than Walmart’s 20.75% in the same fiscal year. It should also be noted that Walmart’s decreased profitability is not associated with depreciation or interest costs. The analysis revealed that Target’s depreciation costs were 2.24% from net sales in FY2021-2022, which is higher than Walmart’s 1.88% of total sales for the same fiscal year. Similarly, Target’s interest expense was 0.4% in FY2021-2022, which is higher than Walmart’s 0.32% for the same fiscal year.
There may be several reasons for such a difference in net profit margin. One of the possible reasons for low net profit margin is the low prices of the goods. However, comparative analysis of prices between Target and Walmart revealed that the prices were almost the same, with a slight difference in favor of Target, showing that shopping in Target was associated with 0.9% savings in comparison with Walmart (Balestra, 2021). Another reason for the differences in prices may be associated with supply chain costs. Walmart operates in the US, Puerto Rico, Canada, China, Mexico, Brazil, Germany, Britain, Argentina and South Korea (Walmart, 2022). This implies that the company needs to maintain a more complicated supply chain in comparison with Target, which operates only in the US (Target, 2022). Moreover, sales may be lower in the countries with lower quality of life and the cost of sales and associated SG&A may be higher. Additionally, Walmart launched a new membership program, which offered unlimited free shipping (Walmart, 2022). This program may need more time to repay for itself.
Another measure of profitability is return on equity (ROE). Target’s ROE was 0.54 in FY2021-2022, while Walmart’s ROE was only 0.15 for the same year. However, it should be noted that the difference in ROE may be associated with Target’s higher equity multiplier, which is demonstrates a higher level of company’s financial leverage.
Liquidity
Liquidity was measured using two financial ratios, including current ratio and acid test ratio. The current ratio demonstrated of two companies was comparable, with 0.99 for Target 0.93 for Walmart in FY2021-2022. The companies performed similarly in terms of acid test ratio, with 0.35 for Target 0.28 for Walmart in FY2021-2022. The results of the analysis demonstrated a high reliance on inventory in terms of current assets, which may be difficult to turn into cash. The analysis demonstrated that Walmart required lower liquidity due to high inventory turnover, which was 10.05 for Walmart in FY2021-2022 in comparison with Target’s 7.52. Therefore, Walmart could allow to operate with a lower liquidity.
Leverage
Financial leverage was measured using debt-to-assets ratio and equity multiplier. Target’s debt-to-assets ratio was 0.25 for FY2021-2022, while Walmart’s debt-to-assets ratio was 0.14 for the same fiscal year. Walmart’s relatively low reliance on debt to finance its assets be associated with the fact that Walmart needed to operate with lower risks due to international supply chain maintenance.
Efficiency
The companies’ efficiency was measured using return on assets (ROA), total assets turnover (TAT) ratio, current assets turnover (CAT) ratio, sales-to-cash ratio, accounts receivable turnover (ART) ratio, sales-to-PPE, sales-to-store, sales-to-employees, and sales-to-square feet. Target’s ROA was 0.13 for FY2021-2022, while Walmart’s ROA was more than twice as low with 0.06 for the same year. However, Walmart demonstrated a better ability to turn assets into sales, as its TOT ratio was 2.32 in comparison with Target’s 1.94. Similar situation was with the CAT ratio, which was 4.85 for Target and 7.0 for Walmart. Similarly, analysis demonstrates that Walmart used its PPE more efficiently to generate sales, as its sales-to-PPE ratio was 6.01, while Target’s ratio was 3.71. The ART ratio was high for both companies with 77.32 for Target and 68.57 for Walmart, demonstrating that Walmart requires overall more time to collect money on credit sales.
Walmart’s ability to generate sales from property is explained by the company embracing online sales. Walmart took advantage of trends to online sales due to the COVID-19 pandemic, which allowed the company to increase it sales (Walmart, 2022). Target did not demonstrate such a focus on online sales despite systematically increasing its capacities to fulfill online sales (Target, 2022).
Conclusion
In order to explain the differences in efficiency, it is crucial to look at sales-to-store, sales-to-employees, and sales-to-square feet. Both companies’ sales-to-store ratio were relatively the same with $53.98 million of sales per store for Target and $53.64 million of sales per store for Walmart. Similarly, Target’s sales-to-employees ratio was $230 thousand in sales for employee, while Walmart’s sales-to-employees ratio was $250 thousand, which demonstrates a relative parity in the matter. However, Walmart’s sales-to-square feet ratio was significantly lower ($297.99) in comparison with that of Target ($415.22). This demonstrates that Walmart’s stores are larger that Target’s store, while they provide similar sales. As a result, Walmart has additional expenses associated with maintaining larger stores, which leads to lower net profit margin and low ROA. Therefore, it is crucial that the company increases its efficiency of store area to improve its performance.
References
Balestra, D. (2021). Target vs. Walmart Price Comparison: Which is Cheaper? Koopy. Web.
Target. (2022). Annual report 2021. Web.
Walmart. (2022). Annual report 2021. Web.