Dividend modelling

	A	B	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z
1	https://sleepyinvestor.blogspot.com/					year 1	year 2	year 3	year 4	year 5	year 6	year 7	year 8	year 9	year 10	year 11	year 12	year 13	year 14	year 15	year 16	year 17	year 18	year 19	year 20
2	https://sleepyinvestor.blogspot.com/			new capital		10000	10000	10000	10000	10000	10000	10000	10000	10000	10000	10000	10000	10000	10000	10000	10000	10000	10000	10000	10000
3				dividend capital			300.00	624.00	973.92	1351.83	1759.98	2200.78	2676.84	3190.99	3746.27	4345.97	4993.65	5693.14	6448.59	7264.48	8145.63	9097.28	10125.07	11235.07	12433.88
4
5			total dividend		yield	dividends	dividends	dividends	dividends	dividends	dividends	dividends	dividends	dividends	dividends	dividends	dividends	dividends	dividends	dividends	dividends	dividends	dividends	dividends	dividends
6	starting yield	3.00%	300.00	year 1	3.00%	300.00
7	annual yield growth	5.00%	624.00	year 2	3.15%	315.00	309.00
8			973.92	year 3	3.31%	330.75	324.45	318.72
9	annual capital	10000	1351.83	year 4	3.47%	347.29	340.67	334.66	329.22
10			1759.98	year 5	3.65%	364.65	357.71	351.39	345.68	340.56
11	year 20 income	13728.59	2200.78	year 6	3.83%	382.88	375.59	368.96	362.96	357.58	352.80
12	year 20 income	13728.59	2676.84	year 7	4.02%	402.03	394.37	387.41	381.11	375.46	370.44	366.02
13			3190.99	year 8	4.22%	422.13	414.09	406.78	400.17	394.23	388.96	384.32	380.31
14			3746.27	year 9	4.43%	443.24	434.79	427.12	420.17	413.95	408.41	403.54	399.32	395.73
15			4345.97	year 10	4.65%	465.40	456.53	448.47	441.18	434.64	428.83	423.72	419.29	415.52	412.39
16			4993.65	year 11	4.89%	488.67	479.36	470.89	463.24	456.38	450.27	444.90	440.25	436.29	433.01	430.38
17			5693.14	year 12	5.13%	513.10	503.33	494.44	486.40	479.20	472.78	467.15	462.26	458.11	454.66	451.90	449.81
18			6448.59	year 13	5.39%	538.76	528.49	519.16	510.72	503.15	496.42	490.51	485.38	481.01	477.39	474.49	472.30	470.79
19			7264.48	year 14	5.66%	565.69	554.92	545.12	536.26	528.31	521.25	515.03	509.65	505.06	501.26	498.22	495.91	494.33	493.46
20			8145.63	year 15	5.94%	593.98	582.67	572.38	563.07	554.73	547.31	540.78	535.13	530.32	526.32	523.13	520.71	519.05	518.13	517.93
21			9097.28	year 16	6.24%	623.68	611.80	600.99	591.23	582.46	574.67	567.82	561.88	556.83	552.64	549.28	546.75	545.00	544.04	543.83	544.37
22			10125.07	year 17	6.55%	654.86	642.39	631.04	620.79	611.59	603.41	596.21	589.98	584.67	580.27	576.75	574.08	572.25	571.24	571.02	571.59	572.92
23			11235.07	year 18	6.88%	687.61	674.51	662.60	651.83	642.17	633.58	626.02	619.48	613.91	609.28	605.59	602.79	600.87	599.80	599.57	600.17	601.56	603.75
24			12433.88	year 19	7.22%	721.99	708.23	695.73	684.42	674.28	665.26	657.33	650.45	644.60	639.75	635.87	632.93	630.91	629.79	629.55	630.18	631.64	633.94	637.05
25			13728.59	year 20	7.58%	758.09	743.65	730.51	718.64	707.99	698.52	690.19	682.97	676.83	671.74	667.66	664.57	662.45	661.28	661.03	661.68	663.22	665.64	668.90	673.02
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