Company Analysis Spreadsheet

Still loading...

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z
1
2		UKValueInvestor.com Company Analysis Spreadsheet 2016 Instructions: Choose the standard, insurance or bank worksheet depending on the type of company you're analysing. Look at the example worksheets to get an idea of how they work. Fill in the grey boxes with data for the company you're analysing (company name, revenue, earnings per share etc). Check that the various factors (e.g. Growth Rate) are within the various minimum and maximum values, i.e. coloured green. Check that the defensive and value factors are good enough relative to the FTSE 100. If they are then you may want to analyse the company further using the Company Analysis Questions document. If you have any problems or if you find any errors please send an email to: john@ukvalueinvestor.com
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