Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS

WMT Stock Forecast, Price Targets, Chart, Dividends & Analysis

Walmart Inc. logo

Walmart Inc.

Sector: Consumer Defensive   

Industry: Discount Stores

87.18
 
USD
  
0.58
  
(0.67%)
Previous close: 86.6  Open: 86.6  Bid: 87.13  Ask: 87.19
52 week range    
49.85   
   88.29
Mkt Cap: 696,113 M  Avg Vol (90 Days): 14,884,819
Peers   
TGT / 
COST / 
DG / 
M / 
KSS / 
AMZN / 
EBAY / 
DLTR / 
Last updated: Thursday 21st November 2024

Stock Rankings

74
MarketXLS Rank
65
Value
92
Technical
65
Quality
How are these ranks calculated?
Ad slot not ready
Search for a stock

Metrics

Peers

StockDividendMarket Cap (B)PEPrice ($)

AMZN

2,151 B43.42202.88

COST

0.0051412 B54.74928.08

DG

0.031117 B11.7873.27

DLTR

14 B-1363.18

EBAY

0.017629 B15.4560.82

KSS

0.11112 B7.0616.31

M

0.04554 B23.714.56

PSMT

0.01323 B18.8487.7

TGT

0.029472 B15.72121.72
Financials

WMT Income Statement

Annual
Jan-15Jan-16Jan-17Jan-18Jan-19Jan-20Jan-21Jan-22Jan-23Jan-24
Amortization of intangibles18,102 M16,695 M17,037 M18,242 M31,181 M31,073 M29,014 M28,174 M28,113 M
Basic EPS from continuing operations5.014.584.43.292.285.221.591.631.431.92
Basic EPS total5.074.584.43.292.285.221.591.631.431.92
Basic weighted shares outstanding3,230 M3,207 M3,101 M2,995 M2,929 M2,850 M8,493 M8,376 M8,172 M8,077 M
BasicDiscontinuousOperations0.06
Cost of sales365,086 M360,984 M361,256 M373,396 M385,301 M394,605 M420,315 M429,000 M463,721 M490,142 M
Depreciation9,173 M9,454 M10,080 M10,529 M10,678 M10,987 M10,658 M10,945 M11,853 M
Depreciation unreconciled463,721 M
DepreciationAndAmortization9,173 M9,454 M10,080 M10,529 M10,678 M10,987 M10,658 M10,945 M11,853 M
Diluted EPS total5.054.574.383.282.265.191.581.621.421.91
Diluted normalized net income/share4.994.574.383.282.265.191.581.621.421.91
Diluted weighted shares outstanding3,243 M3,217 M3,112 M3,010 M2,945 M2,868 M8,541 M8,415 M8,202 M8,108 M
DilutedDiscontinuousOperations0.06
Dividends paid per share1.921.962.02.042.082.120.720.730.752.28
ExciseTaxes365,086 M463,721 M
GainOnSaleOfBusiness262 M-4,850 M-15 M-433 M
GainOnSaleOfSecurity-3,516 M
GeneralAndAdministrativeExpense93,418 M97,041 M463,109 M106,510 M107,147 M108,791 M117,812 M127,140 M621,113 M
Gross operating profit120,565 M121,146 M124,617 M126,947 M129,104 M129,359 M138,836 M143,754 M147,568 M157,983 M
ImpairmentOfCapitalAssets1,400 M
Income before tax24,799 M21,638 M20,497 M15,123 M11,460 M20,116 M20,564 M18,696 M17,016 M21,848 M
Income restructuring and M&A360,984 M1,201 M
Income taxes15,970 M6,558 M6,204 M4,600 M4,281 M4,915 M6,858 M4,756 M5,724 M5,578 M
InsuranceAndClaims490,142 M
Interest income113 M81 M100 M152 M217 M189 M121 M158 M254 M546 M
InterestExpenseNonOperating2,461 M2,548 M2,367 M2,330 M2,346 M1,925 M-2,315 M1,994 M2,128 M2,683 M
InterestExpenseOperating429,000 M
MarketingExpense385,301 M
MinorityInterests-736 M-386 M-650 M-661 M-509 M-320 M-196 M-267 M388 M-759 M
MiscOtherSpecialCharges3,422 M3,516 M4,556 M1,446 M-4,292 M5,996 M4,128 M-418 M3,870 M2,461 M
Net income from total operations16,363 M14,694 M13,643 M9,862 M6,670 M14,881 M13,510 M13,673 M11,680 M15,511 M
NetIncomeCommonStockholders8,378 M14,694 M13,643 M9,862 M6,670 M15,555 M13,510 M13,673 M11,680 M15,511 M
NetIncomeContinuousOperations16,363 M14,694 M13,643 M9,862 M6,670 M14,881 M13,510 M13,673 M11,292 M16,270 M
NetIncomeDiscontinuousOperations285 M
NetNonOperatingInterestIncomeExpense-2,348 M-2,467 M-2,267 M-2,178 M-2,129 M-1,736 M-2,194 M-1,196 M1,874 M2,137 M
NonRecurringOperationExpense361,256 M
Operating income27,147 M24,105 M22,764 M20,437 M21,957 M20,568 M22,548 M25,942 M20,428 M27,012 M
Operating income before depreciation (EBITDA)36,433 M33,640 M32,944 M27,982 M13,806 M22,041 M34,031 M31,348 M30,089 M36,384 M
OperatingExpense93,418 M97,041 M463,109 M479,906 M492,448 M108,791 M-116,288 M117,812 M127,140 M621,113 M
Other income net-3,422 M-3,516 M-4,556 M-1,446 M4,292 M-5,996 M-210 M418 M-1,538 M-3,027 M
Other special charges394,605 M
OtherGainLossFromDispositionOfDiscontinuedOperations285 M
OtherGandA93,418 M97,041 M463,109 M106,510 M107,147 M108,791 M117,812 M127,140 M621,113 M
OtherImpairmentOfCapitalAssets700 M
OtherOperatingExpenses-174 M-119 M-145 M-122 M-203 M-66 M-75 M-357 M-102 M
PromotionAndAdvertising2,400 M2,500 M2,900 M3,100 M3,500 M3,700 M3,900 M4,100 M4,400 M
RentAndLandingFees2,800 M2,500 M361,256 M2,900 M3,000 M
RestructringAndMnAIncome360,984 M1,201 M
Revenue per share18,102 M16,695 M17,037 M18,242 M31,181 M31,553 M29,579 M28,770 M28,868 M
SalariesAndWages-173 M-151 M-212 M-150 M-181 M-200 M-300 M-400 M-500 M
SecuritiesAmortization373,396 M
Selling Gen & administrative expense93,418 M97,041 M463,109 M106,510 M492,448 M108,791 M-116,288 M117,812 M127,140 M621,113 M
SellingAndMarketingExpense2,400 M2,500 M2,900 M3,100 M385,301 M3,700 M3,900 M4,100 M4,400 M
Special income/charges-360,984 M-361,256 M-2,601 M-394,605 M
Total Income available for interest expense (EBIT)27,260 M24,186 M22,864 M17,453 M13,806 M22,041 M22,879 M20,690 M19,144 M24,531 M
Total common shares outstanding3,226 M3,144 M3,033 M2,951 M2,870 M2,832 M8,451 M8,255 M8,087 M8,058 M
Total net income16,363 M14,694 M13,643 M9,862 M6,670 M14,881 M13,510 M13,673 M11,680 M15,511 M
Total ordinary shares8,038 M8,038 M8,038 M8,038 M8,038 M8,038 M8,038 M8,038 M8,038 M8,038 M
Total revenues482,229 M478,614 M481,317 M495,761 M510,329 M519,926 M559,151 M567,762 M605,881 M642,637 M
TotalExpenses458,504 M458,025 M824,365 M853,302 M877,749 M503,396 M956,918 M546,812 M590,861 M621,113 M
TotalRevenue485,651 M482,130 M485,873 M500,343 M514,405 M523,964 M559,151 M572,754 M611,289 M648,125 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.

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