CompanyValuationSpreadsheet

	A	B	C	D	E	F	G	H	I	J	K
1	To Edit the spreadsheet click on File > Make a Copy
2
3				Share price at time of Calculation
4	Company Name	xvvx		100.00				Bargain
5	EPS (T12M)	2.12						Undervalued
6	Growth Rate	12.00%						Fair price
7	Minimum Rate of Return	12%						Overvalued
8	Margin of Safety	30%
9	P/E (T12M)	23
10
11
12		Year 1	Year 2	Year 3	Year 4	Year 5	Year 6	Year 7	Year 8	Year 9	Year 10
13	Expected EPS Growth	2.12	2.37	2.66	2.98	3.34	3.74	4.18	4.69	5.25	5.88
14	Expected Price Target	48.76	54.61	61.16	68.50	76.72	85.93	96.24	107.79	120.73	135.22
15
16	10 Year Price Target	135.22
17	Fair Value Today	48.76
18	Fair Value with MoS	34.13
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