Sheet1RENDIMIENTOFechaAjustes de Cierre*RendimientoFechaAjustes de Cierre*RendimientoPEPSICOS&P 50011 de may de 201596.41-0.001451078211 de may de 20152,098.48-0.0083614987-0.0014510782-0.00836149874 de may de 201596.550.01030668644 de may de 20152,116.100.00369757950.01030668640.003697579527 de abr de 201595.560.004089556427 de abr de 20152,108.29-0.00444867960.0040895564-0.004448679620 de abr de 201595.17-0.006702297620 de abr de 20152,117.690.0173908314-0.00670229760.017390831413 de abr de 201595.81-0.00406229413 de abr de 20152,081.18-0.0099827757-0.004062294-0.00998277576 de abr de 201596.20.00531555796 de abr de 20152,102.060.01683888750.00531555790.016838887530 de mar de 201595.69-0.002713422730 de mar de 20152,066.960.0028779229-0.00271342270.0028779229FRMULA23 de mar de 201595.950.006377772723 de mar de 20152,061.02-0.0225860620.0063777727-0.022586062Beta=Covarianza(Ri, Rm)0.000130903316 de mar de 201595.340.010756193516 de mar de 20152,108.100.0262901120.01075619350.026290112Varianza (Rm)0.00024118399 de mar de 201594.32-0.01942420259 de mar de 20152,053.40-0.0086601619-0.0194242025-0.00866016192 de mar de 201596.17-0.02211000652 de mar de 20152,071.26-0.0159207915-0.0221100065-0.0159207915Beta =0.54275324923 de feb de 201598.32-0.000813338823 de feb de 20152,104.50-0.0027522082-0.0008133388-0.002752208217 de feb de 201598.4-0.000711129217 de feb de 20152,110.300.0063271343-0.00071112920.00632713439 de feb de 201598.470.02467484089 de feb de 20152,096.990.01999845090.02467484080.01999845092 de feb de 201596.070.03075864742 de feb de 20152,055.470.02986549450.03075864740.02986549450.546188396226 de ene de 201593.16-0.049321622426 de ene de 20151,994.99-0.0280881664-0.0493216224-0.028088166420 de ene de 201597.870.012647333320 de ene de 20152,051.820.01591686270.01264733330.015916862712 de ene de 201596.640.004771298312 de ene de 20152,019.42-0.01249453420.0047712983-0.01249453425 de ene de 201596.180.02494997575 de ene de 20152,044.81-0.00652693880.0249499757-0.006526938829 de dic de 201493.81-0.027234741529 de dic de 20142,058.20-0.0147435616-0.0272347415-0.014743561622 de dic de 201496.40.016736792422 de dic de 20142,088.770.00871280830.01673679240.008712808315 de dic de 201494.80.007305098415 de dic de 20142,070.650.03355106520.00730509840.03355106528 de dic de 201494.11-0.03138004578 de dic de 20142,002.33-0.0358279486-0.0313800457-0.03582794861 de dic de 201497.11-0.01705079851 de dic de 20142,075.370.003770283-0.01705079850.00377028324 de nov de 201498.780.01212012624 de nov de 20142,067.560.00196559780.0121201260.001965597817 de nov de 201497.590.011853975817 de nov de 20142,063.500.01154200150.01185397580.011542001510 de nov de 201496.440.00948071910 de nov de 20142,039.820.00388040980.0094807190.00388040983 de nov de 201495.530.00651126013 de nov de 20142,031.920.00684946020.00651126010.006849460227 de oct de 201494.910.016466086227 de oct de 20142,018.050.02685321660.01646608620.026853216620 de oct de 201493.360.033214791720 de oct de 20141,964.580.04041740970.03321479170.040417409713 de oct de 201490.31-0.033750209613 de oct de 20141,886.76-0.0102139363-0.0337502096-0.01021393636 de oct de 201493.410.01227934436 de oct de 20141,906.13-0.03189197580.0122793443-0.031891975829 de sep de 201492.270.003909224229 de sep de 20141,967.90-0.00756821940.0039092242-0.007568219422 de sep de 201491.91-0.007047245522 de sep de 20141,982.85-0.0137985035-0.0070472455-0.013798503515 de sep de 201492.560.031609304115 de sep de 20142,010.400.01244278980.03160930410.01244278988 de sep de 201489.68-0.00954396328 de sep de 20141,985.54-0.0111038516-0.0095439632-0.01110385162 de sep de 201490.54-0.00099354212 de sep de 20142,007.710.0021640065-0.00099354210.002164006525 de ago de 201490.630.009645842325 de ago de 20142,003.370.00750046730.00964584230.007500467318 de ago de 201489.76-0.002670228618 de ago de 20141,988.400.0169094117-0.00267022860.016909411711 de ago de 2014900.017146158811 de ago de 20141,955.060.01207738560.01714615880.01207738564 de ago de 201488.470.02437052144 de ago de 20141,931.590.00333961120.02437052140.003339611228 de jul de 201486.34-0.038289255428 de jul de 20141,925.15-0.0272542224-0.0382892554-0.027254222421 de jul de 201489.710.016068664221 de jul de 20141,978.340.00006065880.01606866420.000060658814 de jul de 201488.280.002722324714 de jul de 20141,978.220.00539817170.00272232470.00539817177 de jul de 201488.04-0.00192907867 de jul de 20141,967.57-0.0090412732-0.0019290786-0.009041273230 de jun de 201488.210.014157103730 de jun de 20141,985.440.01240640280.01415710370.012406402823 de jun de 201486.97-0.003901772223 de jun de 20141,960.96-0.0009735387-0.0039017722-0.000973538716 de jun de 201487.310.021650628616 de jun de 20141,962.870.01370105790.02165062860.01370105799 de jun de 201485.44-0.00815950449 de jun de 20141,936.16-0.0068355218-0.0081595044-0.00683552182 de jun de 201486.140.0026736432 de jun de 20141,949.440.01335931730.0026736430.013359317327 de may de 201485.910.028693154427 de may de 20141,923.570.01205003990.02869315440.012050039919 de may de 201483.48-0.00823148119 de may de 20141,900.530.011999964-0.0082314810.01199996412 de may de 201484.17-0.007221102712 de may de 20141,877.86-0.0003301086-0.0072211027-0.00033010865 de may de 201484.780.01905273165 de may de 20141,878.48-0.00141503690.0190527316-0.001415036928 de abr de 201483.180.003251252228 de abr de 20141,881.140.00947520.00325125220.009475221 de abr de 201482.91-0.003611850821 de abr de 20141,863.40-0.0007778449-0.0036118508-0.000777844914 de abr de 201483.210.028524605814 de abr de 20141,864.850.02671506010.02852460580.02671506017 de abr de 201480.870.00669977697 de abr de 20141,815.69-0.02684374850.0066997769-0.026843748531 de mar de 201480.33-0.004347562931 de mar de 20141,865.090.0040132108-0.00434756290.004013210824 de mar de 201480.680.009840024624 de mar de 20141,857.62-0.00477963610.0098400246-0.004779636117 de mar de 201479.890.01399153117 de mar de 20141,866.520.0136962210.0139915310.01369622110 de mar de 201478.78-0.006957209810 de mar de 20141,841.13-0.0198491663-0.0069572098-0.01984916633 de mar de 201479.330.02553438873 de mar de 20141,878.040.00994793470.02553438870.009947934724 de feb de 201477.330.023419661324 de feb de 20141,859.450.01255529660.02341966130.012555296618 de feb de 201475.540.001589825518 de feb de 20141,836.25-0.00129528060.0015898255-0.001295280610 de feb de 201475.42-0.026818272810 de feb de 20141,838.630.0228909917-0.02681827280.02289099177 de feb de 201477.4707 de feb de 20141,797.020003 de feb de 201477.47-0.00180552023 de feb de 20141,797.020.0080623745-0.00180552020.008062374527 de ene de 201477.61-0.01318419127 de ene de 20141,782.59-0.004310255-0.013184191-0.00431025521 de ene de 201478.64-0.009491939921 de ene de 20141,790.29-0.0266811823-0.0094919399-0.026681182313 de ene de 201479.39-0.015622388613 de ene de 20141,838.70-0.0019939861-0.0156223886-0.00199398616 de ene de 201480.640.01524457866 de ene de 20141,842.370.00598846560.01524457860.005988465630 de dic de 201379.42-0.005775282830 de dic de 20131,831.37-0.0054618312-0.0057752828-0.005461831223 de dic de 201379.880.010951081823 de dic de 20131,841.400.0126131540.01095108180.01261315416 de dic de 201379.010.01081641916 de dic de 20131,818.320.02393230950.0108164190.02393230959 de dic de 201378.16-0.02701161329 de dic de 20131,775.32-0.0166297637-0.0270116132-0.01662976372 de dic de 201380.3-0.00892641682 de dic de 20131,805.09-0.0003987926-0.0089264168-0.000398792625 de nov de 201381.02-0.014945763925 de nov de 20131,805.810.0005816256-0.01494576390.000581625618 de nov de 201382.24-0.003398886518 de nov de 20131,804.760.0036525767-0.00339888650.003652576711 de nov de 201382.520.002062231611 de nov de 20131,798.180.01545092230.00206223160.01545092234 de nov de 201382.350.01517219854 de nov de 20131,770.610.00507892660.01517219850.005078926628 de oct de 201381.110.014404818828 de oct de 20131,761.640.00106207470.01440481880.001062074721 de oct de 201379.950.004136121721 de oct de 20131,759.770.0087151370.00413612170.00871513714 de oct de 201379.620.026600359314 de oct de 20131,744.500.0239591470.02660035930.0239591477 de oct de 201377.530.01507500937 de oct de 20131,703.200.00748449140.01507500930.007484491430 de sep de 201376.37-0.007305968630 de sep de 20131,690.50-0.000739153-0.0073059686-0.00073915323 de sep de 201376.93-0.019055552823 de sep de 20131,691.75-0.0106772414-0.0190555528-0.010677241416 de sep de 201378.410.017626702816 de sep de 20131,709.910.01290226560.01762670280.01290226569 de sep de 201377.040.01319676829 de sep de 20131,687.990.01963474940.01319676820.01963474943 de sep de 201376.030.00118444443 de sep de 20131,655.170.01350327990.00118444440.013503279926 de ago de 201375.94-0.001447463926 de ago de 20131,632.97-0.0185233738-0.0014474639-0.018523373819 de ago de 201376.05-0.004198930219 de ago de 20131,663.500.0046214228-0.00419893020.004621422812 de ago de 201376.37-0.050553201312 de ago de 20131,655.83-0.0212660191-0.0505532013-0.02126601915 de ago de 201380.330.00062262635 de ago de 20131,691.42-0.01073195660.0006226263-0.010731956629 de jul de 201380.28-0.012010297329 de jul de 20131,709.670.0105959854-0.01201029730.010595985422 de jul de 201381.25-0.012840286522 de jul de 20131,691.65-0.0002600673-0.0128402865-0.000260067315 de jul de 201382.30.024476961515 de jul de 20131,692.090.0070575690.02447696150.0070575698 de jul de 201380.310.04260833988 de jul de 20131,680.190.02916802990.04260833980.02916802991 de jul de 201376.96-0.01214014651 de jul de 20131,631.890.0158179058-0.01214014650.015817905824 de jun de 201377.90.020490925724 de jun de 20131,606.280.00865979510.02049092570.008659795117 de jun de 201376.32-0.024590342217 de jun de 20131,592.43-0.0213107134-0.0245903422-0.021310713410 de jun de 201378.22-0.004591844810 de jun de 20131,626.73-0.0101832317-0.0045918448-0.01018323173 de jun de 201378.580.02826541663 de jun de 20131,643.380.0077211970.02826541660.00772119728 de may de 201376.39-0.022138259328 de may de 20131,630.74-0.0114989348-0.0221382593-0.011498934820 de may de 201378.1-0.014743530920 de may de 20131,649.60-0.0107746734-0.0147435309-0.010774673413 de may de 201379.260.00963496313 de may de 20131,667.470.02046012660.0096349630.02046012666 de may de 201378.50.00204029666 de may de 20131,633.700.0118716220.00204029660.01187162229 de abr de 201378.340.003836812529 de abr de 20131,614.420.02013419450.00383681250.020134194522 de abr de 201378.04-0.003070626822 de abr de 20131,582.240.0172052601-0.00307062680.017205260115 de abr de 201378.280.034174702315 de abr de 20131,555.25-0.02137417970.0341747023-0.02137417978 de abr de 201375.650.01760280158 de abr de 20131,588.850.022641660.01760280150.022641661 de abr de 201374.33-0.00657059021 de abr de 20131,553.28-0.0101907385-0.0065705902-0.010190738525 de mar de 201374.820.005898140425 de mar de 20131,569.190.0078693210.00589814040.00786932118 de mar de 201374.380.020647296918 de mar de 20131,556.89-0.00244419690.0206472969-0.002444196911 de mar de 201372.86-0.002193584611 de mar de 20131,560.700.0061185069-0.00219358460.00611850694 de mar de 201373.020.01670963414 de mar de 20131,551.180.0214905090.01670963410.02149050925 de feb de 201371.810.011766489625 de feb de 20131,518.200.00171402240.01176648960.001714022419 de feb de 201370.970.02540090919 de feb de 20131,515.60-0.00276076730.025400909-0.002760767311 de feb de 201369.190.014705076811 de feb de 20131,519.790.00122460280.01470507680.00122460284 de feb de 201368.18-0.00087963654 de feb de 20131,517.930.0031407766-0.00087963650.003140776628 de ene de 201368.240.002494315728 de ene de 20131,513.170.00677029110.00249431570.006770291122 de ene de 201368.070.000146918422 de ene de 20131,502.960.01136200970.00014691840.011362009714 de ene de 201368.060.022285872614 de ene de 20131,485.980.00941850010.02228587260.00941850017 de ene de 201366.560.02018431077 de ene de 20131,472.050.00379783480.02018431070.003797834831 de dic de 201265.230.020913162531 de dic de 20121,466.470.04465170610.02091316250.044651706124 de dic de 201263.88-0.023363018224 de dic de 20121,402.43-0.0195728876-0.0233630182-0.019572887617 de dic de 201265.39-0.007617343417 de dic de 20121,430.150.0116538402-0.00761734340.011653840210 de dic de 201265.89-0.001364980910 de dic de 20121,413.58-0.0031712985-0.0013649809-0.00317129853 de dic de 201265.980.00837079693 de dic de 20121,418.070.00133368640.00837079690.001333686426 de nov de 201265.430.000305716926 de nov de 20121,416.180.00497642010.00030571690.004976420119 de nov de 201265.410.027118730119 de nov de 20121,409.150.03559022520.02711873010.035590225212 de nov de 201263.66-0.007823541712 de nov de 20121,359.88-0.014578337-0.0078235417-0.0145783375 de nov de 201264.16-0.00295697055 de nov de 20121,379.85-0.0245892026-0.0029569705-0.02458920262 de nov de 201264.3502 de nov de 20121,414.2000031 de oct de 201264.350.001088393231 de oct de 20121,414.200.00159935490.00108839320.001599354922 de oct de 201264.28-0.012983180822 de oct de 20121,411.94-0.0149380838-0.0129831808-0.014938083815 de oct de 201265.12-0.00245398915 de oct de 20121,433.190.0032147852-0.0024539890.00321478528 de oct de 201265.28-0.01490068628 de oct de 20121,428.59-0.0223852754-0.0149006862-0.02238527541 de oct de 201266.260.00468951771 de oct de 20121,460.930.01396493610.00468951770.013964936124 de sep de 201265.950.003189310924 de sep de 20121,440.67-0.0134308870.0031893109-0.01343088717 de sep de 201265.740.001217656217 de sep de 20121,460.15-0.00384153150.0012176562-0.003841531510 de sep de 201265.66-0.023034514910 de sep de 20121,465.770.0191830767-0.02303451490.01918307674 de sep de 201267.190.00298107244 de sep de 20121,437.920.02203639880.00298107240.022036398827 de ago de 201266.99-0.008768726827 de ago de 20121,406.58-0.0032295758-0.0087687268-0.003229575820 de ago de 201267.58-0.004429359120 de ago de 20121,411.13-0.0049694549-0.0044293591-0.004969454913 de ago de 201267.880.017236682313 de ago de 20121,418.160.00870392850.01723668230.00870392856 de ago de 201266.72-0.01014025996 de ago de 20121,405.870.0106406044-0.01014025990.010640604430 de jul de 201267.40.008343314230 de jul de 20121,390.990.00361546830.00834331420.003615468323 de jul de 201266.840.032385954723 de jul de 20121,385.970.01696158370.03238595470.016961583716 de jul de 201264.71-0.006469523516 de jul de 20121,362.660.0043244265-0.00646952350.00432442659 de jul de 201265.130.00276752949 de jul de 20121,356.780.00154898130.00276752940.00154898132 de jul de 201264.95-0.00629270742 de jul de 20121,354.68-0.0055064111-0.0062927074-0.005506411125 de jun de 201265.360.028240821725 de jun de 20121,362.160.02012540210.02824082170.020125402118 de jun de 201263.54-0.011423330518 de jun de 20121,335.02-0.0058405012-0.0114233305-0.005840501211 de jun de 201264.270.01710516411 de jun de 20121,342.840.01287632560.0171051640.01287632564 de jun de 201263.180.01178169974 de jun de 20121,325.660.03658279430.01178169970.036582794329 de may de 201262.44-0.008928630729 de may de 20121,278.04-0.0306512018-0.0089286307-0.030651201821 de may de 2012630.007648220821 de may de 20121,317.820.01729829130.00764822080.017298291314 de may de 201262.520.019543543814 de may de 20121,295.22-0.04393199110.0195435438-0.043931991111 de may de 201261.3111 de may de 20121,353.39