AMT REIT Investment

Still loading...

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V
1	Quarter	0	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20
2	Stock Price	$131.19	$135.26	$139.46	$143.78	$148.24	$152.84	$157.59	$162.48	$167.52	$172.71	$178.07	$183.60	$189.29	$195.17	$201.22	$207.47	$213.90	$220.54	$227.38	$234.44	$241.71
3	Investment	-$9,997
4	Dividend Per Share		$0.65	$0.68	$0.71	$0.75	$0.78	$0.82	$0.86	$0.90	$0.94	$0.99	$1.03	$1.08	$1.14	$1.19	$1.25	$1.31	$1.37	$1.43	$1.50	$1.57
5	Dividend		$49	$52	$54	$57	$60	$62	$65	$69	$72	$75	$79	$83	$86	$91	$95	$99	$104	$109	$114	$120
6	Sale																					$18,418
7	Cash Flow	-$9,997	$49	$52	$54	$57	$60	$62	$65	$69	$72	$75	$79	$83	$86	$91	$95	$99	$104	$109	$114	$18,538
8	Quarterly IRR	3.68%
9
10	Year	0	1	2	3	4	5
11	Stock Price	$131.19	$148.24	$167.52	$189.29	$213.90	$241.71
12	Investment	-$9,997
13	Dividend Per Share		$2.79	$3.36	$4.05	$4.88	$5.87
14	Dividend		$213	$256	$308	$371	$447
15	Sale						$18,418
16	Cash Flow	-$9,997	$213	$256	$308	$371	$18,866
17	IRR	15.42%
18
19	Assumptions
20	Desired Amount	$10,000
21	Price per Share	$131.2
22	Shares	76
23	Actual Amount	$9,997
24	Holding Period	5 years
25	Annual Share Price Growth	13.00%
26	Quarterly Share Price Growth	3.10%
27	Quarterly Divedend growth	4.76%
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