ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Stock Valuation--Zero or Constant Dividend Growth
2
3
Current Dividend (Do)
$0.00
4
Dividend Growth Rate
0.00%
5
Required Rate of Return
0.00%
6
Stock Price
#DIV/0!
7
8
Stock Valuation--Nonconstant Dividend Growth
9
10
Current Dividend (Do)
$0.00
11
Required Rate of Return
0.00%
12
Constant Growth Rate
0.00%
13
Super-Normal Growth
14
YearGrowth RateDividend
Present Value of Dividend
15
10.00%$0.00 $0.00
16
20.00%$0.00 $0.00
17
30.00%$0.00 $0.00
18
40.00%$0.00 $0.00
19
50.00%$0.00 $0.00
20
60.00%$0.00 $0.00
21
70.00%$0.00 $0.00
22
80.00%$0.00 $0.00
23
90.00%$0.00 $0.00
24
100.00%$0.00 $0.00
25
Present Value of Dividends
$0.00
26
Year 10 Stock Price
#DIV/0!
27
Present Value of Year 10 Stock Price
#DIV/0!
28
Current Stock Price
#DIV/0!
29
30
Implied Dividend Growth--Constant Dividend Growth
31
32
Current Dividend (Do)
$0.00
33
Stock Price
$0.00
34
Required Rate of Return
0.00%
35
Dividend Growth Rate
#DIV/0!
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