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

WMT Stock Annual Balance Sheet. Download in Excel

Walmart Inc. logo

Walmart Inc.

Sector: Consumer Defensive   

Industry: Discount Stores

96.72
 
USD
  
-0.47
  
(-0.49%)
Previous close: 97.195  Open: 96.75  Bid: 96.5  Ask: 96.7
52 week range    
59.44   
   105.30
Mkt Cap: 769,938 M  Avg Vol (90 Days): 22,980,190
Last updated: Sunday 11th May 2025

Stock Rankings

60
MarketXLS Rank
55
Value
70
Technical
55
Quality
How are these ranks calculated?
Financials

WMT Balance Sheet

Annual
Jan-16Jan-17Jan-18Jan-19Jan-20Jan-21Jan-22Jan-23Jan-24Jan-25
Accounts payable38,487 M41,433 M46,092 M47,060 M46,973 M49,141 M55,261 M53,742 M56,812 M58,666 M
Accounts receivable2,500 M2,900 M6,516 M3,400 M
Accrued expenses58,615 M63,008 M68,859 M69,647 M69,549 M67,607 M82,172 M85,595 M85,878 M88,619 M
Accumulated depreciation & depletion-66,787 M-71,782 M-77,479 M-81,493 M-89,820 M-88,370 M-94,809 M-101,610 M-109,049 M-111,624 M
Additional paid in capital1,805 M2,371 M2,648 M2,965 M3,247 M3,646 M4,839 M4,430 M4,544 M5,503 M
Building & improvements97,582 M
Cash and equivalents8,705 M6,867 M6,756 M7,700 M9,500 M17,700 M14,800 M8,600 M9,900 M9,000 M
CashCashEquivalentsAndShortTermInvestments8,705 M6,867 M6,756 M7,700 M9,500 M17,700 M14,800 M8,600 M9,900 M9,000 M
CashEquivalents8,705 M6,867 M6,756 M7,722 M9,500 M17,700 M
Common par317 M305 M295 M288 M284 M282 M276 M808 M805 M802 M
Common stock equity80,546 M77,798 M77,869 M72,496 M74,669 M80,925 M83,253 M76,693 M83,861 M91,013 M
CommonStock317 M305 M295 M288 M284 M282 M276 M808 M805 M802 M
Construction in progress4,741 M
Cost in excess16,695 M17,037 M18,242 M31,181 M31,073 M28,983 M29,014 M28,174 M28,113 M28,792 M
CurrentAccruedExpenses19,607 M20,654 M22,122 M22,159 M22,296 M14,896 M26,060 M31,126 M28,759 M29,345 M
CurrentCapitalLeaseObligation551 M565 M667 M729 M2,304 M1,957 M1,994 M2,040 M2,212 M2,299 M
CurrentDeferredRevenue744 M743 M730 M2,310 M
CurrentDeferredTaxesAssets7,202 M7,359 M4,096 M4,027 M8,186 M8,242 M8,110 M
CurrentDeferredTaxesLiabilities9,055 M10,127 M6,048 M8,527 M12,476 M14,851 M13,554 M
Deferred revenues2,310 M
Float term debt44,030 M42,018 M36,825 M50,203 M64,192 M41,194 M52,116 M52,320 M54,784 M52,149 M
GoodwillAndOtherIntangibleAssets16,695 M17,037 M18,242 M31,181 M31,073 M28,983 M29,014 M28,174 M28,113 M28,792 M
Gross fixed assets (Plant Property & Equipment)188,054 M191,129 M197,857 M192,888 M216,869 M198,218 M207,433 M220,844 M239,387 M251,328 M
IncomeTaxPayable521 M921 M645 M428 M280 M242 M851 M727 M307 M608 M
Intangibles5,800 M5,200 M4,900 M4,800 M
InterestPayable-2,467 M-2,267 M-2,178 M-2,129 M-2,410 M-2,194 M-1,836 M
Inventories44,469 M43,046 M43,783 M44,269 M44,435 M44,949 M56,511 M56,576 M54,892 M56,435 M
Invested capital162,790 M155,831 M144,739 M166,219 M182,575 M180,069 M170,233 M163,662 M174,777 M176,563 M
Land & improvements19,308 M
Leases11,096 M11,637 M12,703 M7,078 M4,417 M4,005 M4,351 M4,919 M5,855 M6,112 M
LineOfCredit4,500 M3,600 M400 M400 M1,600 M1,800 M1,700 M
LongTermCapitalLeaseObligation5,816 M6,003 M6,780 M6,683 M20,478 M16,756 M17,252 M17,671 M18,652 M18,748 M
LongTermDebtAndCapitalLeaseObligation44,030 M42,018 M36,825 M50,203 M48,021 M57,950 M52,116 M52,320 M54,784 M52,149 M
Machinery furniture & equipment58,940 M
Minority interest3,065 M2,737 M2,953 M7,138 M6,883 M6,606 M8,638 M7,298 M6,710 M6,679 M
Net fixed assets (net PP&E)121,267 M119,347 M120,378 M111,395 M127,049 M109,848 M112,624 M119,234 M130,338 M139,704 M
NetOtherUnrealizedGainLoss-3,516 M
Non-current deferred income taxes7,321 M9,344 M8,354 M11,981 M12,961 M14,370 M13,474 M14,688 M14,629 M14,398 M
NonCurrentDeferredLiabilities7,321 M9,344 M8,354 M11,981 M12,961 M14,370 M13,474 M14,688 M14,629 M14,398 M
NonCurrentDeferredTaxesAssets8,658 M8,853 M5,939 M6,475 M16,774 M17,024 M17,652 M
Other current assets607 M1,050 M1,010 M1,305 M1,817 M3,135 M3,245 M
Other equity adjustments-11,597 M-14,232 M-10,181 M-11,542 M-12,805 M-11,766 M
Other fixed assets176,958 M179,492 M185,154 M104,317 M122,632 M17,647 M108,273 M114,315 M124,483 M133,592 M
Other non-current assets6,131 M9,921 M11,798 M14,822 M16,567 M23,598 M22,152 M20,134 M17,071 M12,869 M
Other non-current liabilities-5,169 M-5,560 M-5,682 M2,949 M
Other receivable5,624 M5,835 M5,614 M6,283 M6,284 M6,516 M8,280 M7,933 M8,796 M9,975 M
OtherCurrentBorrowings2,708 M1,099 M5,257 M5,200 M600 M3,339 M400 M400 M900 M3,100 M
OtherCurrentLiabilities-4,751 M-5,169 M-5,560 M6,504 M6,093 M12,734 M7,908 M8,287 M8,590 M7,897 M
OtherInventories44,469 M43,046 M43,783 M44,269 M44,435 M44,949 M56,511 M56,576 M54,892 M56,435 M
OtherPayable11,477 M10,619 M10,051 M10,344 M10,705 M10,264 M13,106 M
Payables39,008 M42,354 M46,737 M47,488 M47,253 M52,711 M56,112 M54,469 M57,119 M59,274 M
Prepaid expenses1,441 M1,941 M3,511 M3,623 M1,622 M20,861 M1,519 M2,521 M3,322 M4,011 M
Restricted cash362 M265 M300 M34 M
Retained earnings78,424 M75,122 M74,926 M69,243 M71,138 M88,763 M78,138 M71,455 M78,512 M84,708 M
Short term debt5,453 M3,355 M8,995 M7,076 M5,962 M3,339 M3,203 M4,591 M4,347 M5,698 M
Total assets204,332 M203,994 M210,082 M219,273 M236,530 M252,455 M244,860 M243,197 M252,399 M260,823 M
Total current assets60,239 M57,689 M59,664 M61,875 M61,841 M90,026 M81,070 M75,655 M76,877 M79,458 M
Total current liabilities59,868 M61,759 M72,961 M77,452 M77,815 M92,621 M87,379 M92,198 M92,415 M96,584 M
Total equity80,546 M77,798 M77,869 M72,496 M74,669 M80,925 M83,253 M76,693 M83,861 M91,013 M
Total liabilities111,219 M113,121 M124,000 M139,636 M154,968 M164,941 M152,959 M159,234 M161,850 M163,163 M
Total non-current assets144,093 M146,305 M150,418 M157,398 M174,689 M162,429 M163,790 M167,542 M175,522 M181,365 M
Total non-current liabilities51,351 M51,362 M45,179 M62,184 M77,153 M72,320 M65,590 M67,008 M69,413 M66,547 M
TotalEquityGrossMinority83,611 M80,535 M80,822 M79,634 M81,552 M87,531 M91,891 M83,754 M90,349 M97,421 M
TotalEquityGrossMinorityInterest83,611 M80,535 M80,822 M79,634 M81,552 M87,531 M91,891 M83,754 M90,349 M97,421 M
TotalLiabilitiesAndTotalEquityGrossMinorityInterest204,332 M203,994 M210,082 M219,273 M236,530 M252,455 M244,860 M243,197 M252,399 M260,823 M
TotalNonCurrentLiabilitiesNetMinorityInteres51,351 M51,362 M45,179 M62,184 M77,153 M72,320 M65,590 M67,008 M69,413 M66,547 M
TotalTaxPayable521 M921 M645 M428 M280 M3,570 M851 M727 M307 M608 M
Treasury stock4,112 M8,298 M8,296 M7,410 M5,717 M2,625 M9,787 M
Working capital371 M-4,070 M-13,297 M-15,577 M-15,974 M-2,595 M-6,309 M-16,543 M-15,538 M-17,126 M
debtc6,004 M3,920 M9,662 M7,805 M8,266 M5,272 M5,197 M6,631 M6,559 M7,997 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 provides all the tools I need for in-depth stock analysis. It's user-friendly and constantly improving. A must-have for serious investors.

John D.

Financial Analyst

I have been using MarketXLS for the last 6+ years and they really enhanced the product every year and now in the journey of bringing in AI...

Kirubakaran K.

Investment Professional

MarketXLS is a powerful tool for financial modeling. It integrates seamlessly with Excel and provides real-time data.

David L.

Financial Analyst

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

Lloyd L.

Professional Trader