Forecasting Quarterly Sales

The company is walmart

Assignment 4

Use the Excel file “Assignment4Data” to complete this assignment.The file contains quarterly sales and quarterly EPS for your group project companies

Part 1. Forecasting Quarterly Sales

What were your company’s sales for the most recent 5 quarters (use Assignment4Data to complete the table below)?

For your company, what is the coefficient estimate for the intercept?

For your company, what is the coefficient estimate for the slope?

Complete the table below.Using your company’s sales regression coefficients and your company’s past sales, forecast your company’s sales for the next four quarters.Also, collect the

Value

Line sales forecasts for these quarters from the most recent Value Line PDF report.

What were your company’s EPS for the most recent 5 quarters (use Assignment4Data to complete the table below)?

For your company, what is the coefficient estimate for the intercept?For your company, what is the coefficient estimate for the slope?

Complete the table below.Using your company’s EPS regression coefficients and your company’s past EPS, forecast your company’s EPS for the next four quarters.Also, collect the Value Line sales forecasts for these quarters from the most recent Value Line PDF report.

Quarter End Date

Value

Qt

-5

10/31/2022

Qt-4

1/31/2023

Qt-3

4/30/2023

Qt-2

7/31/2023

Qt-1 (most recent quarter)

10/31/2023

Estimate the Foster Model regression for predicting quarterly sales.

Quarter End Date

Foster Model Forecast

Value Line Forecast

Qt

1/31/2024

Qt+1

4/30/2024

Qt+2

7/31/2024

Qt+3

10/31/2024

Part 2. Forecasting Quarterly EPS

Quarter End DateValue

Qt-5

10/31/2022Qt-41/31/2023Qt-34/30/2023Qt-27/31/2023

Qt-1 (most recent quarter)

10/31/2023

Estimate the Foster Model regression for predicting quarterly EPS.

  Quarter End Date

Foster Model   Forecast

Value Line   Forecast

 Qt1/31/2024 Qt+14/30/2024 Qt+27/31/2024 Qt+310/31/2024 Ticker Symbol Period End Date Measure Value
TJX
10/31/2023 SAL
13265
TJX
7/31/2023 SAL
12758
TJX
4/30/2023 SAL
11783
TJX
1/31/2023 SAL
14520
TJX
10/31/2022 SAL
12166.286
TJX
7/31/2022 SAL
11843.008
TJX
4/30/2022 SAL
11406.474
TJX
1/31/2022 SAL
13854.368
TJX
10/31/2021 SAL
12531.89
TJX
7/31/2021 SAL
12077.063
TJX
4/30/2021 SAL
10086.661
TJX
1/31/2021 SAL
10943.21
TJX
10/31/2020 SAL
10117.289
TJX
7/31/2020 SAL
6667.575
TJX
4/30/2020 SAL
4408.888
TJX
1/31/2020 SAL
12206.462
TJX
10/31/2019 SAL
10451.334
TJX
7/31/2019 SAL
9781.596
TJX
4/30/2019 SAL
9277.585
TJX
1/31/2019 SAL
11127.34
TJX
10/31/2018 SAL
9825.759
TJX
7/31/2018 SAL
9331.115
TJX
4/30/2018 SAL
8688.72
TJX
1/31/2018 SAL
10960.72
TJX
10/31/2017 SAL
8762.22
TJX
7/31/2017 SAL
8357.7
TJX
4/30/2017 SAL
7784.024
TJX
1/31/2017 SAL
9467.647
TJX
10/31/2016 SAL
8291.688
TJX
7/31/2016 SAL
7882.053
TJX
4/30/2016 SAL
7542.356
TJX
1/31/2016 SAL
8962.075
Ticker Symbol Period End Date Measure Value
TJX
10/31/2023 EPS
1.03
TJX
7/31/2023 EPS
0.85
TJX
4/30/2023 EPS
0.76
TJX
1/31/2023 EPS
0.89
TJX
10/31/2022 EPS
0.86
TJX
7/31/2022 EPS
0.69
TJX
4/30/2022 EPS
0.68
TJX
1/31/2022 EPS
0.78
TJX
10/31/2021 EPS
0.84
TJX
7/31/2021 EPS
0.79
TJX
4/30/2021 EPS
0.44
TJX
1/31/2021 EPS
0.5
TJX
10/31/2020 EPS
0.71
TJX
7/31/2020 EPS
-0.18
TJX
4/30/2020 EPS
-0.74
TJX
1/31/2020 EPS
0.81
TJX
10/31/2019 EPS
0.68
TJX
7/31/2019 EPS
0.62
TJX
4/30/2019 EPS
0.57
TJX
1/31/2019 EPS
0.68
TJX
10/31/2018 EPS
0.63
TJX
7/31/2018 EPS
1.17
TJX
4/30/2018 EPS
0.96
TJX
1/31/2018 EPS
1.3
TJX
10/31/2017 EPS
1
TJX
7/31/2017 EPS
0.85
TJX
4/30/2017 EPS
0.78
TJX
1/31/2017 EPS
1.03
TJX
10/31/2016 EPS
0.91
TJX
7/31/2016 EPS
0.84
TJX
4/30/2016 EPS
0.76
TJX
1/31/2016 EPS
0.99
Ticker Symbol Period End Date Measure Value
AEO
10/31/2023 SAL
1301
AEO
7/31/2023 SAL
1201
AEO
4/30/2023 SAL
1081
AEO
1/31/2023 SAL
1496
AEO
10/31/2022 SAL
1241
AEO
7/31/2022 SAL
1198
AEO
4/30/2022 SAL
1055
AEO
1/31/2022 SAL
1508
AEO
10/31/2021 SAL
1274
AEO
7/31/2021 SAL
1194
AEO
4/30/2021 SAL
1035
AEO
1/31/2021 SAL
1292
AEO
10/31/2020 SAL
1032
AEO
7/31/2020 SAL
884
AEO
4/30/2020 SAL
552
AEO
1/31/2020 SAL
1315
AEO
10/31/2019 SAL
1066
AEO
7/31/2019 SAL
1041
AEO
4/30/2019 SAL
886
AEO
1/31/2019 SAL
1244
AEO
10/31/2018 SAL
1004
AEO
7/31/2018 SAL
965
AEO
4/30/2018 SAL
823
AEO
1/31/2018 SAL
1229
AEO
10/31/2017 SAL
960
AEO
7/31/2017 SAL
845
AEO
4/30/2017 SAL
762
AEO
1/31/2017 SAL
1097
AEO
10/31/2016 SAL
941
AEO
7/31/2016 SAL
823
AEO
4/30/2016 SAL
749
AEO
1/31/2016 SAL
1106
Ticker Symbol Period End Date Measure Value
FIVE
10/31/2023 SAL
736
FIVE
7/31/2023 SAL
759
FIVE
4/30/2023 SAL
726
FIVE
1/31/2023 SAL
1123
FIVE
10/31/2022 SAL
645
FIVE
7/31/2022 SAL
669
FIVE
4/30/2022 SAL
640
FIVE
1/31/2022 SAL
996
FIVE
10/31/2021 SAL
608
FIVE
7/31/2021 SAL
647
FIVE
4/30/2021 SAL
598
FIVE
1/31/2021 SAL
859
FIVE
10/31/2020 SAL
477
FIVE
7/31/2020 SAL
426
FIVE
4/30/2020 SAL
201
FIVE
1/31/2020 SAL
687
FIVE
10/31/2019 SAL
377
FIVE
7/31/2019 SAL
417
FIVE
4/30/2019 SAL
365
FIVE
1/31/2019 SAL
603
FIVE
10/31/2018 SAL
313
FIVE
7/31/2018 SAL
348
FIVE
4/30/2018 SAL
296
FIVE
1/31/2018 SAL
505
FIVE
10/31/2017 SAL
257
FIVE
7/31/2017 SAL
283
FIVE
4/30/2017 SAL
233
FIVE
1/31/2017 SAL
388
FIVE
10/31/2016 SAL
199
FIVE
7/31/2016 SAL
220
FIVE
4/30/2016 SAL
193
FIVE
1/31/2016 SAL
326
Ticker Symbol Period End Date Measure Value
FL
10/31/2023 SAL
1989
FL
7/31/2023 SAL
1864
FL
4/30/2023 SAL
1931
FL
1/31/2023 SAL
2337
FL
10/31/2022 SAL
2173
FL
7/31/2022 SAL
2065
FL
4/30/2022 SAL
2175
FL
1/31/2022 SAL
2341
FL
10/31/2021 SAL
2189
FL
7/31/2021 SAL
2275
FL
4/30/2021 SAL
2153
FL
1/31/2021 SAL
2189
FL
10/31/2020 SAL
2106
FL
7/31/2020 SAL
2077
FL
4/30/2020 SAL
1176
FL
1/31/2020 SAL
2221
FL
10/31/2019 SAL
1932
FL
7/31/2019 SAL
1774
FL
4/30/2019 SAL
2078
FL
1/31/2019 SAL
2272
FL
10/31/2018 SAL
1860
FL
7/31/2018 SAL
1782
FL
4/30/2018 SAL
2025
FL
1/31/2018 SAL
2210
FL
10/31/2017 SAL
1870
FL
7/31/2017 SAL
1701
FL
4/30/2017 SAL
2001
FL
1/31/2017 SAL
2113
FL
10/31/2016 SAL
1886
FL
7/31/2016 SAL
1780
FL
4/30/2016 SAL
1987
FL
1/31/2016 SAL
2007
Ticker Symbol Period End Date Measure Value
GPS
10/31/2023 SAL
3767
GPS
7/31/2023 SAL
3548
GPS
4/30/2023 SAL
3276
GPS
1/31/2023 SAL
4243
GPS
10/31/2022 SAL
4039
GPS
7/31/2022 SAL
3857
GPS
4/30/2022 SAL
3477
GPS
1/31/2022 SAL
4525
GPS
10/31/2021 SAL
3943
GPS
7/31/2021 SAL
4211
GPS
4/30/2021 SAL
3991
GPS
1/31/2021 SAL
4424
GPS
10/31/2020 SAL
3994
GPS
7/31/2020 SAL
3275
GPS
4/30/2020 SAL
2107
GPS
1/31/2020 SAL
4674
GPS
10/31/2019 SAL
3998
GPS
7/31/2019 SAL
4005
GPS
4/30/2019 SAL
3706
GPS
1/31/2019 SAL
4623
GPS
10/31/2018 SAL
4089
GPS
7/31/2018 SAL
4085
GPS
4/30/2018 SAL
3783
GPS
1/31/2018 SAL
4778
GPS
10/31/2017 SAL
3838
GPS
7/31/2017 SAL
3799
GPS
4/30/2017 SAL
3440
GPS
1/31/2017 SAL
4429
GPS
10/31/2016 SAL
3798
GPS
7/31/2016 SAL
3851
GPS
4/30/2016 SAL
3438
GPS
1/31/2016 SAL
4385
Ticker Symbol Period End Date Measure Value
JWN
10/31/2023 SAL
3320
JWN
7/31/2023 SAL
3772
JWN
4/30/2023 SAL
3181
JWN
1/31/2023 SAL
4319
JWN
10/31/2022 SAL
3546
JWN
7/31/2022 SAL
4095
JWN
4/30/2022 SAL
3569
JWN
1/31/2022 SAL
4486
JWN
10/31/2021 SAL
3637
JWN
7/31/2021 SAL
3657
JWN
4/30/2021 SAL
3009
JWN
1/31/2021 SAL
3645
JWN
10/31/2020 SAL
3089
JWN
7/31/2020 SAL
1862
JWN
4/30/2020 SAL
2119
JWN
1/31/2020 SAL
4538
JWN
10/31/2019 SAL
3672
JWN
7/31/2019 SAL
3872
JWN
4/30/2019 SAL
3443
JWN
1/31/2019 SAL
4484
JWN
10/31/2018 SAL
3748
JWN
7/31/2018 SAL
4067
JWN
4/30/2018 SAL
3561
JWN
1/31/2018 SAL
4702
JWN
10/31/2017 SAL
3629
JWN
7/31/2017 SAL
3793
JWN
4/30/2017 SAL
3354
JWN
1/31/2017 SAL
4316
JWN
10/31/2016 SAL
3542
JWN
7/31/2016 SAL
3651
JWN
4/30/2016 SAL
3249
JWN
1/31/2016 SAL
4194
Ticker Symbol Period End Date Measure Value
M
10/31/2023 SAL
4860
M
7/31/2023 SAL
5130
M
4/30/2023 SAL
4982
M
1/31/2023 SAL
8264
M
10/31/2022 SAL
5230
M
7/31/2022 SAL
5600
M
4/30/2022 SAL
5348
M
1/31/2022 SAL
8665
M
10/31/2021 SAL
5440
M
7/31/2021 SAL
5647
M
4/30/2021 SAL
4706
M
1/31/2021 SAL
6780
M
10/31/2020 SAL
3990
M
7/31/2020 SAL
3559
M
4/30/2020 SAL
3017
M
1/31/2020 SAL
8337
M
10/31/2019 SAL
5173
M
7/31/2019 SAL
5546
M
4/30/2019 SAL
5504
M
1/31/2019 SAL
8455
M
10/31/2018 SAL
5404
M
7/31/2018 SAL
5572
M
4/30/2018 SAL
5541
M
1/31/2018 SAL
8666
M
10/31/2017 SAL
5281
M
7/31/2017 SAL
5552
M
4/30/2017 SAL
5338
M
1/31/2017 SAL
8515
M
10/31/2016 SAL
5626
M
7/31/2016 SAL
5866
M
4/30/2016 SAL
5771
M
1/31/2016 SAL
8869
Ticker Symbol Period End Date Measure Value
TGT
10/31/2023 SAL
25398
TGT
7/31/2023 SAL
24773
TGT
4/30/2023 SAL
25322
TGT
1/31/2023 SAL
31395
TGT
10/31/2022 SAL
26518
TGT
7/31/2022 SAL
26037
TGT
4/30/2022 SAL
25170
TGT
1/31/2022 SAL
30996
TGT
10/31/2021 SAL
25652
TGT
7/31/2021 SAL
25160
TGT
4/30/2021 SAL
24197
TGT
1/31/2021 SAL
28339
TGT
10/31/2020 SAL
22632
TGT
7/31/2020 SAL
22975
TGT
4/30/2020 SAL
19615
TGT
1/31/2020 SAL
23398
TGT
10/31/2019 SAL
18665
TGT
7/31/2019 SAL
18422
TGT
4/30/2019 SAL
17627
TGT
1/31/2019 SAL
22977
TGT
10/31/2018 SAL
17821
TGT
7/31/2018 SAL
17776
TGT
4/30/2018 SAL
16781
TGT
1/31/2018 SAL
22766
TGT
10/31/2017 SAL
16667
TGT
7/31/2017 SAL
16429
TGT
4/30/2017 SAL
16017
TGT
1/31/2017 SAL
20690
TGT
10/31/2016 SAL
16441
TGT
7/31/2016 SAL
16169
TGT
4/30/2016 SAL
16196
TGT
1/31/2016 SAL
21626
Ticker Symbol Period End Date Measure Value
ULTA
10/31/2023 SAL
2488.933
ULTA
7/31/2023 SAL
2529.809
ULTA
4/30/2023 SAL
2634.3
ULTA
1/31/2023 SAL
3226.8
ULTA
10/31/2022 SAL
2338.793
ULTA
7/31/2022 SAL
2297.113
ULTA
4/30/2022 SAL
2345.901
ULTA
1/31/2022 SAL
2729.388
ULTA
10/31/2021 SAL
1995.775
ULTA
7/31/2021 SAL
1967.207
ULTA
4/30/2021 SAL
1938.519
ULTA
1/31/2021 SAL
2198.701
ULTA
10/31/2020 SAL
1552.033
ULTA
7/31/2020 SAL
1228.009
ULTA
4/30/2020 SAL
1173.21
ULTA
1/31/2020 SAL
2305.918
ULTA
10/31/2019 SAL
1682.514
ULTA
7/31/2019 SAL
1666.607
ULTA
4/30/2019 SAL
1743.029
ULTA
1/31/2019 SAL
2124.716
ULTA
10/31/2018 SAL
1560.011
ULTA
7/31/2018 SAL
1488.221
ULTA
4/30/2018 SAL
1543.667
ULTA
1/31/2018 SAL
1937.592
ULTA
10/31/2017 SAL
1342.181
ULTA
7/31/2017 SAL
1289.854
ULTA
4/30/2017 SAL
1314.879
ULTA
1/31/2017 SAL
1580.574
ULTA
10/31/2016 SAL
1131.232
ULTA
7/31/2016 SAL
1069.215
ULTA
4/30/2016 SAL
1073.716
ULTA
1/31/2016 SAL
1268.295
Ticker Symbol Period End Date Measure Value
WMT
10/31/2023 SAL
160804
WMT
7/31/2023 SAL
161632
WMT
4/30/2023 SAL
152301
WMT
1/31/2023 SAL
164048
WMT
10/31/2022 SAL
152813
WMT
7/31/2022 SAL
152859
WMT
4/30/2022 SAL
141569
WMT
1/31/2022 SAL
152871
WMT
10/31/2021 SAL
140525
WMT
7/31/2021 SAL
141048
WMT
4/30/2021 SAL
138310
WMT
1/31/2021 SAL
152079
WMT
10/31/2020 SAL
134708
WMT
7/31/2020 SAL
137742
WMT
4/30/2020 SAL
134622
WMT
1/31/2020 SAL
141671
WMT
10/31/2019 SAL
127991
WMT
7/31/2019 SAL
130377
WMT
4/30/2019 SAL
123925
WMT
1/31/2019 SAL
138793
WMT
10/31/2018 SAL
124894
WMT
7/31/2018 SAL
128028
WMT
4/30/2018 SAL
122690
WMT
1/31/2018 SAL
136267
WMT
10/31/2017 SAL
123179
WMT
7/31/2017 SAL
123355
WMT
4/30/2017 SAL
117542
WMT
1/31/2017 SAL
130936
WMT
10/31/2016 SAL
118179
WMT
7/31/2016 SAL
120854
WMT
4/30/2016 SAL
115904
WMT
1/31/2016 SAL
129667
Ticker Symbol Period End Date Measure Value
AEO
10/31/2023 EPS
0.49
AEO
7/31/2023 EPS
0.25
AEO
4/30/2023 EPS
0.17
AEO
1/31/2023 EPS
0.37
AEO
10/31/2022 EPS
0.42
AEO
7/31/2022 EPS
0.04
AEO
4/30/2022 EPS
0.16
AEO
1/31/2022 EPS
0.35
AEO
10/31/2021 EPS
0.76
AEO
7/31/2021 EPS
0.6
AEO
4/30/2021 EPS
0.48
AEO
1/31/2021 EPS
0.39
AEO
10/31/2020 EPS
0.35
AEO
7/31/2020 EPS
-0.03
AEO
4/30/2020 EPS
-0.84
AEO
1/31/2020 EPS
0.37
AEO
10/31/2019 EPS
0.48
AEO
7/31/2019 EPS
0.39
AEO
4/30/2019 EPS
0.24
AEO
1/31/2019 EPS
0.43
AEO
10/31/2018 EPS
0.48
AEO
7/31/2018 EPS
0.34
AEO
4/30/2018 EPS
0.23
AEO
1/31/2018 EPS
0.44
AEO
10/31/2017 EPS
0.42
AEO
7/31/2017 EPS
0.19
AEO
4/30/2017 EPS
0.16
AEO
1/31/2017 EPS
0.39
AEO
10/31/2016 EPS
0.41
AEO
7/31/2016 EPS
0.23
AEO
4/30/2016 EPS
0.22
AEO
1/31/2016 EPS
0.42
Ticker Symbol Period End Date Measure
FIVE
10/31/2023 EPS
FIVE
7/31/2023 EPS
FIVE
4/30/2023 EPS
FIVE
1/31/2023 EPS
FIVE
10/31/2022 EPS
FIVE
7/31/2022 EPS
FIVE
4/30/2022 EPS
FIVE
1/31/2022 EPS
FIVE
10/31/2021 EPS
FIVE
7/31/2021 EPS
FIVE
4/30/2021 EPS
FIVE
1/31/2021 EPS
FIVE
10/31/2020 EPS
FIVE
7/31/2020 EPS
FIVE
4/30/2020 EPS
FIVE
1/31/2020 EPS
FIVE
10/31/2019 EPS
FIVE
7/31/2019 EPS
FIVE
4/30/2019 EPS
FIVE
1/31/2019 EPS
FIVE
10/31/2018 EPS
FIVE
7/31/2018 EPS
FIVE
4/30/2018 EPS
FIVE
1/31/2018 EPS
FIVE
10/31/2017 EPS
FIVE
7/31/2017 EPS
FIVE
4/30/2017 EPS
FIVE
1/31/2017 EPS
FIVE
10/31/2016 EPS
FIVE
7/31/2016 EPS
FIVE
4/30/2016 EPS
FIVE
1/31/2016 EPS
Value
0.26
0.84
0.67
3.07
0.29
0.74
0.59
2.49
0.43
1.15
0.88
2.2
0.36
0.53
-0.91
1.97
0.18
0.51
0.46
1.59
0.24
0.45
0.35
1.18
0.18
0.3
0.15
0.9
0.1
0.18
0.12
0.77
Ticker Symbol Period End Date Measure Value
FL
10/31/2023 EPS
0.3
FL
7/31/2023 EPS
0.04
FL
4/30/2023 EPS
0.7
FL
1/31/2023 EPS
0.97
FL
10/31/2022 EPS
1.27
FL
7/31/2022 EPS
1.1
FL
4/30/2022 EPS
1.6
FL
1/31/2022 EPS
1.67
FL
10/31/2021 EPS
1.93
FL
7/31/2021 EPS
2.21
FL
4/30/2021 EPS
1.96
FL
1/31/2021 EPS
1.55
FL
10/31/2020 EPS
1.21
FL
7/31/2020 EPS
0.71
FL
4/30/2020 EPS
-0.67
FL
1/31/2020 EPS
1.63
FL
10/31/2019 EPS
1.13
FL
7/31/2019 EPS
0.66
FL
4/30/2019 EPS
1.53
FL
1/31/2019 EPS
1.56
FL
10/31/2018 EPS
0.95
FL
7/31/2018 EPS
0.75
FL
4/30/2018 EPS
1.45
FL
1/31/2018 EPS
1.26
FL
10/31/2017 EPS
0.87
FL
7/31/2017 EPS
0.62
FL
4/30/2017 EPS
1.36
FL
1/31/2017 EPS
1.37
FL
10/31/2016 EPS
1.13
FL
7/31/2016 EPS
0.94
FL
4/30/2016 EPS
1.39
FL
1/31/2016 EPS
1.16
Ticker Symbol Period End Date Measure Value
GPS
10/31/2023 EPS
0.59
GPS
7/31/2023 EPS
0.34
GPS
4/30/2023 EPS
0.01
GPS
1/31/2023 EPS
-0.75
GPS
10/31/2022 EPS
0.38
GPS
7/31/2022 EPS
0.18
GPS
4/30/2022 EPS
-0.44
GPS
1/31/2022 EPS
-0.02
GPS
10/31/2021 EPS
0.27
GPS
7/31/2021 EPS
0.7
GPS
4/30/2021 EPS
0.48
GPS
1/31/2021 EPS
0.28
GPS
10/31/2020 EPS
0.25
GPS
7/31/2020 EPS
-0.01
GPS
4/30/2020 EPS
-2.51
GPS
1/31/2020 EPS
0.58
GPS
10/31/2019 EPS
0.53
GPS
7/31/2019 EPS
0.63
GPS
4/30/2019 EPS
0.24
GPS
1/31/2019 EPS
0.72
GPS
10/31/2018 EPS
0.69
GPS
7/31/2018 EPS
0.76
GPS
4/30/2018 EPS
0.42
GPS
1/31/2018 EPS
0.61
GPS
10/31/2017 EPS
0.58
GPS
7/31/2017 EPS
0.58
GPS
4/30/2017 EPS
0.36
GPS
1/31/2017 EPS
0.51
GPS
10/31/2016 EPS
0.6
GPS
7/31/2016 EPS
0.6
GPS
4/30/2016 EPS
0.32
GPS
1/31/2016 EPS
0.57
Ticker Symbol Period End Date Measure Value
JWN
10/31/2023 EPS
0.25
JWN
7/31/2023 EPS
0.84
JWN
4/30/2023 EPS
0.07
JWN
1/31/2023 EPS
0.74
JWN
10/31/2022 EPS
0.2
JWN
7/31/2022 EPS
0.81
JWN
4/30/2022 EPS
-0.01
JWN
1/31/2022 EPS
1.23
JWN
10/31/2021 EPS
0.39
JWN
7/31/2021 EPS
0.49
JWN
4/30/2021 EPS
-1.05
JWN
1/31/2021 EPS
0.21
JWN
10/31/2020 EPS
0.34
JWN
7/31/2020 EPS
-1.62
JWN
4/30/2020 EPS
-2.23
JWN
1/31/2020 EPS
1.42
JWN
10/31/2019 EPS
0.81
JWN
7/31/2019 EPS
0.9
JWN
4/30/2019 EPS
0.23
JWN
1/31/2019 EPS
1.48
JWN
10/31/2018 EPS
0.67
JWN
7/31/2018 EPS
0.95
JWN
4/30/2018 EPS
0.51
JWN
1/31/2018 EPS
1.2
JWN
10/31/2017 EPS
0.71
JWN
7/31/2017 EPS
0.65
JWN
4/30/2017 EPS
0.43
JWN
1/31/2017 EPS
1.27
JWN
10/31/2016 EPS
0.84
JWN
7/31/2016 EPS
0.67
JWN
4/30/2016 EPS
0.26
JWN
1/31/2016 EPS
1.17
Ticker Symbol Period End Date Measure Value
M
10/31/2023 EPS
0.21
M
7/31/2023 EPS
0.26
M
4/30/2023 EPS
0.56
M
1/31/2023 EPS
1.71
M
10/31/2022 EPS
0.52
M
7/31/2022 EPS
1
M
4/30/2022 EPS
1.08
M
1/31/2022 EPS
2.45
M
10/31/2021 EPS
1.23
M
7/31/2021 EPS
1.29
M
4/30/2021 EPS
0.39
M
1/31/2021 EPS
0.8
M
10/31/2020 EPS
-0.19
M
7/31/2020 EPS
-0.81
M
4/30/2020 EPS
-2.03
M
1/31/2020 EPS
2.12
M
10/31/2019 EPS
0.07
M
7/31/2019 EPS
0.28
M
4/30/2019 EPS
0.44
M
1/31/2019 EPS
2.73
M
10/31/2018 EPS
0.27
M
7/31/2018 EPS
0.7
M
4/30/2018 EPS
0.48
M
1/31/2018 EPS
2.82
M
10/31/2017 EPS
0.23
M
7/31/2017 EPS
0.48
M
4/30/2017 EPS
0.24
M
1/31/2017 EPS
2.02
M
10/31/2016 EPS
0.17
M
7/31/2016 EPS
0.54
M
4/30/2016 EPS
0.4
M
1/31/2016 EPS
2.09
Ticker Symbol Period End Date Measure Value
TGT
10/31/2023 EPS
2.1
TGT
7/31/2023 EPS
1.8
TGT
4/30/2023 EPS
2.05
TGT
1/31/2023 EPS
1.89
TGT
10/31/2022 EPS
1.54
TGT
7/31/2022 EPS
0.39
TGT
4/30/2022 EPS
2.19
TGT
1/31/2022 EPS
3.19
TGT
10/31/2021 EPS
3.03
TGT
7/31/2021 EPS
3.64
TGT
4/30/2021 EPS
3.69
TGT
1/31/2021 EPS
2.67
TGT
10/31/2020 EPS
2.79
TGT
7/31/2020 EPS
3.38
TGT
4/30/2020 EPS
0.59
TGT
1/31/2020 EPS
1.69
TGT
10/31/2019 EPS
1.36
TGT
7/31/2019 EPS
1.82
TGT
4/30/2019 EPS
1.53
TGT
1/31/2019 EPS
1.53
TGT
10/31/2018 EPS
1.09
TGT
7/31/2018 EPS
1.47
TGT
4/30/2018 EPS
1.32
TGT
1/31/2018 EPS
1.37
TGT
10/31/2017 EPS
0.91
TGT
7/31/2017 EPS
1.23
TGT
4/30/2017 EPS
1.21
TGT
1/31/2017 EPS
1.45
TGT
10/31/2016 EPS
1.04
TGT
7/31/2016 EPS
1.23
TGT
4/30/2016 EPS
1.29
TGT
1/31/2016 EPS
1.52
Ticker Symbol Period End Date Measure Value
ULTA
10/31/2023 EPS
5.07
ULTA
7/31/2023 EPS
6.02
ULTA
4/30/2023 EPS
6.88
ULTA
1/31/2023 EPS
6.68
ULTA
10/31/2022 EPS
5.34
ULTA
7/31/2022 EPS
5.7
ULTA
4/30/2022 EPS
6.3
ULTA
1/31/2022 EPS
5.41
ULTA
10/31/2021 EPS
3.94
ULTA
7/31/2021 EPS
4.56
ULTA
4/30/2021 EPS
4.07
ULTA
1/31/2021 EPS
3.41
ULTA
10/31/2020 EPS
1.64
ULTA
7/31/2020 EPS
0.73
ULTA
4/30/2020 EPS
-1.05
ULTA
1/31/2020 EPS
3.89
ULTA
10/31/2019 EPS
2.25
ULTA
7/31/2019 EPS
2.76
ULTA
4/30/2019 EPS
3.26
ULTA
1/31/2019 EPS
3.61
ULTA
10/31/2018 EPS
2.18
ULTA
7/31/2018 EPS
2.46
ULTA
4/30/2018 EPS
2.7
ULTA
1/31/2018 EPS
2.75
ULTA
10/31/2017 EPS
1.75
ULTA
7/31/2017 EPS
1.83
ULTA
4/30/2017 EPS
1.91
ULTA
1/31/2017 EPS
2.24
ULTA
10/31/2016 EPS
1.4
ULTA
7/31/2016 EPS
1.43
ULTA
4/30/2016 EPS
1.45
ULTA
1/31/2016 EPS
1.69
Ticker Symbol Period End Date Measure Value
WMT
10/31/2023 EPS
1.53
WMT
7/31/2023 EPS
1.84
WMT
4/30/2023 EPS
1.47
WMT
1/31/2023 EPS
1.71
WMT
10/31/2022 EPS
1.5
WMT
7/31/2022 EPS
1.77
WMT
4/30/2022 EPS
1.3
WMT
1/31/2022 EPS
1.53
WMT
10/31/2021 EPS
1.45
WMT
7/31/2021 EPS
1.78
WMT
4/30/2021 EPS
1.69
WMT
1/31/2021 EPS
1.46
WMT
10/31/2020 EPS
1.34
WMT
7/31/2020 EPS
1.56
WMT
4/30/2020 EPS
1.18
WMT
1/31/2020 EPS
1.38
WMT
10/31/2019 EPS
1.16
WMT
7/31/2019 EPS
1.27
WMT
4/30/2019 EPS
1.13
WMT
1/31/2019 EPS
1.41
WMT
10/31/2018 EPS
1.08
WMT
7/31/2018 EPS
1.29
WMT
4/30/2018 EPS
1.14
WMT
1/31/2018 EPS
1.33
WMT
10/31/2017 EPS
1
WMT
7/31/2017 EPS
1.08
WMT
4/30/2017 EPS
1
WMT
1/31/2017 EPS
1.3
WMT
10/31/2016 EPS
0.98
WMT
7/31/2016 EPS
1.07
WMT
4/30/2016 EPS
0.98
WMT
1/31/2016 EPS
1.49