[go: up one dir, main page]

0% found this document useful (0 votes)
6 views9 pages

Group Project

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1/ 9

2021 2020

Net Sales 555,233 519926


A/C receivable 6516 6284
Inventories 44949 44435
Cost of sales 420315 394605
Total Revenue 559151 523964
Operating Income 22548 20568
Property and Equipment, net 92201 105,208
Current Asset 90067 61806 -2578 -15984
Current Liability 92645 77790 13406
Total Debt 164965 154943
Total Equity 87531 81552
Consolidated net income attributable to Walmart 13510 14881
Cash and cash equivalents and restricted cash balance 17788 9515
1 Accounts receivable(net) turnover 86.76
2 Number of days net sales in accounts receivable(net) 4.21
3 Inventory Turnover Rate 9.40
4 Number of days sales in inventory 38.81
5 Gross Margin 24.30% 24.10% 0.2% Increased
6 Property and equipment(net) turnover rate 5.63 omit average
7 Current Ratio 0.97 0.79 Liquidity Increased
8 Debt to equity ratio at January 31, 2020 1.90
9 Consolidated net income attributable to Walmart decreased by -9% in 2021
Three major factors in 2021 that affected the company’s net income compared to the year ended January 31, 2020
a)
b)
c)
10 Cash and cash equivalents and restricted cash balance
at January 31, 2021 increased by 87% 8273
Explanation

-89%
40%
24.83%

-1371
ar ended January 31, 2020
(Amounts in millions, except per share data) 2021 2020 2019
Revenues:
Net sales $ 555,233 $ 519,926 $ 510,329
Membership and other income 3,918 4,038 4,076
Total revenues 559,151 523,964 514,405
Costs 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 22548.00 20,568 21,957
Interest:
Debt 1976.00 2,262 1,975
Finance, capital lease and financing obligations
339.00 337 371
Interest income -121.00 -189 -217
Interest, net 2,194 2,410 2,129

Other (gains) and losses -210.00 -1,958 8,368


Income before income taxes 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.00 -320 -509
Consolidated net income attributable to Walmart $ 13,510 $ 14,881 $ 6,670

Revenues:
Net sales 41.09793
Membership and other income
Total revenues
Costs and expenses:
Cost of sales
Operating, selling, general and administrative expenses
Operating income
Interest:
Debt
Finance, capital lease and financing obligations
Interest income
Interest, net

Other (gains) and losses


Income before income taxes
Provision for income taxes
Consolidated net income
Consolidated net income attributable to noncontrolling interest
Consolidated net income attributable to Walmart
2019 (Amounts in millions, except per share data) 2021
Revenues:
Net sales 555233.00
Membership and other income 3918.00
Total revenues 559151.00
Costs and expenses:
Cost of sales 420315.00
Operating, selling, general and administrative expenses 116288.00
Operating income 22548.00
Interest:
Debt 1976.00
Finance, capital lease and financing obligations 339.00
Interest income 121.00
Interest, net 2194.00

Other (gains) and losses 210.00


Income before income taxes 20564.00
Provision for income taxes 6858.00
Consolidated net income 13706.00
Consolidated net income attributable to noncontrolling interest 196.00
Consolidated net income attributable to Walmart 13510.00

0.209440001 #DIV/0!
Revenues:
Net sales 35307
Membership and other income
Total revenues
Costs and expenses:
Cost of sales 25710
Operating, selling, general and administrative expenses 7497
Operating income
Interest:
Debt -286
Finance, capital lease and financing obligations 2
Interest income -68
Interest, net

Other (gains) and losses -1748


Income before income taxes 448
Provision for income taxes
Consolidated net income -1495
Consolidated net income attributable to noncontrolling interest -124
Consolidated net income attributable to Walmart -1371
2020 2019

519,926 510,329
4,038 4,076
523,964 514,405

394,605 385,301
108,791 0.21 0.21 107,147 0.21
20,568 21,957 22548.00

2,262 1,975 -1976.00


337 371 -339.00
189 -217 121.00
2,410 2,129

1958 8,368 210


20,116 11,460 -6858.00
4,915 4,281
15,201 7,179
320 -509
14,881 $ 6670

0.209243

1943
120
(Amounts in millions) 2021 2020 2019
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 activities:
Depreciation and amortization 11,152 10,987 10,678
Net unrealized and realized
-8,589 -1,886 3,516
(gains) and losses
Losses on disposal of business
8,401 15 4,850
operations
Asda pension contribution — -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 payable 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
215 321 519
and equipment
Proceeds from the disposal of certain
56 833 876
operations

Payments for business acquisitions, net


-180 -56 -14,656
of cash acquired
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
— 5,492 15,872
debt
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
-434 -555 -431
interest

Other financing activities -1,236 -908 -629


Net cash used in financing activities -16,117 -14,299 -2,537

Effect of exchange rates on cash, cash


235 -69 -438
equivalents and restricted cash

Net increase in cash, cash equivalents and


10,121 1,759 742
restricted cash
Cash and cash equivalents reclassified as
-1,848 — —
assets held for sale
Cash, cash equivalents and restricted cash at
9,515 7,756 7,014
beginning of year
Cash, cash equivalents and restricted cash at
$ 17,788 $ 9,515 $ 7,756
end of year
Receivables, net -1086 154
Inventories -2395 -300
Accounts payable 6,966 -274
Accrued liabilities 4,623 186
Accrued income taxes -136 -93

7972 -327 8299

Net cash provided by operating activities 36,074 25,255


10,819

8,273

You might also like