Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS
Walmart Inc. logo

Walmart Inc.

Sector: Consumer Defensive   

Industry: Discount Stores

58.61
 
USD
  
-1.01
  
(-1.69%)
Optionable: Yes  Market Cap: 160,430 M  90-day average vol: 23,550,452

Previous close: 59.62  Open: 59.45  Bid: 58.69  Ask: 58.77
52 week range    
45.36   
   60.45
Peers   
TGT / 
COST / 
DG / 
M / 
KSS / 
AMZN / 
EBAY / 
DLTR / 
Last updated: Friday 1st March 2024
64
MarketXLS Rank
60
Value
69
Technical
63
Quality

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today
Search for a stock

🎉 Exciting news! 🎉

You are invited to join our Discord Channel.

Interact, learn, and grow with experts in the markets!

Join our Discord

Metrics

Peers

StockDividendMarket Cap (B)PEPrice ($)

AMZN

1,534 B58.53158.71

COST

0.0061225 B26.4515.89

DG

0.008348 B20.4200.59

DLTR

30 B22.2135.72

EBAY

0.012338 B3.358.7

KSS

0.01688 B9.359.66

M

0.02358 B9.625.58

PSMT

0.01022 B21.968.81

TGT

0.0168105 B16.2211.29
Financials

WMT Income Statement

Annual
Jan-14Jan-15Jan-16Jan-17Jan-18Jan-19Jan-20Jan-21Jan-22Jan-23
Amortization of intangibles19,510 M18,102 M16,695 M17,037 M18,242 M31,181 M31,073 M28,174 M
Basic EPS from continuing operations4.875.014.584.43.292.285.224.774.94.29
Basic EPS total4.95.074.584.43.292.285.224.774.94.29
Basic weighted shares outstanding3,269 M3,230 M3,207 M3,101 M2,995 M2,929 M2,850 M2,831 M2,792 M2,724 M
BasicDiscontinuousOperations0.030.06
Cost of sales358,069 M365,086 M360,984 M361,256 M373,396 M385,301 M394,605 M420,315 M429,000 M463,721 M
Depreciation8,870 M9,173 M9,454 M10,080 M10,529 M10,678 M10,987 M10,945 M
DepreciationAndAmortization8,870 M9,173 M9,454 M10,080 M10,529 M10,678 M10,987 M10,945 M
Diluted EPS total4.885.054.574.383.282.265.194.754.874.27
Diluted normalized net income/share4.854.994.574.383.282.265.194.754.874.27
Diluted weighted shares outstanding3,283 M3,243 M3,217 M3,112 M3,010 M2,945 M2,868 M2,847 M2,805 M2,734 M
DilutedDiscontinuousOperations0.030.06
Dividends paid per share1.881.921.962.02.042.082.122.162.22.24
ExciseTaxes365,086 M
GainOnSaleOfBusiness262 M-4,850 M-15 M
GainOnSaleOfSecurity-3,516 M
GeneralAndAdministrativeExpense91,353 M93,418 M97,041 M463,109 M106,510 M107,147 M108,791 M127,140 M
Gross operating profit118,225 M120,565 M121,146 M124,617 M126,947 M129,104 M129,359 M138,836 M143,754 M147,568 M
ImpairmentOfCapitalAssets1,400 M
Income before tax24,656 M24,799 M21,638 M20,497 M15,123 M11,460 M20,116 M20,564 M18,696 M17,016 M
Income restructuring and M&A-100 M360,984 M1,201 M
Income taxes8,105 M15,970 M6,558 M6,204 M4,600 M4,281 M4,915 M6,858 M4,756 M5,724 M
Interest income119 M113 M81 M100 M152 M217 M189 M121 M158 M254 M
InterestExpenseNonOperating2,335 M2,461 M2,548 M2,367 M2,330 M2,346 M1,925 M-2,315 M-1,994 M1,446 M
MarketingExpense358,069 M385,301 M
MinorityInterests-673 M-736 M-386 M-650 M-661 M-509 M-320 M-196 M-267 M388 M
MiscOtherSpecialCharges3,218 M3,422 M3,516 M4,556 M1,446 M-4,292 M5,996 M4,128 M-418 M3,870 M
Net income from total operations16,022 M16,363 M14,694 M13,643 M9,862 M6,670 M14,881 M13,510 M13,673 M11,680 M
NetIncomeCommonStockholders16,022 M8,378 M14,694 M13,643 M9,862 M6,670 M15,555 M13,510 M13,673 M12,362 M
NetIncomeContinuousOperations16,022 M16,363 M14,694 M13,643 M9,862 M6,670 M14,881 M13,510 M13,673 M11,680 M
NetIncomeDiscontinuousOperations144 M285 M
NetNonOperatingInterestIncomeExpense-2,216 M-2,348 M-2,467 M-2,267 M-2,178 M-2,129 M-1,736 M-2,194 M-1,836 M-1,192 M
NonRecurringOperationExpense361,256 M
Operating income26,872 M27,147 M24,105 M22,764 M20,437 M21,957 M20,568 M22,548 M25,942 M20,428 M
Operating income before depreciation (EBITDA)35,861 M36,433 M33,640 M32,944 M27,982 M13,806 M22,041 M22,201 M20,050 M18,462 M
OperatingExpense449,422 M93,418 M97,041 M463,109 M479,906 M492,448 M108,791 M-116,288 M117,812 M127,140 M
Other income net-3,218 M-3,422 M-3,516 M-4,556 M-1,446 M4,292 M-5,996 M-210 M5,410 M459,851 M
Other special charges394,605 M-2,410 M
OtherGainLossFromDispositionOfDiscontinuedOperations144 M285 M
OtherGandA91,353 M93,418 M97,041 M463,109 M106,510 M107,147 M108,791 M127,140 M
OtherImpairmentOfCapitalAssets700 M
OtherOperatingExpenses-133 M-174 M-119 M-145 M-122 M-203 M-66 M-357 M
OtherWriteDown358,069 M
PromotionAndAdvertising2,400 M2,400 M2,500 M2,900 M3,100 M3,500 M3,700 M4,100 M
RentAndLandingFees2,800 M2,800 M2,500 M361,256 M2,900 M3,000 M
RestructringAndMnAIncome-100 M360,984 M1,201 M
Revenue per share19,510 M18,102 M16,695 M17,037 M18,242 M31,181 M31,553 M28,770 M
SalariesAndWages-145 M-173 M-151 M-212 M-150 M-181 M-200 M-400 M
SecuritiesAmortization373,396 M
Selling Gen & administrative expense449,422 M93,418 M97,041 M463,109 M106,510 M492,448 M108,791 M-116,288 M117,812 M127,140 M
SellingAndMarketingExpense358,069 M2,400 M2,500 M2,900 M3,100 M385,301 M3,700 M4,100 M
Special income/charges100 M-360,984 M-361,256 M-2,601 M-394,605 M-2,410 M
Total Income available for interest expense (EBIT)26,991 M27,260 M24,186 M22,864 M17,453 M13,806 M22,041 M22,201 M20,050 M18,462 M
Total common shares outstanding3,229 M3,226 M3,144 M3,033 M2,951 M2,870 M2,832 M2,817 M2,752 M2,696 M
Total net income16,022 M16,363 M14,694 M13,643 M9,862 M6,670 M14,881 M13,510 M13,673 M11,680 M
Total ordinary shares2,692 M2,692 M2,692 M2,692 M2,692 M2,692 M2,692 M2,692 M2,692 M2,692 M
Total revenues473,076 M482,229 M478,614 M481,317 M495,761 M510,329 M519,926 M559,151 M572,754 M605,881 M
TotalExpenses807,491 M458,504 M458,025 M824,365 M853,302 M877,749 M503,396 M956,918 M546,812 M590,861 M
TotalRevenue476,294 M485,651 M482,130 M485,873 M500,343 M514,405 M523,964 M559,151 M572,754 M611,289 M
Call: 1-877-778-8358
Ankur Mohan MarketXLS
Welcome! I'm Ankur, the founder and CEO of MarketXLS. With more than ten years of experience, I have assisted over 2,500 customers in developing personalized investment research strategies and monitoring systems using Excel.

I invite you to book a demo with me or my team to save time, enhance your investment research, and streamline your workflows.
Implement “your own” investment strategies in Excel with thousands of MarketXLS functions and templates.

We respect your privacy and will never share your email.
MarketXLS is a complete Excel stock solution

Kevin Hsu

StockKevin.com

I have used lots of stock and option information services. This is the only one which gives me what I need inside Excel

Lloyd Lenase

Option Day Trader

MarketXLS is a data junkie’s dream. It gives me the flexibility to mine for hidden treasures.

Dave

Swing trader since 2011

I like to access historical closing prices on a particular date. That makes tracking performance easy.

Patrick Cusatis, Ph.D., CFA

Associate Professor of Finance - Penn State University