studydata_for_analysis_.xlsx

Study Data

Descrip Options Revenues ROE Assets NI Common E ROI Age Tenure
2015 1.126 283 9.55 392 34 351 8.55 76 35
2014 0.879 247 9.22 345 28 306 8.17 75 34
2013 0.829 208 10.54 291 27 258 9.35 74 33
2012 0.573 184 10.27 252 23 219 8.93 73 32
2011 0.469 173 12.06 220 23 189 10.36 72 31
2010 0.475 141 11.44 180 18 153 9.72 71 30
2009 0.369 119 10.78 142 14 129 9.79 70 29
2014 38.645 2,820 13.25 3,838 338 2,550 8.81 62 27
2013 33.062 2,105 21.72 2,951 424 1,952 14.37 61 26
2012 26.630 1,378 60.24 2,080 750 1,245 36.06 60 25
2013 0.878 147 (16.03) 847 (61) 378 (7.15) 69 25
2011 7.450 446 (45.68) 1,324 (222) 486 (16.77) 59 24
2012 0.345 102 (35.79) 546 (66) 183 (12.00) 68 24
2014 9.074 2,234 19.90 4,202 657 3,302 15.64 56 23
2010 5.512 459 (19.70) 1,089 (104) 528 (9.55) 58 23
2011 0.611 99 (49.59) 485 (85) 171 (17.48) 67 23
2013 5.501 1,551 10.62 3,318 253 2,382 7.63 55 22
2009 3.456 379 (17.08) 741 (68) 397 (9.15) 57 22
2010 0.681 109 (24.98) 550 (61) 245 (11.13) 66 22
2012 6.845 1,134 12.94 2,614 255 1,971 9.76 54 21
2008 1.255 238 (19.74) 670 (83) 419 (12.34) 56 21
2009 1.070 122 (10.13) 657 (31) 302 (4.66) 65 21
2011 0.578 191 22.87 203 41 181 20.39 52 20
2014 1.214 70 2.63 213 5 205 2.54 53 20
2011 7.170 783 15.43 1,395 175 1,134 12.54 53 20
2010 1.191 50 (57.12) 144 (75) 132 (52.36) 66 20
2010 0.504 164 23.09 150 31 135 20.71 51 19
2013 1.735 65 (20.41) 163 (18) 88 (11.06) 52 19
2010 4.512 541 11.28 1,012 97 860 9.58 52 19
2014 29.460 1,280 27.38 1,884 340 1,242 18.05 60 19
2009 1.191 102 (29.04) 230 (54) 187 (23.61) 65 19
2009 0.139 109 11.36 107 10 86 9.13 50 18
2009 2.909 387 42.88 786 295 688 37.53 51 18
2013 36.097 1,117 13.90 2,088 175 1,259 8.38 59 18
2008 0.256 62 (6.78) 85 (5) 75 (5.98) 49 17
2008 3.898 259 13.44 478 33 247 6.95 50 17
2014 2.145 76 (214.24) 329 (190) 89 (57.58) 51 17
2008 5.888 176 (192.47) 980 (460) 239 (46.94) 58 17
2012 3.025 916 28.04 1,627 304 1,084 18.68 58 17
2014 8.586 13,062 (5.75) 52,529 (1,630) 28,336 (3.10) 61 17
2015 6.250 20,405 20.85 41,247 4,423 21,211 10.72 61 17
2013 0.706 81 (21.11) 340 (19) 92 (5.71) 68 17
2011 0.824 87 40.13 122 42 105 34.81 58 16
2013 8.393 8,678 (7.87) 22,726 (751) 9,537 (3.30) 60 16
2014 4.650 20,247 10.61 41,275 2,284 21,526 5.53 60 16
2012 2.209 150 (50.42) 230 (73) 144 (31.58) 49 15
2010 14.264 604 11.99 1,432 106 884 7.40 56 15
2012 7.008 5,915 2.54 14,104 97 3,834 0.69 59 15
2013 7.062 21,848 9.47 42,953 2,383 25,171 5.55 59 15
2015 7.124 41 (22.92) 1,387 (290) 1,265 (20.91) 53 14
2009 14.558 370 2.99 1,052 20 653 1.85 55 14
2011 8.731 4,584 7.32 6,698 261 3,564 3.90 58 14
2012 2.057 39,874 22.32 67,235 5,963 26,721 8.87 58 14
2014 1.055 47 (53.79) 123 (49) 91 (39.84) 59 14
2014 2.592 48 (31.60) 174 (38) 121 (22.04) 62 14
2008 3.426 282 - 0 871 - 0 508 - 0 54 13
2010 8.021 3,567 5.57 5,827 183 3,283 3.14 57 13
2011 1.836 38,851 19.35 60,277 4,729 24,440 7.85 57 13
2015 2.519 161 33.47 246 79 236 32.11 58 13
2013 2.521 58 (0.33) 126 (0) 79 (0.21) 61 13
2014 2.011 187 (17.96) 490 (46) 255 (9.33) 71 13
2013 5.127 47 (33.04) 421 (89) 270 (21.19) 51 12
2010 0.193 46 3.11 92 2 78 2.63 52 12
2014 1.053 50 12.50 172 20 161 11.71 55 12
2009 8.186 2,793 7.34 5,992 222 3,023 3.70 56 12
2010 2.726 35,167 20.66 59,462 4,626 22,388 7.78 56 12
2014 1.756 48 23.09 155 34 149 22.19 58 12
2013 4.587 914 19.30 2,941 143 741 4.86 62 12
2013 2.930 156 (22.10) 499 (62) 281 (12.44) 70 12
2012 1.424 67 (79.10) 288 (106) 134 (36.81) 50 11
2013 2.500 1,054 (1.33) 3,146 (19) 1,394 (0.59) 55 11
2008 8.344 2,535 11.29 3,677 238 2,108 6.47 55 11
2009 3.016 30,765 25.14 52,417 5,746 22,856 10.96 55 11
2011 0.887 44 (44.34) 104 (33) 75 (32.02) 56 11
2014 6.162 710 61.53 911 276 449 30.34 57 11
2012 4.169 735 11.46 1,875 64 560 3.42 61 11
2012 5.535 268 33.16 506 95 285 18.68 69 11
2011 0.561 83 (48.90) 282 (58) 118 (20.46) 49 10
2011 2.596 6,130 15.38 11,598 537 3,492 4.63 50 10
2012 2.875 926 15.54 1,932 154 991 7.97 54 10
2008 10.758 29,528 27.08 42,419 4,734 17,480 11.16 54 10
2014 1.810 40 (65.66) 248 (50) 76 (20.22) 55 10
2013 0.259 313 6.35 627 31 490 4.96 56 10
2011 3.393 541 15.89 1,313 87 550 6.66 60 10
2011 4.189 65,030 16.94 113,644 9,672 57,080 8.51 62 10
2011 6.440 193 25.80 281 49 188 17.26 68 10
2015 1.613 407 32.33 509 150 464 29.47 70 10
2010 0.728 100 (27.53) 393 (44) 158 (11.07) 48 9
2010 2.729 5,451 9.61 11,537 346 3,602 3.00 49 9
2011 2.198 754 4.13 1,887 33 800 1.75 53 9
2012 0.205 282 5.33 564 24 441 4.17 55 9
2010 2.410 337 (6.74) 852 (27) 402 (3.18) 59 9
2014 1.711 4,604 1.20 19,721 128 10,663 0.65 59 9
2014 5.868 749 (8.76) 2,475 (134) 1,528 (5.41) 61 9
2010 4.713 61,587 23.57 102,908 13,334 56,579 12.96 61 9
2014 0.459 135 16.24 182 25 155 13.86 66 9
2014 0.270 289 13.48 380 37 274 9.71 66 9
2010 2.530 74 (65.50) 164 (49) 75 (29.76) 67 9
2014 0.727 274 19.42 343 57 294 16.65 69 9
2015 0.852 1,797 7.65 4,461 204 2,668 4.57 69 9
2015 3.100 492 (1.52) 2,800 (30) 1,980 (1.07) 79 9
2010 2.343 48 (89.05) 604 (439) 493 (72.68) 44 8
2009 0.924 101 (26.74) 481 (48) 178 (9.90) 47 8
2009 2.419 5,064 7.44 10,802 233 3,131 2.16 48 8
2014 1.613 136 (23.03) 182 (35) 152 (19.23) 50 8
2010 1.262 636 14.22 1,415 94 663 6.66 52 8
2008 0.968 42 (51.27) 169 (63) 122 (36.98) 53 8
2011 0.897 273 5.56 547 23 414 4.20 54 8
2009 0.928 233 (11.78) 543 (44) 370 (8.03) 58 8
2013 1.552 3,540 2.36 13,880 205 8,693 1.48 58 8
2015 0.835 434 18.40 506 57 311 11.32 59 8
2013 6.851 548 (13.15) 2,249 (176) 1,341 (7.84) 60 8
2009 5.238 61,897 24.25 94,682 12,266 50,588 12.95 60 8
2013 2.699 5,630 391.78 4,311 572 146 13.27 62 8
2014 5.202 17,277 190.39 13,459 2,180 1,145 16.20 62 8
2014 6.386 198 (8.01) 362 (14) 171 (3.78) 63 8
2013 0.496 127 7.48 180 11 147 6.11 65 8
2013 0.260 245 12.54 310 30 236 9.55 65 8
2013 1.470 512 12.47 997 101 810 10.13 65 8
2015 0.373 195 21.35 183 35 166 19.32 67 8
2013 0.151 151 10.31 168 13 129 7.92 68 8
2014 0.852 1,718 10.51 4,458 270 2,570 6.06 68 8
2014 1.824 91 (20.89) 1,268 (175) 836 (13.77) 78 8
2008 2.015 96 (12.97) 555 (26) 202 (4.72) 46 7
2008 2.044 5,138 (6.69) 10,410 (181) 2,704 (1.74) 47 7
2009 1.055 562 16.90 978 80 471 8.14 51 7
2010 0.585 286 12.79 500 47 369 9.44 53 7
2015 5.414 628 (17.28) 1,856 (227) 1,314 (12.23) 53 7
2008 0.694 179 (18.73) 401 (47) 251 (11.72) 57 7
2014 1.824 659 (3.48) 1,886 (32) 920 (1.70) 57 7
2012 1.329 3,173 18.96 5,351 442 2,331 8.26 57 7
2014 0.579 375 22.83 487 57 251 11.77 58 7
2012 2.353 501 (11.22) 1,568 (114) 1,016 (7.27) 59 7
2008 3.979 63,747 30.46 84,912 12,949 42,511 15.25 59 7
2014 1.300 41 (34.33) 199 (55) 160 (27.61) 60 7
2014 0.470 44 (3.52) 161 (4) 125 (2.73) 60 7
2013 5.156 17,420 97.22 13,876 2,241 2,305 16.15 61 7
2014 2.249 60 (94.31) 151 (71) 76 (47.31) 62 7
2012 0.677 156 6.71 174 10 143 5.52 64 7
2012 0.465 184 (12.73) 172 (17) 132 (9.77) 64 7
2012 1.151 582 8.09 864 56 691 6.47 64 7
2012 0.171 123 3.60 158 4 111 2.53 67 7
2013 1.077 1,588 12.31 3,137 296 2,405 9.44 67 7
2013 1.970 97 (13.01) 1,392 (114) 876 (8.19) 77 7
2012 4.394 5,915 2.54 14,104 97 3,834 0.69 51 6
2015 2.268 182 (23.53) 171 (33) 139 (19.15) 52 6
2010 0.980 66 (33.14) 336 (81) 245 (24.17) 52 6
2009 0.885 235 12.90 345 31 241 9.01 52 6
2014 4.980 619 (2.15) 1,921 (30) 1,397 (1.56) 52 6
2014 3.486 59 (33.91) 420 (117) 345 (27.86) 56 6
2013 1.151 70 (164.93) 463 (221) 134 (47.73) 56 6
2013 0.878 688 1.74 1,741 16 892 0.89 56 6
2013 0.691 318 14.43 458 30 210 6.62 57 6
2011 3.629 441 (6.96) 1,306 (54) 773 (4.12) 58 6
2013 1.700 68 (3.26) 163 (3) 104 (2.09) 59 6
2012 5.384 17,085 112.93 13,394 2,472 2,189 18.46 60 6
2015 3.260 22,859 130.39 53,050 5,144 3,945 9.70 62 6
2015 5.843 48,851 10.75 167,460 6,960 64,720 4.16 62 6
2011 0.422 134 19.00 200 29 150 14.25 63 6
2011 5.450 152 (18.59) 231 (26) 142 (11.43) 63 6
2011 1.686 513 10.86 794 66 603 8.25 63 6
2012 2.421 1,445 11.31 2,941 248 2,193 8.43 66 6
2013 1.833 2,617 (130.23) 6,572 (685) 526 (10.42) 67 6
2013 0.444 318 20.15 432 52 260 12.13 47 5
2014 1.209 297 (48.81) 1,135 (264) 540 (23.22) 48 5
2014 3.517 158 (24.53) 412 (39) 160 (9.53) 50 5
2011 4.663 4,584 7.32 6,698 261 3,564 3.90 50 5
2008 0.309 179 - 0 291 - 0 199 - 0 51 5
2013 3.627 576 2.63 1,470 25 952 1.70 51 5
2012 2.317 362 (22.89) 1,351 (188) 820 (13.89) 52 5
2010 2.321 211 (54.24) 244 (51) 94 (20.98) 53 5
2013 0.957 65 (12.70) 492 (54) 424 (10.96) 55 5
2014 0.688 165 (8.12) 369 (17) 209 (4.61) 55 5
2012 1.392 559 8.74 972 51 586 5.27 55 5
2012 0.571 277 38.77 394 63 163 16.04 56 5
2010 3.144 376 28.69 1,263 206 717 16.30 57 5
2014 0.334 597 12.45 2,669 78 628 2.93 57 5
2011 1.733 72 (67.68) 607 (134) 198 (22.08) 59 5
2010 2.500 5,234 726.51 4,548 603 83 13.26 59 5
2011 4.236 16,734 107.54 12,724 2,554 2,375 20.07 59 5
2014 2.763 19,960 101.84 27,547 1,774 1,742 6.44 61 5
2014 6.362 49,605 12.75 169,274 9,086 71,272 5.37 61 5
2010 0.549 85 25.67 98 21 82 21.57 62 5
2010 1.291 880 49.21 693 250 508 36.08 62 5
2010 0.297 125 8.78 140 8 89 5.57 65 5
2011 2.229 1,331 9.03 2,625 175 1,937 6.67 65 5
2012 1.761 3,027 (68.97) 6,569 (740) 1,073 (11.27) 66 5
2014 1.649 222 22.89 215 38 166 17.63 38 4
2013 5.875 49 (56.02) 142 (63) 113 (44.48) 49 4
2012 0.722 368 21.90 194 25 116 13.09 49 4
2010 3.074 3,567 5.57 5,827 183 3,283 3.14 49 4
2012 3.749 390 (13.35) 1,435 (114) 854 (7.94) 50 4
2011 1.655 447 (9.24) 1,412 (76) 823 (5.39) 51 4
2009 1.080 164 (44.21) 261 (54) 121 (20.50) 52 4
2009 0.330 313 9.51 791 31 329 3.96 53 4
2011 1.840 485 25.00 693 128 512 18.47 54 4
2009 2.575 50,009 9.58 212,949 8,621 89,953 4.05 54 4
2015 4.563 70,074 21.66 133,411 15,409 71,150 11.55 54 4
2011 0.329 256 13.70 336 14 100 4.08 55 4
2009 1.822 325 - 0 917 - 0 322 - 0 56 4
2013 0.160 624 12.90 1,796 73 563 4.04 56 4
2010 3.019 159 (41.79) 521 (38) 91 (7.27) 58 4
2010 2.000 3,917 11.21 6,046 357 3,184 5.90 58 4
2010 3.905 15,564 82.36 11,172 2,203 2,675 19.72 58 4
2014 12.669 580 (67.38) 2,335 (739) 1,096 (31.63) 59 4
2014 2.000 4,464 9.99 6,650 333 3,337 5.01 59 4
2013 3.617 18,790 91.90 29,198 4,128 4,492 14.14 60 4
2014 3.323 42,237 24.50 98,335 11,920 48,647 12.12 60 4
2013 6.066 51,584 14.87 172,101 11,341 76,274 6.59 60 4
2009 1.935 358 22.57 661 50 222 7.58 61 4
2014 2.500 4,785 43.61 6,588 583 1,337 8.85 63 4
2009 0.042 119 8.38 125 7 78 5.20 64 4
2011 1.222 2,730 9.50 7,293 188 1,978 2.58 65 4
2009 5.662 18,808 21.82 31,008 3,239 14,843 10.45 66 4
2014 0.454 56 20.54 260 29 140 11.06 58 3
2013 1.874 99 50.82 101 40 80 40.00 37 3
2011 2.963 137 27.22 307 43 158 14.01 45 3
2011 0.603 368 20.14 176 18 87 10.00 48 3
2009 1.945 2,793 7.34 5,992 222 3,023 3.70 48 3
2011 1.921 187 (11.61) 452 (46) 392 (10.07) 49 3
2010 2.045 325 (12.16) 1,353 (85) 698 (6.27) 50 3
2008 0.183 327 (63.61) 801 (187) 294 (23.35) 52 3
2012 0.895 47 (17.38) 336 (54) 310 (16.06) 53 3
2010 2.228 259 81.88 305 122 149 40.00 53 3
2010 0.313 438 29.33 474 105 358 22.15 53 3
2008 2.222 48,296 13.96 111,148 8,026 57,483 7.22 53 3
2014 4.168 74,331 23.40 131,119 16,323 69,742 12.45 53 3
2010 0.367 227 8.61 352 9 108 2.64 54 3
2014 0.839 124 29.57 1,389 136 460 9.79 55 3
2008 7.891 296 11.14 906 31 277 3.40 55 3
2009 0.548 51 (29.38) 157 (31) 106 (19.83) 57 3
2009 1.258 72 (100.98) 576 (103) 102 (17.88) 57 3
2009 1.422 3,879 15.40 5,503 404 2,624 7.34 57 3
2009 4.282 15,327 73.52 11,134 2,291 3,116 20.58 57 3
2013 7.529 1,212 (32.82) 2,319 (445) 1,356 (19.19) 58 3
2013 1.933 4,003 (0.28) 6,179 (8) 2,962 (0.13) 58 3
2012 0.730 18,380 156.85 27,008 5,275 3,363 19.53 59 3
2013 4.000 44,033 8.85 105,645 4,404 49,765 4.17 59 3
2012 6.498 58,986 11.68 185,798 9,490 81,221 5.11 59 3
2010 0.192 143 19.42 155 27 137 17.16 62 3
2013 2.000 4,561 53.62 6,558 504 940 7.69 62 3
2013 1.110 401 (7.21) 1,201 (18) 251 (1.51) 63 3
2009 0.553 1,080 6.52 2,552 101 1,540 3.94 63 3
2010 1.222 1,716 16.48 3,912 287 1,742 7.34 64 3
2008 5.123 20,597 25.77 29,552 3,155 12,241 10.68 65 3
2010 5.600 45,987 1.58 105,781 861 54,376 0.81 65 3
2010 3.160 86 25.12 111 22 87 19.64 44 2
2013 0.995 6,909 21.21 15,236 624 2,942 4.10 44 2
2014 0.972 1,179 (6.94) 1,241 (27) 392 (2.19) 47 2
2008 2.029 2,536 11.28 3,678 238 2,109 6.47 47 2
2010 3.483 178 (9.59) 516 (40) 413 (7.67) 48 2
2009 1.003 250 (2.66) 1,325 (20) 751 (1.51) 49 2
2009 0.102 820 13.00 2,067 176 1,354 8.51 49 2
2015 1.969 3,268 (5.03) 19,350 (300) 5,968 (1.55) 50 2
2015 3.000 5,655 491.53 4,164 580 118 13.93 51 2
2011 6.015 2,463 3.99 13,142 160 4,007 1.22 52 2
2013 2.670 71,312 18.68 132,683 13,831 74,053 10.42 52 2
2014 2.061 85 (42.16) 478 (35) 84 (7.36) 53 2
2014 1.292 4,409 123.30 3,777 720 584 19.06 53 2
2013 0.725 81 (5.58) 265 (10) 172 (3.62) 54 2
2014 3.984 41 (90.82) 480 (117) 129 (24.33) 55 2
2008 0.299 84 19.63 161 24 120 14.69 56 2
2008 2.402 3,630 18.07 5,074 321 1,776 6.33 56 2
2008 4.742 15,330 101.77 9,979 1,957 1,923 19.61 56 2
2012 2.556 1,527 (10.71) 2,759 (107) 999 (3.88) 57 2
2012 3.716 4,092 1.45 6,089 44 3,042 0.73 57 2
2014 0.327 366 7.76 197 10 129 5.08 58 2
2011 0.343 17,639 145.43 25,948 3,243 2,230 12.50 58 2
2012 3.800 47,267 11.63 106,132 6,168 53,020 5.81 58 2
2011 6.919 67,425 10.59 188,002 8,697 82,145 4.63 58 2
2010 8.999 143 (149.80) 1,725 (755) 504 (43.77) 59 2
2012 0.442 4,336 10.83 6,262 436 4,026 6.96 61 2
2008 0.193 1,047 4.62 2,588 65 1,417 2.53 62 2
2009 2.995 1,461 17.77 2,489 266 1,497 10.69 63 2
2009 2.805 27,428 21.84 112,090 12,901 59,058 11.51 64 2
2011 0.423 61 (42.60) 267 (77) 181 (28.88) 42 1
2012 1.378 6,796 19.19 11,932 641 3,341 5.37 43 1
2013 2.166 995 (15.22) 1,233 (42) 276 (3.41) 46 1
2009 1.037 327 30.11 566 131 435 23.14 47 1
2008 1.742 194 (2.19) 510 (10) 475 (2.04) 48 1
2008 0.162 757 16.64 1,624 200 1,202 12.32 48 1
2014 1.823 2,877 (30.36) 10,910 (721) 2,375 (6.61) 49 1
2014 0.463 5,591 362.34 4,258 558 154 13.10 50 1
2008 1.670 348 - 0 387 - 0 298 - 0 51 1
2012 1.483 67,224 16.74 121,347 10,853 64,826 8.94 51 1
2013 0.517 85 (23.06) 211 (26) 111 (12.13) 52 1
2013 0.967 4,201 222.60 3,474 650 292 18.71 52 1
2012 1.892 85 (9.71) 258 (17) 173 (6.51) 53 1
2010 4.084 302 8.07 1,057 29 362 2.76 53 1
2008 0.665 68 (37.38) 158 (45) 119 (28.26) 54 1
2011 7.078 1,411 5.24 2,204 41 787 1.87 56 1
2011 2.450 4,057 (0.32) 5,779 (9) 2,938 (0.16) 56 1
2013 0.775 378 16.76 200 18 105 8.80 57 1
2011 3.000 48,047 11.50 105,128 6,272 54,517 5.97 57 1
2010 0.838 67,809 9.42 195,014 8,266 87,761 4.24 57 1
2013 7.992 81 (114.38) 432 (175) 153 (40.51) 58 1
2009 10.699 102 (58.52) 1,956 (642) 1,097 (32.82) 58 1
2008 0.145 140 - 0 146 - 0 128 - 0 60 1
2011 0.369 4,233 6.59 5,711 245 3,720 4.29 60 1
2011 4.753 264 (38.98) 301 (33) 84 (10.93) 61 1
2008 1.875 1,261 23.23 1,957 262 1,128 13.39 62 1
2008 6.408 23,850 41.62 47,196 7,808 18,758 16.54 63 1