ABCDEFGHIJKLMNOPQRSTUVWXYZAAAB
1
Some helpful tips
2
1. Put the companies in alphabetical order by ticker
3
2. A good site for data is stockrow.com but check against the investor relations page to make sure it lines up
4
3. If the company has the data, do the last 10 years if you can of revenue, gross profit, operating income and free cash flow (cash from ops - capex)
5
4. If the company doesn't have 10 years, just do as far back as you can
6
5. Please copy the format. To start a new tab, just duplicate the tab closest in the alphabet to the company you want to include.
7
6. For example, if I wanted to do Apple, I'd right-click duplicate on AAL and then delete AAL's numbers but I'd still have the same format
8
7. Please fix any mistakes you see, make this your own! There will likely be some mistakes.
9
8. The next tab "List" includes a snapshot of important data points. You can add to that by going to the cell and clicking = and then navigating to the respective tab with the data
10
11
12
13
14
List of Companies (so you don't do one that has already been done)
15
AALAmerican Airlines
16
ACGLArch Capital Group
17
AFLAflac
18
ANSSAnsys
19
AZOAutoZone
20
BAMBrookfield Asset Management
21
BDXBecton Dickinson
22
BF.BBrown Forman
23
BRBroadridge
24
CERNCerner
25
CHDChurch and Dwight
26
CIGIColliers
27
CHRWCH Robinson
28
CKPTCheckpoint
29
CLXClorox
30
CMSCAComcast
31
DGDollar General
32
DLRDigital Realty
33
DLTRDollar Tree
34
EBAYeBay
35
ECLEcoLab
36
EXPDExpeditors
37
FDSFactSet
38
FASTFastenal
39
GILDGilead
40
GLWCorning
41
GL Globe Life
42
HASHasbro
43
HRLHormel
44
HSYHershey
45
JNJJohnson and Johnson
46
LSTRLandStar
47
LUVSouthwest
48
MDTMedtronic
49
MKLMarkel
50
MIDDMiddleby
51
MNSTMonster
52
MSFTMicrosoft
53
NVRNVR Homes
54
ODFLOld Dominion
55
ORLYO'Reiily
56
PGProctor and Gamble
57
POOLPool Corp
58
RMDResMed
59
SAVESpirit
60
SCLStepan
61
SLGNSilgan
62
SNAPSnap
63
TAT&T
64
TJXTJ Maxx
65
TGTTarget
66
TMUST-Mobile
67
TREXTrex
68
TWTRTwitter
69
UNPUnion Pacific
70
VZVerizon
71
WFCWells Fargo
72
WSOWatsco
73
XPOXPO Logisitics
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