Efficient Frontier 4 ETFs.xlsx

	A	B	C	D	E	F	G	H	I	J
1
2
3
4
5	Covariance Table							Returns
6	Gewichtung		0%	0%	8%	92%			Monthly	Annual
7			MSCI World	FTSE 50 China	MSCI EM	S&P 500		MSCI World	0,87%	10,41%
8	0%	MSCI World	0,001210648501	0,001171974673	0,0008381870346	0,001262282852		FTSE 50 China	0,86%	10,32%
9	0%	FTSE 50 China	0,001171974673	0,00299442392	0,001684582013	0,001132981494		MSCI EM	0,52%	6,25%
10	8%	MSCI EM	0,0008381870346	0,001684582013	0,001458411187	0,0008347674649		S&P 500	1,18%	14,17%
11	92%	S&P 500	0,001262282852	0,001132981494	0,0008347674649	0,001448569548
12	100%		0,0000000	0,0000000	0,0000749	0,0012789		Target Return	12,50%	13,50%
13								St. Dev.		12,75%
14
15	Portfolios
16	Return	6,50%	7,50%	8,50%	9,50%	10,50%	11,50%	12,50%	13,50%
17	St. Dev.	12,90%	11,87%	11,37%	11,40%	11,59%	11,86%	12,32%	12,75%
18	MSCI World	6%	30%	54%	55%	34%	12%	0%	0%
19	FTSE 50 China	0%	0%	0%	0%	0%	0%	0%	0%
20	MSCI EM	94%	70%	46%	33%	30%	28%	21%	8%
21	S&P 500	0%	0%	0%	12%	36%	60%	79%	92%
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