Walmart Financial Statement and Financial Ratios Analysis

Walmart 2022 - Brief Company Summary

Walmart is a retail store (Walmart Stores) and wholesale outlet (Sam’s Club).  The company generates revenues through three main business segments, which are Walmart U.S., Walmart International, and Sam’s Club.  Specifically, Walmart operates supercenters, supermarkets, warehouse clubs, and eCommerce websites.  The main revenue generators from Walmart would include grocery products, including dry grocery products, deli and bakery, frozen foods, and alcoholic and nonalcoholic beverages.  In addition, secondary revenue generators are gasoline stations and tobacco sales.

From a financial perspective, as of February 2022, Walmart’s market capitalization is $382.7 billion.  The organization’s beta is .5.  A beta below 1.0 indicates that the company's stock is less risky as compared to the overall market.  Walmart’s current stock price is $137.99.  The organization’s current dividend yield is approximately 11.62%.  Finally, important competitors for the organization would be Target as well as Amazon.com (2/22).

Walmart Financial Report Sources

"Walmart 2021 Financial Statements and Financial Ratios: Defined, Discussed, and Analyzed for 5 Years” was written by Paul Borosky, MBA., doctoral candidate and owner of Quality Business Plan.  In this summarized book, the author researched Walmart's 10k, Walmart's 2017 10k annual report, Walmart's 2021 10k annual report, Walmart's 2020 10k annual report, and Walmart's 2019 10k annual report as the basis for information gathering.  Once all Walmart's 10k annual statements were collected, the author then inserted Walmart's income statement information and Walmart balance sheet information into a customized financial template. 

 

 

Section 1: Walmart Income Statement Analyzed

In this section, I walk through a broad definition of what an income statement is and why it is important.  From this, I then discuss and define income statement line items, such as revenues, gross profits, etc. in detail.  After each line item is defined and discussed, I finally offer a summary analysis of Walmart's important income statement line item trends from 2017 to 2021, in most cases.

Revenue Growth:

Walmart’s revenues for the last five years have increased steadily.  On average, revenue growth over this time frame was 3.1%.  For a multinational organization, this would be considered about average.  However, the impressive aspect of its revenue growth would be its consistency in positive growth over this time frame.

Analyst Grade: A

Walmart Income Statement 2021
Column1	2021	2020	2019	2018	2017
Revenues	559,151	523,964	514,405	506,343	485,873
COGS	420,315	394,605	385,301	373,396	361,256
Gross Profit	138,836	129,359	129,104	132,947	124,617
SG&A	116,288	108,791	107,147	106,510	101,853
Depreciation	11,152	10,987	10,678	10,529	10,080
R & D	-	-	-	-	-
Other		-	-	-	-
Operating Expenses	536,603	503,396	492,448	479,906	463,109
EBIT	24,524	22,978	24,086	28,615	25,031
Other Income		-	-	-	-
Interest Expense	1,976	2,410	2,129	2,178	2,267
EBT	22,548	20,568	21,957	26,437	22,764
Taxes	6,858	4,915	4,281	4,600	6,204
Net Income	15,690	15,201	6,670	9,862	13,643
Tax Rate	30.4%	23.9%	19.5%	17.4%	27.3%

 

Walmart Balance Sheet Analyzed

For Walmart's balance sheet, I again go through each important line item from the balance sheet.  In reviewing each line item, I will define the balance sheet line item, such as cash, property, plant and equipment, and liabilities between 2017 to 2021.  Next, I then offer an analysis of Walmart's important balance sheet line item.

Cash:

Walmart’s cash position between 2018 and 2020 was approximately 1.3 to 1.8% of sales.  However, in 2021, the organization’s cash position as compared to sales increased significantly to 3.2% of sales.  This increase may have been due to the organization’s concerns about the Covid-19 pandemic and their desire to have an increased cash buffer.  Further, this hypothesis may be supported because, in 2022, the organization’s cash position as compared to sales decreased to 2.6% of sales.  If this trend continues, then investors should expect a cash position in the future within the range of 1.3% to about 1.8%.

Analyst Grade: A

Walmart Summary Balance Sheet 2021
Column1	2021	2020	2019	2018	2017
Cash	17,741	9,465	7,722	6,756	6,867
Short Term Investment	-	-	-	-	-
Account Receivable	6,516	6,284	6,283	5,614	5,835
Inventory	44,949	44,435	44,269	43,783	43,046
Other	-		-	-	-
Current Assets	90,067	61,806	61,897	59,664	57,689
Net PPE	92,201	105,208	104,317	107,675	107,710
Goodwill	28,983	31,073	31,181	18,242	17,037
Other	-	-	-	-	-
Total Assets	252,496	236,495	219,295	204,522	198,825
Accounts Payable	49,141	46,973	47,060	46,092	41,433
Accrued Expense	37,966	22,296	22,159	22,122	20,654
Accrued Taxes	242	280	428	645	921
Notes Payable	3,115	5,362	5,225	5,257	1,099
LT Debt - Current	491	511	729	667	2,256
Other		-	-	-	-
Total Current Liabilities	92,645	77,790	77,477	78,521	66,928
LT Debt	41,194	43,714	50,203	36,825	42,018
Other		-	-	-	-
Total Liabilities	164,965	154,943	50,203	36,825	42,018
Common Stock	3,928	3,531	3,253	2,943	2,676
Treasury	-	-	-	-	-
Retained Earnings	88,763	83,943	80,785	85,107	89,354
Other	-	-	-	-	-
Total Equity	87,531	81,552	79,634	80,822	80,535
Total Equity & Liability	252,496	236,495	219,295	204,522	198,825

 

 

Walmart's Financial Ratio Summary

For this section, I have chosen several different financial ratios to review for Walmart from 2017 to 2021.  In reviewing each of Walmart's financial ratios, I first start with defining the financial ratio.  Next, I supply the financial formula for calculating the specific ratio.  Finally, I offer a brief analysis of Walmart's Important Financial ratios. 

Walmart's Current Ratio: 

Walmart’s current ratio has increased from .79 in 2020 to .93 and 2022.  The increase in the organization’s current ratio during a pandemic is a smart move, in my opinion.  The increased current ratio shows that the firm may be increasing its cash position to ensure liquidity for the short term.

Analyst Grade: A

Walmart's Total Asset Turnover: 

Walmart’s total asset turnover ended 2018 at 2.48.  In the next four years, the organization would decrease its total asset turnover ending 2021 at 2.21.  Fortunately, the organization would improve its asset utilization and end 2022 at a 2.3 total asset turnover.  If this trend continues, then it may indicate the company has achieved its cost-cutting objectives over the last several years and is ready to move forward with growth.

Analyst Grade: A-