Spreadsheet: 105602d1302897307-conditional-formatting-without-changing-current-formats-testexcelfile
Sheet: Summary

 |  |  |  |  | Adjusted Market Share - Top 20 YOY Comparison |  |  |  |  |  |  |  | *For Internal Use Only
 |  |  |  |  | Data as of June 2010
Unadjusted |  |  |  |  |  | 2010 |  |  |  |  | 2009
2010 Rank | name | BHC ID | # of Offices | Cash | Market Share % | change | % Growth | avg | Change in Share BPs | # of Offices | Cash Value | Market Share % | 2009 Rank
1 | [NAME] | 1039502 | 101 | 8798929 | 0.1481 | 482971 | 0.05807761414860441 | 87118.10891089108 | 157 | 0 | 8315958 | 0.1324 | 2
2 | [NAME] | 1231333 | 79 | 7188912 | 0.121 | -1298504 | -0.1529916761473692 | 90998.88607594937 | -142 | 0 | 8487416 | 0.1352 | 1
3 | [NAME] | 2260406 | 47 | 6772224 | 0.114 | 681098 | 0.1118180776427872 | 144089.8723404255 | 170 | 0 | 6091126 | 0.097 | 3
4 | [NAME] | 1073757 | 47 | 3068304 | 0.0516 | -385468 | -0.111607830511105 | 65283.06382978724 | -34 | 0 | 3453772 | 0.055 | 5
5 | [NAME] | 1069778 | 40 | 2565492 | 0.0432 | -1421596 | -0.3565499432167035 | 64137.3 | -203 | 0 | 3987088 | 0.0635 | 4
6 | [NAME] | 1070345 | 45 | 2197165 | 0.037 | -218820 | -0.0905717543776141 | 48825.88888888889 | -15 | 0 | 2415985 | 0.0385 | 6
7 | [NAME] | 1951350 | 15 | 2168185 | 0.0365 | 134105 | 0.06592906866986549 | 144545.6666666667 | 41 | 0 | 2034080 | 0.0324 | 8
8 | Darin | 1199611 | 7 | 2132084 | 0.0359 | 127104 | 0.06339414857006055 | 304583.4285714286 | 40 | 0 | 2004980 | 0.0319 | 9
9 | [NAME] | 1208184 | 21 | 1646162 | 0.0277 | 113397 | 0.07398198680162973 | 78388.66666666667 | 33 | 0 | 1532765 | 0.0244 | 10
10 | [NAME] | 1070804 | 18 | 1367880 | 0.023 | 555740 | 0.6842908858078657 | 75993.33333333333 | 101 | 0 | 812140 | 0.0129 | 17
11 | [NAME] | 1119794 | 24 | 1148575 | 0.0193 | 267250 | 0.3032366039769665 | 47857.29166666666 | 53 | 0 | 881325 | 0.014 | 14
12 | Peggy | 1205398 | 2 | 1091859 | 0.0184 | -91638 | -0.07742985406807115 | 545929.5 | -4.000000000000011 | 0 | 1183497 | 0.0188 | 11
13 | [NAME] | 1090987 | 13 | 1018083 | 0.0171 | -1193091 | -0.5395735478076352 | 78314.07692307692 | -181 | 0 | 2211174 | 0.0352 | 7
14 | Gerard | 1201112 | 8 | 930785 | 0.0157 | 67530 | 0.07822717505256269 | 116348.125 | 20 | 0 | 863255 | 0.0137 | 15
15 | Rita | 3833526 | 18 | 905013 | 0.0152 | -64667 | -0.06668901080768913 | 50278.5 | -2.000000000000005 | 0 | 969680 | 0.0154 | 13
16 | Julie | 1199974 | 12 | 899833 | 0.0151 | 159055 | 0.2147134499134694 | 74986.08333333333 | 33 | 0 | 740778 | 0.0118 | 18
17 | Carol | 1199563 | 17 | 864686 | 0.0146 | 206636 | 0.3140126130233265 | 50863.88235294117 | 41 | 0 | 658050 | 0.0105 | 22
18 | Claudia | 1130098 | 17 | 856550 | 0.0144 | 32236 | 0.03910645700546151 | 50385.29411764706 | 13 | 0 | 824314 | 0.0131 | 16
19 | Anna | 1401109 | 7 | 783348 | 0.0132 | 68548 | 0.09589815332960269 | 111906.8571428571 | 18 | 0 | 714800 | 0.0114 | 19
20 | [NAME] | 2389941 | 46 | 639766 | 0.0108 | -38669 | -0.05699735420489804 | 13907.95652173913 | 0 | 0 | 678435 | 0.0108 | 21
Top 20 Banks: |  |  | 584 | 47043835 | 0.7918 | -1816783 | -0.03718297218426504 | 80554.51198630137 |  | 0 | 48860618 | 0.7779
All Other Banks: |  |  | 216 | 12384085 | 0.2082000000000001 | -1544412 | -0.1108814540434621 | 57333.72685185185 |  | 805 | 13928497 | 0.2221
Total Market: |  |  | 800 | 59427920 | 1 | -3361195 | -0.05353149188358523 | 74284.9 |  | 805 | 62789115 | 1