Upload
notas90
View
222
Download
0
Embed Size (px)
Citation preview
8/18/2019 Trabajo DF2
1/14
ABENGOA 2004 2005 2006 20071 0.358 0.351 0.356 2.162
2 0 0 0 0
3 7 9 9 14
4 0 1 1 3
5 28.57 22.22 22.22 50
6 42.85 55.55 55.55 28.57
7 6 6 8 8
8 50 60 60 75
9 25 20 20 25ROE 12.09 14.92 22.45 17.03
ROA 2.93 3.43 2.23 1.89
RENTABILIDAD 5.2 9.45 15.03 7.94
FAES FARMA 2004 2005 2006 20071 2.69 2.59 1.91 1.81
2 0 0 0 0.016
3 10 9 10 10
4 0 0 0 0
5 40 44.44 40 40
6 20 22.22 20 30
7 7 7 8 8
8 66.66 66.66 66.66 66.66
9 0 0 0 0
ROE 18.25 17.68 16.28 14.66
ROA 10.94 8.55 9.35 6.93
RENTABILIDAD 19.08 26.6 43.55 36.67
ENCE 2004 2005 2006 20071 6.61 20.241 41.788 50.33
2 0 0 0 0
3 11 12 12 14
4 0 0 0 0
5 54.54 7 58.3 42.85
6 36.56 4 33.52 35.74
7 18 15 14 13
8 0.67 0.67 1 0.25
9 0.33 0.33 0 0.5
8/18/2019 Trabajo DF2
2/14
8/18/2019 Trabajo DF2
3/14
2008 2009 2010 2011 2012 2013
2.245 2.229 2.343 2.432 2.51 2.51
2.426 0.16 0.25 3.21 3.39 3.39
15 15 15 15 15 15
3 3 3 3 3 3
46.66 46.66 46.66 46.66 53.33 46.67
33.33 40 33.33 33.33 26.66 26.67
11 15 15 11 15 16
60 60 60 60 60 60
20 20 20 20 20 2026.42 17.31 15.61 15.86 9.37 5.83
0.12 2.11 1.55 0.82 0.24 0.32
9.64 9.18 8.09 7.74 8.32 7.23
2008 2009 2010 2011 2012 2013
1.81 1.77 1.81 1.68 1.79 1.44
0.016 0.016 0.016 0.144 0.128 1.11
10 10 10 10 9 10
0 0 0 1 1 1
40 40 40 40 44.44 40
30 30 40 40 33.33 40
8 9 7 8 8 11
66.66 66.66 75 75 75 66.67
0 0 0 20 20 33
12.52 13.07 12.07 8.46 10.56 11.42
6.53 6.81 6.55 4.25 6.71 8.49
16.02 21.02 19.35 13.73 13.19 18.16
2008 2009 2010 2011 2012 2013
49.758 54.801 54.804 49.794 49.519 51.67
0 0.09 0.4 7.732 7.489 2.9
14 14 14 13 12 13
0 0 0 0 0 1
42.86 42.85 42.2 38.46 33.33 30.67
35.7142857 35.71 35.71 38.46 41.16 40.15
14 10 12 11 11 12
0.25 0.25 0.25 0.25 0.25 0.25
0.5 0.5 0.5 0.5 0.5 0.5
8/18/2019 Trabajo DF2
4/14
0.65 -26.47 8.34 5.72 5.94 0.59
0.35 -3.54 6.78 4.17 4.62 0.41
8/18/2019 Trabajo DF2
5/14
2014 ABENGO 1 20.33 2004 0.358 0
6.24 2005 0.351 0
16 2006 0.356 0
3 2007 2.162 0
43.75 2008 2.245 2.426
31.25 2009 2.229 0.16
18 2010 2.343 0.25
100 2011 2.432 3.21
0 2012 2.51 3.392013 2.51 3.39
2014 0.33 6.24
2014 FAES FAR 1 21.85 2004 2.69 0
1.31 2005 2.59 0
10 2006 1.91 0
1 2007 1.81 0.016
40 2008 1.81 0.016
40 2009 1.77 0.016
11 2010 1.81 0.016
67 2011 1.68 0.144
33 2012 1.79 0.128
2013 1.44 1.11
2014 1.85 1.31
2014
37.47 Olive!"
1.17 92.614 55.397 28.403 33.835
13
1
46.15 ENCE 1 238.46 2004 6.61 0
12 2005 20.241 0
0.4 2006 41.788 0
0.4 2007 50.33 0
8/18/2019 Trabajo DF2
6/14
2008 49.758 0
2009 54.801 0.09
2010 54.804 0.4
2011 49.794 7.732
2012 49.519 7.489
2013 51.67 2.9
2014 37.47 1.17
8/18/2019 Trabajo DF2
7/14
3 4 5 6 7 8
7 0 28.57 42.85 6 50
9 1 22.22 55.55 6 60
9 1 22.22 55.55 8 60
14 3 50 28.57 8 75
15 3 46.66 33.33 11 60
15 3 46.66 40 15 60
15 3 46.66 33.33 15 60
15 3 46.66 33.33 11 60
15 3 53.33 26.66 15 6015 3 46.67 26.67 16 60
16 3 43.75 31.25 18 100
3 4 5 6 7 8
10 0 40 20 7 66.66
9 0 44.44 22.22 7 66.66
10 0 40 20 8 66.66
10 0 40 30 8 66.66
10 0 40 30 8 66.66
10 0 40 30 9 66.66
10 0 40 40 7 75
10 1 40 40 8 75
9 1 44.44 33.33 8 75
10 1 40 40 11 66.67
10 1 40 40 11 67
18.065 30.407 25.403 26.662 28.76 35.74
3 4 5 6 7 8
11 0 54.54 36.56 18 0.67
12 0 7 4 15 0.67
12 0 58.3 33.52 14 1
14 0 42.85 35.74 13 0.25
8/18/2019 Trabajo DF2
8/14
14 0 42.86 35.7142857 14 0.25
14 0 42.85 35.71 10 0.25
14 0 42.2 35.71 12 0.25
13 0 38.46 38.46 11 0.25
12 0 33.33 41.16 11 0.25
13 1 30.67 40.15 12 0.25
13 1 46.15 38.46 12 0.4
8/18/2019 Trabajo DF2
9/14
9 ROE ROA RENTABILIDAD
25 12.09 2.93 5.2 roe roa 0.07239592
20 14.92 3.43 9.45 roe rent 0.60102536
20 22.45 2.23 15.03 roa rent 0.09587329
25 17.03 1.89 7.94
20 26.42 0.12 9.64
20 17.31 2.11 9.18
20 15.61 1.55 8.09
20 15.86 0.82 7.74
20 9.37 0.24 8.3220 5.83 0.32 7.23
0
9 ROE ROA RENTABILIDAD
0 18.25 10.94 19.08 roe roa 0.83633743
0 17.68 8.55 26.6 roe rent 0.58520637
0 16.28 9.35 43.55 roa rent 0.38772605
0 14.66 6.93 36.67
0 12.52 6.53 16.02
0 13.07 6.81 21.02
0 12.07 6.55 19.35
20 8.46 4.25 13.73
20 10.56 6.71 13.19
33 11.42 8.49 18.16
33
19.27
9 ROE ROA RENTABILIDAD
0.33 12.22 7.17 roe roa 0.78327737
0.33 8.68 8.03 roe rent #VALUE!
0 6.9 12.23 roa rent #VALUE!
0.5 7.76 6.14
8/18/2019 Trabajo DF2
10/14
0.5 0.65 0.35
0.5 -26.47 -3.54
0.5 8.34 6.78
0.5 5.72 4.17
0.5 5.94 4.62
0.5 0.59 0.41
0.4
8/18/2019 Trabajo DF2
11/14
ROE ROA RET
-0.1726524 -0.8722878 -0.1633034 1
-0.3300447 -0.7876403 -0.1163851 2
-0.0496156 -0.7560899 -0.4081529 3
-0.0191961 -0.7650657 0.56455715 4
-0.1892697 0.78260372 -0.1373978 5
0.36596739 -0.689812 0.16940649 6
-0.3358588 -0.1401879 -0.4588273 7
0.17574893 0.3839867 0.60102536 8
-0.1004199 0.07239592 0.09587329 9
ROE ROA RET
0.81724673 0.08050607 0.14909536 1
-0.3500298 -0.0337023 -0.5296083 2
-0.1034486 -0.3810711 -0.1490954 3
-0.728394 0.03370226 -0.560945 4
0.10344864 -0.7201178 -0.1133218 5
-0.8945082 -0.0633859 -0.5025736 6
-0.4142378 -0.6208239 -0.4704304 7
-0.6815857 -0.2380116 0.58520637 8
-0.650273 0.83633743 0.38772605 9
ROE ROA RET
-0.4477285 -0.1227635 #VALUE! 1
0.1121801 -0.5523387 #VALUE! 2
-0.4853441 -0.3268366 #VALUE! 3
-0.0783775 0.13430014 #VALUE! 4
C O
R R E L
A T I O !
8/18/2019 Trabajo DF2
12/14
-0.0348442 -0.3256567 #VALUE! 5
-0.1588432 0.52233684 #VALUE! 6
0.57320604 0.73784521 #VALUE! 7
0.34142529 -0.7237694 #VALUE! 8
-0.2784008 0.78327737 #VALUE! 9
8/18/2019 Trabajo DF2
13/14
8/18/2019 Trabajo DF2
14/14