Financial Ratios Walmart Inc.

Equities

WMT

US9311421039

Food Retail & Distribution

Market Closed - Nyse Other stock markets 13:00:01 2024-11-29 EST			5-day change	1st Jan Change
92.50 ^USD	+0.67%		+2.28%	+76.02%

11-30	Black Friday data shows US shoppers spent $10.8 billion online	RE
11-29	'Robust' consumer should power holiday sales, market expert says	RE

22d98e012880f533fa6d7b19eb95.-3KjtJ9dh8a2_75H6NySA-2lB6vWgd85_57utCtJBNg.uRDz2P0v3ZnEsfl_0abcS7L_QuCs4qwKvM3e7W56UKK8PtaF3BnS_96Pig

Published financial data: WALMART INC.

Annual

Quarterly

Halfyear

YTD

LTM

Fiscal Period: January	2020	2021	2022	2023	2024
Revenues	524B	559B	573B	611B	648B
Total Revenues	524B	559B	573B	611B	648B
Cost of Goods Sold, Total	395B	420B	429B	464B	490B
Gross Profit	129B	139B	144B	148B	158B
Selling General & Admin Expenses, Total	108B	112B	118B	123B	131B
Other Operating Expenses, Total	108B	112B	118B	123B	131B
Operating Income	21.47B	26.95B	25.94B	24.53B	27.01B
Interest Expense, Total	-2.6B	-2.32B	-1.99B	-2.13B	-2.68B
Interest And Investment Income	189M	121M	158M	454M	546M
Net Interest Expenses	-2.41B	-2.19B	-1.84B	-1.67B	-2.14B
Other Non Operating Income (Expenses)	87M	22M	-127M	-455M	166M
EBT, Excl. Unusual Items	19.14B	24.78B	23.98B	22.4B	25.04B
Restructuring Charges	-900M	-400M	-	-800M	-
Gain (Loss) On Sale Of Investments	1.89B	8.59B	-2.44B	-1.28B	-3.19B
Gain (Loss) On Sale Of Assets	-15M	-8.4B	-433M	-	-
Legal Settlements	-	-	-	-3.3B	-
Other Unusual Items	-	-4B	-2.41B	-	-
EBT, Incl. Unusual Items	20.12B	20.56B	18.7B	17.02B	21.85B
Income Tax Expense	4.92B	6.86B	4.76B	5.72B	5.58B
Earnings From Continuing Operations	15.2B	13.71B	13.94B	11.29B	16.27B
Earnings Of Discontinued Operations	-	-	-	-	-
Net Income to Company	15.2B	13.71B	13.94B	11.29B	16.27B
Minority Interest	-320M	-196M	-267M	388M	-759M
Net Income - (IS)	14.88B	13.51B	13.67B	11.68B	15.51B
Net Income to Common Incl Extra Items	14.88B	13.51B	13.67B	11.68B	15.51B
Net Income to Common Excl. Extra Items	14.88B	13.51B	13.67B	11.68B	15.51B
Per Share Items
Net EPS - Basic	1.74	1.59	1.63	1.43	1.92
Basic EPS - Continuing Operations	1.74	1.59	1.63	1.43	1.92
Basic Weighted Average Shares Outstanding	8.55B	8.49B	8.38B	8.17B	8.08B
Net EPS - Diluted	1.73	1.58	1.62	1.42	1.91
Diluted EPS - Continuing Operations	1.73	1.58	1.62	1.42	1.91
Diluted Weighted Average Shares Outstanding	8.6B	8.54B	8.42B	8.2B	8.11B
Normalized Basic EPS	1.36	1.8	1.76	1.76	1.84
Normalized Diluted EPS	1.35	1.79	1.75	1.75	1.84
Dividend Per Share	0.71	0.72	0.73	0.75	0.76
Payout Ratio	40.64	45.27	44.99	52.35	39.58
American Depositary Receipts Ratio (ADR)	0.06	0.06	0.06	0.06	0.06
Supplemental Items
EBITDA	32.46B	38.1B	36.6B	35.47B	38.86B
EBITA	21.47B	26.95B	25.94B	24.53B	27.01B
EBIT	21.47B	26.95B	25.94B	24.53B	27.01B
EBITDAR	35.82B	41.5B	39.7B	38.68B	42.22B
Total Revenues (As Reported)	524B	559B	573B	611B	648B
Effective Tax Rate - (Ratio)	24.43	33.35	25.44	33.64	25.53
Current Domestic Taxes	3.38B	3.73B	3.96B	2.64B	3.98B
Current Foreign Taxes	1.2B	1.13B	1.55B	2.65B	1.77B
Total Current Taxes	4.59B	4.86B	5.52B	5.29B	5.75B
Deferred Domestic Taxes	698M	2.34B	-630M	727M	-297M
Deferred Foreign Taxes	-369M	-341M	-129M	-297M	126M
Total Deferred Taxes	329M	2B	-759M	430M	-171M
Normalized Net Income	11.65B	15.29B	14.72B	14.39B	14.89B
Interest Capitalized	-	-	-	-	-
Interest on Long-Term Debt	306M	298M	232M	341M	424M
Non-Cash Pension Expense	-	-	-	-	-
Supplemental Operating Expense Items
Advertising Expense	3.7B	3.2B	3.9B	4.1B	4.4B
Selling and Marketing Expenses	3.7B	3.2B	3.9B	4.1B	4.4B
Net Rental Expense, Total	3.36B	3.4B	3.1B	3.2B	3.36B
Imputed Operating Lease Interest Expense	1.06B	921M	809M	914M	1.16B
Imputed Operating Lease Depreciation	2.3B	2.48B	2.29B	2.29B	2.2B
Stock-Based Comp., SG&A Exp. (Total)	854M	1.17B	1.16B	1.58B	2.09B
Total Stock-Based Compensation	854M	1.17B	1.16B	1.58B	2.09B

Fiscal Period: January	2020	2021	2022	2023	2024
Assets
Cash And Equivalents	9.46B	17.74B	14.76B	8.62B	9.87B
Total Cash And Short Term Investments	9.46B	17.74B	14.76B	8.62B	9.87B
Accounts Receivable, Total	6.28B	6.52B	8.28B	7.93B	8.8B
Total Receivables	6.28B	6.52B	8.28B	7.93B	8.8B
Inventory	44.44B	44.95B	56.51B	56.58B	54.89B
Prepaid Expenses	1.62B	1.66B	1.52B	2.52B	3.32B
Deferred Tax Assets Current	-	-	-	-	-
Restricted Cash	-	-	-	-	-
Other Current Assets, Total	-	19.2B	-	-	-
Total Current Assets	61.81B	90.07B	81.07B	75.66B	76.88B
Gross Property Plant And Equipment	217B	198B	207B	221B	239B
Accumulated Depreciation	-90.3B	-88.37B	-94.81B	-102B	-109B
Net Property Plant And Equipment	127B	110B	113B	119B	130B
Long-term Investments	5.99B	14.96B	12.89B	11.17B	8.45B
Goodwill	31.07B	28.98B	29.01B	28.17B	28.11B
Other Intangibles, Total	5.2B	4.9B	4.8B	4.3B	4.1B
Deferred Tax Assets Long-Term	1.91B	1.84B	1.47B	1.5B	1.66B
Other Long-Term Assets, Total	3.46B	1.9B	2.99B	3.16B	2.86B
Total Assets	236B	252B	245B	243B	252B
Liabilities
Accounts Payable, Total	46.97B	49.14B	55.26B	53.74B	56.81B
Accrued Expenses, Total	20.31B	15.68B	23.48B	25.69B	26.1B
Short-term Borrowings	575M	224M	410M	372M	878M
Current Portion of Long-Term Debt	5.36B	3.12B	2.8B	4.19B	3.45B
Current Portion of Leases	2.3B	1.96B	1.99B	2.04B	2.21B
Current Income Taxes Payable	280M	242M	851M	727M	307M
Unearned Revenue Current, Total	1.99B	2.31B	2.56B	2.49B	2.66B
Other Current Liabilities	-	19.98B	21M	2.95B	-
Total Current Liabilities	77.79B	92.64B	87.38B	92.2B	92.42B
Long-Term Debt	44.41B	41.65B	35.96B	36.76B	38.09B
Long-Term Leases	20.48B	16.76B	17.25B	17.67B	18.65B
Pension & Other Post Retirement Benefits	140M	-	-	-	-
Deferred Tax Liability Non Current	6.2B	8.44B	6.92B	7.27B	11.97B
Other Non Current Liabilities	5.92B	5.47B	5.46B	5.31B	700M
Total Liabilities	155B	165B	153B	159B	162B
Common Stock, Total	284M	282M	276M	269M	805M
Additional Paid In Capital	3.25B	3.65B	4.84B	4.97B	4.54B
Retained Earnings	83.94B	88.76B	86.9B	83.14B	89.81B
Comprehensive Income and Other	-12.8B	-11.77B	-8.77B	-11.68B	-11.3B
Total Common Equity	74.67B	80.92B	83.25B	76.69B	83.86B
Minority Interest	6.88B	6.61B	8.64B	7.3B	6.71B
Total Equity	81.55B	87.53B	91.89B	83.99B	90.57B
Total Liabilities And Equity	236B	252B	245B	243B	252B
Supplemental Items
ECS Total Shares Outstanding on Filing Date	8.5B	8.45B	8.26B	8.09B	8.06B
ECS Total Common Shares Outstanding	8.5B	8.46B	8.28B	8.08B	8.05B
Book Value / Share	8.79	9.56	10.05	9.49	10.41
Tangible Book Value	38.4B	47.04B	49.44B	44.22B	51.65B
Tangible Book Value Per Share	4.52	5.56	5.97	5.47	6.41
Total Debt	73.13B	63.7B	58.42B	61.04B	63.28B
Net Debt	63.66B	45.96B	43.66B	52.41B	53.41B
Debt Equivalent Oper. Leases	26.89B	27.22B	24.78B	25.64B	26.87B
Minority Interest, Total (Incl. Fin. Div)	6.88B	6.61B	8.64B	7.3B	6.71B
Account Code - Inventory Valuation	4	4	4	4	4
Land - (BS)	24.62B	19.31B	19.2B	19.32B	19.56B
Buildings, Total	106B	97.58B	100B	105B	112B
Machinery, Total	60.98B	58.94B	62.54B	67.7B	75.14B
Full Time Employees	2.2M	2.3M	2.3M	2.1M	2.1M
Assets under Capital Lease - Gross	-	-	-	-	-
Assets under Capital Lease - Accumulated Depreciation	-	-	-	-	-
Accumulated Allowance for Doubtful Accounts (Supple)	-	-	-	-	-

Fiscal Period: January	2020	2021	2022	2023	2024
Net Income	14.88B	13.51B	13.67B	11.68B	15.51B
Depreciation & Amortization - CF	10.99B	11.15B	10.66B	10.94B	11.85B
Depreciation & Amortization, Total	10.99B	11.15B	10.66B	10.94B	11.85B
(Gain) Loss From Sale Of Asset	15M	8.4B	433M	-	-
(Gain) Loss on Sale of Investments - (CF)	-1.89B	-8.59B	2.44B	1.68B	3.19B
Net Cash From Discontinued Operations	-	-	-	-	-
Other Operating Activities, Total	1.58B	3.63B	3.57B	1.98B	3.23B
Change In Accounts Receivable	154M	-1.09B	-1.8B	240M	-797M
Change In Inventories	-300M	-2.4B	-11.76B	-528M	2.02B
Change In Accounts Payable	-274M	6.97B	5.52B	-1.42B	2.52B
Change In Income Taxes	-93M	-136M	39M	-127M	-468M
Change in Other Net Operating Assets	186M	4.62B	1.4B	4.39B	-1.32B
Cash from Operations	25.26B	36.07B	24.18B	28.84B	35.73B
Capital Expenditure	-10.7B	-10.26B	-13.11B	-16.86B	-20.61B
Sale of Property, Plant, and Equipment	321M	215M	394M	170M	250M
Cash Acquisitions	-56M	-180M	-359M	-740M	-9M
Divestitures	833M	56M	7.94B	-	135M
Investment in Marketable and Equity Securities, Total	-	-	-	-	-
Other Investing Activities, Total	479M	102M	-879M	-295M	-1.06B
Cash from Investing	-9.13B	-10.07B	-6.02B	-17.72B	-21.29B
Short Term Debt Issued, Total	-	-	193M	-	512M
Long-Term Debt Issued, Total	5.49B	-	6.94B	5.04B	4.97B
Total Debt Issued	5.49B	-	7.14B	5.04B	5.48B
Short Term Debt Repaid, Total	-4.66B	-324M	-	-34M	-
Long-Term Debt Repaid, Total	-1.91B	-5.38B	-13.01B	-2.69B	-4.22B
Total Debt Repaid	-6.56B	-5.71B	-13.01B	-2.72B	-4.22B
Repurchase of Common Stock	-5.72B	-2.62B	-9.79B	-9.92B	-2.78B
Common Dividends Paid	-6.05B	-6.12B	-6.15B	-6.11B	-6.14B
Common & Preferred Stock Dividends Paid	-6.05B	-6.12B	-6.15B	-6.11B	-6.14B
Other Financing Activities, Total	-1.46B	-1.67B	-1.02B	-3.32B	-5.76B
Cash from Financing	-14.3B	-16.12B	-22.83B	-17.04B	-13.41B
Foreign Exchange Rate Adjustments	-69M	235M	-140M	-73M	69M
Miscellaneous Cash Flow Adjustments	-	-1.85B	1.85B	-	-
Net Change in Cash	1.76B	8.27B	-2.95B	-5.99B	1.09B
Supplemental Items
Cash Interest Paid	2.46B	2.22B	2.24B	2.05B	2.52B
Cash Income Tax Paid (Refund)	3.62B	5.27B	5.92B	3.31B	5.88B
Levered Free Cash Flow	14.67B	15.27B	14.52B	12.37B	8.85B
Unlevered Free Cash Flow	16.29B	16.71B	15.77B	13.7B	10.53B
Change In Net Working Capital	-1.74B	2.18B	-839M	-2.7B	-303M
Net Debt Issued / Repaid	-1.07B	-5.71B	-5.87B	2.32B	1.26B

Fiscal Period: January	2020	2021	2022	2023	2024
Profitability
Return on Assets	5.89	6.89	6.52	6.28	6.81
Return on Total Capital	9.17	11.01	10.76	10.38	11.3
Return On Equity %	18.86	16.21	15.54	12.84	18.64
Return on Common Equity	20.22	17.37	16.66	14.6	19.32
Margin Analysis
Gross Profit Margin %	24.69	24.83	25.1	24.14	24.38
SG&A Margin	20.59	20.01	20.57	20.13	20.21
EBITDA Margin %	6.19	6.81	6.39	5.8	6
EBITA Margin %	4.1	4.82	4.53	4.01	4.17
EBIT Margin %	4.1	4.82	4.53	4.01	4.17
Income From Continuing Operations Margin %	2.9	2.45	2.43	1.85	2.51
Net Income Margin %	2.84	2.42	2.39	1.91	2.39
Net Avail. For Common Margin %	2.84	2.42	2.39	1.91	2.39
Normalized Net Income Margin	2.22	2.73	2.57	2.35	2.3
Levered Free Cash Flow Margin	2.8	2.73	2.54	2.02	1.37
Unlevered Free Cash Flow Margin	3.11	2.99	2.75	2.24	1.62
Asset Turnover
Asset Turnover	2.3	2.29	2.3	2.5	2.62
Fixed Assets Turnover	4.39	4.72	5.15	5.27	5.19
Receivables Turnover (Average Receivables)	83.39	87.37	77.42	75.41	77.49
Inventory Turnover (Average Inventory)	8.9	9.4	8.46	8.2	8.79
Short Term Liquidity
Current Ratio	0.79	0.97	0.93	0.82	0.83
Quick Ratio	0.2	0.26	0.26	0.18	0.2
Operating Cash Flow to Current Liabilities	0.32	0.39	0.28	0.31	0.39
Days Sales Outstanding (Average Receivables)	4.38	4.19	4.71	4.84	4.71
Days Outstanding Inventory (Average Inventory)	41.02	38.92	43.16	44.51	41.5
Average Days Payable Outstanding	43.47	41.8	43.25	42.89	41.31
Cash Conversion Cycle (Average Days)	1.93	1.31	4.63	6.45	4.91
Long Term Solvency
Total Debt/Equity	89.67	72.78	63.57	72.67	69.86
Total Debt / Total Capital	47.28	42.12	38.87	42.09	41.13
LT Debt/Equity	79.57	66.73	57.91	64.81	62.65
Long-Term Debt / Total Capital	41.95	38.62	35.4	37.53	36.88
Total Liabilities / Total Assets	65.52	65.33	62.47	65.46	64.12
EBIT / Interest Expense	8.26	11.64	13.01	11.53	10.07
EBITDA / Interest Expense	13.78	17.93	19.91	18.18	15.74
(EBITDA - Capex) / Interest Expense	9.66	13.49	13.34	10.25	8.06
Total Debt / EBITDA	2.04	1.53	1.47	1.58	1.5
Net Debt / EBITDA	1.78	1.11	1.1	1.36	1.26
Total Debt / (EBITDA - Capex)	2.91	2.04	2.2	2.8	2.93
Net Debt / (EBITDA - Capex)