EDU 042020 DDM

	A	B	C	D	E	F	G	H	I	J	K
1	hi everyone :) i see many people are using it! add oil.
2	to use it: download it and open with excel :)
3	disclaimer: Note that it's a very basic formula with lots of assumptions behind. This is purely to calculate a right price for yourself and it is not the market price. But it would give you a general view of what you are investing
4
5	KO
6	dividend	0.88	0.94	1.02	1.12	1.22	1.32	1.4	1.48	1.56	1.6
7			6.82%	8.51%	9.80%	8.93%	8.20%	6.06%	5.71%	5.41%	2.56%
8	g	6.87%
9	r	2.90%
10	k	5%
11
12	P'
13	165.7230589
14
15	VZ
16	dividend	1.93	1.98	2.03	2.09	2.16	2.23	2.29	2.33	2.38	2.44
17			2.59%	2.53%	2.96%	3.35%	3.24%	2.69%	1.75%	2.15%	2.52%
18	g	2.64%
19	r	4.84%
20	k	5%
21
22	P'
23	34.78121071
24
25	HD
26	dividend	0.9	0.94	1.04	1.16	1.56	1.88	2.36	2.76	3.56	4.12
27			4.44%	10.64%	11.54%	34.48%	20.51%	25.53%	16.95%	28.99%	15.73%
28	g	18.41%
29	r	2.30%
30	k	5%
31
32	P'
33	-43.8935447
34
35	HH
36	dividend	108000	108000	114000	114000	126000	162000	174000	216000	216000	204000
37			0.00%	5.56%	0.00%	10.53%	28.57%	7.41%	24.14%	0.00%	-5.56%
38	g	7.32%
39	r	1.77%
40	k	7%
41
42	P'
43	15,122,157.71
44
45	5
46	dividend	0.35	0.42	0.41	0.48	0.49	0.5	0.51	0.51	0.51	0.51
47			20.00%	-2.38%	17.07%	2.08%	2.04%	2.00%	0.00%	0.00%	0.00%
48	g	0.00%
49	r	10.00%
50	k	3%
51
52	P'
53	31.824
54
55	Maybank
56	dividend	0.54	0.61	0.72	0.76	0.74	0.72	0.68	0.72	0.74	0.73
57			12.96%	18.03%	5.56%	-2.63%	-2.70%	-5.56%	5.88%	2.78%	-1.35%
58	g	3.41%
59	r	7.77%
60	k	3%
61
62	P'
63	11.00
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