Security			Wi 	
S1	0.4	1.85	0.25	3%
S2	-0.5	0.75	0.4	2%
S3	0.67	-0.25	0.35	0.50%
	"= 1,20"	"= 0,80"		
	beta_F1	beta_F2	sigma_F1	Sigma_F2
	1.2	0.8	0.24	0.14
				
beta_i				
1	1.96			
2	0			
3	0.604			
				
sigma_i^2				
1	0.077197			
2	0.025825			
3	0.02710664			
				
sigma_i	0.277843481			
	0.160701587			
	0.164640943			
				
bpi				
bp1	0.1345			
bp2	0.675			
				
var_p	0.010095561			
sigma_p	0.100476668			
##### Sheet/List 2 #####
 																	
   																rf	0.03
 																x	y
", "												F1	F2	F3		0.65	0.35
", "											E(ri)	0.04	0.065	0.09	alfa	0.06	0.09
											bx	0.08	0.4	1.48	sigma_eps	0.14	0.25
", "											by	0.75	0.65	0.59	eps_i	0.025	0.0185
", "											sigma_Fi	0.1	0.095	0.12			
											beta_Fi	1.2	0.56	1.58			
"= 1,20, "																	
"= 0,56, "											E(ri)						
"= 1,58 "											x	0.2474			1.078205387		
											y	0.23385			0.893473021		
																	
											var_i						
											x	0.05264976					
											y	0.068503358					
																	
											sigma_i						
											x	0.229455355					
											y	0.261731462					
																	
											Rp	0.2426575					
																	
											bp1	0.3145					
											bp2	0.4875					
											bp3	1.1685					
																	
											Var_p	0.038732849			1.232974231		
											Sigma_p	0.196806627					
##### Sheet/List 3 #####
		rf	0.06					
		rM	0.12					
				F1	F2		Xa	Xb
sigma_M^2	624		bA	0.75	1.5		0.48	0.52
"cov_F1,M"	256		bB	0.85	1.7			
"cov_F2,M"	850							
beta_F								
beta_F1	0.41025641							
beta_F2	1.362179487							
								
betaA	2.350961538							
betaB	2.664423077							
								
E(ri)								
A	0.201057692							
B	0.219865385							
								
Rp	0.210837692							
								
"sigma_i or sigma_p is not possible to calculate, there is no var_epsilon"								
##### Sheet/List 4 #####
CP							
A	0.5	0.8	16.2			wA	wB
B	1.5	1.4	21.6			1.5	-0.5
	0	0	10				
						bp1	bp2
						0	0.5
							
						Rp	13.5