Walmart Financial Ratios and Financial Statements Analysis and Review
In "Walmart 2019 Financial Statements and Financial Ratios: Defined, Discussed, and Analyzed for 5 Years” that was written by, Paul Borosky, MBA., doctoral candidate, and owner of Quality Business Plan and Finance Homework Help, the author summarized Walmart's 2019 10k, Walmart's 2018, 10k annual report, Walmart's 2017 10k annual report, and Walmart's 2016 10k annual reports as the basis for information gathering. After all of Walmart's 10k annual statements were collected, which included Walmart's Income Statements and Walmart's Balance Sheets, he then used proprietary financial templates to calculate different financial ratios such as Walmart's ROE, ROA, and debt ratio.
Walmart 2015 to 2019 Income Statement Summarized
|Walmart Income Statement 2019 - Summarized|
|R & D|
Walmart 2019 Revenues Analysis:
Walmart’s revenue declined slightly in 2016. However, over the next three years, the organization had moderate to slow growth. This is typical for businesses in a mature industry such as the one Walmart competes, which is retail.
|Revenues and Growth|
Walmart 2019 Cost of Goods Analysis:
Walmart’s cost of goods has stayed, on average, at approximately 74.5% of the revenues. This indicates that Walmart has a specific price structure that they follow to ensure optimal gross profit margins. Further, the company has held to the strategy over several consecutive periods. This indicates that the firm is disciplined in their negotiations with vendors as well.
|Walmart COGS as % of Revenues|
|Income Statement 2018|
Walmart 2019 SG&A Analysis:
Walmart’s cost of goods has stayed, on average, at approximately 74.5% of the revenues. This indicates that Walmart has a specific price structure that they follow to ensure optimal gross profit margins. Further, the company has
Walmart lumps in numerous costs into their SG&A. By doing this, investors and competitors are not able to fully understand the company’s cost structure. This is beneficial for the company because competitors cannot analyze their cost structures strategies. However, this is detrimental to investors. This is because investors are not able to ascertain how well management is conducting their job related to specific aspects of their business.
|Walmart SG&A as % of Revenues|
|Income Statement 2018|
Walmart 2015 to 2019 Balance Sheet Summarized
|Walmart Balance Sheet Summarized - 2019 to 2015|
|Short Term Investment||-||-||-||-||-|
|LT Debt - Current||729||667||2,256||2,745||4,810|
|Total Current Liabilities||77,477||78,521||66,928||64,619||65,272|
|Total Equity & Liability||219,295||204,522||198,825||199,581||203,706|
Walmart 2019 Cash Analysis:
In the last five years, it looks like Walmart has been attempting to keep their cash position at approximately 1.5% of sales. By following this strategy, the organization has been able to keep a sufficient amount of money set aside for operational needs. Since this is a proven track record for the organization, I would chalk this up as “well done” for Walmart.
|Walmart Cash as a % of Sales 2019|
|% of Sales||1.5%||1.3%||1.4%||1.8%||1.9%|
|% of Total Assets||3.5%||3.3%||3.5%||4.4%||4.5%|
Walmart 2019 Accounts Receivable Analysis:
Walmart’s Accounts Receivable has remained at approximately 1.2% of sales. This indicates that the company has a solid collection program. Further, this also indicates seasoned management in this area as well.
|Walmart Accounts Receivable as a % of Sales|
|Balance Sheet - 2019|
|% of Sales||1.2%||1.1%||1.2%||1.2%||1.4%|
Walmart 2019 Inventory Analysis:
A trend is starting to emerge with Walmart’s current assets. The company has held their inventory to approximately 21% of its total assets. Further, this trend has continued for approximately five years. As for the current asset trend, as noted earlier, the management team had kept their accounts receivable aligned with sales and cash balance aligned with sales as well. By keeping their inventory aligned with total assets, this indicates that the organization has done significant research into how to best optimize their current assets. Further, the company has followed the strategy for several years (all noted line items have five-year trends) and it must have proven effective or else they would have made changes.
|Walmart Inventory as a % of Sales and Total Assets|
|% of Sales||8.6%||8.6%||8.9%||9.2%||9.3%|
|% of Total Assets||20.2%||21.4%||21.7%||22.3%||22.2%|
Walmart 2015 to 2019 Financial Ratios
|Walmart 2019 Liquidity Ratios|
|Walmart 2019 Asset Utilization|
|Total Asset Turnover||2.35||2.48||2.44||2.42||2.38|
|Fixed Asset Turnover||4.93||4.70||4.51||4.38||4.25|
|Days Sales Outstanding||4.46||4.05||4.38||4.26||5.09|
|Accounts Receivable Turnover||81.87||90.19||83.27||85.73|| 71.65|
|Walmart 2019 Profitability Ratios|
|Return on Assets||3.04%||4.82%||6.86%||7.56%||8.39%|
|Return on Equity||8.38%||12.20%||16.94%||18.04%||21.01%|
|Net Profit Margin||1.30%||1.95%||2.81%||3.13%||3.52%|
Walmart 2019 Current Ratio Analysis:
Walmart’s current ratio ended 2015 on an excellent note, which was .97. Almost par for most industries. However, this ratio has fallen over the last several years to a .8 in 2019. In most industries, this moderate decline would be worrisome for investors. However, in the retail industry, a .8 current ratio is actually a little high. In other words, Walmart could probably optimize their current assets at a .6 or .7 current ratio. From this perspective, Walmart looks to be solvent for the short to moderate term.
Walmart 2019 Cash Ratio Analysis:
When you really want to shake things up, in reference to liquidity ratios, then the cash ratio is the way to do it. As noted above, the current ratio is often considered the industry standard, as to whether a company is sufficiently liquid or not. A more restrictive calculation, to determine the same concept, is the cash ratio. This ratio is more restrictive because only cash is included in the calculation.
In this ratio, we are comparing the company’s cash to its total current liabilities. If an organization exceeds one, after the calculation is complete, then this means that the company is able to handle its 12 months debt payments with cash alone.
Walmart 2019 Fixed Asset Turnover Analysis:
Walmart’s fixed asset turnover has steadily increased over the last five years. This shows that the firm is increasing their fixed asset utilization. Walmart may have accomplished this task by selling or closing down some of their low performing stores. Disposing of underperforming fixed assets is a popular strategy some businesses use for rapid improvement in fixed asset utilization.
Walmart 2019 Days Sales Outstanding Analysis:
Walmart’s days sales outstanding for 2019 was approximately 4.5 days. Such a low days sales outstanding should be expected from a retail establishment. This is because industry competitors often receive cash during their transactions.
Walmart Return of Assets Analysis:
Walmart ended 2015 with a return on assets of 8.39%. Over the next four years, the return on assets would steadily decline to 3.04%. In other words, Walmart is utilizing more assets to generate similar returns. To mitigate this issue, Walmart’s executive team needs to identify which assets may be sold that will not impact operations or revenues. Further, profits from the sale need to be applied to the firm’s debt. By doing this, the organization will eventually level off or possibly start to improve on this ratio.
Walmart Return of Equity Analysis:
At the end of 2015, Walmart had a healthy return on equity of approximately 21%. Unfortunately, the company’s return on equity fell drastically over the next five years to 8.38% in 2019. The substantial decline should be alarming for investors. However, the organization is utilizing more debt in their capital structure. In doing this, the company should be able to improve their return on equity over time.
Walmart Profit Margin Analysis:
Walmart ended 2015 with a profit margin of 3.52%. Over the next several years, its profit margin fell to 1.3%. This means that their net income has declined as compared to their sales. A driving reason for this to happen would be the firm is incurring additional costs that are not passed on to its consumers. To mitigate this issue, Walmart needs to find new avenues for revenues, such as online sales, or start raising their prices and pass along some of the additional cost burdens onto their customers.