Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

AutoSave . Off) Walmart FS - Excel Search Brenda Gutierrez1 BG X File Home Insert Page Layout Formulas Data Review View Help Share Comments &

image text in transcribedimage text in transcribedimage text in transcribed

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed
AutoSave . Off) Walmart FS - Excel Search Brenda Gutierrez1 BG X File Home Insert Page Layout Formulas Data Review View Help Share Comments & Cut v 11 ~ A" A = _ AutoSum Calibri ce Wrap Text General X AY O Paste [A Copy Fill Merge & Center $ ~ % " 00 80 Conditional Format as Cell Insert Delete Format Sort & Find & Analyze Sensitivity Format Painter Formatting > Table Styles Clear Filter ~ Select Data Clipboard Font Alignment Number Styles Cells Editing Analysis Sensitivity A1 X V fx Cover Page - USD ($) B C D E F G H Cover Page - USD ($) 12 Months Ended IN Jan. 31, 2021 Mar. 17, 2021 Jul. 31, 2020 Document Type LO-K 4 Document Annual Report true Document Period End Date Jan. 31, 5 2021 6 Current Fiscal Year End Date --01-31 7 Document Transition Report false 8 Entity File Number 001-06991 9 Entity Registrant Name WALMART INC. 10 Entity Incorporation, State or Country Code DE 11 Entity Tax Identification Number 71-0415188 12 Entity Address, Address Line One 702 S.W. 8th Street 13 Entity Address, Postal Zip Code 72716 14 Entity Address, City or Town Bentonville, 15 Entity Address, State or Province AR 16 City Area Code 479 17 Local Phone Number 273-4000 18 Entity Well-known Seasoned Issuer Yes 19 Entity Voluntary Filers No 20 Entity Current Reporting Status Yes 21 Entity Interactive Data Current Yes 22 Entity Filer Category Large Accelerated Filer 23 Entity Small Business False 24 Entity Emerging Growth Company False 25 Auditor Attestation Flag true 26 Entity Shell Company false 27 Entity Public Float $ 182,886,052,366 28 Entity Common Stock, Shares Outstanding 2,817,071,695 Cover Page Consolidated Statements of Inco Consolidated Statements of Comp | Consolidated Balance Sheets | ( ... +) -+ 100% Type here to search O 9 W ? ~ D ( 1) ENG 9:13 PM 5/3/2021AutoSave . Off) Walmart FS - Excel Search Brenda Gutierrez1 BG X File Home Insert Page Layout Formulas Data Review View Help Share Comments & Cut _ AutoSum Calibri v 11 ~ A" A " = ce Wrap Text General X AY O [ Copy Fill Paste Merge & Center $ ~ % " Conditional Format as Cell Insert Delete Format Sort & Find & Analyze Sensitivity Format Painter Formatting Table Styles Clear Filter ~ Select Data Clipboard Font Alignment Number Styles Cells Editing Analysis Sensitivity A1 X V fx Cover Page - USD ($) A B C D E F G H 22 Entity Filer Category Large Accelerated Filer 23 Entity Small Business False 24 Entity Emerging Growth Company false 25 Auditor Attestation Flag true 26 Entity Shell Company false 27 Entity Public Float $ 182,886,052,366 28 Entity Common Stock, Shares Outstanding 2,817,071,695 Documents Incorporated by Reference Document Parts Into Which Incorporated Portions of the registrant's Proxy Statement for the 29 Annual Meeting of Shareholders to be held June 2, 2021 (the "Proxy Statement") Part III 30 Entity Central Index Key 0000104169 31 Document Fiscal Year Focus 2021 32 Document Fiscal Period Focus =Y 33 Amendment Flag false 34 Common Stock, par value $0.10 per share [ Member] 35 Title of 12(b) Security Common Stock, par value $0.10 per share 36 Trading Symbol WMT 37 Security Exchange Name NYSE 38 1.900% Notes Due 2022 [ Member] 39 Title of 12(b) Security 1.900% Notes Due 2022 40 Trading Symbol WMT22 41 Security Exchange Name NYS 42 2.550% Notes Due 2026 [ Member] 43 Title of 12(b) Security 2.550% Notes Due 2026 44 Trading Symbol WMT26 45 Security Exchange Name NYSE 46 47 48 19 Cover Page Consolidated Statements of Inco Consolidated Statements of Comp | Consolidated Balance Sheets | ( ... +) + 100% W 9:14 PM Type here to search O 9 ?) ~ 0 (1) ENG 5/3/2021AutoSave . Off) Walmart FS - Excel Search Brenda Gutierrez1 BG X File Home Insert Page Layout Formulas Data Review View Help Share Comments & Cut Calibri v 11 ~ A" A " _ AutoSum ce Wrap Text General X AY O Paste [A Copy Fill BIUT Y Av Merge & Center $ ~ % " Conditional Format as Cell Insert Delete Format Sort & Find & Analyze Sensitivity Format Painter Formatting > Table Styles Clear Filter ~ Select Data Clipboard Font Alignment Number Styles Cells Editing Analysis Sensitivity A1 X fx Consolidated Statements of Income - USD ($) shares in Millions, $ in Millions B C D E F G H K L M Consolidated Statements of Income - USD ($) shares in Millions, $ in Millions 12 Months Ended IN Jan. 31, 2021 Jan. 31, 2020 Jan. 31, 2019 3 Revenues: 4 Net sales $ 555,233 $ 519,926 $ 510,329 5 Membership and other income 3,918 4,038 4,076 6 Total revenues 559,151 523,964 514,405 7 Costs and expenses: 8 Cost of sales 420,315 394,605 385,301 9 Operating, selling, general and administrative expenses 116,288 108,791 107,147 10 Operating income 22,548 20,568 21,957 11 Interest: 12 Debt 1,976 2,262 1,975 13 Finance, capital lease and financing obligations 339 337 371 14 Interest income (121 (189 (217 15 Interest, net 2,194 2,410 2,129 16 Other (gains) and losses (210 (1,958) 8,368 17 Income before income taxes 20,564 20,116 11,460 18 Provision for income taxes 6,858 4,915 4,281 19 Consolidated net income 13,706 15,201 7,179 20 Consolidated net income attributable to noncontrolling interest (196 (320 (509 21 Consolidated net income attributable to Walmart $ 13,510 $ 14,881 $ 6,670 22 Net income per common share: 23 Basic net income per common share attributable to Walmart (in USD per share) $ 4.77 $ 5.22 $ 2.28 24 Diluted net income per common share attributable to Walmart (in USD per share) $ 4.75 $ 5.19 $ 2.26 25 Weighted-average common shares outstanding: 26 Basic (in shares) 2,831 2,850 2,929 27 Diluted (in shares) 2,847 2,868 2,945 28 Dividends declared per common share (in USD per share) $ 2.16 $ 2.12 $ 2.08 29 Cover Page Consolidated Statements of Inco Consolidated Statements of Comp Consolidated Balance Sheets ( ... + 0 -+ 100% Type here to search O 9 w ?~ D ( 1) ENG 9:14 PM 5/3/2021AutoSave . Off) Walmart FS - Excel Search Brenda Gutierrez1 BG X File Home Insert Page Layout Formulas Data Review View Help Share Comments & Cut Calibri v 11 ~ A" A " ce Wrap Text General X _ AutoSum AY O Fill Paste [A Copy Merge & Center $ ~ % " Conditional Format as Cell Insert Delete Format Sort & Find & Analyze Sensitivity Format Painter Formatting * Table Styles Clear Filter ~ Select Data Clipboard Font Alignment Number Styles Cells Editing Analysis Sensitivity A1 X fx Consolidated Statements of Comprehensive Income - USD ($) $ in Millions B C D E F G H J K L M N Consolidated Statements of Comprehensive Income - USD ($) $ in Millions 12 Months Ended N Jan. 31, 2021 Jan. 31, 2020 Jan. 31, 2019 Statement of Comprehensive Income [ Abstract] Consolidated net income $ 13,706 $ 15,201 $ 7,179 5 Consolidated net income attributable to noncontrolling interest 196) (320) (509) 6 Consolidated net income attributable to Walmart 13,510 14,881 6,670 7 Other comprehensive income (loss), net of income taxes 8 Currency translation and other 842 286 (226) 9 Net investment hedges (221 122 272 10 Cash flow hedges 235 (399) 290) 11 Minimum pension liability (30) (1,244) 131 12 Other comprehensive income (loss), net of income taxes 826 (1,235) (113) 13 Other comprehensive (income) loss attributable to noncontrolling interest 213 28) 188 14 Other comprehensive income (loss) attributable to Walmart 1,039 (1,263) 75 15 Comprehensive income, net of income taxes 14,532 13,966 7,066 16 Comprehensive (income) loss attributable to noncontrolling interest 17 (348) (321) 17 Comprehensive income attributable to Walmart $ 14,549 $ 13,618 $ 6,745 18 19 20 21 22 23 24 25 26 27 28 29 Cover Page | Consolidated Statements of Inco Consolidated Statements of Comp Consolidated Balance Sheets | ( ... +) -+ 100% Type here to search O 9 W ? ~ 0 (1) ENG 9:14 PM 5/3/2021AutoSave . Off) Walmart FS - Excel Search Brenda Gutierrez1 BG X File Home Insert Page Layout Formulas Data Review View Help Share Comments & Cut Calibri v 11 ~ A" A " _ AutoSum ce Wrap Text General X AY O Paste [ Copy Fill BEE E Merge & Center $ ~ % " Conditional Format as Cell Insert Delete Format Sort & Find & Analyze Sensitivity Format Painter Formatting * Table Styles Clear Filter ~ Select Data Clipboard Font Alignment Number Styles Cells Editing Analysis Sensitivity A1 X v fx Consolidated Balance Sheets - USD ($) $ in Millions D E F G H K L M N P Q R S T U V W Consolidated Balance Sheets - USD ($) $ in Millions Jan. 31, 2021 Jan. 31, 2020 2 Current assets 3 Cash and cash equivalents $ 17,741 $ 9,465 ceivables, n 6,516 6,28 5 Inventories 44,949 14,435 6 Prepaid expenses and other 20,861 1,622 7 Total current assets 90,067 61,806 8 Property and equipment, net 92,20 105,208 9 Operating lease right-of-use assets 3,642 17,424 10 Finance lease right-of-use assets, net 4,005 4,417 11 Goodwill 28,98 31,073 12 Other long-term assets 23,598 16,567 13 Total assets 252,496 236,495 14 Current liabilities: 15 Short-term borrowings 224 575 16 Accounts payable 19,141 46,973 17 Accrued liabilities 37,966 22,296 18 Accrued income taxes 242 280 19 Long-term debt due within one year 3,115 5,362 20 Operating lease obligations due within one year 1,466 1,793 21 Finance lease obligations due within one year 491 511 22 Total current liabilities 92,645 77,790 23 Long-term debt 41,194 43,714 24 Long-term operating lease obligations 12,909 16,171 25 Long-term finance lease obligations 3,847 4,307 26 Deferred income taxes and other 14,370 12,961 27 Commitments and contingencies 28 Equity: 29 Common stock 282 284 30 Capital in excess of par value 3,646 3,247 31 Retained earnings 88,763 83,943 32 Accumulated other comprehensive loss (11,766) (12,805) 33 T almart shar 80,925 74,669 $4 Noncontrolling interest 6,606 6,883 Total equity 87,531 81,552 36 Total liabilities and equity $ 252,496 $ 236,495 37 Cover Page | Consolidated Statements of Inco Consolidated Statements of Comp Consolidated Balance Sheets ( ... + - + 80% Type here to search O 9 W ? ~ D (1) ENG 9:14 PM 5/3/2021AutoSave . Off) Walmart FS - Excel Search Brenda Gutierrez1 BG X File Home Insert Page Layout Formulas Data Review View Help Share Comments & Cut v 11 ~ A" A " ce Wrap Text General X _ AutoSum Calibri AY O Paste [ Copy Fill Format Painter BIU FLAV BEE E Merge & Center $ ~ % " Conditional Format as Cell Insert Delete Format Sort & Find & Analyze Sensitivity Formatting * Table Styles v Clear Filter ~ Select Data Clipboard Font Alignment Number Styles Cells Editing Analysis Sensitivity A1 X fx Consolidated Statements Of Shareholders' Equity - USD ($) shares in Millions, $ in Millions Consolidated Statements Of Shareholders' Equity - USD ($) shares in Millions, $ in Millions Total Cumulative Effect, Period of Adoption, Adjustment [Member] Common Stock [Member] Capital in excess of par value [Member] Retained earnings [Member] |Retained earnings [N Beginning balances (in shares) at Jan. 31, 2018 2,952 3 Beginning balances at Jan. 31, 2018 $ 80,822 $ 924 $ 295 $ 2,648 $ 85,107 4 Increase (Decrease) in Stockholders' Equity [Roll Forward] Consolidated net income 7,179 6,670 6 Other comprehensive income (loss), net of income taxes (113) 7 Cash dividends declared (6,102) (6,102) 8 Purchase of Company stock (in shares) (80) 9 Purchase of Company stock (7,487) $ (8) (245) (7,234) 10 Cash dividend declared to noncontrolling interest (488) 11 Noncontrolling interest of acquired entity 1,345 12 Other (in shares) 6 13 Other 554 $1 562 (17) 14 Ending balances (in shares) at Jan. 31, 2019 2,878 15 Ending balances at Jan. 31, 2019 79,634 $ (300 $ 288 2,965 80,785 16 Increase (Decrease) in Stockholders' Equity [Roll Forward] 17 Consolidated net income 15,201 14,881 18 Other comprehensive income (loss), net of income taxes (1,235) 19 Cash dividends declared (6,048) (6,048 20 Purchase of Company stock (in shares) (53) 21 Purchase of Company stock (5,639) $ ( 5 ) (199) (5,435) 22 Cash dividend declared to noncontrolling interest (475) 23 Other (in shares) 7 24 Other 414 $1 481 26 25 Ending balances (in shares) at Jan. 31, 2020 2,832 26 Ending balances at Jan. 31, 2020 81,552 $ 284 3,247 83,943 27 Increase (Decrease) in Stockholders' Equity [Roll Forward] 28 Consolidated net income 13,70 13,510 29 Other comprehensive income (loss), net of income taxes 826 30 Cash dividends declared (6,116) (6,116) 31 Purchase of Company stock (in shares) (20) 32 Purchase of Company stock (2,658 $ (2) (97) (2,559 33 Cash dividend declared to noncontrolling interest (365) 34 Other (in shares) 9 35 Other 586 496 (15) 36 Ending balances (in shares) at Jan. 31, 2021 2.821 ... Consolidated Statements of Comp | Consolidated Balance Sheets Consolidated Statements Of Shar Consolidated S ... + - + 80% Type here to search O 9 W ?~ D ( 1) ENG 9:14 PM 5/3/2021 EAutoSave . Off) Walmart FS - Excel Search Brenda Gutierrez1 BG X File Home Insert Page Layout Formulas Data Review View Help Share Comments & Cut Calibri v 11 ~ A" A " _ AutoSum ce Wrap Text General AY O [ Copy Fill Paste BEE E Merge & Center $ ~ % " Conditional Format as Cell Insert Delete Format Sort & Find & Analyze Sensitivity Format Painter Formatting > Table Styles Clear Filter ~ Select Data Clipboard Font Alignment Number Styles Cells Editing Analysis Sensitivity A1 X fx Consolidated Statements Of Shareholders' Equity - USD ($) shares in Millions, $ in Millions Retained earnings [Member] Cumulative Effect, Period of Adoption, Adjustment [Member] | Accumulated other comprehensive income (loss) [Member] Accumulated other comprehensive income (loss) [Member] Cumulative Effect, Period of Adoption, Adjustment [Member] Total Walmart shareholders' equity [Member] A W I $ 2,361 $ (10,181) $ (1,436) $ 77,869 6,670 75 75 (6,102) (7,487) 546 $ (266) (11,542) 72,496 14 ,881 (1,263) (1,263) (6,048) (5,639) 508 (12,805) 74,669 13,510 1,039 1,039 (6,116) (2,658) 481 1 ... Consolidated Statements of Comp | Consolidated Balance Sheets Consolidated Statements Of Shar Consolidated S ... + + 80% Type here to search O 9 W ?) ~ 0 1) ENG 9:15 PM 5/3/2021AutoSave . Off) Walmart FS - Excel Search Brenda Gutierrez1 BG X File Home Insert Page Layout Formulas Data Review View Help Share Comments & Cut v 11 ~ A" A X _ AutoSum Calibri ce Wrap Text General AY O Fill Paste [A Copy BIUT Y Av Merge & Center $ ~ % " Conditional Format as Cell Insert Delete Format Sort & Find & Analyze Sensitivity Format Painter Formatting > Table Styles Clear Filter ~ Select Data Clipboard Font Alignment Number Styles Cells Editing Analysis Sensitivity A1 X fx Consolidated Statements Of Shareholders' Equity (Parenthetical) - $ / shares B C D E F G H K M N - Consolidated Statements Of Shareholders' Equity (Parenthetical) - $ / shares 12 Months Ended N Jan. 31, 2021 Jan. 31, 2020 Jan. 31, 2019 Statement of Stockholders' Equity [Abstract] 4 Cash dividends declared (in USD per share) $ 2.16 $ 2.12 $ 2.08 10 11 23 24 25 26 27 28 29 ... Consolidated Balance Sheets | Consolidated Statements Of Shar Consolidated Statements Of Sh_2 Consolidated St ... + -+ 100% Type here to search O 9 W ?) ~ 0 (1) ENG 9:15 PM 5/3/2021AutoSave . Off) Walmart FS - Excel Search Brenda Gutierrez1 BG X File Home Insert Page Layout Formulas Data Review View Help Share Comments & Cut Calibri v 11 ~ A" A " ce Wrap Text General X _ AutoSum AY O [A Copy Fill Paste Format Painter Merge & Center $ ~ % " 00 80 Conditional Format as Cell Insert Delete Format Sort & Find & Analyze Sensitivity Formatting * Table Styles Clear Filter ~ Select Data Clipboard Font Alignment Number Styles Cells Editing Analysis Sensitivity A1 X V Consolidated Statements of Cash Flows - USD ($) $ in Millions E F G H K L M N O P Q R S T U V W Consolidated Statements of Cash Flows - USD ($) $ in Millions 12 Months Ended Jan. 31, 2021 Jan. 31, 2020 Jan. 31, 2019 W N - Cash flows from operating activities: Consolidated net income $ 13,706 $ 15,201 $ 7,179 Adjustments to reconcile consolidated net income to net cash provided by operating 3 activities: 6 Depreciation and amortization 11,152 10.987 10,678 7 Net unrealized and realized (gains) and losses (8,589 (1,886) 3,516 Losses on disposal of business operations B,401 15 4.850 9 Asda pension contribution (1,036) 10 Deferred income taxes 1,911 320 (499) 11 Other operating activities 1,521 1,981 1,734 12 Changes in certain assets and liabilities, net of effects of acquisitions and dispositions: 13 Receivables, net (1,086) 154 (368 14 Inventories (2,395) (300) 1,311 15 Accounts payable 6.966 (274) 1,831 16 Accrued liabilities 1623 186 183 17 Accrued income taxes (136) (93) (40 18 Net cash provided by operating activities 36,074 25,255 27,753 19 Cash flows from investing activities: 20 Payments for property and equipment (10,264 (10,705) (10,344) 21 Proceeds from the disposal of property and equipment 215 321 519 22 Proceeds from the disposal of certain operations 56 833 876 Payments for business acquisitions, net of cash acquired 180) (56) (14,656) 4 Other investing activities 102 479 (431) 5 Net cash used in investing activities (10,071) 9,128) (24,036) 26 Cash flows from financing activities: 27 Net change in short-term borrowings (324) (4,656) (53 28 Proceeds from issuance of long-term debt 5,492 15,87 29 Repayments of long-term debt (5,382) (1,907) (3,784) 30 Dividends paid (6,116) (6,048 (6,102) 31 Purchase of Company stock (2,625) (5,717) (7,410) 2 Dividends paid to noncontrolling interest (434) (555) (431) 3 Other financing activities (1,236) (908) (629 34 Net cash used in financing activities 16,117) (14,299) (2,537) 35 Effect of exchange rates on cash, cash equivalents and restricted cash 235 (69 (438) 36 Net increase in cash, cash equivalents and restricted cash 10,121 1,759 742 37 Cash and cash equivalents reclassified as assets held for sale (1,848) 38 Cash, cash equivalents and restricted cash at beginning of year 9,515 7,756 7,014 9 Cash, cash equivalents and restricted cash at end of year 17,788 9,515 7,756 40 Supplemental disclosure of cash flow information: ... Consolidated Statements Of Shar Consolidated Statements Of Sh_2 Consolidated Statements of Cash Summary ( ... + + 70% Type here to search O W ?~ (1) ENG 9:15 PM 5/3/2021

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Forensic Accounting And Fraud Examination

Authors: Paul Barnes

1st Edition

1118454138, 978-1118454152

More Books

Students also viewed these Accounting questions

Question

What does the income statement report?

Answered: 1 week ago

Question

8. What are the costs of collecting the information?

Answered: 1 week ago