Company Review Spreadsheet

	B	C
1
2	UKDividendStocks.com
3	Company Review Spreadsheet
4
5	IMPORTANT: You cannot edit this spreadsheet
6	Please make a copy by following these steps:
7	Note: If you're using a mobile device this spreadsheet will usually look better on the Google Sheets app.
8
9	Copy the entire spreadsheet:
10	1	Log into your Google account (or create one if you don't have one)
11	2	Click on File > Make a copy...
12	3	Save and edit your copy of the spreadsheet
13	Copy a template worksheet:
14	1	Log into your Google account (or create one if you don't have one)
15	2	Right-click on the template you want to copy (standard, insurer or bank)
16	3	Select Copy to New / Existing Spreadsheet
17	4	Save and edit your copy of the template
18	Download as an Excel spreadsheet:
19	1	Click on File > Download as > Microsoft Excel
20	2	Download and edit your copy of the spreadsheet
21
22	Purpose:
23	This spreadsheet calculates most of the company analysis ratios and related metrics from my book, The Defensive Value Investor.
24
25	Notes:
26	Enter data into cells with a yellow background.
27
28	Where to find financial data:
29	To fill in the spreadsheet you'll need ten years of financial data for the company.
30	I get my data from ShareScope, but there are other services such as Morningstar Premium.
31	If you sign up to ShareScope using this affiliate link, they'll give you one month free:
32	ShareScope signup with one month free
33
34	Disclaimer, Terms and Conditions:
35	You use this spreadsheet at your own risk and there are no guarantees that this spreadsheet is free from errors.
36	For more details read:
37	Full Disclaimer
38	Terms & Conditions
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