ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Class 18 of Valuation
2
High GrowthStable Growth
3
Expected Growth Rate
15%1.50%
4
Payout Ratio25%92.50%
(based on ROE of 20%)
5
Beta11
6
#of years5foreverafter year 5
7
8
Rfr1.50%
9
ERP5%
10
Required rate of return
6.50%
11
12
Deconstructed PE (x)
1.58
<= E4*(1+E3)*(1-((1+E3)^E6)/((1+F10)^5))/(F10-E3)
13
27.57
<= (F4*((1+E3)^E6)*(1+F3))/((F10-F3)*((1+F10)^E6))
14
Combined PE (x)
29.15
15
16
17
18
Save this spreadsheet into your own drive to test the variables out.
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