Market	Security	ri	risk	"CorrelationA,B"								
I	A	0.22	0.3	0.15								
	B	0.31	0.32									
II	A	0.26	0.29	-0.06								
	B	0.34	0.33									
III	A	0.18	0.2	0.09								
	B	0.41	0.38									
												
Market I	Cov_M											
		0.09	0.0144									
		0.0144	0.1024									
							VRS					
	2*CM	0.18	0.0288	1	0.22		0					
		0.0288	0.2048	1	0.31		0					
		1	1	0	0		1					
		0.22	0.31	0	0		0.3					
	Inv_M						wi					
		0	2.52323E-15	3.444444444	-11.11111111	1	0.111111111					
		0	-2.52323E-15	-2.444444444	11.11111111	2	0.888888889					
		3.444444444	-2.444444444	-2.874320988	10.56691358	lambda1	0.295753086					
		-11.11111111	11.11111111	10.56691358	-40.39506173	lambda2	-1.551604938					
												
						proof	1		Rp	0.3	Var_p	0.084864198
									Sigma_P	0.291314602		
												
												
Market II	Cov_M											
		0.0841	-0.005742									
		-0.005742	0.1089									
							VRS					
	2*CM	0.1682	-0.011484	1	0.26		0					
		-0.011484	0.2178	1	0.34		0					
		1	1	0	0		1					
		0.26	0.34	0	0		0.3					
	Inv_M						wi					
		0	-3.8737E-15	4.25	-12.5	1	0.5					
		0	3.8737E-15	-3.25	12.5	2	0.5					
		4.25	-3.25	-5.6558705	18.860375	lambda1	0.002242					
		-12.5	12.5	18.860375	-63.90125	lambda2	-0.31					
												
						proof	1		Rp	0.3	Var_p	0.045379
									Sigma_P	0.213023473		
												
												
Market III	Cov_M											
		0.04	0.00684									
		0.00684	0.1444									
							VRS					
	2*CM	0.08	0.01368	1	0.18		0					
		0.01368	0.2888	1	0.41		0					
		1	1	0	0		1					
		0.18	0.41	0	0		0.3					
	Inv_M						wi					
		0	8.07083E-16	1.782608696	-4.347826087	1	0.47826087					
		0	-8.07083E-16	-0.782608696	4.347826087	2	0.52173913					
		1.782608696	-0.782608696	-0.392929149	1.450147448	lambda1	0.042115085					
		-4.347826087	4.347826087	1.450147448	-6.454442344	lambda2	-0.486185255					
												
						proof	1		Rp	0.3	Var_p	0.051870246
									Sigma_P	0.227750402		
##### Sheet/List 2 #####
					beta_i	
					1	1.235
Rm	14				2	0.268
Rf	6				3	1.997
					4	2.45
ri						
1	15.88					
2	8.144					
3	21.976					
4	25.6					
##### Sheet/List 3 #####
Year							
1	10	9	22	0.666666667	5	defensive	aggresive
2	32	24	48	0.68	1.64	defensive	aggresive
3	20	14	30	0.538461538	1.769230769	defensive	aggresive
4	18	-2	-20	-0.818181818	-2.454545455	defensive	aggresive
5	17	16	29	0.9	2.2	defensive	aggresive
6	3	4	-3	0.75	2.5	defensive	aggresive
7	12	8	21	0.2	2.8	defensive	aggresive
8	-5	0	-15	0.583333333	1.833333333	defensive	aggresive
9	18	12	28	0.454545455	1.909090909	defensive	aggresive
10	21	15	36	0.571428571	2.071428571	defensive	aggresive
	105.3777778	61.44444444	166.3777778				
		beta_1	beta_2				
E(rm)	14.6	0.583087305	1.578869675				
							
E(ri)	11.43146352						
E(rj)	18.99940953