Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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

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 Prior (1) - Excel Search Brenda Gutierrez1 BG X File Home Insert Page Layout Formulas Data Review View Share Comments & Cut Calibri 1 " A" A ce Wrap Text General X _ AutoSum AY O Paste [A Copy Fill 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 Document And Entity Information - USD ($) B C D E F G H K L M N Document And Entity Information - USD ($) onths Ended IN Jan. 31, 2020 Mar. 18, 2020 Jul. 31, 2019 3 Entity Registrant Name WALMART INC. 4 Entity Central Index Key 0000104169 5 Document Type 10-K 6 Current Fiscal Year End Date -01-31 Document Period End Date Jan. 31, 7 2020 8 Document Fiscal Year Focus 2020 9 Document Fiscal Period Focus FY 10 Document Annual Report true 11 Document Transition Report false 12 Entity File Number 001-6991 13 Entity Incorporation, State or Country Code DE 14 Entity Tax Identification Number 71-0415188 15 City Area Code 479 16 Local Phone Number 273-4000 17 Entity Address, Address Line One 702 S.W. 8th Street 18 Entity Address, City or Town Bentonville, 19 Entity Address, State or Province AR 20 Entity Address, Postal Zip Code 72716 21 Entity Well-known Seasoned Issuer Yes 22 Entity Voluntary Filers No 23 Entity Current Reporting Status Yes 24 Entity Interactive Data Current Yes 25 Entity Filer Category Large Accelerated Filer 26 Entity Small Business false 27 Entity Emerging Growth Company False 28 Entity Shell Company false Document And Entity Information Consolidated Statements of Inco| Consolidated Statements of Comp | Consolida ... + + 100% Type here to search O w ?~ ( 1) ENG 9:40 AM 5/1/2021AutoSave . Off) Walmart FS Prior (1) - Excel Search Brenda Gutierrez1 BG X File Home Insert Page Layout Formulas Data Review View Share Comments & Cut Calibri 1 " A"A ce Wrap Text General X _ AutoSum AY O [ Copy Fill Paste 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 v fx Document And Entity Information - USD ($) A B C D E F G H K L M N 16 Local Phone Number 273-4000 17 Entity Address, Address Line One 702 S.W. 8th Street 18 Entity Address, City or Town Bentonville, 19 Entity Address, State or Province AR 20 Entity Address, Postal Zip Code 72716 21 Entity Well-known Seasoned Issuer Yes 22 Entity Voluntary Filers No 23 Entity Current Reporting Status Yes 24 Entity Interactive Data Current Yes 25 Entity Filer Category Large Accelerated Filer 26 Entity Small Business false 27 Entity Emerging Growth Company false 28 Entity Shell Company false 29 Entity Public Float $ 155,125,468,742 30 Entity Common Stock, Shares Outstanding 2,832,277,220 31 Amendment Flag false 32 2.550% Notes Due 2026 [ Member] 33 Title of 12(b) Security 2.550% Notes Due 2026 34 Trading Symbol WMT26 35 Security Exchange Name NYSE 36 1.900% Notes Due 2022 [Member] 37 Title of 12(b) Security 1.900% Notes Due 2022 38 Trading Symbol WMT22 39 Security Exchange Name NYSE 40 Common Stock, par value $0.10 per share [ Member] 41 Title of 12(b) Security Common Stock, par value $0.10 per share 42 Trading Symbol WMT 43 Security Exchange Name NYSE 44 Document And Entity Information Consolidated Statements of Inco | Consolidated Statements of Comp | Consolida ... + - + 100% 9:40 AM Type here to search O w ?~ 0 7 1) ENG 5/1/2021AutoSave . Off) Walmart FS Prior (1) - Excel Search Brenda Gutierrez1 BG X File Home Insert Page Layout Formulas Data Review View Share Comments & Cut 1 A" A ce Wrap Text General X _ AutoSum Calibri 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 Consolidated Statements of Income - USD ($) shares in Millions, $ in Millions A B C D E F G H I J K L M N O P Consolidated Statements of Income - USD ($) shares in Millions, $ in Millions 12 Months Ended Jan. 31, 2020 Jan. 31, 2019 Jan. 31, 2018 3 Revenues: 4 Net Sales $ 519,926 $ 510,329 $ 495,761 5 Membership and other income BEO't 4,076 4,582 6 Total revenues 523,964 514,405 500,343 7 Costs and expenses: 8 Cost of sales 394,605 385,301 373,396 9 Operating, selling, general and administrative expenses 108,791 107,147 106,510 10 Operating income 20,568 21,957 20,437 11 Interest: 12 Debt 2,262 1,975 1,978 13 Finance, capital lease and financing obligations 337 371 352 14 Interest income (189) (217) (152 15 Interest, net 2,410 2,129 2,178 16 Loss on extinguishment of debt 3,136 17 Other (gains) and losses (1,958) 8,368 18 Income before income taxes 20,116 11,460 15,123 19 Provision for income taxes 4,915 4,281 4,600 20 Consolidated net income 15,201 7,179 10,523 21 Consolidated net income attributable to noncontrolling interest (320) (509) (661) 22 Consolidated net income attributable to Walmart $ 14,881 $ 6,670 $ 9,862 23 Net income per common share: 24 Basic net income per common share attributable to Walmart $ 5.22 $ 2.28 $ 3.29 25 Diluted net income per common share attributable to Walmart $ 5.19 $ 2.26 $ 3.28 26 Weighted-average common shares outstanding: 27 Basic (in shares) 2,850 2,929 2,995 28 Diluted (in shares) 2,868 2,945 3,010 29 Dividends declared per common share $ 2.12 $ 2.08 $ 2.04 30 31 Document And Entity Information Consolidated Statements of Inco Consolidated Statements of Comp Consolida ... + - + 90% Type here to search O 9 ?~ ( 1)) ENG 9:41 AM 5/1/2021AutoSave . Off) Walmart FS Prior (1) - Excel Search Brenda Gutierrez1 BG X File Home Insert Page Layout Formulas Data Review View Share Comments & Cut Calibri 1 " A" A ce Wrap Text General X _ AutoSum AY O Fill Paste [A Copy BIU DAY 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 Consolidated Statements of Comprehensive Income - USD ($) $ in Millions B C D E F G H K L M 12 Months Ended Consolidated Statements of Comprehensive Income - USD ($) $ in Millions N Jan. 31, 2020 Jan. 31, 2019 Jan. 31, 2018 3 Consolidated net income $ 15,201 $ 7,179 $ 10,523 4 Consolidated net income attributable to noncontrolling interest (320) (509) (661) 5 Consolidated net income attributable to Walmart 14,881 6,670 ,862 6 Other comprehensive income (loss), net of income taxes 7 Currency translation and other 286 (226) 2,540 8 Net investment hedges 122 272 (405 9 Cash flow hedges (399) (290) 437 10 Minimum pension liability (1,244) 131 147 11 Unrealized gain on available-for-sale securities 1,501 12 Other comprehensive income (loss), net of income taxes (1,235) (113) 4,220 13 Less other comprehensive income (loss) attributable to noncontrolling interest (28) 188 169 14 Other comprehensive income (loss) attributable to Walmart (1,263) 75 4,051 15 Comprehensive income, net of income taxes 13,966 7,066 14,743 16 Comprehensive income attributable to noncontrolling interest (348 (321) (830 17 Comprehensive income attributable to Walmart $ 13,618 $ 6,745 $ 13,913 18 19 20 21 22 23 24 25 26 27 28 29 Document And Entity Information | Consolidated Statements of Inco Consolidated Statements of Comp Consolida ... + + 100% Type here to search O 9 w ?~ ( 1) ENG 9:41 AM 5/1/2021AutoSave . Off) Walmart FS Prior (1) - Excel Search Brenda Gutierrez1 BG X File Home Insert Page Layout Formulas Data Review View Share Comments X Cut X _ AutoSum Calibri 1 A" A ce Wrap Text General AY O Paste [ Copy Fill Format Painter BIUVVDAY BEE E 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 Y Consolidated Balance Sheets - USD ($) $ in Millions D E F G H I K L M N 0 P Q R S T U V W X Y Z Consolidated Balance Sheets - USD ($) $ in Millions Jan. 31, 2020 Jan. 31, 2019 W N Current assets: Cash and cash equivalents 9,465 $ 7,722 4 Receivables, net 6,284 6,283 Inventories 44,435 44,269 6 Prepaid expenses and other 1,622 3,623 7 Total current assets 61,806 61,897 8 Property and equipment, net 105,208 104,317 9 Operating lease right-of-use assets 17.424 10 Finance lease right-of-use assets, net 4.417 11 Property under capital lease and financing obligations, net 0 7,078 12 Goodwill 31,073 31,181 13 Other long-term assets 16,567 14,822 14 Total assets 236,495 219,295 15 Current liabilities: 16 Short-term borrowings 575 5,225 17 Accounts payable 46,973 47,060 18 Accrued liabilities 22,296 22.159 19 Accrued income taxes 280 428 20 Long-term debt due within one year 5,362 1,876 21 Operating lease obligations due within one year 1,793 2 Finance lease obligations due within one year 511 23 Capital lease and financing obligations due within one year 729 4 Total current liabilities 77,790 77,477 25 Long-term debt 43,714 43,520 26 Long-term operating lease obligations 16,171 0 27 Long-term finance lease obligations 4.307 Long-term capital lease and financing obligations 6,683 29 Deferred income taxes and other 12,961 11,981 0 Commitments and contingencies 31 Equity: 32 Common stock 284 288 5 Capital in excess of par value 3,247 2,965 4 Retained earnings 83,943 80,785 3 Accumulated other comprehensive loss (12,805 (11,542) 6 Total Walmart shareholders' equity 74,669 72,496 37 Noncontrolling interest 6,883 7,138 8 Total equity 81,552 79,634 39 Total liabilities and equity $ 236,495 $ 219,295 40 41 ... Consolidated Statements of Inco Consolidated Statements of Comp Consolidated Balance Sheets Consolidated St ... + + 70% Type here to search O w ?~ ( 1) ENG 9:41 AM 5/1/2021AutoSave . Off) Walmart FS Prior (1) - Excel Search Brenda Gutierrez1 BG X File Home Insert Page Layout Formulas Data Review View Share Comments & Cut Calibri 1 " A" A ce Wrap Text _ AutoSum General X AY O Paste [ Copy Fill BIUT Y Av 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 Statement Of Shareholders' Equity - USD ($) shares in Millions, $ in Millions D G H J K Consolidated Statement Of Shareholders' Equity - USD ($) shares in Millions, $ in Millions Total Common Stock Capital in excess of par value Retained earnings Accumulated other comprehensive income (loss) Total Walmart shareholders' equity Noncontrolling interest Balances, in shares at Jan. 31, 2017 3,048 3 Balances at Jan. 31, 2017 $ 80,535 $ 305 $ 2,371 $ 89,354 $ (14,232) $ 77,798 $ 2,737 4 Increase (Decrease) in Stockholders' Equity [Roll Forward] 5 Consolidated net income 10,523 9,862 9,862 661 6 Other comprehensive income (loss), net of income taxes 4,220 4,051 4.051 169 7 Cash dividends declared (6,124) (6,124) o (6,124) 0 8 Purchase of Company stock (in shares) (103) 9 Purchase of Company stock (8,204) $ (10 (219) (7,975) 0 (8,204 10 Cash dividend declared to noncontrolling interest (687) (687) 11 Other, in shares 7 12 Other 559 SO 496 (10) 486 73 13 Balances, in shares at Jan. 31, 2018 2,952 14 Balances at Jan. 31, 2018 80,82 $ 295 2,648 85,107 (10,181) 77,869 2,953 15 Increase (Decrease) in Stockholders' Equity [Roll Forward] 16 Adoption of new accounting standards, net of income taxes 924 2.361 (1,436) 925 (1) 17 Consolidated net income 7,179 6,670 6,670 509 18 Other comprehensive income (loss), net of income taxes (113 75 75 (188) 19 Cash dividends declared (6,102) (6,102) (6,102) 0 20 Purchase of Company stock (in shares) (80) 21 Purchase of Company stock (7,487) (8) (245) (7,234) (7,487) 0 2 Cash dividend declared to noncontrolling interest (488 (488) Noncontrolling interest of acquired entity 4,345 4,345 24 Other, in shares 6 25 554 $ 1 562 (17) 546 8 26 Balances, in shares at Jan. 31, 2019 2,878 27 Balances at Jan. 31, 2019 79,634 $ 288 2,965 30,785 (11,542) 72,496 7,138 28 Increase (Decrease) in Stockholders' Equity [Roll Forward] 9 Adoption of new accounting standards, net of income taxes (300 (266) (266) (34) 30 Consolidated net income 15,201 14,881 0 14,881 320 1 Other comprehensive income (loss), net of income taxes (1,235) (1,263) (1,263) 28 2 Cash dividends declared (6,048) (6,048) 0 (6,048) o 3 Purchase of Company stock (in shares) (53) 34 Purchase of Company stock (5,639) $ (5) (199) (5,435 (5,639) 0 Cash dividend declared to noncontrolling interest (475) (475) 36 Other, in shares 37 Other 414 $1 481 26 0 508 (94) 38 Balances, in shares at Jan. 31, 2020 2,832 39 Balances at Jan. 31, 2020 $ 81,552 $ 284 $ 3,247 $ 83,943 $ (12,805) $ 74,669 $ 6,883 40 ... Consolidated Statements of Comp | Consolidated Balance Sheets Consolidated Statement Of Share Consolidated s ... + + 70% Type here to search O ?~( 1) ENG 9:41 AM 5/1/2021AutoSave . Off) Walmart FS Prior (1) - Excel Search Brenda Gutierrez1 BG X File Home Insert Page Layout Formulas Data Review View Share Comments & Cut Calibri 1 " A" A ce Wrap Text General X _ AutoSum AY O Fill Paste [A Copy BIUVVDAY 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 Statement Of Shareholders' Equity (Parenthetical) - $ / shares B C D E F G H K L M N Consolidated Statement Of Shareholders' Equity (Parenthetical) - $ / shares 12 Months Ended N Jan. 31, 2020 Jan. 31, 2019 Jan. 31, 2018 3 Statement of Stockholders' Equity [Abstract] 4 Dividends declared per common share $ 2.12 $ 2.08 $ 2.04 5 10 11 23 24 25 26 27 28 29 ... Consolidated Balance Sheets | Consolidated Statement Of Share Consolidated Statement Of Sha_2 Consolidated St ... + + 100% Type here to search O 9 w ?~ ( 1)) ENG 9:41 AM 5/1/2021AutoSave . Off) Walmart FS Prior (1) - Excel Search Brenda Gutierrez1 BG X File Home Insert Page Layout Formulas Data Review View Share Comments & Cut _ AutoSum Calibri v 11 ~ A" A " ce Wrap Text General X AY O Fill Paste [A Copy Conditional Format as Cell Insert Delete Format Sort & Find & Analyze Sensitivity Format Painter BIUVV DAY Merge & Center $ ~ % " 00 -80 Formatting * Table ~ Styles Clear Filter ~ Select Data Clipboard Font Alignment Number Styles Cells Editing Analysis Sensitivity A1 X fx Consolidated Statements of Cash Flows - USD ($) $ in Millions B C D E F G H I J K L M N O P Consolidated Statements of Cash Flows - USD ($) $ in Millions 12 Months Ended Jan. 31, 2020 Jan. 31, 2019 Jan. 31, 2018 W Cash flows from operating activities: 4 Consolidated net income $ 15,201 $ 7,179 $ 10,523 Adjustments to reconcile income from continuing operations to net cash provided by 5 operating activities: 6 Depreciation and amortization 10,987 10,678 10,529 Unrealized (gains) and losses (1,886) 3,516 0 8 (Gains) and losses for disposal of business operations 15 4,850 0 9 Asda pension contribution (1,036) 0 10 Deferred income taxes 320 (499) (304) 11 Loss on extinguishment of debt 0 0 3,136 12 Other operating activities 1,981 1,734 1,210 13 Changes in certain assets and liabilities, net of effects of acquisitions: 14 Receivables, net 154 (368) (1,074) 15 Inventories (300) 1,311) (140) 16 Accounts payable (274) 1,831 4,086 17 Accrued liabilities 186 183 928 18 Accrued income taxes (93) (40) (557 19 Net cash provided by operating activities 25,255 27,753 28,337 20 Cash flows from investing activities: 21 Payments for property and equipment (10,705) (10,344) (10,051) 22 Proceeds from the disposal of property and equipment 321 519 378 23 Proceeds from the disposal of certain operations 833 876 1,046 24 Payments for business acquisitions, net of cash acquired (56) (14,656) (375 25 Other investing activities 479 (431) (77) 26 Net cash used in investing activities (9,128) (24,036 (9,079) 27 Cash flows from financing activities: 28 Net change in short-term borrowings (4,656) (53) 4,148 29 Proceeds from issuance of long-term debt 5,492 15,872 7,476 30 Repayments of long-term debt (1,907) (3,784) (13,061 31 Premiums paid to extinguish debt n (3 059 ... Consolidated Statement Of Share| Consolidated Statement Of Sha_2 Consolidated Statements of Cash Summary ... + : - + 90% Type here to search O 9 ?~ ( 1)) ENG 9:42 AM 5/1/2021AutoSave . Off) Walmart FS Prior (1) - Excel Search Brenda Gutierrez1 BG X File Home Insert Page Layout Formulas Data Review View Share Comments & Cut 11 ~ A" A " ce Wrap Text General X _ AutoSum Calibri AY O Paste [ Copy Fill 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 Statements of Cash Flows - USD ($) $ in Millions A B C D E F G H I J K L M N O P 18 Accrued income taxes (93) (40) (557) 19 Net cash provided by operating activities 25,255 27,753 28,337 20 Cash flows from investing activities: 21 Payments for property and equipment (10,705) (10,344) (10,051) 22 Proceeds from the disposal of property and equipment 321 519 378 23 Proceeds from the disposal of certain operations 833 876 1,046 24 Payments for business acquisitions, net of cash acquired (56) (14,656) (375 25 Other investing activities 479 (431) (77) 26 Net cash used in investing activities (9,128) (24,036) (9,079) 27 Cash flows from financing activities: 28 Net change in short-term borrowings (4,656) (53) 4,148 29 Proceeds from issuance of long-term debt 5,492 15,872 7,476 30 Repayments of long-term debt (1,907) (3,784) (13,061) 31 Premiums paid to extinguish debt 0 0 (3,059 32 Dividends paid (6,048 (6,102) (6,124) 33 Purchase of Company stock (5,717) (7,410) (8,296) 34 Dividends paid to noncontrolling interest (555) (431) 690 35 Purchase of noncontrolling interest 0 (8 36 Other financing activities (908) (629) (261 37 Net cash used in financing activities (14,299) (2,537) (19,875) 38 Effect of Exchange Rate on Cash, Cash Equivalents, and Restricted Cash (69) (438 487 39 Net increase (decrease) in cash, cash equivalents and restricted cash 1,759 742 (130) 40 Cash, cash equivalents and restricted cash at beginning of year 7,756 7,014 7,144 41 Cash, cash equivalents and restricted cash at end of year 9,515 7,756 7,014 42 Supplemental disclosure of cash flow information: 43 Income taxes paid 3,616 3,982 6,179 44 Interest Paid, Excluding Capitalized Interest, Operating Activities $ 2,464 $ 2,348 $ 2,450 45 46 47 48 ... Consolidated Statement Of Share | Consolidated Statement Of Sha_2 Consolidated Statements of Cash Summary ... + - + 90% Type here to search O 9 ?~ ( 1)) ENG 9:42 AM 5/1/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

Step: 3

blur-text-image

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

Managerial Accounting

Authors: Kurt Heisinger, Joe Ben Hoyle

2nd edition

1453375723, 1453375724, 978-1453375716

More Books

Students also viewed these Accounting questions

Question

Compare and contrast skills, knowledge, and interests.

Answered: 1 week ago

Question

14. Now reconcile what you answered to problem 15 with problem 13.

Answered: 1 week ago