project analy1

profileshanta75
WALMARTFINANCES.xlsx

asreported

Powered by Clearbit
Walmart Inc (NYS: WMT)
Exchange rate used is that of the Year End reported date
As Reported Annual Balance Sheet
Report Date 01/31/2021 01/31/2020 01/31/2019 01/31/2018 01/31/2017
Currency USD USD USD USD USD
Audit Status Not Qualified Not Qualified Not Available Not Qualified Not Qualified
Consolidated Yes Yes Yes Yes Yes
Scale Thousands Thousands Thousands Thousands Thousands
Cash & cash equivalents 17741000 9465000 7722000 6756000 6867000
Receivables, net 6516000 6284000 6283000 5614000 5835000
Inventories 44949000 44435000 44269000 43783000 43046000
Prepaid expenses & other current assets 20861000 1622000 3623000 3511000 1941000
Total current assets 90067000 61806000 61897000 59664000 57689000
Land 19308000 24619000 24526000 25298000 24801000
Buildings & improvements 97582000 105674000 101006000 101155000 98547000
Fixtures & equipment 56639000 58607000 54488000 52695000 48998000
Transportation equipment 2301000 2377000 2316000 2387000 2845000
Construction in progress 4741000 3751000 3474000 3619000 4301000
Property & equipment, gross 180571000 195028000 185810000 185154000 179492000
Less: accumulated depreciation 88370000 89820000 81493000 77479000 71782000
Property & equipment, net 92201000 105208000 104317000 107675000 107710000
Operating lease right-of-use assets 13642000 17424000 - - -
Finance lease right-of-use assets, net 4005000 4417000 - - -
Property under capital lease & financing obligations - - 12760000 12703000 11637000
Less: accumulated amortization - - 5682000 5560000 5169000
Property under capital lease & financing obligations, net - - 7078000 7143000 6468000
Goodwill 28983000 31073000 31181000 18242000 17037000
Other long-term assets 23598000 16567000 14822000 - -
Other assets & deferred charges - - - 11798000 9921000
Total assets 252496000 236495000 219295000 204522000 198825000
Short-term borrowings 224000 575000 5225000 5257000 1099000
Accounts payable 49141000 46973000 47060000 46092000 41433000
Liabilities for sale 12734000 - - - -
Accrued wages & benefits 7654000 6093000 6504000 6998000 6105000
Self-insurance 4698000 4469000 3979000 3737000 3922000
Accrued non-income taxes 3328000 3039000 2979000 3073000 2816000
Deferred gift card revenue 2310000 1990000 1932000 2017000 -
Other accrued liabilities 7242000 6705000 6765000 6297000 7811000
Accrued liabilities 37966000 22296000 22159000 22122000 20654000
Accrued income taxes 242000 280000 428000 645000 921000
Operating lease obligations due within one year 1466000 1793000 - - -
Long-term debt due within one year 3115000 5362000 1876000 3738000 2256000
Finance lease obligations due within one year 491000 511000 - - -
Capital lease & financing obligations due within one year - - 729000 667000 565000
Total current liabilities 92645000 77790000 77477000 78521000 66928000
Unsecured debt 44306000 49180000 45661000 33897000 38132000
Other debt 3000 -104000 -265000 -114000 139000
Total long-term debt 44309000 49076000 45396000 33783000 38271000
Less: amounts due within one year 3115000 5362000 1876000 3738000 2256000
Long-term debt 41194000 43714000 43520000 30045000 36015000
Long-term operating lease obligations 12909000 16171000 - - -
Long-term finance lease obligations 3847000 4307000 - - -
Long-term capital lease & financing obligations - - 6683000 6780000 6003000
Deferred income taxes & other liabilities 14370000 12961000 11981000 8354000 9344000
Common stock 282000 284000 288000 295000 305000
Capital in excess of par value 3646000 3247000 2965000 2648000 2371000
Retained earnings (accumulated deficit) 88763000 83943000 80785000 85107000 89354000
Currency translation & other -10772000 -11827000 -12085000 -12136000 -14362000
Net investment hedges 1296000 1517000 1395000 1030000 1435000
Unrealized gain on available-for-sale securities - - - 1646000 -
Cash flow hedges -304000 -539000 -140000 122000 -315000
Minimum pension liability -1986000 -1956000 -712000 -843000 -990000
Accumulated other comprehensive income (loss) -11766000 -12805000 -11542000 -10181000 -14232000
Total Walmart Inc. shareholders' equity (deficit) 80925000 74669000 72496000 77869000 77798000
Noncontrolling interest 6606000 6883000 7138000 2953000 -
Nonredeemable noncontrolling interest - - - - 2737000
Total equity (deficit) 87531000 81552000 79634000 80822000 80535000