Company Review Spreadsheet
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZAA
1
2
UK Value Investor Company Review Spreadsheet
3
4
IMPORTANT: You cannot edit this spreadsheet
5
Please make a copy by following these steps:
6
7
Google Sheets copy:
8
1
Log into your Google account (if you don't have a Google account it only takes a minute to create one)
9
2
Create a copy of the spreadsheet by clicking on File > Make a copy...
10
3
Edit your copy of the spreadsheet.
11
MS Excel copy:
12
1
Download as an Excel file by clicking on File > Download as > Microsoft Excel
13
2
Edit the downloaded copy of the spreadsheet.
14
15
Purpose:
16
17
This spreadsheet calculates most of the company analysis ratios and related metrics from the book, The Defensive Value Investor.
18
19
Notes:
20
Enter data into cells with a yellow background.
21
22
Free Data:
23
To fill in the spreadsheet you'll need ten years of financial data for the company.
24
If you don't have access to that data (i.e. you aren't subscribed to a paid data service like SharePad or Morningstar Premium) then here are a few sources of free data:
25
26
Investegate.co.uk:
27
Investegate has ten years of free income statement data for most companies.
28
E.g.
29
Ten years of income data for XP Power
30
31
Morningstar:
32
Morningstar has five years of balance sheet and cash flow statement data for most companies.
33
E.g.
34
Five years of balance sheet data for XP Power
35
Five years of cash flow data for XP Power
36
37
Disclaimer, Terms and Conditions:
38
Obviously you use this spreadsheet at your own risk and we cannot guarantee that the spreadsheet is free from errors or that it will make you a millionaire overnight.
39
For more details read:
40
Full disclaimer
41
Terms & Conditions
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
Loading...