Chat with us, powered by LiveChat Equity Beta and Wacc – Walmart Inc. Valuation Worksheet Assignment | Abc Paper
+1(978)310-4246 credencewriters@gmail.com
  

(1) Estimate the equity beta and WACC.(2) Estimate the capital structure.(3) Estimate WMT’ price per share, based on the set of assumptions about the future, as of the end of Feb. 2018. Submit a copy of the finalized worksheet (the first 10 years only).
copy_of_wmt_2018v0_1__8.xls

Unformatted Attachment Preview

A
B
C
D
E
F
G
H
I
J
K
Walmart, Inc.
1
L
M
N
O
P
Q
R
S
T
U
V
W
X
Y
Z
0.00
0.00
AA
AB
AC
AD
AE
AF
AG
AH
AI
AJ
AK
AL
AM
AN
AO
AP
AQ
AR
AS
AT
AU
AV
AW
AX
AY
AZ
BA
BB
BC
BD
BE
BF
BG
BH
BI
BJ
BK
BL
BM
BN
BO
BP
BQ
BR
BS
BT
BU
BV
BW
BX
BY
Amazon.com
2
3
Balance Sheet, standardized ($million)
Fiscal Year Ending
ASSETS
Cash & Equivalents
Receivables – Total (Net)
8
Inventories – Total
9
Prepaid Expenses & Other current assets
10 Current Assets – Total
Plant, Property & Equip (Gross)
11
Accumulated Depreciation
12
13 Plant, Property & Equip (Net)
4
C=not meaningful
2012
2013
2014
2015
2016
2017
2012
2013
2014
2015
2016
2017
7,781
6,768
43,803
1,588
59,940
171,724
55,043
116,681
7,281
6,677
44,858
2,369
61,185
178,678
60,771
117,907
9,135
6,778
45,141
2,224
63,278
182,634
65,979
116,655
8,705
5,624
44,469
1,441
60,239
188,054
71,538
116,516
6,867
5,835
43,046
1,941
57,689
191,129
76,951
114,178
6,756
5,614
43,783
3,511
59,664
197,857
83,039
114,818
11,448
2,600
6,031
1,217
21,296
9,582
2,522
7,060
12,447
3,000
7,411
1,767
24,625
14,809
3,860
10,949
17,416
3,300
8,299
2,312
31,327
22,730
5,763
16,967
19,808
4,400
10,243
2,023
36,474
30,053
8,215
21,838
25,981
6,561
11,461
1,778
45,781
42,441
13,327
29,114
32,315
9,692
16,047
2,143
60,197
68,573
19,707
48,866
0
20,497
5,987
203,105
0
19,510
6,149
204,751
0
18,102
5,671
203,706
0
16,695
6,131
199,581
17,037
9,921
198,825
18,242
11,798
204,522
140
3,277
782
32,555
127
3,300
1,158
40,159
209
4,083
1,919
54,505
280
4,521
2,331
65,444
467
4,638
3,402
83,402
737
16,721
4,789
131,310
38,080
6,805
18,117
2,211
5,914
691
71,818
37,415
7,670
17,976
966
4,412
906
69,345

38,410
1,592
18,337
1,021
5,097
815
65,272
38,487
2,708
18,863
521
3,296
744
64,619
41,433
1,099
19,911
921
2,821
743
66,928
46,092
5,257
19,375
645
4,405
2,747
78,521
13,318
0
15,133
0
16,459
0
20,397
0
25,309
0
0
1,134
4,550
19,002
0
1,736
6,111
22,980
0
3,600
8,030
28,089
0
3,364
10,138
33,899
0
5,197
13,310
43,816
0
6,221
17,046
57,883
41,417
4,373
3,240
519
121,367
44,559
5,110
2,907
1,491
123,412
43,692
4,671
4,134
0
117,769
44,030
3,357
3,964
0
115,970
42,018
4,333
5,011
0
118,290
36,825
3,831
4,523
0
123,700
3,830
1,531
0
24,363
5,181
571
1,681
0
30,413
12,489
1,021
2,165
0
43,764
14,183
1,084
2,894
0
52,060
15,213
392
4,696
0
64,117
37,926
990
6,802
0
103,601
0
332
3,620
72,391
0
76,343
5,395
81,738
203,105
0
323
2,362
73,570
0
76,255
5,084
81,339
204,751
0
323
2,462
78,609
0
81,394
4,543
85,937
203,706
0
317
1,805
78,424
0
80,546
3,065
83,611
199,581
0
305
2,371
75,122
0
77,798
2,737
80,535
198,825
0
295
2,648
74,926
0
77,869
2,953
80,822
204,522
0
5
8,347
1,677
1,837
8,192
0
8,192
32,555
0
5
9,573
2,005
1,837
9,746
0
9,746
40,159
0
5
11,135
1,438
1,837
10,741
0
10,741
54,505
0
5
13,394
1,822
1,837
13,384
0
13,384
65,444
0
5
17,186
3,931
1,837
19,285
0
19,285
83,402
0
5
21,389
8,152
1,837
27,709
0
27,709
131,310
2012
467,231
343,987
123,244
5
6
7
14
15
16
17
18
19
20
21
22
23
24
25
Investments
Intangibles & Goodwill
Deferred Charges & Other Long term Assets
TOTAL ASSETS
LIABILITIES
Accounts Payable
Notes Payable
Accrued Expenses
Tax payable
Debt (Long-Term) Due In One Year
Other Current Liabilities & Tax payable
Total Current Liabilities
Long Term Debt
Deferred Taxes (Balance Sheet)
Liabilities – Other
Non-controlling interest-redeemable
TOTAL LIABILITIES
31 SHAREHOLDERS’ EQUITY
32
Preferred Stock
33
Common Stock
34
Capital Surplus
35
Retained Earnings (Net Other)
36
Less: Treasury Stock
37 Shareholders Equity – Parent
38 Non-contrlling interest-nonredeemable
39 TOTAL SHAREHOLDERS EQUITY
40 TOTAL LIABILITIES AND EQUITY
26
27
28
29
30
34,616
0
41
42
ANNUAL INCOME STATEMENT
43
Fiscal Year Ending
Sales (Net)
Cost of Goods Sold
Gross Profit
2013
474,259
349,199
125,060
2014
483,521
355,913
127,608
2015
479,962
351,530
128,432
2016
482,154
351,176
130,978
2017
496,785
362,867
133,918
2012
61,093
44,271
16,822
2013
74,452
51,681
22,771
2014
88,988
59,152
29,836
2015
107,006
66,751
40,255
2016
135,987
81,865
54,122
2017
177,866
103,134
74,732
88,716
34,528
8,501
26,027
90,920
34,140
8,870
25,270
92,996
34,612
9,173
25,439
96,915
31,517
9,454
22,063
101,384
29,594
10,080
19,514
104,736
29,182
10,529
18,653
14,287
2,535
1,863
672
19,412
3,359
2,668
691
25,925
3,911
3,781
130
32,951
7,304
5,128
2,176
43,369
10,753
6,687
4,066
61,612
13,120
9,166
3,954
51
Interest Expense
52
Interest Income
53
Other Non-Operating Income/Expense
54
Special Items
55 Pretax Income
2,325
102
2,090
(157)
25,737
2,413
113
2,119
(433)
24,656
2,520
81
2,221
(422)
24,799
2,587
181
2,107
(126)
21,638
2,403
100
3,220
66
20,497
2,330
152
3,171
(4,523)
15,123
92
40
(231)
389
141
38
(153)
0
435
210
39
(33)
0
(74)
459
50
(221)
0
1,546
484
100
114
0
3,796
848
202
494
0
3,802
Income Taxes – Total
Minority Interest
58 Income Before EI&DO
59
Extraordinary Items
60
Discontinued Operations
61 Net Income (Loss)
7,981
757
16,999
0
0
16,999
8,105
633
15,918
0
104
16,022
7,985
632
16,182
0
181
16,363
6,558
386
14,694
0
0
14,694
6,204
650
13,643
0
0
13,643
4,600
661
9,862
0
0
9,862
428
0
(39)
0
0
(39)
161
0
274
0
0
274
167
0
(241)
0
0
(241)
950
0
596
0
0
596
1,425
0
2,371
0
0
2,371
769
0
3,033
0
0
3,033
0
16,999
0
3,033
44
45
46
47
48
49
50
Selling, General, & Admin Expenses
Operating Income Before Depreciation
Depreciation, Depletion, & Amortiz
Operating Income After Depreciation
56
57
0
15,918
0
16,182
0
14,694
0
13,643
0
9,862
0
(39)
0
274
0
(241)
0
596
0
2,371
EARNINGS PER SHARE
EPS – Primary, Including EI&DO
EPS – Fully Diluted, Including EI&DO
67 COMMON SHARES
68
Common Shares for Primary EPS Calculation
69
Common Shares for Fully Diluted EPS
70
Com.Shares Outstanding at Fiscal Yr End
71
Stock price–fiscal year end
5.04
5.02
4.87
4.85
5.01
4.99
4.58
4.57
4.40
4.38
3.29
3.28
(0.09)
(0.09)
0.60
0.59
(0.52)
(0.52)
1.28
1.25
5.01
4.90
6.32
6.15
3,374
3,389
3,314
70
3,269
3,283
3,233
75
3,230
3,243
3,228
85
3,207
3,217
3,162
66
3,101
3,112
3,048
67
2,995
3,010
2,952
107
453
453
454
251
457
465
459
399
462
462
465
310
467
477
471
676
474
484
477
750
480
493
484
1169
72
73
2012
2013
2014
2015
2016
2017
2012
2013
2014
2015
2016
2017
(39)
2,159
0
(265)
62
63
Preferred Dividends
Adjusted Available for Common
64
65
66
74
75
76
77
78
79
80
81
82
83
84
85
86
87
Statement of Cashflows
INDIRECT OPERATING ACTIVITIES
Income Before Extraordinary Items
Depreciation and Amortizations
Extr. Items and Disc. Operations
Deferred Taxes
Equity in Net Loss (Earnings)
Sale of PPEq and Investments – Loss (Gain)
Funds from Operations – Other
Receivables – Decrease(Increase)
Inventory – Decrease (Increase)
Accounts/P and Accrued Liabs – Inc(Dec)
Income Taxes – Accrued – Increase(Decrease)
Other Assets and Liabilities – Net Change
Operating Actiities – Net Cash Flow
17,756
8,501
0
(133)
16,551
8,870
0
(279)
16,814
9,173
0
(503)
15,080
9,454
0
(672)
14,293
10,080
0
761
10,523
10,529
0
(304)
0
527
(614)
(2,759)
1,332
981
0
25,591
0
938
(566)
(1,667)
634
(1,224)
0
23,257
0
785
(569)
(1,229)
3,927
166
0
28,564
0
1,410
(19)
(703)
3,311
(472)
0
27,389
0
206
(402)
1,021
5,079
492
0
31,530
0
4,346
(1,074)
(140)
5,014
(557)
0
28,337
274
3,253
0
(156)
(241)
4,746
0
(316)
596
6,281
0
81
2,371
8,116
0
(246)
3,033
11,478
0
(29)
(9)
811
1
1,336
(3)
1,682
5
2,400
0
2,286
0
4,125
(999)
(1,410)
(1,193)
(2,187)
(1,426)
0
2,522
4,180
0
2,177
5,475
0
2,167
6,842
0
4,744
11,920
0
5,342
16,443
(3,583)
7,175
0
(3,765)
18,434
3,302
4,237
2,826
2,306
2,542
3,349
4,091
3,025
0
0
(3,789)
11,955
0
(12,075)
(27,819)
INVESTING ACTIVITIES
Investments – Increase
Sale of Investments
Short term Investments – Change
92 Capital Expenditures
93 Sale of Property Plant and Equipment
94 Acquisitions
95 Investing Activities – Other
96 Investing Activites – Net Cash Flow
0
0
12,898
532
0
0
13,115
727
0
0
0
12,174
570
0
0
0
11,477
635
0
0
10,619
456
(245)
(12,611)
90
(12,298)
479
(11,125)
167
(10,675)
(3,824)
(13,987)
0
0
0
10,051
378
375
988
(9,060)
FINANCING ACTIVITIES
Sale of Common and Preferred Stock
Purchase of Common and Preferred Stock
100 Cash Dividends
101 Long Term Debt – Issuance
102 Long Term Debt – Reduction
103 Current Debt – Changes
104 Financing Activities – Other
105 Financing Activities – Net Cash Flow
0
7,600
5,361
211
1,478
2,754
(498)
(11,972)
0
6,683
6,139
7,072
4,968
911
(1,210)
(11,017)
0
1,015
6,185
5,174
3,904
(6,288)
(2,853)
(15,071)
0
4,112
6,294
39
4,432
1,235
(2,558)
(16,122)
0
8,298
6,216
137
2,055
(1,673)
(824)
(18,929)
0
8,296
6,124
7,476
13,061
4,148
(4,018)
(19,875)
223
1,231
(442)
(500)
(514)
1,854
(1,022)
(430)
(452)
(1,838)
487
(111)
(29)
2,815
2013
2014
2015
2016
2017
AMZN
2012
88
89
90
91
97
98
99
106 Exchange Rate Effect
107 Cash and Cash Equivalents – Change
3,785
0
3,444
0
4,893
0
4,589
0
0
(3,023)
6,737
(745)
(3,595)
(312)
(4,276)
(979)
(5,065)
(795)
(6,450)
(116)
(9,876)
0
960
0
0
0
0
0
0
0
0
0
0
0
0
0
588
1,011
1,933
3,378
2,259
394
(539)
6,359
4,432
(3,882)
(3,763)
267
(2,911)
9,860
9,860
(86)
574
(310)
5,899
(374)
1,333
(212)
3,444
713
1,188
2013
2014
2015
2016
2017
0
0
0
4,007
108
109 Financial Ratios
110 Fiscal Year
111 Sales Growth Rate
WMT
112 Gross Margin
113 S&A/Sales (excluding depreciation)
114 S&A/Sales (including depreciation)
115 EBITDA/Sales
116 Operating Margin
117 EBIT
118 EBIT Margin ratio
119 Reported tax rate
120 LT standard Tax rate
121 NOPAT –Operating ($)
122 NOPAT Margin Ratio
123 Asset Turnover
124 ROA
125 Net Assets (Invested Capital)
126 Net Asset Turnover
127
128 RONA (ROIC)
129 ROE
130 Receivable Days
131 INV Days
132 Payable Days (incl. other)
133 Payable Days
134 PPE Turnovers
135 Current Ratio
136 i- Debt
137 i-Debt-to-Equity
138 i-Debt-to-Equity (Mkt)
139 Interest Coverage
140 CapEx/Depr
141 OCF/Sales
142 NI/Sales
143 OCF/Share
144 cash/sales
145 P/E ratio
146 Piotroski F
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
BZ
CA
CB
CC
CD
CE
CF
CG
CH
CI
CJ
CK
CL
CM
CN
CO
CP
CQ
CR
CS
CT
CU
CV
CW
CX
CY
CZ
DA
DB
DC
DD
DE
DF
DG
DH
DI
DJ
DK
DL
DM
DN
DO
DP
DQ
DR
DS
DT
DU
DV
DW
DX
DY
DZ
EA
EB
EC
ED
EE
EF
EG
EH
EI
EJ
EK
EL
EM
EN
EO
EP
EQ
ER
ES
ET
EU
EV
EW
EX
EY
EZ
FA
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
FB
FC
FD
FE
FF
FG
FH
FI
FJ
FK
FL
FM
FN
FO
FP
FQ
FR
FS
FT
FU
FV
FW
FX
FY
FZ
GA
GB
GC
GD
GE
GF
GG
GH
GI
GJ
GK
GL
GM
GN
GO
GP
GQ
GR
GS
GT
GU
GV
GW
GX
GY
GZ
HA
HB
HC
HD
HE
HF
HG
HH
HI
HJ
HK
HL
HM
HN
HO
HP
HQ
HR
HS
HT
HU
HV
HW
HX
HY
HZ
IA
IB
IC
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
ID
IE
IF
IG
IH
II
IJ
0.00
0.00
IK
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
0.00
0.00
0.00
0.00
0.00
0.00
Students: Please fill
in this column.
Walmart Inc.
Quarterly Income Statement (as reported by the company)
(Amounts in millions, except per share data)
Fiscal Quarter
Revenues:
Net sales
Membership and other income
Total revenues
Costs and expenses:
Cost of sales
Operating, selling, general and administrative expenses
Operating income
Interest:
Debt
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
Net income per common share:
Basic net income per common share attributable to Walmart
Diluted net income per common share attributable to Walmart
Weighted-average common shares outstanding:
Basic
Diluted
Apr-18
Q1 Expected
Jan-19
4
Jul-18
2
Apr-18
1
Jan-18
4
Oct-17
3
Jul-17
2
Apr-17
1
123,897
997
124,894
127,059
969
128,028
121,630
1,060
122,690
135,150
1,117
136,267
122,136
1,043
123,179
121,949
1,406
123,355
116,526
1,016
117,542
93,116
26,792
4,986
95,571
26,707
5,750
91,707
25,829
5,154
102,640
29,160
4,467
91,547
26,868
4,764
91,521
25,865
5,969
87,688
24,617
5,237
Oct-18
3
501
92
(59)
534
1,876
2,576
759
1,817
(107)
1,710
0.58 $
0.58
2,924
2,941
460
94
(51)
503
4,849
398
1,125
(727)
(134)
(861)
(0.29) $
(0.29)
2,946
2,946
437
93
(43)
487
1,845
2,822
546
2,276
(142)
2,134
0.72
0.72
2,950
2,967
448
88
(37)
499
1,004
2,964
601
2,363
(188)
2,175
0.74 $
0.73
2,959
2,978
502
81
(42)
541
1,344
2,879
975
1,904
(155)
1,749
0.59 $
0.58
2,981
2,996
522
91
(38)
575
788
4,606
1,502
3,104
(205)
2,899
0.96 $
0.96
3,008
3,021
506
92
(35)
563
0
4,674
1,522
3,152
(113)
3,039
1.00
1.00
3,035
3,047
Jan-17
4
Jul-16
2
Apr-16
1
Jan-16
4
Oct-15
3
Jul-15
2
129,750
1,186
130,936
117,176
1,003
118,179
119,405
1,449
120,854
114,986
918
115,904
128,684
983
129,667
116,598
810
117,408
119,330
899
120,229
97,743
26,988
6,205
87,484
25,576
5,119
89,485
25,204
6,165
86,544
24,085
5,275
96,999
26,026
6,642
87,446
24,248
5,714
90,056
24,104
6,069
508
77
(30)
555
0
5,650
1,664
3,988
(229)
3,757
$
Oct-16
3
1.23 $
1.22
3,065
3,077
528
81
(24)
585
509
79
(22)
566
499
86
(24)
561
472
93
(17)
548
509
64
(21)
552
523
44
(24)
543
4,534
1,332
3,202
(168)
3,034
5,599
1,710
3,889
(116)
3,773
4,714
1,498
3,216
(137)
3,079
6,094
1,346
4,748
(174)
4,574
5,162
1,748
3,414
(110)
3,304
5,526
1,891
3,635
(160)
3,475
0.98 $
0.98
3,089
3,100
1.21 $
1.21
3,109
3,119
0.98 $
0.98
3,144
3,154
1.23 $
1.22
3,186
3,195
1.03 $
1.03
3,210
3,219
1.08
1.08
3,221
3,231
Jul-16
Apr-15
Apr-17
Apr-16
1
119,405
1,449
120,854
114,002
824
114,826
116,526
1,016
117,542
114,986
918
115,904
89,485
25,204
6,165
86,483
22,663
5,680
87,688
24,617
5,237
86,544
24,085
5,275
509
79
(22)
566
0
5,599
1,710
3,889
(116)
3,773
$
1.21 $
1.21
3,109
3,119
523
320
(19)
824
4,856
1,573
3,283
58
3,341
1.03 $
1.03
3,231
3,243
506
92
(35)
563
499
86
(24)
561
4,674
1,522
3,152
(113)
3,039
4,714
1,498
3,216
(137)
3,079
1.00 $
1.00
3,035
3,047
0.98
0.98
3,144
3,154
Walmart Quarterly Sales and EPS History
Fiscal
Data
Year and
Quarter
2005Q1
2005Q2
2005Q3
2005Q4
2006Q1
2006Q2
2006Q3
2006Q4
2007Q1
2007Q2
2007Q3
2007Q4
2008Q1
2008Q2
2008Q3
2008Q4
2009Q1
2009Q2
2009Q3
2009Q4
2010Q1
2010Q2
2010Q3
2010Q4
2011Q1
2011Q2
2011Q3
2011Q4
2012Q1
2012Q2
2012Q3
2012Q4
2013Q1
Sales ($million)
70,755
76,697
75,397
89,252
79,675
85,430
84,467
99,078
86,378
92,827
91,794
107,289
94,940
102,342
98,345
108,747
94,214
100,876
99,373
113,622
99,811
103,726
101,952
116,360
104,189
109,366
110,226
123,169
113,010
114,065
113,800
127,776
114,070
Diluted Earnings
Per ShareExcluding
Basic Earnings Per
Extraordinary
Share- Excluding
items Extraordinary items
0.60
0.60
0.68
0.68
0.58
0.58
0.87
0.87
0.64
0.64
0.72
0.72
0.62
0.62
0.95
0.95
0.68
0.68
0.75
0.75
0.70
0.70
1.03
1.03
0.76
0.77
0.86
0.86
0.77
0.77
0.96
0.97
0.77
0.77
0.89
0.89
0.82
0.82
1.26
1.27
0.87
0.88
0.97
0.97
0.95
0.95
1.41
1.42
0.98
0.98
1.09
1.09
0.97
0.97
1.51
1.52
1.09
1.10
1.18
1.19
1.07
1.08
1.67
1.68
1.14
1.14
2013Q2
116,830
1.24
2013Q3
115,688
1.14
2013Q4
129,706
1.34
2014Q1
114,960
1.10
2014Q2
120,125
1.21
2014Q3
119,001
1.15
2014Q4
131,565
1.53
2015Q1
114,826
1.03
2015Q2
120,229
1.08
2015Q3
117,408
1.03
2015Q4
129,667
1.43
2016Q1
115,904
0.98
2016Q2
120,319
1.21
2016Q3
118,179
0.98
2016Q4
130,936
1.22
2017Q1
117,542
1.00
2017Q2
122,968
0.96
2017Q3
123,179
0.58
2017Q4
136,267
0.73
2018Q1
122,690
0.72
2018Q2
128,028
(0.29)
2018Q3
123,897
0.58
2018Q4 Not available as of the press date
2019Q1E
1.24
1.14
1.34
1.10
1.22
1.15
1.54
1.03
1.08
1.03
1.44
0.98
1.21
0.98
1.23
1.00
0.96
0.59
0.74
0.72
(0.29)
0.58
<---Please update this on your own. date this on your own. Data Year - Fiscal 1984 1985 1986 1987 1988 1989 1990 1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 Ticker Symbol WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT WMT Sales 6,400.8 8,451.5 11,909.1 15,959.3 20,649.0 25,810.7 32,601.6 43,886.9 55,483.8 67,344.6 82,494.0 93,627.0 104,859.0 117,958.0 137,634.0 165,639.0 192,003.0 218,529.0 245,308.0 257,157.0 286,103.0 313,335.0 345,977.0 375,376.0 402,298.0 406,103.0 420,016.0 444,948.0 467,231.0 474,259.0 483,521.0 479,962.0 482,154.0 496,785.0 Operating Income After Depreciati on 497.0 605.0 848.2 1,078.1 1,324.3 1,670.9 1,949.6 2,416.5 2,988.2 3,567.6 4,050.0 4,112.0 4,408.0 5,212.0 6,546.0 8,935.0 10,198.0 10,794.0 12,427.0 13,501.0 15,205.0 16,211.0 17,824.0 18,467.0 19,841.0 22,099.0 23,709.0 24,622.0 26,027.0 25,270.0 25,439.0 22,063.0 19,514.0 18,653.0 Capital Expenditu Data Year res - Fiscal 324.9 532.2 586.6 658.5 592.8 954.6 1,388.3 1,805.3 3,756.4 3,643.7 3,734.0 3,566.0 1995 2,643.0 1996 2,636.0 1997 3,734.0 1998 6,183.0 1999 8,042.0 2000 8,383.0 2001 9,355.0 2002 10,308.0 2003 12,893.0 2004 14,563.0 2005 15,666.0 2006 14,937.0 2007 11,499.0 2008 ... Purchase answer to see full attachment

error: Content is protected !!