Excel - part 2

profileZola_17
order_159081_436173.xlsx
Home>Business & Finance homework help>Excel - part 2

Company Information

ACCT 370 EXCE PROJECT
Company name Walmart Inc. 
Ticker symbol WMT
Industry Retail industry
Products and services Electonics, footwear, Jewelry, Garden supplies, music and movies, Walmart money card, Walmart-2-Walmart and financial services
Major competitors Amazon.com Inc, Costco Wholesale Corp, The Kroger Co and Home Depot

Consolidated Income Statements.

Wal-Mart Inc.
Consolidated Statements of Income
Fiscal Years Ended January 31,
Amounts in millions, except per share data 2021 2020 2019
Revenue
Net sales 555,233 519,926 510,329
Membership and other income 3918 4038 4,076
Total revenues 559,151 523,964 514,405
Cost and expenses
Cost of sales 420,315 394,605 385,301
Operating, selling, general and administrative expenses 116,288 108,791 107,147
Operating income 22,548 20,568 21,957
Interest
Debt 1,976 2,262 1,975
Finance, capital lease and financing obligations 339 337 371
Interest income -121 -189 -217
Interest net 2194 2410 2129
Other (gains) and losses -210 -1,958 8,863
Income before income tax 20,564 20,116 11,460
Provision for income taxes 6,858 4,915 4,281
Consolidated net income 13,706 15,201 7,179
Consolidated net income attributable to noncontrolling interest -196 -320 -509
Consolidated net income attributable to Walmart 13,510 14,881 6,670
Net income per common share:
Basic net income per common share attributable to Walmart 4.77 5.22 2.28
Diluted net income per common share attributable to Walmart 4.75 5.19 2.26
Weighted-average common shares outstanding:
Basic 2,831 2,850 2,929
Diluted 2,847 2,868 2,945
Dividends declared per common share 2.16 2.12 2.08

Consolidated Balance Sheets

Wal-Mart Inc.
Consolidated Balance Sheet
As of January 31,
Amounts in millions 2021 2020 2019
ASSETS
Current assets
Cash and cas equivalent 17,741 9,465 7,722
Receivables, net 6,516 6,284 6,283
Inventories 44,949 44,435 44,269
Prepaid expenses and other 20,861 1,622 3,623
Total current assets 90,067 61,806 61,897
Property and equipment, net 92,201 105,208 104,317
Operating lease right-of-use assets 13,642 17,424
Finance lease right of use assets, net 4,005 4,417 7,078
Goodwill 28,983 31,073 31,181
Other long term assets 23,598 16,567 14,822
Total assets 252,496 236,495 219,295
LIABILITIES AND EQUITY
Current liabilitiess
Short-term borrowings 224 575 5,225
Accounts payables 49,141 46,973 47,060
Accrued liabilities 37,966 22,296 22,159
Accrued income taxes 242 280 428
Long-term debt due within one year 3,115 5,362 1,876
Operating lease obligations due within one year 1,466 1,793
Finance lease obligations due within one year 491 511 729
Total current laibilities 92645 77790 77477
Long-term debt 41,194 43,714 43,520
Long-term operating lease obligations 12,909 16,171
Long-term finance lease obligations 3,847 4,307 6,683
Deferred income taxes and other 14,370 12,961 11981
Equity
Common stock 282 284 288
Cpiatl in excess of par value 3,646 3,247 2,965
Retained earnings 88,763 83,943 80,785
Accumulated other comprehensive loss -11,766 -12,805 -11,542
Total Wal-Mart shareholders' equity 80,925 74,669 72,496
Non-controlling interest 6,606 6,883 7,138
Total equity 87,531 81,552 79,634
Total liabilities and equity 252,496 236,495 219,295

Cash flow

Wal-Mart Inc.
Consolidated Statements of Cash Flow
Fiscal Years Ended January 31,
Amounts in millions 2021 2020 2019
Cash flow from operating activities
Consolidatesd net income 13,706 15,201 7,179
Adjustments to reconcile consolidated net income to net cash provided by operating activities:
Depreciation and amrotization 11,152 10,987 10,678
Net unrealized (gains) and losses 8,589 1,886 3,516
Losses and disposal of business operations 8,401 15 4,850
Asda pension contributions 1,036
Deferred income taxes 1,911 320 -499
Other operating activities 1,521 1,981 1,734
Changes in certain assets and liabilities, net of effects of acquisitions and dispositions:
Receivables, net -1,086 154 -368
Inventories -2,395 -300 -1,311
Accounts payables 6,966 -274 1,831
Accrued liabilities 4,623 186 183
Accrued income taxes -136 -93 -40
Net cash provided by operating activities 36,074 25,255 27,753
Cash flows from investing activities:
Payments for property and equipment -10,264 -10,705 -10,344
Proceeds from the disposal of property and equipment 215 321 519
Proceeds from the disposal of certain operations 56 833 876
Payments for business acquisitions, net of cash acquired -180 -56 -14,656
Other investing activities 102 479 -431
Net cash used in investing activities -10,071 -9,128 -24,036
Cash flows from financing activities:
Net change in short-term borrowings -324 -4,656 -53
Proceeds from issuance of long-term debt 5,492 15,872
Repayments of long-term debt -5,382 -1,907 -3,784
Dividends paid -6,116 -6,048 -6,102
Purchase of Company stock -2,625 -5,717 -7,410
Dividends paid to noncontrolling interest -434 -555 -431
Other financing activities -1,236 -908 -629
Net cash used in financing activities -16117 -14299 -2537
Effect of exchange rates on cash, cash equivalents and restricted cash 235 -69 -438
Net increase in cash, cash equivalents and restricted cash 10,121 1,759 742
Cash and cash equivalents reclassified as assets held for sale -1,848
Cash, cash equivalents and restricted cash at beginning of year 9,515 7,756 7,014
Cash, cash equivalents and restricted cash at end of year 17,788 9,515 7,756
Supplemental disclosure of cash flow information:
Income taxes paid 5,271 3,616 3,982
Interest paid 2,216 2,464 2,348