pohatta_osinko_vs_indeksi.xlsx

	A	B	C	D	E	F	G	I	J	K	L	M	N	W	X	Y	Z	AA	AB	AD	AE	AF	AG	AH	AI	AQ	AR	AS
1		KASVAVIEN OSINKOJEN SALKKU												INDEKSIRAHASTOSALKKU
2		Alkusijoitus		10000										Alkusijoitus		10000
3		Hallinnointi		0.00%										Hallinnointi		0.56%
4		Osingon kasvu		8.00%										Arvon nousu		5.20%
5		Arvon nousu		8.00%										Osingon kasvu		5.20%
6		Osinkotuotto alussa		3.50%										Osinkotuotto alussa		2.80%
7		Osinkovero		25.50%										Lähdevero		15.00%
8		Välityspalkkio		0.03%										Välityspalkkio		0.00%
9		Uudelleen sijoitus		kyllä	* Kyllä, Ei									Uudelleen sijoitus		kyllä	* Kyllä, Ei
10		Kokonaistuotto		11.50%										Kokonaistuotto		8.00%											Kuva
11
12		arvo alussa	lkm	hinta		hinta lopussa	arvo ennen osinkojen uud. Sij.	osinko/ osake	osinkotuotto	välitys- palkkio	hallinnointi- palkkio	ostetut osakkeet	arvo lopussa	arvo alussa	lkm	hinta		hinta lopussa	arvo ennen osinkojen uud. Sij.	osinko/ osuus	osinkotuotto	välitys- palkkio	hallinnointi- palkkio	ostetut osuudet	arvo lopussa		Osinko	Indeksi
13	1	9997.00	99.97	100.00		108.00	10796.76	2.61	260.67	0.078	0.000	2.413	11057.35	10000.00	100.00	100.00		105.20	10520.00	2.38	238.00	0.000	58.912	1.702	10699.09	1	11057.35	10699.09
14	2	11057.35	102.3829	108.00		116.64	11941.94	2.82	288.32	0.086	0.000	2.471	12230.18	10699.09	101.7024	105.20		110.67	11255.44	2.50	254.64	0.000	63.030	1.731	11447.05	2	12230.18	11447.05
15	3	12230.18	104.8540	116.64		125.97	13208.59	3.04	318.90	0.096	0.000	2.531	13527.40	11447.05	103.4337	110.67		116.43	12042.29	2.63	272.44	0.000	67.437	1.761	12247.30	3	13527.40	12247.30
16	4	13527.40	107.3848	125.97		136.05	14609.59	3.28	352.73	0.106	0.000	2.592	14962.21	12247.30	105.1945	116.43		122.48	12884.16	2.77	291.49	0.000	72.151	1.791	13103.49	4	14962.21	13103.49
17	5	14962.21	109.9767	136.05		146.93	16159.19	3.55	390.14	0.117	0.000	2.654	16549.21	13103.49	106.9853	122.48		128.85	13784.87	2.92	311.86	0.000	77.195	1.821	14019.54	5	16549.21	14019.54
18	6	16549.21	112.6311	146.93		158.69	17873.14	3.83	431.52	0.129	0.000	2.718	18304.54	14019.54	108.8066	128.85		135.55	14748.56	3.07	333.67	0.000	82.592	1.852	14999.63	6	18304.54	14999.63
19	7	18304.54	115.3496	158.69		171.38	19768.90	4.14	477.29	0.143	0.000	2.784	20246.05	14999.63	110.6588	135.55		142.60	15779.61	3.23	356.99	0.000	88.366	1.884	16048.24	7	20246.05	16048.24
20	8	20246.05	118.1337	171.38		185.09	21865.73	4.47	527.92	0.158	0.000	2.851	22393.49	16048.24	112.5427	142.60		150.01	16882.74	3.39	381.95	0.000	94.543	1.916	17170.15	8	22393.49	17170.15
21	9	22393.49	120.9850	185.09		199.90	24184.97	4.83	583.91	0.175	0.000	2.920	24768.70	17170.15	114.4585	150.01		157.81	18063.00	3.57	408.65	0.000	101.153	1.948	18370.49	9	24768.70	18370.49
22	10	24768.70	123.9052	199.90		215.89	26750.20	5.21	645.84	0.194	0.000	2.991	27395.85	18370.49	116.4070	157.81		166.02	19325.76	3.76	437.22	0.000	108.224	1.982	19654.75	10	27395.85	19654.75
23	11	27395.85	126.8958	215.89		233.16	29587.52	5.63	714.35	0.214	0.000	3.063	30301.65	19654.75	118.3887	166.02		174.65	20676.80	3.95	467.78	0.000	115.790	2.015	21028.79	11	30301.65	21028.79
24	12	30301.65	129.9586	233.16		251.82	32725.78	6.08	790.12	0.237	0.000	3.137	33515.66	21028.79	120.4041	174.65		183.73	22122.29	4.16	500.49	0.000	123.885	2.050	22498.89	12	33515.66	22498.89
25	13	33515.66	133.0953	251.82		271.96	36196.91	6.57	873.92	0.262	0.000	3.212	37070.57	22498.89	122.4538	183.73		193.29	23668.83	4.37	535.47	0.000	132.545	2.085	24071.76	13	37070.57	24071.76
26	14	37070.57	136.3077	271.96		293.72	40036.21	7.09	966.62	0.290	0.000	3.290	41002.54	24071.76	124.5384	193.29		203.34	25323.49	4.60	572.91	0.000	141.812	2.120	25754.59	14	41002.54	25754.59
27	15	41002.54	139.5977	293.72		317.22	44282.74	7.66	1069.14	0.321	0.000	3.369	45351.56	25754.59	126.6585	203.34		213.91	27093.83	4.84	612.96	0.000	151.725	2.156	27555.06	15	45351.56	27555.06
28	16	45351.56	142.9670	317.22		342.59	48979.69	8.27	1182.54	0.355	0.000	3.451	50161.88	27555.06	128.8147	213.91		225.04	28987.93	5.09	655.81	0.000	162.332	2.193	29481.40	16	50161.88	29481.40
29	17	50161.88	146.4177	342.59		370.00	54174.83	8.93	1307.97	0.392	0.000	3.534	55482.40	29481.40	131.0075	225.04		236.74	31014.44	5.36	701.66	0.000	173.681	2.230	31542.41	17	55482.40	31542.41
30	18	55482.40	149.9517	370.00		399.60	59921.00	9.65	1446.70	0.434	0.000	3.619	61367.27	31542.41	133.2378	236.74		249.05	33182.62	5.63	750.71	0.000	185.823	2.268	33747.51	18	61367.27	33747.51
31	19	61367.27	153.5710	399.60		431.57	66276.65	10.42	1600.15	0.480	0.000	3.707	67876.32	33747.51	135.5059	249.05		262.00	35502.38	5.93	803.19	0.000	198.813	2.307	36106.75	19	67876.32	36106.75
32	20	67876.32	157.2776	431.57		466.10	73306.42	11.25	1769.88	0.531	0.000	3.796	75075.77	36106.75	137.8127	262.00		275.62	37984.30	6.24	859.34	0.000	212.712	2.346	38630.93	20	75075.77	38630.93
33	21	75075.77	161.0737	466.10		503.38	81081.83	12.15	1957.60	0.587	0.000	3.888	83038.84	38630.93	140.1588	275.62		289.95	40639.74	6.56	919.42	0.000	227.583	2.386	41331.57	21	83038.84	41331.57
34	22	83038.84	164.9614	503.38		543.65	89681.95	13.13	2165.24	0.650	0.000	3.982	91846.54	41331.57	142.5448	289.95		305.03	43480.82	6.90	983.69	0.000	243.493	2.427	44221.02	22	91846.54	44221.02
35	23	91846.54	168.9430	543.65		587.15	99194.26	14.18	2394.90	0.718	0.000	4.078	101588.44	44221.02	144.9714	305.03		320.89	46520.51	7.26	1052.46	0.000	260.515	2.468	47312.45	23	101588.44	47312.45
36	24	101588.44	173.0206	587.15		634.12	109715.52	15.31	2648.92	0.795	0.000	4.176	112363.64	47312.45	147.4394	320.89		337.58	49772.70	7.64	1126.04	0.000	278.727	2.510	50620.01	24	112363.64	50620.01
37	25	112363.64	177.1967	634.12		684.85	121352.73	16.53	2929.88	0.879	0.000	4.277	124281.74	50620.01	149.9493	337.58		355.14	53252.25	8.03	1204.76	0.000	298.213	2.553	54158.79	25	124281.74	54158.79
38	26	124281.74	181.4736	684.85		739.64	134224.28	17.86	3240.65	0.972	0.000	4.380	137463.95	54158.79	152.5020	355.14		373.60	56975.05	8.45	1288.98	0.000	319.060	2.596	57944.97	26	137463.95	57944.97
39	27	137463.95	185.8537	739.64		798.81	148461.07	19.29	3584.37	1.075	0.000	4.486	152044.36	57944.97	155.0981	373.60		393.03	60958.11	8.89	1379.09	0.000	341.365	2.640	61995.83	27	152044.36	61995.83
40	28	152044.36	190.3395	798.81		862.71	164207.91	20.83	3964.56	1.189	0.000	4.594	168171.28	61995.83	157.7384	393.03		413.47	65219.62	9.35	1475.50	0.000	365.230	2.685	66329.89	28	168171.28	66329.89
41	29	168171.28	194.9336	862.71		931.73	181624.98	22.50	4385.07	1.316	0.000	4.705	186008.73	66329.89	160.4237	413.47		434.97	69779.04	9.84	1578.65	0.000	390.763	2.731	70966.93	29	186008.73	70966.93
42	30	186008.73	199.6386	931.73		1006.27	200889.43	24.29	4850.18	1.455	0.000	4.819	205738.15	70966.93	163.1547	434.97		457.59	74657.21	10.35	1689.01	0.000	418.080	2.777	75928.14	30	205738.15	75928.14
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