ABCDEFGHIJKLMNOPQRSTUVWX
1
AAPL
2
Auto DDRMManual DDRM
3
Dividend Rate ($)#N/ADividend Rate ($)#N/A
4
Divided by: share price166.9Divided by: share price166.90
5
Current yield (%)#N/ACurrent yield (%)#N/A
6
Core Growth Estimate (%)8.00Core Growth Estimate (%)8.00
7
Divided by: ROE (%)Cash RatioDivided by: ROE (%)22.00
8
Multiplied by: EPS ($)#N/AMultiplied by: EPS ($)8.65
9
Cost of Growth (%)#VALUE!Cost of Growth (%)3.15
10
Earnings per Share ($)#N/AEarnings per Share ($)8.65
11
Minus: Dividend#N/AMinus: Dividend#N/A
12
Minus: Cost of Growth#VALUE!Minus: Cost of Growth3.15
13
Funding Gap ($)#N/AFunding Gap ($)#N/A
14
Divided by: Share Price ($)166.9Divided by: Share Price ($)166.90
15
Share Change (%)#N/AShare Change (%)#N/A
16
Core Growth (%)8.00Core Growth (%)8.00
17
Plus: Share Change (%)#N/APlus: Share Change (%)#N/A
18
Total Dividend Growth (%)#N/ATotal Dividend Growth (%)#N/A
19
Plus: Dividend Yield (%)#N/APlus: Dividend Yield (%)#N/A
20
Projected Total Return (%)
#N/A
Projected Total Return (%)
#N/A
21
22
Dividend Rate ($)#N/ADividend Rate ($)#N/A
23
Required Return (%)10.00Required Return (%)12.00
24
Div Growth (%)#N/ADiv Growth (%)#N/A
25
Price#N/APrice#N/A
26
27
Dividend Rate ($)#N/ADividend Rate ($)#N/A
28
Required Return (%)16.00Required Return (%)12.00
29
Est Growth (%)15.00Est Growth (%)8.00
30
Price#N/APrice#N/A
31
32
Average#N/AAverage#N/A
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