YieldCompass_Dividend_Tracker.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L
1	YieldCompass – Dividend Portfolio Tracker
2	Portfolio Overview \| yieldcompass.io
3
4	Ticker	Company Name	Sector	Country	Shares	Avg. Buy Price (€)	Current Price (€)	Total Cost (€)	Current Value (€)	Div/Share (€)	Annual Income (€)	Yield on Cost (%)
5	ASML	ASML Holding	Technology	Netherlands	10	650		6.500,00		6	60,00	0,92%
6	UNA	Unilever	Consumer Staples	United Kingdom	50	42		2.100,00		1,85	92,50	4,40%
7	ALV	Allianz	Financials	Germany	20	230		4.600,00		11,4	228,00	4,96%
8	NOVN	Novartis	Healthcare	Switzerland	30	88		2.640,00		3,5	105,00	3,98%
9	ENGI	Engie	Utilities	France	100	14		1.400,00		0,97	97,00	6,93%
10
11
12
13
14
15	PORTFOLIO TOTALS							17.240,00	0,00		582,50
16
17	Legend:		Blue cells = Input data (you fill these in)
18			Grey cells = Calculated automatically
19			Green cells = Key output (income, yield on cost)
20
21
22
23
24
25
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