Exemplos_Aula (1)

Prévia do material em texto

Retorno Histórico
		Preço Fech_Petr4	Ret. Arit. Petr4	Ret. Log. Petr4
	Dec-16	7.50
	Jan-17	7.58	1.01%	1.00%
	Feb-17	7.66	1.07%	1.06%
	Mar-17	7.31	-4.55%	-4.65%
	Apr-17	7.05	-3.59%	-3.65%
	May-17	6.54	-7.23%	-7.50%
	Jun-17	6.24	-4.55%	-4.66%
	Jul-17	6.71	7.44%	7.17%
	Aug-17	6.89	2.71%	2.67%
	Sep-17	7.72	12.09%	11.41%
	Oct-17	8.46	9.61%	9.17%
	Nov-17	7.76	-8.29%	-8.65%
	Dec-17	8.12	4.68%	4.58%
	Jan-18	9.94	22.36%	20.18%
	Feb-18	10.83	8.93%	8.56%
	Mar-18	10.80	-0.23%	-0.23%
	Apr-18	11.59	7.29%	7.03%
	May-18	9.60	-17.21%	-18.88%
	Jun-18	8.69	-9.43%	-9.91%
	Jul-18	9.97	14.72%	13.73%
	Aug-18	9.76	-2.09%	-2.11%
	Sep-18	10.69	9.50%	9.08%
	Oct-18	14.00	30.96%	26.97%
	Nov-18	12.96	-7.45%	-7.75%
	Dec-18	11.93	-7.93%	-8.26%
	Jan-19	13.45	12.79%	12.03%
	Feb-19	14.23	5.79%	5.62%
	Mar-19	14.76	3.70%	3.63%
	Apr-19	14.27	-3.32%	-3.37%
	May-19	13.50	-5.40%	-5.55%
	Jun-19	14.48	7.28%	7.03%
	Jul-19	13.78	-4.85%	-4.97%
	Aug-19	13.58	-1.46%	-1.47%
	Sep-19	14.67	8.04%	7.73%
	Oct-19	16.18	10.31%	9.81%
	Nov-19	15.62	-3.45%	-3.51%
	Dec-19	16.40	4.96%	4.84%
	Jan-20	15.46	-5.73%	-5.90%
	Feb-20	13.77	-10.93%	-11.58%
	Mar-20	7.60	-44.79%	-59.40%
	Apr-20	9.81	29.02%	25.48%
	May-20	11.05	12.69%	11.94%
	Jun-20	11.71	5.95%	5.78%
	Jul-20	12.06	3.02%	2.97%
	Aug-20	11.89	-1.40%	-1.41%
	Sep-20	10.66	-10.42%	-11.00%
	Oct-20	10.29	-3.42%	-3.48%
	Nov-20	13.53	31.47%	27.36%
	Dec-20	15.40	13.82%	12.94%
	Jan-21	14.50	-5.82%	-6.00%
	Feb-21	12.08	-16.67%	-18.24%
	Mar-21	13.10	8.36%	8.03%
	Apr-21	13.27	1.30%	1.29%
	May-21	15.09	13.76%	12.89%
	Jun-21	16.53	9.53%	9.10%
	Jul-21	15.11	-8.56%	-8.95%
	Aug-21	16.18	7.06%	6.82%
	Sep-21	16.20	0.15%	0.15%
	Oct-21	16.22	0.07%	0.07%
	Nov-21	17.51	8.00%	7.70%
	Dec-21	19.02	8.60%	8.25%
		Média	2.32%	1.55%
		Desvio-Padrão	12.04%	12.67%
		Coef. Variação	518.84%	817.50%
Retorno Petr4
Ret. Arit. Petr4	1.0087424346280294E-2	1.065246338684811E-2	-4.5454545460479778E-2	-3.5886818494277661E-2	-7.2297780961797953E-2	-4.5524691348585278E-2	7.4373484224242947E-2	2.7088036125695991E-2	0.12087912087289832	9.6078431370491657E-2	-8.2886106132181059E-2	4.6814044214219086E-2	0.22360248446409825	8.9340101461450105E-2	-2.3299161328311779E-3	7.2863148128538224E-2	-0.17205224204609837	-9.4309799793968141E-2	0.147178592210647	-2.0883666991794558E-2	9.5015576294324999E-2	0.30962541489788786	-7.4527311976269384E-2	-7.9283627308984528E-2	0.12786596124217109	5.7857701346365031E-2	3.6954915014081546E-2	-3.31807448075494E-2	-5.3972077616763037E-2	7.2798434483616559E-2	-4.852243706943	4488E-2	-1.4555485942132407E-2	8.039215690736734E-2	0.10308529946426992	-3.4461096703362948E-2	4.9596217797469144E-2	-5.7322730317871051E-2	-0.10931458700298113	-0.4479084451158174	0.29020729092256681	0.12686980604766052	5.9488692247624098E-2	3.0182837870608603E-2	-1.396396398155153E-2	-0.10415714940513299	-3.4166241718532109E-2	0.31467793038841529	0.13815261043250637	-5.8221594937310939E-2	-0.1667291120100034	8.3633093547131887E-2	1.3033063147296353E-2	0.13759525828105446	9.5273539299541854E-2	-8.5626911340145884E-2	7.0584737814903376E-2	1.4711290827589263E-3	7.3448402057585405E-4	8.0000000014799566E-2	8.5953243559568904E-2	Ret. Log. Petr4	1.0036885865868254E-2	1.0596125636136725E-2	-4.6520015641109767E-2	-3.6546583062438048E-2	-7.5044482347544086E-2	-4.6593504509842468E-2	7.1737686309763099E-2	2.6727648913909996E-2	0.11411330676186954	9.1738747434850679E-2	-8.6523611747000351E-2	4.5751307913831793E-2	0.20179936374702712	8.5572101402252049E-2	-2.3326346107955045E-3	7.0330914161757782E-2	-0.18880522084597673	-9.905797379223133E-2	0.13730552978485427	-2.1104815106458077E-2	9.0768588093615044E-2	0.2697411534975756	-7.7450657913233661E-2	-8.2603245973619316E-2	0.12032731732916097	5.6245826608206158E-2	3.6288451941688817E-2	-3.3743713933626317E-2	-5.5483194104505189E-2	7.0270593703521775E-2	-4.973917325904894E-2	-1.466245630025494E-2	7.7324083475844921E-2	9.8111071337696476E-2	-3.5068884505712224E-2	4.8405535730795965E-2	-5.9031292802278493E-2	-0.11576398568861344	-0.59404138616090785	0.25480289610187185	0.11944370580023941	5.778642594403776E-2	2.9736298983802104E-2	-1.4062377361298827E-2	-0.1099902713509104	-3.4763552455624451E-2	0.27359171577524322	0.12940643078373584	-5.9985270865711648E-2	-0.18239649401368202	8.0319371134485493E-2	1.2948863576256761E-2	0.12891661188045775	9.1004139651236382E-2	-8.9516597534084363E-2	6.8204983145008183E-2	1.4700480324829797E-3	7.3421441919147565E-4	7.6961041149831627E-2	8.2458166772350044E-2	
Ret. Esperado1
			INVESTIMENTO A
			Probabilidade 	Retorno	(Ra-Média)	(Ra-Média)2	P x (Ra-Média)2
		alta rec	10%	600	
 : =D4-$D$9	
 : =E4^2	
 : =F4*C4				Retorno Esperado
		rec	15%	650
		mod	50%	700
		cresc	15%	750
		alto cresc	10%	800					CV = 
			E(Ra) =	700.00
 : =(D4*C4)+(D5*C5)+(D6*C6)+(D7*C7)+(D8*C8)		VAR (Ra) = 
							
 : =SOMA(G4:G8)	Desvio (Ra) =
							
 : =RAIZ(G9)		
 : =G10/D9	INVESTIMENTO B
			Probabilidade 	Retorno	(Rb-Média)	(Rb-Média)2	P x (Rb-Média)2				Desvio-Padrão
		alta rec	10%	300
					
 : =D15-$D$20	
 : =E15^2	
 : =F15*C15	rec	20%	500
		mod	40%	700
		cresc	20%	900
		alto cresc	10%	1100					CV = 
			E(Rb) =	700.00
 : =(D4*C4)+(D5*C5)+(D6*C6)+(D7*C7)+(D8*C8)		VAR (Ra) = 
							
 : =SOMA(G15:G19)	700.00		Desvio (Ra) =
							
 : =RAIZ(G20)		
 : =G21/D20
Retorno Esperado2
		Retorno Esperado				Desvio-Padrão
				INVESTIMENTO A
				Probabilidade 	Retorno	(Ra-Média)	(Ra-Média)2	P x (Ra-Média)2
				10%	7%
				30%	12%
				40%	15%
				20%	20%					CV = 
				E(Ra) =	14.30%
 : =(E14*D14)+(E15*D15)+(E16*D16)+(E17*D17)		VAR (Ra) = 
							Desvio (Ra) =
				INVESTIMENTO B
				Probabilidade 	Retorno	(Rb-Média)	(Rb-Média)2	P x (Rb-Média)2
				20%	-5%
				30%	0%
				40%	10%
				10%	30%					CV = 
				E(Rb) =	6.00%
 : =(E14*D14)+(E15*D15)+(E16*D16)+(E17*D17)		VAR (Ra) = 
								
 : =SOMA(H14:H17)	Desvio (Ra) =
								
 : =RAIZ(H18)		
 : =H29/E28	
 : =E14-$E$18	
 : =F14^2	
 : =G14*D14	
 : =(E14*D14)+(E15*D15)+(E16*D16)+(E17*D17)			
 : =SOMA(H14:H17)	
 : =RAIZ(H18)		
 : =H19/E18	
 : =E14-$E$18	
 : =F14^2	
 : =G14*D14	
 : =(E14*D14)+(E15*D15)+(E16*D16)+(E17*D17)
Correlação
			Ret (%) de A	Ret (%) de B
		Jan	10%	30%		Gráfico de Linhas:
		Fev	15%	25%
		Mar	20%	20%
		Abr	15%	25%
		Mai	10%	30%
		Jun	5%	35%
		Jul	10%	30%
		Ago	15%	25%
		Set	20%	20%
		Out	15%	25%
		Nov	10%	30%
		Dez	5%	35%
		Correlação		-100%
		Retorno (média)	12.5%	27.5%
		Risco (desviopadrão)	5.0%	5.0%
		CV (desv/média)	40.0%	18.2%		Gráfico de Dispersão:
		Retorno da Carteira	20.0%
		Risco da Carteira	5.0%
Ret (%) de 	A	0.1	0.15	0.2	0.15	0.1	0.05	0.1	0.15	0.2	0.15	0.1	0.05	Ret (%) de B	0.3	0.25	0.2	0.25	0.3	0.35	0.3	0.25	0.2	0.25	0.3	0.35	
Ret (%	) de B	0.1	0.15	0.2	0.15	0.1	0.05	0.1	0.15	0.2	0.15	0.1	0.05	0.3	0.25	0.2	0.25	0.3	0.35	0.3	0.25	0.2	0.25	0.3	0.35	
Correl Petro_IBOV
		Preço Fech_Petr4	Ibov_Fech	Ret. Petr4	Ret. Ibovespa
	Dec-16	7.50	60,227.00
	Jan-17	7.58	64,670.00	1.01%	7.38%
	Feb-17	7.66	66,662.00	1.07%	3.08%
	Mar-17	7.31	64,984.00	-4.55%	-2.52%
	Apr-17	7.05	65,403.00	-3.59%	0.64%
	May-17	6.54	62,711.00	-7.23%	-4.12%
	Jun-17	6.24	62,899.00	-4.55%	0.30%
	Jul-17	6.71	65,920.00	7.44%	4.80%
	Aug-17	6.89	70,835.05	2.71%	7.46%
	Sep-17	7.72	74,293.51	12.09%	4.88%
	Oct-17	8.46	74,308.49	9.61%	0.02%
	Nov-17	7.76	71,970.99	-8.29%	-3.15%
	Dec-17	8.12	76,402.08	4.68%	6.16%
	Jan-18	9.94	84,912.70	22.36%	11.14%
	Feb-18	10.83	85,353.60	8.93%	0.52%
	Mar-18	10.80	85,365.56	-0.23%	0.01%
	Apr-18	11.59	86,115.50	7.29%	0.88%
	May-18	9.60	76,753.61	-17.21%	-10.87%
	Jun-18	8.69	72,762.52	-9.43%	-5.20%
	Jul-18	9.97	79,220.44	14.72%	8.88%
	Aug-18	9.76	76,677.53	-2.09%	-3.21%
	Sep-18	10.69	79,342.43	9.50%	3.48%
	Oct-18	14.00	87,423.55	30.96%	10.19%
	Nov-18	12.96	89,504.03	-7.45%	2.38%
	Dec-18	11.93	87,887.27	-7.93%	-1.81%
	Jan-19	13.45	97,393.75	12.79%	10.82%		Correlação Petro e Ibovespa				0.8540343388
	Feb-19	14.23	95,584.35	5.79%	-1.86%
	Mar-19	14.76	95,414.56	3.70%	-0.18%
	Apr-19	14.27	96,353.33	-3.32%	0.98%
	May-19	13.50	97,030.32	-5.40%	0.70%
	Jun-19	14.48	100,967.20	7.28%	4.06%Jul-19	13.78	101,812.13	-4.85%	0.84%
	Aug-19	13.58	101,134.61	-1.46%	-0.67%
	Sep-19	14.67	104,745.32	8.04%	3.57%
	Oct-19	16.18	107,219.83	10.31%	2.36%
	Nov-19	15.62	108,233.28	-3.45%	0.95%
	Dec-19	16.40	115,645.34	4.96%	6.85%
	Jan-20	15.46	113,760.57	-5.73%	-1.63%
	Feb-20	13.77	104,171.57	-10.93%	-8.43%
	Mar-20	7.60	73,019.76	-44.79%	-29.90%
	Apr-20	9.81	80,505.89	29.02%	10.25%
	May-20	11.05	87,402.59	12.69%	8.57%
	Jun-20	11.71	95,055.82	5.95%	8.76%
	Jul-20	12.06	102,912.24	3.02%	8.27%
	Aug-20	11.89	99,369.15	-1.40%	-3.44%
	Sep-20	10.66	94,603.38	-10.42%	-4.80%
	Oct-20	10.29	93,952.40	-3.42%	-0.69%
	Nov-20	13.53	108,893.32	31.47%	15.90%
	Dec-20	15.40	119,017.24	13.82%	9.30%
	Jan-21	14.50	115,067.55	-5.82%	-3.32%
	Feb-21	12.08	110,035.17	-16.67%	-4.37%
	Mar-21	13.10	116,633.72	8.36%	6.00%
	Apr-21	13.27	118,893.84	1.30%	1.94%
	May-21	15.09	126,215.73	13.76%	6.16%
	Jun-21	16.53	126,801.66	9.53%	0.46%
	Jul-21	15.11	121,800.79	-8.56%	-3.94%
	Aug-21	16.18	118,781.03	7.06%	-2.48%
	Sep-21	16.20	110,979.10	0.15%	-6.57%
	Oct-21	16.22	103,500.71	0.07%	-6.74%
	Nov-21	17.51	101,915.45	8.00%	-1.53%
	Dec-21	19.02	104,822.44	8.60%	2.85%
		Média		2.32%	1.17%
		Desvio-Padrão		12.04%	6.81%
		Coef. Variação		518.84%	581.24%
Ret. Petr4	1.0087424346280294E-2	1.065246338684811E-2	-4.5454545460479778E-2	-3.5886818494277661E-2	-7.2297780961797953E-2	-4.5524691348585278E-2	7.4373484224242947E-2	2.7088036125695991E-2	0.12087912087289832	9.6078431370491657E-2	-8.2886106132181059E-2	4.6814044214219086E-2	0.22360248446409825	8.9340101461450105E-2	-2.3299161328311779E-3	7.2863148128538224E-2	-0.17205224204609837	-9.4309799793968141E-2	0.147178592210647	-2.08836669917	94558E-2	9.5015576294324999E-2	0.30962541489788786	-7.4527311976269384E-2	-7.9283627308984528E-2	0.12786596124217109	5.7857701346365031E-2	3.6954915014081546E-2	-3.31807448075494E-2	-5.3972077616763037E-2	7.2798434483616559E-2	-4.8522437069434488E-2	-1.4555485942132407E-2	8.039215690736734E-2	0.10308529946426992	-3.4461096703362948E-2	4.9596217797469144E-2	-5.7322730317871051E-2	-0.10931458700298113	-0.4479084451158174	0.29020729092256681	0.12686980604766052	5.9488692247624098E-2	3.0182837870608603E-2	-1.396396398155153E-2	-0.10415714940513299	-3.4166241718532109E-2	0.31467793038841529	0.13815261043250637	-5.8221594937310939E-2	-0.1667291120100034	8.3633093547131887E-2	1.3033063147296353E-2	0.13759525828105	446	9.5273539299541854E-2	-8.5626911340145884E-2	7.0584737814903376E-2	1.4711290827589263E-3	7.3448402057585405E-4	8.0000000014799566E-2	8.5953243559568904E-2	Ret. Ibovespa	7.3770900094642045E-2	3.0802535951754972E-2	-2.5171762023341593E-2	6.4477409823957554E-3	-4.1160191428527781E-2	2.997879159956085E-3	4.8029380435301139E-2	7.4560831310679587E-2	4.8824134379801931E-2	2.0163268635453591E-4	-3.1456701650107499E-2	6.1567723328524337E-2	0.11139251706236264	5.192391715255873E-3	1.4012297079424307E-4	8.785041	6491146444E-3	-0.10871318171525446	-5.1998726835128628E-2	8.8753385671634266E-2	-3.2099165316425982E-2	3.4754640635920264E-2	0.10185117849302072	2.3797706682009645E-2	-1.8063544177843061E-2	0.10816674587798669	-1.8578194185971841E-2	-1.7763368166442417E-3	9.8388547827501505E-3	7.0261193878822237E-3	4.0573709331268804E-2	8.3683612103733207E-3	-6.6546098190854996E-3	3.5702021296171615E-2	2.3624062631151466E-2	9.452076169119028E-3	6.8482263496033813E-2	-1.6297846502072555E-2	-8.429106851345769E-2	-0.29904329943380914	0.10252197487365078	8.5667023866204062E-2	8.7562965811425197E-2	8.2650594145629253E-2	-3.4428266258707541E-2	-4.7960257283070185E-2	-6.881149489584959E-3	0.15902648575235978	9.2970992160033239E-2	-3.3185864501646956E-2	-4.3734137035158938E-2	5.9967644890265515E-2	1.9377929470139499E-2	6.1583426021062149E-2	4.6422898318616568E-3	-3.9438521546169114E-2	-2.4792614235096488E-2	-6.5683299765964209E-2	-6.7385570796663519E-2	-1.5316416669992061E-2	2.8523545743064593E-2	
Ret. Ibovespa	1.0087424346280294E-2	1.065246338684811E-2	-4.5454545460479778E-2	-3.5886818494277661E-2	-7.2297780961797953E-2	-4.5524691348585278E-2	7.4373484224242947E-2	2.7088036125695991E-2	0.12087912087289832	9.6078431370491657E-2	-8.2886106132181059E-2	4.6814044214219086E-2	0.22360248446409825	8.9340101461450105E-2	-2.3299161328311779E-3	7.2863148128538224E-2	-0.17205224204609837	-9.4309799793968141E-2	0.147178592210647	-2.0883666991794558E-2	9.5015576294324999E-2	0.30962541489788786	-7.4527311976269384E-2	-7.9283627308984528E-2	0.12786596124217109	5.7857701346365031E-2	3.695491501408154	6E-2	-3.31807448075494E-2	-5.3972077616763037E-2	7.2798434483616559E-2	-4.8522437069434488E-2	-1.4555485942132407E-2	8.039215690736734E-2	0.10308529946426992	-3.4461096703362948E-2	4.9596217797469144E-2	-5.7322730317871051E-2	-0.10931458700298113	-0.4479084451158174	0.29020729092256681	0.12686980604766052	5.9488692247624098E-2	3.0182837870608603E-2	-1.396396398155153E-2	-0.10415714940513299	-3.4166241718532109E-2	0.31467793038841529	0.13815261043250637	-5.8221594937310939E-2	-0.1667291120100034	8.3633093547131887E-2	1.3033063147296353E-2	0.13759525828105446	9.5273539299541854E-2	-8.5626911340145884E-2	7.0584737814903376E-2	1.4711290827589263E-3	7.3448402057585405E-4	8.0000000014799566E-2	8.5953243559568904E-2	7.3770900094642045E-2	3.0802535951754972E-2	-2.5171762023341593E-2	6.4477409823957554E-3	-4.1160191428527781E-2	2.997879159956085E-3	4.8029380435301139E-2	7.4560831310679587E-2	4.8824134379801931E-2	2.0163268635453591E-4	-3.1456701650107499E-2	6.1567723328524337E-2	0.11139251706236264	5.192391715255873E-3	1.4012297079424307E-4	8.7850416491146444E-3	-0.10871318171525446	-5.1998726835128628E-2	8.8753385671634266E-2	-3.2099165316425982E-2	3.4754640635920264E-2	0.10185117849302072	2.3797706682009645E-2	-1.8063544177843061E-2	0.10816674587798669	-1.8578194185971841E-2	-1.7763368166442417E-3	9.8388547827501505E-3	7.0261193878822237E-3	4.0573709331268804E-2	8.3683612103733207E-3	-6.6546098190854996E-3	3.	5702021296171615E-2	2.3624062631151466E-2	9.452076169119028E-3	6.8482263496033813E-2	-1.6297846502072555E-2	-8.429106851345769E-2	-0.29904329943380914	0.10252197487365078	8.5667023866204062E-2	8.7562965811425197E-2	8.2650594145629253E-2	-3.4428266258707541E-2	-4.7960257283070185E-2	-6.881149489584959E-3	0.15902648575235978	9.2970992160033239E-2	-3.3185864501646956E-2	-4.3734137035158938E-2	5.9967644890265515E-2	1.9377929470139499E-2	6.1583426021062149E-2	4.6422898318616568E-3	-3.9438521546169114E-2	-2.4792614235096488E-2	-6.5683299765964209E-2	-6.7385570796663519E-2	-1.5316416669992061E-2	2.8523545743064593E-2	
Correl VALE_IBOV
		Preço Fech_Vale3	Ibov_Fech	Ret. Vale3	Ret. Ibovespa
	Dec-16	17.20	60,227.00
	Jan-17	21.55	64,670.00	25.31%	7.38%
	Feb-17	21.91	66,662.00	1.68%	3.08%
	Mar-17	19.95	64,984.00	-8.95%	-2.52%
	Apr-17	19.01	65,403.00	-4.71%	0.64%
	May-17	18.80	62,711.00	-1.09%	-4.12%
	Jun-17	20.07	62,899.00	6.74%	0.30%
	Jul-17	21.66	65,920.00	7.93%	4.80%
	Aug-17	24.28	70,835.05	12.08%	7.46%
	Sep-17	22.06	74,293.51	-9.15%	4.88%
	Oct-17	22.22	74,308.49	0.72%	0.02%
	Nov-17	24.32	71,970.99	9.47%	-3.15%
	Dec-17	28.16	76,402.08	15.79%	6.16%
	Jan-18	28.99	84,912.70	2.96%	11.14%
	Feb-18	31.51	85,353.60	8.69%	0.52%
	Mar-18	29.86	85,365.56	-5.24%	0.01%
	Apr-18	34.43	86,115.50	15.30%	0.88%
	May-18	35.82	76,753.61	4.03%	-10.87%
	Jun-18	35.08	72,762.52	-2.05%	-5.20%
	Jul-18	38.80	79,220.44	10.59%	8.88%
	Aug-18	39.03	76,677.53	0.59%	-3.21%
	Sep-18	43.54	79,342.43	11.56%	3.48%
	Oct-18	41.27	87,423.55	-5.20%	10.19%
	Nov-18	38.43	89,504.03	-6.89%	2.38%
	Dec-18	37.12	87,887.27	-3.41%	-1.81%
	Jan-19	33.12	97,393.75	-10.78%	10.82%		Correlação Petro e Ibovespa				0.4490528474
	Feb-19	34.28	95,584.35	3.52%	-1.86%
	Mar-19	37.07	95,414.56	8.13%	-0.18%
	Apr-19	36.46	96,353.33	-1.63%	0.98%
	May-19	35.66	97,030.32	-2.20%	0.70%
	Jun-19	37.72	100,967.20	5.76%	4.06%
	Jul-19	36.25	101,812.13	-3.88%	0.84%
	Aug-19	33.17	101,134.61	-8.51%	-0.67%
	Sep-19	34.75	104,745.32	4.78%	3.57%
	Oct-19	34.35	107,219.83	-1.15%	2.36%
	Nov-19	36.38	108,233.28	5.89%	0.95%
	Dec-19	39.82	115,645.34	9.47%	6.85%
	Jan-20	37.56	113,760.57-5.68%	-1.63%
	Feb-20	33.10	104,171.57	-11.86%	-8.43%
	Mar-20	32.29	73,019.76	-2.46%	-29.90%
	Apr-20	33.52	80,505.89	3.79%	10.25%
	May-20	39.60	87,402.59	18.15%	8.57%
	Jun-20	41.78	95,055.82	5.51%	8.76%
	Jul-20	45.36	102,912.24	8.57%	8.27%
	Aug-20	44.59	99,369.15	-1.70%	-3.44%
	Sep-20	46.01	94,603.38	3.19%	-4.80%
	Oct-20	47.13	93,952.40	2.44%	-0.69%
	Nov-20	60.71	108,893.32	28.82%	15.90%
	Dec-20	68.07	119,017.24	12.12%	9.30%
	Jan-21	68.45	115,067.55	0.57%	-3.32%
	Feb-21	73.57	110,035.17	7.47%	-4.37%
	Mar-21	79.69	116,633.72	8.32%	6.00%
	Apr-21	88.68	118,893.84	11.28%	1.94%
	May-21	93.36	126,215.73	5.28%	6.16%
	Jun-21	93.93	126,801.66	0.60%	0.46%
	Jul-21	90.20	121,800.79	-3.96%	-3.94%
	Aug-21	81.84	118,781.03	-9.27%	-2.48%
	Sep-21	69.80	110,979.10	-14.71%	-6.57%
	Oct-21	65.56	103,500.71	-6.07%	-6.74%
	Nov-21	64.04	101,915.45	-2.32%	-1.53%
	Dec-21	71.37	104,822.44	11.45%	2.85%
		Média		2.76%	1.17%
		Desvio-Padrão		8.76%	6.81%
		Coef. Variação		317.49%	581.24%
Ret. Vale3	0.25311526476857238	1.6780609106977096E-2	-8.9547677271808457E-2	-4.7115368814286018E-2	-1.0921004709917526E-2	6.7353698887961277E-2	7.931034486486821E-2	0.12076677313364881	-9.1505131130621309E-2	7.2168183459238033E-3	9.4704049846199956E-2	0.15794136248349244	2.9557873798462531E-2	8.6851628466369624E-2	-5.2396888186094448E-2	0.15304430229197208	4.0271214290824586E-2	-2.05411	81121200736E-2	0.10586811858410528	5.9356845952684978E-3	0.11562849682375886	-5.1989301241567532E-2	-6.8947275614108183E-2	-3.4090909082037935E-2	-0.10784313725278893	3.516483515527824E-2	8.1316348185648701E-2	-1.6296878047617147E-2	-2.1956087845754313E-2	5.7551020410463671E-2	-3.8788112682624165E-2	-8.512346919298508E-2	4.7838490234459519E-2	-1.1518324604346875E-2	5.8898305080959057E-2	9.468507707648488E-2	-5.6848030021367291E-2	-0.11855977719506827	-2.4599413212318511E-2	3.7945395647997815E-2	0.18145341060336651	5.5094339607641318E-2	8.5658082997102758E-2	-1.6965903490080203E-2	3.1852320370030496E-2	2.4361360188897674E-2	0.28819157719511135	0.12115384615523994	5.717552887734012E-3	7.470153497602916E-2	8.3194452172918654E-2	0.1127	8962948217641	5.2834342328666128E-2	6.0408750608604844E-3	-3.9646799114831821E-2	-9.2681132775708108E-2	-0.14714632688426665	-6.0729275967067453E-2	-2.3181119948335716E-2	0.11451036453640295	Ret. Ibovespa	7.3770900094642045E-2	3.0802535951754972E-2	-2.5171762023341593E-2	6.4477409823957554E-3	-4.1160191428527781E-2	2.997879159956085E-3	4.8029380435301139E-2	7.4560831310679587E-2	4.8824134379801931E-2	2.0163268635453591E-4	-3.1456701650107499E-2	6.1567723328524337E-2	0.11139251706236264	5.19239171525587	3E-3	1.4012297079424307E-4	8.7850416491146444E-3	-0.10871318171525446	-5.1998726835128628E-2	8.8753385671634266E-2	-3.2099165316425982E-2	3.4754640635920264E-2	0.10185117849302072	2.3797706682009645E-2	-1.8063544177843061E-2	0.10816674587798669	-1.8578194185971841E-2	-1.7763368166442417E-3	9.8388547827501505E-3	7.0261193878822237E-3	4.0573709331268804E-2	8.3683612103733207E-3	-6.6546098190854996E-3	3.5702021296171615E-2	2.3624062631151466E-2	9.452076169119028E-3	6.8482263496033813E-2	-1.6297846502072555E-2	-8.429106851345769E-2	-0.29904329943380914	0.10252197487365078	8.5667023866204062E-2	8.7562965811425197E-2	8.2650594145629253E-2	-3.4428266258707541E-2	-4.7960257283070185E-2	-6.881149489584959E-3	0.159026485752359	78	9.2970992160033239E-2	-3.3185864501646956E-2	-4.3734137035158938E-2	5.9967644890265515E-2	1.9377929470139499E-2	6.1583426021062149E-2	4.6422898318616568E-3	-3.9438521546169114E-2	-2.4792614235096488E-2	-6.5683299765964209E-2	-6.7385570796663519E-2	-1.5316416669992061E-2	2.8523545743064593E-2	
Ret. Ibovespa	0.25311526476857238	1.6780609106977096E-2	-8.9547677271808457E-2	-4.7115368814286018E-2	-1.0921004709917526E-2	6.7353698887961277E-2	7.931034486486821E-2	0.12076677313364881	-9.1505131130621309E-2	7.2168183459238033E-3	9.4704049846199956E-2	0.15794136248349244	2.9557873798462531E-2	8.6851628466369624E-2	-5.2396888186094448E-2	0.15304430229197208	4.0271214290824586E-2	-2.0541181121200736E-2	0.10586811858410528	5.9356845952684978E-3	0.11562849682375886	-5.1989301241567532E-2	-6.8947275614108183E-2	-3.4090909082037935E-2	-0.10784313725278893	3.516483515527824E-2	8.1316348185648701E-2	-1.6296878047617147E-2	-2.1956087845754313E-2	5.7551020410463671E-2	-3.8788112682624165E-2	-8.512346919298508E-2	4.7838490234459519E-2	-1.1518324604346875E-2	5.8898305080959057E-2	9.468507707648488E-2	-5.6848030021367291E-2	-0.11855977719506827	-2.4599413212318511E-2	3.7945395647997815E-2	0.18145341060336651	5.5094339607641318E-2	8.5658082997102758E-2	-1.6965903490080203E-2	3.1852320370030496E-2	2.4361360188897674E-2	0.28819157719511135	0.12115384615523994	5.717552887734012E-3	7.470153497602916E-2	8.3194452172918654E-2	0.11278962948217641	5.2834342328666128E-2	6.0408750608604844E-3	-3.9646799114831821E-2	-9.2681132775708108E-2	-0.14714632688426665	-6.0729275967067453E-2	-2.318111994833	5716E-2	0.11451036453640295	7.3770900094642045E-2	3.0802535951754972E-2	-2.5171762023341593E-2	6.4477409823957554E-3	-4.1160191428527781E-2	2.997879159956085E-3	4.8029380435301139E-2	7.4560831310679587E-2	4.8824134379801931E-2	2.0163268635453591E-4	-3.1456701650107499E-2	6.1567723328524337E-2	0.11139251706236264	5.192391715255873E-3	1.4012297079424307E-4	8.7850416491146444E-3	-0.10871318171525446	-5.1998726835128628E-2	8.8753385671634266E-2	-3.2099165316425982E-2	3.4754640635920264E-2	0.10185117849302072	2.3797706682009645E-2	-1.8063544177843061E-2	0.10816674587798669	-1.8578194185971841E-2	-1.7763368166442417E-3	9.8388547827501505E-3	7.0261193878822237E-3	4.0573709331268804E-2	8.3683612103	733207E-3	-6.6546098190854996E-3	3.5702021296171615E-2	2.3624062631151466E-2	9.452076169119028E-3	6.8482263496033813E-2	-1.6297846502072555E-2	-8.429106851345769E-2	-0.29904329943380914	0.10252197487365078	8.5667023866204062E-2	8.7562965811425197E-2	8.2650594145629253E-2	-3.4428266258707541E-2	-4.7960257283070185E-2	-6.881149489584959E-3	0.15902648575235978	9.2970992160033239E-2	-3.3185864501646956E-2	-4.3734137035158938E-2	5.9967644890265515E-2	1.9377929470139499E-2	6.1583426021062149E-2	4.6422898318616568E-3	-3.9438521546169114E-2	-2.4792614235096488E-2	-6.5683299765964209E-2	-6.7385570796663519E-2	-1.5316416669992061E-2	2.8523545743064593E-2	
Correl_MGLU_VIA
		Preço Fech_MGLU	Preço Fech_VIA	Ret. MGLU	Ret. VIA
	Aug-17	2.18	6.67
	Sep-17	2.27	7.80	4.52%	17.01%
	Oct-17	1.95	7.56	-14.10%	-3.06%
	Nov-17	1.74	7.32	-10.87%	-3.16%
	Dec-17	2.47	7.92	42.02%	8.12%
	Jan-18	2.61	8.09	5.41%	2.14%
	Feb-18	2.81	7.87	7.68%	-2.72%
	Mar-18	3.03	8.14	7.84%	3.43%
	Apr-18	3.30	8.11	8.99%	-0.34%
	May-18	3.35	6.50	1.60%	-19.85%
	Jun-18	3.96	5.89	18.05%	-9.38%
	Jul-18	4.09	7.15	3.34%	21.39%
	Aug-18	4.03	5.70	-1.52%	-20.28%
	Sep-18	3.79	5.06	-5.96%	-11.23%
	Oct-18	5.22	5.60	37.81%	10.67%
	Nov-18	5.09	5.18	-2.47%	-7.50%
	Dec-18	5.60	4.39	9.99%	-15.25%
	Jan-19	5.55	6.00	-0.78%	36.67%
	Feb-19	5.38	4.58	-3.13%	-23.67%
	Mar-19	5.36	4.22	-0.35%	-7.86%
	Apr-19	5.94	4.10	10.90%	-2.84%
	May-19	6.09	4.70	2.48%	14.63%
	Jun-19	6.56	5.07	7.71%	7.87%
	Jul-19	8.20	7.72	24.91%	52.27%
	Aug-19	9.02	7.73	10.09%	0.13%
	Sep-19	9.21	7.92	2.07%	2.46%		Correlação MGLU e VIA				0.6334688549
	Oct-19	11.12	7.42	20.75%	-6.31%
	Nov-19	11.22	8.81	0.87%	18.73%
	Dec-19	11.88	11.17	5.93%	26.79%
	Jan-20	13.91	14.00	17.07%	25.34%
	Feb-20	12.59	13.81	-9.46%	-1.36%
	Mar-20	9.72	5.28	-22.82%	-61.77%
	Apr-20	12.39	9.18	27.47%	73.86%
	May-20	16.04	12.40	29.48%	35.08%
	Jun-20	17.86	15.31	11.34%	23.47%
	Jul-20	20.14	19.52	12.77%	27.50%
	Aug-20	23.26	20.50	15.50%	5.02%
	Sep-20	22.26	17.35	-4.31%	-15.37%
	Oct-20	24.59	17.16	10.45%	-1.10%
	Nov-20	23.34	17.75	-5.08%	3.44%
	Dec-20	24.93	16.16	6.83%	-8.96%
	Jan-21	25.25	14.69	1.28%	-9.10%
	Feb-21	24.16	11.87	-4.31%	-19.20%
	Mar-21	20.23	12.07	-16.29%	1.68%
	Apr-21	20.02	11.83	-1.04%	-1.99%
	May-21	20.15	12.98	0.65%	9.72%
	Jun-21	21.13	15.79	4.91%	21.65%
	Jul-21	20.60	12.59	-2.53%	-20.27%
	Aug-21	18.24	10.39	-11.46%	-17.47%
	Sep-21	14.34	7.71	-21.38%	-25.79%
	Oct-21	10.81	6.15-24.62%	-20.23%
	Nov-21	7.80	5.67	-27.84%	-7.80%
	Dec-21	7.22	5.25	-7.44%	-7.41%
	Jan-22	7.00	4.72	-3.05%	-10.10%
	Feb-22	6.01	3.79	-14.14%	-19.70%
	Mar-22	6.82	4.17	13.48%	10.03%
	Apr-22	4.88	2.97	-28.45%	-28.78%
	May-22	3.72	3.14	-23.77%	5.72%
	Jun-22	2.34	1.92	-37.10%	-38.85%
	Jul-22	2.58	2.40	10.26%	25.00%
	Aug-22	4.15	3.27	60.85%	36.25%
		Média		2.52%	1.29%
		Desvio-Padrão		17.37%	22.14%
		Coef. Variação		690.12%	1716.24%
Ret. MGLU	4.5211267623720186E-2	-0.14095135425268357	-0.10870588238390555	0.42024092131645308	5.4101221635052932E-2	7.6750236546589967E-2	7.8419433542886496E-2	8.9878459802117838E-2	1.6024739962711365E-2	0.1805017524492305	3.3361981410946262E-2	-1.5197338583514797E-2	-5.9577735118589992E-2	0.37807167931633345	-2.4703791480855886E-2	9.9860292789030858E-2	-7.7976296092302499E-3	-3.1328530743450322E-2	-3.5166609136293436E-3	0.1090200050986	1964	2.4783017879282054E-2	7.714285713844804E-2	0.24914740431950033	0.10086455331647715	2.0666850372275114E-2	0.20749816447852298	8.7365590939116888E-3	5.9293804137410255E-2	0.17068968556936404	-9.4623655917843719E-2	-0.22822644496932065	0.27468581686910265	0.29476861165491619	0.11344211343528365	0.12772299169538437	0.15499938051075124	-4.3123793182234582E-2	0.10448430494266692	-5.0751116544990871E-2	6.8262861171575651E-2	1.2825651285677475E-2	-4.3134151159446854E-2	-0.16294458229007569	-1.0375494055878565E-2	6.4902646053401902E-3	4.9107142854926789E-2	-2.5298354015061086E-2	-0.11456310679611659	-0.21381578947368418	-0.24616457461645747	-0.27844588344125809	-7.4358974358974317E-2	-3.0470914127423754E-2	-0.14142857142857146	0.13477537437604004	-0.28445747800586518	-0.23770491803278682	-0.37096774193548399	0.10256410256410264	0.60852713178294593	Ret. VIA	0.17014925374455148	-3.0612244902013863E-2	-3.1578947372736033E-2	8.1178706188606231E-2	2.1437578817605996E-2	-2.7160493830854282E-2	3.4263959395653076E-2	-3.4359006662864067E-3	-0.19852034525277429	-9.3846153846153912E-2	0.2139219015280136	-0.20279720279720281	-0.11228070175438609	0.10671936758893286	-7.4999999999999956E-2	-0.15250965250965254	0.3667425968109	3413	-0.23666666666666669	-7.8602620087336317E-2	-2.8436018957346043E-2	0.14634146341463428	7.8723404255319096E-2	0.52268244575936862	1.2953367875647714E-3	2.4579560155239211E-2	-6.3131313131313149E-2	0.18733153638814026	0.26787741203178195	0.25335720680393914	-1.3571428571428568E-2	-0.61766835626357719	0.73863636363636354	0.35076252723311563	0.23467741935483866	0.27498367080339636	5.0204918032786816E-2	-0.15365853658536577	-1.0951008645533222E-2	3.4382284382284301E-2	-8.9577464788732408E-2	-9.0965346534653491E-2	-0.19196732471068756	1.6849199663016012E-2	-1.988400994200501E-2	9.7210481825866557E-2	0.21648690292758088	-0.2026599113362888	-0.17474185861795066	-0.25794032723772864	-0.2023346303501945	-7.8048780487804947E-2	-7.407407407407407E-2	-0.10095238095238102	-0.1970338	9830508466	0.10026385224274414	-0.28776978417266186	5.7239057239057312E-2	-0.38853503184713378	0.25	0.36250000000000004	
Ret. VIA	4.5211267623720186E-2	-0.14095135425268357	-0.10870588238390555	0.42024092131645308	5.4101221635052932E-2	7.6750236546589967E-2	7.8419433542886496E-2	8.9878459802117838E-2	1.6024739962711365E-2	0.1805017524492305	3.3361981410946262E-2	-1.5197338583514797E-2	-5.9577735118589992E-2	0.37807167931633345	-2.4703791480855886E-2	9.9860292789030858E-2	-7.7976296092302499E-3	-3.1328530743450322E-2	-3.5166609136293436E-3	0.10902000509861964	2.4783017879282054E-2	7.714285713844804E-2	0.24914740431950033	0.10086455331647715	2.0666850372275114E-2	0.20749816447852298	8.7365590939116888E-3	5.9293804137410255E-2	0.17068968556936404	-9.4623655917843719E-2	-0.22822644496932065	0.27468581686910265	0.29476861165491619	0.11344211343528365	0.12772299169538437	0.15499938051075124	-4.3123793182234582E-2	0.10448430494266692	-5.0751116544990871E-2	6.8262861171575651E-2	1.2825651285677475E-2	-4.3134151159446854E-2	-0.16294458229007569	-1.0375494055878565E-2	6.4902646053401902E-3	4.9107142854926789E-2	-2.5298354015061086E-2	-0.11456310679611659	-0.21381578947368418	-0.24616457461645747	-0.27844588344125809	-7.4358974358974317E-2	-3.0470914127423754E-2	-0.14142857142857146	0.13477537437604004	-0.28445747800586518	-0.23770491803278682	-0.37096774193548399	0.10256410256410264	0.60852713178294593	0.17014925374455148	-3.0612244902013863E-2	-3.1578947372736033E-2	8.1178706188606231E-2	2.1437578817605996E-2	-2.7160493830854282E-2	3.4263959395653076E-2	-3.4359006662864067E-3	-0.19852034525277429	-9.3846153846153912E-2	0.2139219015280136	-0.20279720279720281	-0.11228070175438609	0.10671936758893286	-7.4999999999999956E-2	-0.15250965250965254	0.36674259681093413	-0.23666666666666669	-7.8602620087336317E-2	-2.8436018957346043E-2	0.14634146341463428	7.8723404255319096E-2	0.52268244575936862	1.2953367875647714E-3	2.4579560155239211E-2	-6.3131313131313149E-2	0.18733153638814026	0.26787741203178195	0.25335720680393914	-1.3571428571428568E-2	-0.61766835626357719	0.73863636363636354	0.35076252723311563	0.23467741935483866	0.27498367080339636	5.0204918032786816E-2	-0.15365853658536577	-1.0951008645533222E-2	3.4382284382284301E-2	-8.9577464788732408E-2	-9.0965346534653491E-2	-0.19196732471068756	1.6849199663016012E-2	-1.988400994200501E-2	9.7210481825866557E-2	0.21648690292758088	-0.2026599113362888	-0.17474185861795066	-0.25794032723772864	-0.2023346303501945	-7.8048780487804947E-2	-7.407407407407407E-2	-0.10095238095238102	-0.19703389830508466	0.10026385224274414	-0.28776978417266186	5.7239057239057312E-2	-0.38853503184713378	0.25	0.36250000000000004	
Retorno e Risco Carteira
		INVESTIMENTO A
		Probabilidade 	Retorno	(Ra-Média)	(Ra-Média)2	P x (Ra-Média)2
		30%	28%	15.2%
 Tatiana Albanez: =C4-$C$7	0.023104
 Tatiana Albanez: =D4^2	0.006931
 Tatiana Albanez: =E4*B4
		40%	14%	1.2%	0.000144	0.000058
		30%	-4%	-16.8%	0.028224	0.008467		CV = 
		E(Ra) =	12.8%
 Tatiana Albanez: =(C4*B4)+(C5*B5)+(C6*B6)		VAR (Ra) = 	1.5%
 Tatiana Albanez: =SOMA(F4:F6)		97.13%
 Tatiana Albanez: =F8/C7
					Desvio (Ra) =	12.4%
 Tatiana Albanez: =RAIZ(F7)
		INVESTIMENTO B
		Probabilidade 	Retorno	(Rb-Média)	(Rb-Média)2	P x (Rb-Média)2
		30%	8%	-1.3%
 Tatiana Albanez: =C4-$C$7	0.000169
 Tatiana Albanez: =D4^2	0.000051
 Tatiana Albanez: =E4*B4
		40%	12%	2.7%	0.000729	0.000292
		30%	7%	-2.3%	0.000529	0.000159		CV = 
		E(Rb) =	9.3%
 Tatiana Albanez: =(C4*B4)+(C5*B5)+(C6*B6)		VAR (Ra) = 	0.1%
 Tatiana Albanez: =SOMA(F4:F6)		24.07%
 Tatiana Albanez: =F17/C16
					Desvio (Ra) =	2.2%
 Tatiana Albanez: =RAIZ(F7)
		Retorno Esperado da Carteira		11.05%
 Tatiana Albanez: =C7*0,5+C16*0,5
		Risco da Carteira 		7.34%
 Tatiana Albanez: =F8*0,5+F17*0,5
		Risco da Carteira Considerando Correlação entre os Ativos:
		Estado de Natureza	Probabilidade 	Retorno Esperado	(R-Rp)	(R-Rp)2	P x (R-Rp)2
		Crescimento	30.0%	18%
 Tatiana Albanez: =0,5*C4+0,5*C13
		Estabilidade	40.0%	13%
		Recessão	30.0%	2%
						VAR (Rp) = 
		Risco da Carteira 		0.00%
 Tatiana Albanez: =G30			
 Tatiana Albanez: =SOMA(G26:G28)	Desvio (Rp) =
							
 Tatiana Albanez: =RAIZ(G29)	
 Tatiana Albanez: =C4-$C$7	
 Tatiana Albanez: =D4^2	
 Tatiana Albanez: =E4*B4	
 Tatiana Albanez: =(C4*B4)+(C5*B5)+(C6*B6)			
 Tatiana Albanez: =SOMA(F4:F6)	
 Tatiana Albanez: =RAIZ(F7)		
 Tatiana Albanez: =F8/C7	
 Tatiana Albanez: =C4-$C$7	
 Tatiana Albanez: =D4^2	
 Tatiana Albanez: =E4*B4	
 Tatiana Albanez: =(C4*B4)+(C5*B5)+(C6*B6)			
 Tatiana Albanez: =SOMA(F4:F6)	
 Tatiana Albanez: =RAIZ(F7)	
 Tatiana Albanez: =C7*0,5+C16*0,5				
 Tatiana Albanez: =F17/C16	
 Tatiana Albanez: =F8*0,5+F17*0,5	
 Tatiana Albanez: =0,5*C4+0,5*C13	
 Tatiana Albanez: =D26-$D$19	
 Tatiana Albanez: =E26^2	
 Tatiana Albanez: =F26*C26
(
)
å
=
-
´
=
n
k
K
k
R
R
P
1
2
s
å
=
´
=
=
n
K
K
K
R
P
R
R
E
1
)
(
2
s
=
VAR