PRECIOS DE ACCIONES

FECHA EMPRESA 1 EMPRESA 2 EMPRESA 3 EMPRESA 4 EMPRESA 5 EMPRESA 6

31-Dec 7.80 7.10 11.00 6.90 18.00 13.00
30-Nov 7.00 7.10 11.27 7.60 17.07 12.60
31-Oct 6.80 7.00 11.72 7.66 17.58 11.00
30-Sep 4.80 5.41 9.00 3.05 11.26 10.50
31-Aug 3.20 6.65 10.10 3.99 16.29 10.00
31-Jul 4.80 6.75 8.70 4.06 14.96 9.50
30-Jun 4.80 7.40 10.00 4.55 16.75 9.90
31-May 3.00 6.50 10.00 3.88 16.08 9.90
30-Apr 3.00 6.00 9.00 3.50 15.50 8.00
31-Mar 3.50 5.11 6.72 5.20 11.55 9.60
28-Feb 2.99 3.50 8.00 5.20 12.20 7.10
31-Jan 4.50 5.60 8.10 3.50 14.05 6.10
31-Dec 4.00 5.35 6.70 3.50 12.46 5.11
30-Nov 4.00 6.00 8.00 3.25 14.25 6.25
31-Oct 5.60 7.36 9.12 4.27 16.39 8.00
30-Sep 5.60 6.44 7.27 3.58 13.85 8.61
31-Aug 3.80 5.76 7.72 3.07 14.49 6.33
31-Jul 3.80 4.91 6.01 2.43 12.14 8.00
30-Jun 3.30 6.20 9.10 3.15 16.95 7.13
31-May 3.79 5.98 8.17 2.99 15.86 6.90
30-Apr 4.11 6.56 9.00 3.42 17.12 6.10
31-Mar 4.20 6.15 8.10 3.11 15.91 4.50
29-Feb 2.60 3.85 5.10 4.10 11.19 4.20
31-Jan 4.20 6.42 8.64 3.32 16.66 4.30
31-Dec 4.20 6.10 8.00 3.08 15.78 4.50
 RETORNOS MENSUALES
EMPRESA 1 EMPRESA 2 EMPRESA 3 EMPRESA 4 EMPRESA 5 EMPRESA 6
11.43% 0.00% -2.40% -9.23% 5.44% 3.17%
2.94% 1.43% -3.84% -0.78% -2.90% 14.55%
41.67% 29.51% 30.22% 150.88% 56.09% 4.76%
50.00% -18.72% -10.89% -23.42% -30.84% 5.00%
-33.33% -1.48% 16.09% -1.85% 8.86% 5.26%
0.00% -8.78% -13.00% -10.71% -10.67% -4.04%
60.00% 13.85% 0.00% 17.42% 4.20% 0.00%
0.00% 8.33% 11.11% 10.71% 3.71% 23.75%
-14.29% 17.42% 33.93% -32.69% 34.17% -16.67%
17.06% 46.00% -16.00% 0.00% -5.31% 35.21%
-33.56% -37.50% -1.23% 48.57% -13.17% 16.39%
12.50% 4.67% 20.90% 0.00% 12.74% 19.32%
0.00% -10.83% -16.25% 7.69% -12.54% -18.20%
-28.57% -18.48% -12.28% -23.89% -13.06% -21.88%
0.00% 14.37% 25.45% 19.40% 18.37% -7.10%
47.37% 11.72% -5.83% 16.49% -4.44% 36.04%
0.00% 17.43% 28.45% 26.40% 19.37% -20.88%
15.15% -20.89% -33.96% -22.90% -28.38% 12.20%
-12.93% 3.68% 11.38% 5.53% 6.91% 3.33%
-7.79% -8.77% -9.22% -12.62% -7.37% 13.11%
-2.14% 6.59% 11.11% 9.76% 7.56% 35.56%
61.54% 59.74% 58.82% -24.09% 42.23% 7.14%
-38.10% -40.03% -40.97% 23.68% -32.83% -2.33%
0.00% 5.25% 8.00% 7.80% 5.58% -4.44%
 INDICADORES EMPRESA 1 EMPRESA 2 EMPRESA 3 EMPRESA 4
RETORNO ESPERADO (PROM) 6.21% 3.10% 3.73% 7.59%
DESVIACIÓN ESTANDAR 28.51% 22.89% 22.57% 36.10%
COEFICIENTE DE VARIACIÓN 4.59 7.38 6.05 4.76
DESEMPEÑO 0.22 0.14 0.17 0.21
EMPRESA 5 EMPRESA 6 VARIACIÓN/PROMEDIO
2.65% 5.80% EMPRESA 1 EMPRESA 2 EMPRESA 3 EMPRESA 4
21.51% 16.81% 5.22% -3.10% -6.13% -16.82%
8.10 2.90 -25.57% -21.47% -26.41% -36.88%
0.12 0.35 -417.76% -708.10% -574.32% -324.67%
28.23% -32.28% -27.43% -44.45%
-33.33% -1.48% 16.09% -1.85%
0.00% -8.78% -13.00% -10.71%
60.00% 13.85% 0.00% 17.42%
0.00% 8.33% 11.11% 10.71%
-14.29% 17.42% 33.93% -32.69%
17.06% 46.00% -16.00% 0.00%
-33.56% -37.50% -1.23% 48.57%
12.50% 4.67% 20.90% 0.00%
 VARIACIÓN/PROMEDIO (ABS)
EMPRESA 5 EMPRESA 6 EMPRESA 1 EMPRESA 2 EMPRESA 3 EMPRESA 4 EMPRESA 5
2.79% -2.63% 5.22% 3.10% 6.13% 16.82% 2.79%
-24.41% -2.26% 25.57% 21.47% 26.41% 36.88% 24.41%
-754.12% -284.83% 417.76% 708.10% 574.32% 324.67% 754.12%
-43.19% -29.53% 28.23% 32.28% 27.43% 44.45% 43.19%
8.86% 5.26% 33.33% 1.48% 16.09% 1.85% 8.86%
-10.67% -4.04% 0.00% 8.78% 13.00% 10.71% 10.67%
4.20% 0.00% 60.00% 13.85% 0.00% 17.42% 4.20%
3.71% 23.75% 0.00% 8.33% 11.11% 10.71% 3.71%
34.17% -16.67% 14.29% 17.42% 33.93% 32.69% 34.17%
-5.31% 35.21% 17.06% 46.00% 16.00% 0.00% 5.31%
-13.17% 16.39% 33.56% 37.50% 1.23% 48.57% 13.17%
12.74% 19.32% 12.50% 4.67% 20.90% 0.00% 12.74%
53.96% 75.25% 62.21% 45.40% 76.44%
EMPRESA 6
2.63%
2.26%
284.83%
29.53%
5.26%
4.04%
0.00%
23.75%
16.67%
35.21%
16.39%
19.32%
36.66% =+AVERAGE(AK5:AK16)
 EMPRESA 1 EMPRESA
9.00 8.00
8.00
7.00
7.00
6.00
6.00
5.00
5.00
4.00
4.00

3.00 3.00

2.00 2.00

1.00 1.00
- -
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 1 2 3 4 5 6 7 8 9 10 11 12 13 1

EMPRESA 4 EMPRESA
9.00 20.00

8.00 18.00

7.00 16.00
14.00
6.00
12.00
5.00
10.00
4.00
8.00
3.00
6.00
2.00 4.00
1.00 2.00
- -
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 1 2 3 4 5 6 7 8 9 10 11 12 13
 EMPRESA 2 EMPRESA 3
14.00

12.00

10.00

8.00

6.00

4.00

2.00

-
3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 2

EMPRESA 5 EMPRESA 6
14.00

12.00

10.00

8.00

6.00

4.00

2.00

-
2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 2
 EMPRESA 3

8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25

EMPRESA 6

8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25
 EMPRESA 1 EMPRES
100.00%
100.00%
0.00%
1 2 3 4 5 6
0.00%
1 2 3 4 5 6 7 8 9 10 11 12 -100.00%

-200.00%
-100.00%
-300.00%
-200.00%
-400.00%

-500.00%
-300.00%
-600.00%
-400.00%
-700.00%

-800.00%
-500.00%

EMPRESA 4
100.00% EMPRESA
50.00% 100.00%

0.00% 0.00%
1 2 3 4 5 6 7 8 9 10 11 12 1 2 3 4 5 6
-50.00% -100.00%

-100.00% -200.00%

-150.00% -300.00%

-200.00% -400.00%

-250.00% -500.00%

-300.00% -600.00%

-350.00% -700.00%

-800.00%
 EMPRESA 2 EMPRESA 3
100.00%

0.00%
1 2 3 4 5 6 7 8 9 10 11 12 1 2 3 4 5 6 7 8 9 10 11
-100.00%

-200.00%

-300.00%

-400.00%

-500.00%

-600.00%

-700.00%

EMPRESA 5 EMPRESA 6
100.00%

50.00%
1 2 3 4 5 6 7 8 9 10 11 12
0.00%
1 2 3 4 5 6 7 8 9 10 11
-50.00%

-100.00%

-150.00%

-200.00%

-250.00%

-300.00%

-350.00%
RESA 3

6 7 8 9 10 11 12

ESA 6

6 7 8 9 10 11 12