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									
												
E®=30%												
Market I	CM											
	0.09	0.0144										
	0.0144	0.1024										
											0.111111111	0.888888889
						VFS			0.111111111			
	0.18	0.0288	1	0.22		0			0.888888889		0.001111111	0.001422222
	0.0288	0.2048	1	0.31		0					0.001422222	0.080908642
	1	1	0	0		1						
	0.22	0.31	0	0		0.3					0.084864198	
												
						W(I)		R(P)	VAR(P)	Sigma(p)		
	0	2.52323E-15	3.444444444	-11.11111111		0.111111111		0.3	0.084864198	0.291314602		
	0	-2.52323E-15	-2.444444444	11.11111111		0.888888889						
	3.444444444	-2.444444444	-2.874320988	10.56691358		0.295753086						
	-11.11111111	11.11111111	10.56691358	-40.39506173		-1.551604938						
												
												
					proof	1						
												
Market II	CM											
	0.0841	-0.005742										
	-0.005742	0.1089										
											0.5	0.5
						VFS			0.5			
	0.1682	-0.011484	1	0.26		0			0.5		0.021025	-0.0014355
	-0.011484	0.2178	1	0.34		0					-0.0014355	0.027225
	1	1	0	0		1						
	0.26	0.34	0	0		0.3					0.045379	
												
						W(I)		R(P)	VAR(P)	Sigma(p)		
	0	-3.8737E-15	4.25	-12.5		0.5		0.3	0.045379	0.213023473		
	0	3.8737E-15	-3.25	12.5		0.5						
	4.25	-3.25	-5.6558705	18.860375		0.002242						
	-12.5	12.5	18.860375	-63.90125		-0.31						
												
												
					proof	1						
												
Market III	CM											
	0.09	0.00684										
	0.00684	0.1444										
											0.47826087	0.52173913
						VFS			0.47826087			
	0.18	0.01368	1	0.18		0			0.52173913		0.004782609	0.002907826
	0.01368	0.2888	1	0.41		0					0.000396522	0.066968116
	1	1	0	0		1						
	0.18	0.41	0	0		0.3					0.075055072	
												
						W(I)		R(P)	VAR(P)	Sigma(p)		
	8.07083E-16	-8.07083E-16	1.782608696	-4.347826087		0.47826087		0.3	0.075055072	0.273961808		
	-8.07083E-16	8.07083E-16	-0.782608696	4.347826087		0.52173913						
	1.782608696	-0.782608696	-0.710698526	2.225194707		-0.043140113						
	-4.347826087	4.347826087	2.225194707	-8.344801512		-0.278245747						
												
												
					proof	1						
##### Sheet/List 2 #####
rm	0.14		
rf	0.06		
			beta_i
r1	0.1588		1.235
r2	0.08144		0.268
r3	0.21976		1.997
r4	0.256		2.45
##### Sheet/List 3 #####
Year											
1	10	9	22	0.666666667	5	Defensive	Agressive				
2	32	24	48	0.68	1.64	Defensive	Agressive				
3	20	14	30	0.538461538	1.769230769	Defensive	Agressive				
4	18	-2	-20	-0.818181818	-2.454545455	Defensive	Agressive				
5	17	16	29	0.9	2.2	Defensive	Agressive				
6	3	4	-3	0.75	2.5	Defensive	Agressive				
7	12	8	21	1	2.8	Neutral	Agressive				
8	-5	0	-15	0.583333333	1.833333333	Defensive	Agressive				
9	18	12	28	0.454545455	1.909090909	Defensive	Agressive				
10	21	15	36	0.571428571	2.071428571	Defensive	Agressive				
	14.6	10	17.6			Agressive					
									105.3777778	61.44444444	166.3777778
		covar	105.3777778	61.44444444	166.3777778					0.583087305	1.578869675
		Var(M)	105.3777778								
			beta_i	0.583087305	1.578869675				ri	11.43146352	
									rj	18.99940953	
		beta_10									
rf=7	7										
ri	9										
	24										
	14										
	-2										
	16										
	4										
	12										
	0										
	12										
	15