calculos conta

8
AZUL AZUL Fecha Periodo Precio Rentabilidad Apr-14 1 $ 1,160,000 -3.2527% May-14 2 $ 1,199,000 4.2609% Jun-14 3 $ 1,150,000 -12.2137% Jul-14 4 $ 1,310,000 0.0000% Aug-14 5 $ 1,310,000 10.0840% Sep-14 6 $ 1,190,000 3.4783% Oct-14 7 $ 1,150,000 -0.0869% Nov-14 8 $ 1,151,000 -0.7759% Dec-14 9 $ 1,160,000 5.4545% Jan-15 10 $ 1,100,000 10.0000% Feb-15 11 $ 1,000,000 0.0000% Mar-15 12 $ 1,000,000 0.0000% Apr-15 13 $ 1,000,000

Upload: bastian-farias-farias

Post on 09-Sep-2015

214 views

Category:

Documents


1 download

DESCRIPTION

calculos

TRANSCRIPT

Hoja1AZUL AZULBANMEDICACEMENTOSCGEFechaPeriodoPrecioRentabilidadPrecioRentabilidadPrecioRentabilidadPrecioRentabilidadApr-141$ 1,160,000-3.2527%$ 915,0001.6667%$ 525,0005.0000%$ 2,640,00012.3404%May-142$ 1,199,0004.2609%$ 900,000-1.0989%$ 500,000-0.0020%$ 2,350,0006.2867%Jun-143$ 1,150,000-12.2137%$ 910,000-5.2083%$ 500,010-0.9881%$ 2,211,000-14.3289%Jul-144$ 1,310,0000.0000%$ 960,000-3.0303%$ 505,000-0.9998%$ 2,580,800-5.6346%Aug-145$ 1,310,00010.0840%$ 990,000-2.5111%$ 510,100-1.7148%$ 2,734,900-3.8699%Sep-146$ 1,190,0003.4783%$ 1,015,5004.6907%$ 519,000-0.3839%$ 2,845,000-38.6682%Oct-147$ 1,150,000-0.0869%$ 970,000-1.5228%$ 521,0001.1650%$ 4,638,70014.5358%Nov-148$ 1,151,000-0.7759%$ 985,000-8.7963%$ 515,0000.9804%$ 4,050,000-13.2762%Dec-149$ 1,160,0005.4545%$ 1,080,000-1.8182%$ 510,0000.7905%$ 4,670,0000.0000%Jan-1510$ 1,100,00010.0000%$ 1,100,000-14.5631%$ 506,000-0.7843%$ 4,670,0000.0000%Feb-1511$ 1,000,0000.0000%$ 1,287,50012.9386%$ 510,0004.0816%$ 4,670,0001.6344%Mar-1512$ 1,000,0000.0000%$ 1,140,000-11.5936%$ 490,0000.8230%$ 4,594,9002.1089%Apr-1513$ 1,000,000$ 1,289,500$ 486,000$ 4,500,000

Hoja2RentabilidadesRi=Rendimientos^2 = VarianzaS=Desviacin % PonderacinActivos portafolio1234567891011121314151617181920212223promedioestndarAZUL AZUL-3.25%4.26%-12.21%0.00%10.08%3.48%-0.09%-0.78%5.45%10.00%0.00%0.00%1.41%0.36%6.02%85.00%BANMEDICAERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!3.00%CEMENTOSERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!3.00%CGEERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!3.00%BANCO CENTRALERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!3.00%ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!3.00%

Hoja3