Spreadsheet: 854563d1704387324-filter-function-how-to-condense-a-worksheet-after-filtering-condensing-filtered-data-gk4
Sheet: 3. FinalResults

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | All Current Contracts except the New Adds
StepID | PrevRC | CurrRC | NumContracts | PrevBalance | CurrBalance | CurrBalance2 | PrevBal_x_PrevFtpRate | CurBal_x_PrevFtpRate | CurBal_x_CurrFtpRate | PrevBal_x_PrevCoupon | CurBal_x_PrevCoupon | CurBal_x_CurrCoupon |  |  |  | Step ID | [NAME] | [NAME] | ResponsibilityCenterCode |  | [NAME] | Balance | FTP Rate | Coupon | Spread |  | [NAME] | Balance | FTP Rate | Coupon | Spread |  | [NAME] | Balance | FTP Rate | Coupon
2 | 998699 | NULL | 42 | 43378390.645 | NULL | NULL | 2342237.00295719 | NULL | NULL | 0 | NULL | NULL | NULL |  |  | 1 | 0 | 0 | 0 | 0 | 36 | 104385.93 | 0.05812418237130952 | 0.1241201799227156 | 0.06599599755140612 |  | 36 | 104385.93 | 0.05812418237130953 | 0.1241201799227156 |  |  | 0 | 0 | 0 | 0
2 | 998803 | NULL | 3 | 507236.96 | NULL | NULL | 25361.62890677 | NULL | NULL | 31624.3090925 | NULL | NULL | NULL |  |  | 1 | 0 | 0 | 113000 | Acquired Loans | 3 | 509906.47 | 0.02972396879582642 | 0.03214874739675298 | 0.002424778600926554 |  | 3 | 509906.47 | 0.02972396879582642 | 0.03214874739675298 |  |  | 0 | 0 | 0 | 0
2 | 994931 | NULL | 63 | 2275569.14 | NULL | NULL | 113824.682408055 | NULL | NULL | 140806.578012786 | NULL | NULL | NULL |  |  | 1 | 0 | 0 | 181000 | General Bank | 44740 | 1139191682.64001 | 0.02786520496764959 | 0.04502330577260046 | 0.01715810080495088 |  | 44740 | 1139191682.639999 | 0.02786520496764973 | 0.04502330577260108 |  |  | 0 | 1.120567321777344e-05 | -1.422473250300982e-16 | -6.175615574477433e-16
1 | 998608 | 998608 | 310 | 852286227.125 | 835852263.765 | 835852263.765 | 37185218.8365734 | 36126358.4765875 | 36035442.075919 | 46305527.7965191 | 45042174.8950206 | 45032714.1529052 | 998608 |  |  | 1 | 0 | 0 | 311000 | Acquired Loans | 4 | 134052.475 | 0.0450604759069163 | 0.03910760114649132 | -0.005952874760424977 |  | 4 | 134052.475 | 0.0450604759069163 | 0.03910760114649132 |  |  | 0 | 0 | 0 | 0
1 | 998667 | 998667 | 1 | 254564.99 | 247753.365 | 247753.365 | 3205.73691907 | 3119.958125445 | 3107.32270383 | 0 | 0 | 0 | 998667 |  |  | 1 | 0 | 0 | 796000 | Acquired Loans | 288 | 20621235 | 0.02834030567030273 | 0.04536105876513948 | 0.01702075309483676 |  | 288 | 20621235 | 0.02834030567030272 | 0.04536105876513943 |  |  | 0 | 0 | 0 | 5.551115123125783e-17
1 | 998678 | 998678 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 998678 |  |  | 1 | 0 | 0 | 838000 | Acquired Loans | 16 | 494989.28 | 0.01751965861139346 | 0.04258389523708472 | 0.02506423662569126 |  | 16 | 494989.28 | 0.01751965861139346 | 0.04258389523708474 |  |  | 0 | 0 | 0 | 0
1 | 998791 | 998791 | 70 | 24879831.525 | 24989603.425 | 24989603.425 | 711516.270152741 | 714350.081295434 | 714335.412044211 | 1167385.87346775 | 1173202.0713135 | 1173237.6213135 | 998791 |  |  | 1 | 0 | 0 | 858000 | SBA Lending | 45 | 5552975.79 | 0.0035 | 0.01 | 0.006500000000000001 |  | 45 | 5552975.79 | 0.0035 | 0.01 |  |  | 0 | 0 | 0 | 0
2 | 998402 | NULL | 3559 | 0 | NULL | NULL | 0 | NULL | NULL | 0 | NULL | NULL | NULL |  |  | 1 | 0 | 0 | 859000 | SBA Lending | 498 | 342136265.45 | 0.03577023267867145 | 0.07045483808767194 | 0.03468460540900049 |  | 498 | 342136265.45 | 0.03577023267867149 | 0.07045483808767194 |  |  | 0 | 0 | 0 | 0
2 | 998522 | NULL | 80 | 3419209.91 | NULL | NULL | 183515.441883861 | NULL | NULL | 224048.213667323 | NULL | NULL | NULL |  |  | 1 | 0 | 0 | 860000 | Commercial Segment | 126 | 849773518.845 | 0.04934619313696943 | 0.0654551906278145 | 0.01610899749084508 |  | 126 | 849773518.845 | 0.04934619313696946 | 0.06545519062781449 |  |  | 0 | 0 | 0 | 0
1 | 935000 | 935000 | 148 | 11075729.2 | 11160692.8 | 11160692.8 | 333936.8539173 | 336775.991962326 | 338186.045922608 | 610177.1724685 | 614794.9840515 | 614794.9840515 | 935000 |  |  | 1 | 0 | 0 | 869000 | Acquired Loans | 6 | 263597.65 | 0.04855659896727076 | 0.07588684075502948 | 0.02733024178775872 |  | 6 | 263597.65 | 0.04855659896727076 | 0.07588684075502948 |  |  | 0 | 0 | 0 | 0
1 | 0 | 998516 | 1 | 2770.92 | 6530.49 | 6530.49 | 161.057459416309 | 379.579391734013 | 376.991197827687 | 0 | 0 | 0 | 998516 |  |  | 1 | 0 | 0 | 899000 | Acquired Loans | 3 | 25550.835 | 0.00864261537216451 | 0.03946614650754075 | 0.03082353113537624 |  | 3 | 25550.835 | 0.008642615372164514 | 0.03946614650754075 |  |  | 0 | 0 | 0 | 0
1 | 980000 | 980000 | 62 | 12250816.995 | 12294785.735 | 12294785.735 | 618290.090056929 | 620194.815975082 | 620194.451518933 | 677628.994192632 | 679954.602411889 | 679954.602411889 | 980000 |  |  | 1 | 0 | 0 | 935000 | Acquired Loans | 148 | 11075729.2 | 0.0301503267087191 | 0.05509137696039914 | 0.02494105025168004 |  | 148 | 11075729.2 | 0.03015032670871905 | 0.05509137696039914 |  |  | 0 | 0 | 4.510281037539698e-17 | 0
1 | 998775 | 998775 | 128 | 66580285.92 | 66929751.76 | 66929751.76 | 1722224.42003163 | 1716583.91620419 | 1716583.75761048 | 2968884.91214705 | 2975820.6052164 | 2975820.6052164 | 998775 |  |  | 1 | 0 | 0 | 944000 | Corporate City | 5486 | 54268005.8549999 | 0.05638737328925113 | 0.07666671416584739 | 0.02027934087659626 |  | 5486 | 54268005.855 | 0.0563873732892508 | 0.07666671416584743 |  |  | 0 | -1.043081283569336e-07 | 3.261280134836397e-16 | 0
1 | 998778 | 998778 | 14 | 5188782.46 | 5226052.56 | 5226052.56 | 164791.090954941 | 166004.713197397 | 166004.009833057 | 236608.09516 | 238321.9616586 | 238321.9616586 | 998778 |  |  | 1 | 0 | 0 | 944004 | Corporate | 0 | 0 | #[NAME]! | #[NAME]! | #[NAME]! |  | 0 | 0 | #[NAME]! | #[NAME]! |  |  | 0 | 0 | #[NAME]! | #[NAME]!
1 | 998504 | 998502 | 2 | 1385.315 | 1888.21 | 1888.21 | 80.5203017017106 | 109.75066239533 | 109.002318302335 | 266.534606 | 363.291604 | 363.291604 | 998502 |  |  | 1 | 0 | 0 | 956001 | Acquired Loans | 524 | 7311168.74000001 | 0.05369685543011752 | 0.08332790352061388 | 0.02963104809049636 |  | 524 | 7311168.74 | 0.0536968554301176 | 0.08332790352061413 |  |  | 0 | 9.313225746154785e-09 | -7.632783294297951e-17 | -2.498001805406602e-16
1 | 988000 | 988000 | 38 | 5630618.755 | 5883748.175 | 5883748.175 | 122234.653235391 | 129365.203744049 | 129365.061479367 | 311654.4889585 | 321564.2557675 | 321564.2557675 | 988000 |  |  | 1 | 0 | 0 | 956002 | Acquired Loans | 456 | 17989348.425 | 0.04206470117109563 | 0.05343522636446867 | 0.01137052519337304 |  | 456 | 17989348.425 | 0.04206470117109565 | 0.05343522636446869 |  |  | 0 | 0 | 0 | 0
2 | 998624 | NULL | 1 | -5000 | NULL | NULL | -208.31512 | NULL | NULL | 0 | NULL | NULL | NULL |  |  | 1 | 0 | 0 | 957000 | Mortgage | 13 | 990475.405 | 0.05076627573973429 | 0.05888374804238224 | 0.008117472302647942 |  | 13 | 990475.405 | 0.05076627573973429 | 0.05888374804238224 |  |  | 0 | 0 | 0 | 0 |  | <-- Compare to Ending values on the prior tab
2 | 998801 | NULL | 1 | 150412.46 | NULL | NULL | 7981.78760236 | NULL | NULL | 9475.98498 | NULL | NULL | NULL |  |  | 1 | 0 | 0 | 957001 | Mortgage | 194 | 31204114.925 | 0.03456847016146797 | 0.04873165276152308 | 0.01416318260005511 |  | 194 | 31204114.925 | 0.03456847016146797 | 0.04873165276152314 |  |  | 0 | 0 | 0 | -5.551115123125783e-17 |  | <-- Should see no changes here
1 | 970010 | 970010 | 454 | 188738171.605 | 191145539.235 | 191145539.235 | 6329326.38727181 | 6376271.95264287 | 6357699.15636957 | 10915770.7964201 | 11104664.6956707 | 10819586.7300022 | 970010 |  |  | 1 | 0 | 0 | 957002 | Mortgage | 107 | 46528260.34 | 0.02798038403632737 | 0.04649297691373067 | 0.0185125928774033 |  | 107 | 46528260.34 | 0.02798038403632737 | 0.04649297691373063 |  |  | 0 | 0 | 0 | 0
1 | 970021 | 970021 | 6 | 4288031.235 | 4305702.73 | 4305702.73 | 180202.58498501 | 180686.23433435 | 179983.756818125 | 291210.021753742 | 292169.353414343 | 291808.820730545 | 970021 |  |  | 1 | 0 | 0 | 957003 | Mortgage | 8 | 1203714.325 | 0.02640294835632201 | 0.04354170930465582 | 0.01713876094833381 |  | 8 | 1203714.325 | 0.02640294835632201 | 0.04354170930465582 |  |  | 0 | 0 | 0 | 0
2 | 998782 | NULL | 5 | 408185.17 | NULL | NULL | 20311.9763667 | NULL | NULL | 25025.081855 | NULL | NULL | NULL |  |  | 1 | 0 | 0 | 957004 | Mortgage | 6 | 1856561.865 | 0.03421526219015869 | 0.05363182476550546 | 0.01941656257534677 |  | 6 | 1856561.865 | 0.03421526219015869 | 0.05363182476550546 |  |  | 0 | 0 | 0 | 0
1 | 978000 | 978000 | 318 | 32898093.465 | 33122699.255 | 33122699.255 | 1851417.32074781 | 1864096.41504739 | 1855803.11474536 | 1800822.78736128 | 1812539.79047579 | 1789997.45086892 | 978000 |  |  | 1 | 0 | 0 | 957005 | Mortgage | 6 | 1257117.885 | 0.02077705344746567 | 0.04596089947887187 | 0.0251838460314062 |  | 6 | 1257117.885 | 0.02077705344746567 | 0.04596089947887187 |  |  | 0 | 0 | 0 | 0
1 | 970030 | 970030 | 1950 | 201553971.12 | 205122455.065 | 205122455.065 | 5807033.34255289 | 5927657.55703607 | 5862564.45147661 | 9958638.87905895 | 10155592.0971565 | 10092280.7095091 | 970030 |  |  | 1 | 0 | 0 | 957006 | Mortgage | 209 | 74596469.67 | 0.04169135800024328 | 0.05849252683617205 | 0.01680116883592877 |  | 209 | 74596469.67 | 0.04169135800024335 | 0.05849252683617204 |  |  | 0 | 0 | -6.938893903907228e-17 | 0
1 | 998513 | 994860 | 7 | 8483265.905 | 8080673.47 | 8080673.47 | 201538.575509955 | 192171.01713892 | 192609.73698055 | 308024.585547 | 293227.17415 | 293227.17415 | 994860 |  |  | 1 | 0 | 0 | 957007 | Mortgage | 409 | 45751446.31 | 0.03037946464644387 | 0.04663994688520591 | 0.01626048223876204 |  | 409 | 45751446.31 | 0.03037946464644398 | 0.04663994688520591 |  |  | 0 | 0 | -1.144917494144693e-16 | 0
1 | 998620 | 998620 | 342 | 1976847282.785 | 1998590960.67 | 1998590960.67 | 115873437.71526 | 117756938.444791 | 114121559.335349 | 164162499.754818 | 165863065.169943 | 165661363.19702 | 998620 |  |  | 1 | 0 | 0 | 957008 | Mortgage | 22 | 2800962.73 | 0.05561964575323714 | 0.0878455782855829 | 0.03222593253234576 |  | 22 | 2800962.73 | 0.05561964575323714 | 0.08784557828558272 |  |  | 0 | 0 | 0 | 1.804112415015879e-16
1 | 998514 | 994761 | 3 | 13532.08 | 14189.25 | 14189.25 | 768.67627232 | 806.006157 | 804.019662 | 1488.5288 | 1560.8175 | 1560.8175 | #N/A |  |  | 1 | 0 | 0 | 957009 | Mortgage | 2852 | 1841960571.665 | 0.01914246289881064 | 0.03356176555455558 | 0.01441930265574494 |  | 2852 | 1841960571.665 | 0.01914246289881059 | 0.03356176555455564 |  |  | 0 | 0 | 5.204170427930421e-17 | -5.551115123125783e-17
1 | 998799 | 998799 | 30 | 11308512.61 | 11338426.505 | 11338426.505 | 256715.487330339 | 255168.782342063 | 255168.344956103 | 490640.7321583 | 490874.6133663 | 490874.6133663 | 998799 |  |  | 1 | 0 | 0 | 957010 | 3rd Party Originations | 5582 | 2368105609.86501 | 0.02066884946392585 | 0.03702834135665262 | 0.01635949189272677 |  | 5582 | 2368105609.864999 | 0.02066884946392599 | 0.03702834135665266 |  |  | 0 | 1.096725463867188e-05 | -1.422473250300982e-16 | 0
1 | 970070 | 970070 | 1681 | 348119585.615 | 261025184.285 | 261025184.285 | 17736823.5230939 | 12358921.6429701 | 11972716.3822289 | 20681521.8246011 | 15454186.5593641 | 14581529.9027302 | 970070 |  |  | 1 | 0 | 0 | 957011 | 3rd Party Originations | 105 | 124087568.435 | 0.02916631702978394 | 0.03864791435738878 | 0.009481597327604847 |  | 105 | 124087568.435 | 0.02916631702978389 | 0.03864791435738878 |  |  | 0 | 0 | 4.510281037539698e-17 | 0
1 | 998628 | 998628 | 281 | 910819025.360001 | 907701966.564999 | 907701966.564999 | 35770926.8684777 | 35559562.1093199 | 35559562.1093199 | 37303701.9329937 | 37099032.559117 | 37099032.559117 | 998628 |  |  | 1 | 0 | 0 | 961000 | SBA Lending | 114 | 130243760.04 | 0.04648185119681553 | 0.04284006963474717 | -0.003641781562068368 |  | 114 | 130243760.04 | 0.0464818511968156 | 0.04284006963474717 |  |  | 0 | 0 | -6.245004513516506e-17 | 0
1 | 998507 | 998504 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 998504 |  |  | 1 | 0 | 0 | 964000 | General Bank | 131 | 230852.96 | 0.05812418237130942 | 0.2034189865011911 | 0.1452948041298817 |  | 131 | 230852.96 | 0.05812418237130942 | 0.2034189865011911 |  |  | 0 | 0 | 0 | 0
1 | 997901 | 997901 | 6 | -1.81898940354586e-12 | -1.81898940354586e-12 | -1.81898940354586e-12 | 153.58883214 | 153.58883214 | 153.58883214 | 0 | 0 | 0 | 997901 |  |  | 1 | 0 | 0 | 968000 | Acquired Loans | 230 | 19790371.41 | 0.05528378452097883 | 0.0930995967077583 | 0.03781581218677947 |  | 230 | 19790371.41 | 0.0552837845209786 | 0.0930995967077583 |  |  | 0 | 0 | 2.359223927328458e-16 | 0
1 | 981000 | 981000 | 16 | 1673118.54 | 1687192.855 | 1687192.855 | 35193.81944373 | 35531.79143762 | 35623.17340037 | 79182.751719 | 79968.823896 | 79968.823896 | 981000 |  |  | 1 | 0 | 0 | 969000 | Acquired Loans | 247 | 52402579.225 | 0.04037268346923548 | 0.04753168816321082 | 0.007159004693975339 |  | 247 | 52402579.22500001 | 0.04037268346923538 | 0.0475316881632107 |  |  | 0 | 0 | 1.040834085586084e-16 | 1.179611963664229e-16
2 | 998638 | NULL | 19 | 25328506.825 | NULL | NULL | 1283544.76256053 | NULL | NULL | 1490507.73552689 | NULL | NULL | NULL |  |  | 1 | 0 | 0 | 969001 | Acquired Loans | 5 | 877276.755 | 0.04918247115633994 | 0.05379624809245459 | 0.004613776936114651 |  | 5 | 877276.755 | 0.04918247115633994 | 0.05379624809245459 |  |  | 0 | 0 | 0 | 0
1 | 998504 | 998516 | 9 | 20461.2 | 39974.535 | 39974.535 | 1189.29052033584 | 2323.48716254829 | 2307.6442705302 | 1726.3823 | 3384.388475 | 3384.388475 | 998516 |  |  | 1 | 0 | 0 | 970000 | Acquired Loans | 90 | 7760341.4 | 0.01750945787846962 | 0.04393438144957128 | 0.02642492357110166 |  | 90 | 7760341.399999999 | 0.01750945787846963 | 0.04393438144957128 |  |  | 0 | 0 | 0 | 0
1 | 0 | 998504 | 32 | 94133.005 | 157105.895 | 157105.895 | 5471.40394977939 | 9131.6516925878 | 9069.38675992778 | 11249.054761 | 19816.288884 | 19816.288884 | 998504 |  |  | 1 | 0 | 0 | 970001 | Acquired Loans | 6 | 1330986.595 | 0.006756604947024279 | 0.04914312693547451 | 0.04238652198845023 |  | 6 | 1330986.595 | 0.006756604947024278 | 0.0491431269354745 |  |  | 0 | 0 | 0 | 0
1 | 957008 | 957008 | 22 | 2800962.73 | 2811800.245 | 2811800.245 | 155788.55481062 | 156387.24842642 | 156345.11062712 | 246052.190773215 | 246998.015374398 | 243879.528613658 | 957008 |  |  | 1 | 0 | 0 | 970002 | Acquired Loans | 1150 | 131914836.81 | 0.04522553707407941 | 0.05309747632277695 | 0.007871939248697543 |  | 1150 | 131914836.81 | 0.04522553707407938 | 0.05309747632277697 |  |  | 0 | 0 | 0 | 0
2 | 998773 | NULL | 5 | 1014489.99 | NULL | NULL | 51190.53568648 | NULL | NULL | 67256.637555 | NULL | NULL | NULL |  |  | 1 | 0 | 0 | 970003 | Acquired Loans | 42 | 29722066.035 | 0.0175143434268571 | 0.0347750675295628 | 0.0172607241027057 |  | 42 | 29722066.035 | 0.0175143434268571 | 0.0347750675295628 |  |  | 0 | 0 | 0 | 0
2 | 998787 | NULL | 3 | 300820.515 | NULL | NULL | 15017.788012825 | NULL | NULL | 16733.242785 | NULL | NULL | NULL |  |  | 1 | 0 | 0 | 970004 | Acquired Loans | 210 | 46934480.72 | 0.02541027789160527 | 0.04583537226061803 | 0.02042509436901276 |  | 210 | 46934480.71999999 | 0.02541027789160522 | 0.04583537226061804 |  |  | 0 | 0 | 5.551115123125783e-17 | 0
1 | 970002 | 970002 | 1150 | 131914836.81 | 132283983.225 | 132283983.225 | 5965919.34277179 | 5983094.4587834 | 5956851.38171916 | 7004344.92414196 | 7027800.4548472 | 6988674.35461057 | 970002 |  |  | 1 | 0 | 0 | 970010 | Acquired Loans | 454 | 188738171.605 | 0.03353495656680472 | 0.05783552263749345 | 0.02430056607068873 |  | 454 | 188738171.605 | 0.03353495656680469 | 0.05783552263749318 |  |  | 0 | 0 | 0 | 2.706168622523819e-16
2 | 964000 | NULL | 3 | 9458.45 | NULL | NULL | 549.764672749912 | NULL | NULL | 1782.24018 | NULL | NULL | NULL |  |  | 1 | 0 | 0 | 970011 | Acquired Loans | 5 | 5204391.72 | 0.04360757044477524 | 0.0591818063456607 | 0.01557423590088546 |  | 5 | 5204391.720000001 | 0.04360757044477524 | 0.05918180634566069 |  |  | 0 | 0 | 0 | 0
1 | 998650 | 998650 | 5 | -0.04 | -0.04 | -0.04 | -0.00055893 | -0.00055893 | -0.00055651 | 0 | 0 | 0 | 998650 |  |  | 1 | 0 | 0 | 970020 | Acquired Loans | 166 | 30850376.27 | 0.03413558124586206 | 0.05764007416985971 | 0.02350449292399764 |  | 166 | 30850376.27 | 0.03413558124586202 | 0.0576400741698597 |  |  | 0 | 0 | 0 | 0
1 | 998514 | 998514 | 262 | 35852534.12 | 32280669.97 | 32280669.97 | 1715071.92254658 | 1504288.43187604 | 1511021.15564536 | 2120561.216059 | 1889017.790315 | 1889017.790315 | 998514 |  |  | 1 | 0 | 0 | 970021 | Acquired Loans | 6 | 4288031.235 | 0.04202455045433222 | 0.06791229023165965 | 0.02588773977732743 |  | 6 | 4288031.235 | 0.04202455045433222 | 0.06791229023165965 |  |  | 0 | 0 | 0 | 0
1 | 998830 | 998830 | 1513 | -2.63327137872693e-10 | -2.63327137872693e-10 | -2.63327137872693e-10 | -9025.32831591 | -9025.32831591 | -9025.32831591 | 0 | 0 | 0 | 998830 |  |  | 1 | 0 | 0 | 970030 | Acquired Loans | 1950 | 201553971.12 | 0.0288113070175905 | 0.04940929133631326 | 0.02059798431872276 |  | 1950 | 201553971.12 | 0.02881130701759052 | 0.04940929133631326 |  |  | 0 | 0 | 0 | 0
1 | 998630 | 998630 | 98671 | 1866231834.85498 | 1939095476.93 | 1939095476.93 | 66004964.3490028 | 67728674.6312406 | 67730887.406974 | 186445252.729114 | 193199207.857895 | 193212880.83489 | 998630 |  |  | 1 | 0 | 0 | 970031 | Acquired Loans | 234 | 18336059.06 | 0.0370888406479216 | 0.06074135657370587 | 0.02365251592578427 |  | 234 | 18336059.06 | 0.03708884064792163 | 0.06074135657370559 |  |  | 0 | 0 | 0 | 2.775557561562891e-16
1 | 998675 | 998675 | 9 | 77476.88 | 91859.225 | 91859.225 | 4503.27897850459 | 5339.24168429942 | 5302.83561767546 | 0 | 0 | 0 | 998675 |  |  | 1 | 0 | 0 | 970040 | Acquired Loans | 121 | 26977715.65 | 0.0276897064857087 | 0.0524644226496123 | 0.0247747161639036 |  | 121 | 26977715.65 | 0.0276897064857087 | 0.0524644226496123 |  |  | 0 | 0 | 0 | 0
1 | 998782 | 998782 | 160 | 56859864.395 | 57045173.21 | 57045173.21 | 1588772.68832823 | 1564810.52186588 | 1564722.3590067 | 2593423.0205288 | 2586541.34831141 | 2586541.34831141 | 998782 |  |  | 1 | 0 | 0 | 970041 | Acquired Loans | 15 | 5329525.05 | 0.03506026664071971 | 0.06108674888609446 | 0.02602648224537475 |  | 15 | 5329525.050000001 | 0.0350602666407197 | 0.06108674888609444 |  |  | 0 | 0 | 0 | 0
2 | 998621 | NULL | 16 | 32983260.555 | NULL | NULL | 1684420.77673811 | NULL | NULL | 2645903.39335073 | NULL | NULL | NULL |  |  | 1 | 0 | 0 | 970050 | Corporate | 3 | 0 | #[NAME]! | #[NAME]! | #[NAME]! |  | 3 | 0 | #[NAME]! | #[NAME]! |  |  | 0 | 0 | #[NAME]! | #[NAME]!
1 | 998794 | 998794 | 217 | 85293164.875 | 85902684.7700001 | 85902684.7700001 | 2267739.39511323 | 2273697.6071943 | 2273413.3001479 | 3813252.9843998 | 3833984.4380406 | 3833984.4380406 | 998794 |  |  | 1 | 0 | 0 | 970060 | Acquired Loans | 1615 | 374031.155 | 0.05812418237130941 | 0.1793397662288319 | 0.1212155838575225 |  | 1615 | 374031.155 | 0.05812418237130941 | 0.1793397662288319 |  |  | 0 | 0 | 0 | 0
2 | 998501 | NULL | 10 | 1404231.13 | NULL | NULL | 78341.03593449 | NULL | NULL | 112077.1791652 | NULL | NULL | NULL |  |  | 1 | 0 | 0 | 970070 | Acquired Loans | 1681 | 348119585.615 | 0.05095037526187853 | 0.05940924521113747 | 0.008458869949258936 |  | 1681 | 348119585.615 | 0.05095037526187854 | 0.05940924521113741 |  |  | 0 | 0 | 0 | 5.551115123125783e-17
1 | 957001 | 957001 | 194 | 31204114.925 | 32105132.245 | 32105132.245 | 1078678.51569988 | 1097404.51637968 | 1084475.78587619 | 1520628.09325576 | 1560032.03248223 | 1517209.61987668 | 957001 |  |  | 1 | 0 | 0 | 978000 | Acquired Loans | 318 | 32898093.465 | 0.05627734393537173 | 0.0547394270515147 | -0.001537916883857023 |  | 318 | 32898093.465 | 0.05627734393537172 | 0.05473942705151449 |  |  | 0 | 0 | 0 | 2.151057110211241e-16
1 | 970050 | 970050 | 3 | 0 | 0 | 0 | 13.29933157 | 13.29933157 | 13.21417496 | 0 | 0 | 0 | 970050 |  |  | 1 | 0 | 0 | 980000 | Acquired Loans | 62 | 12250816.995 | 0.05046929444046675 | 0.05531296357371079 | 0.004843669133244036 |  | 62 | 12250816.995 | 0.05046929444046677 | 0.05531296357371079 |  |  | 0 | 0 | 0 | 0
2 | 998802 | NULL | 6 | 388402.555 | NULL | NULL | 19420.017613755 | NULL | NULL | 24283.038238 | NULL | NULL | NULL |  |  | 1 | 0 | 0 | 981000 | Acquired Loans | 16 | 1673118.54 | 0.02103486310284386 | 0.0473264444962758 | 0.02629158139343194 |  | 16 | 1673118.54 | 0.02103486310284387 | 0.04732644449627579 |  |  | 0 | 0 | 0 | 0
1 | 991917 | 991917 | 61 | 14040818.43 | 12656921.86 | 12656921.86 | 816118.092740837 | 735680.236123127 | 730667.878227318 | 1094815.46352382 | 992679.611744132 | 992256.297139992 | 991917 |  |  | 1 | 0 | 0 | 982000 | Acquired Loans | 2 | 0 | #[NAME]! | #[NAME]! | #[NAME]! |  | 2 | 0 | #[NAME]! | #[NAME]! |  |  | 0 | 0 | #[NAME]! | #[NAME]!
2 | 998631 | NULL | 93701 | 1023436424.70999 | NULL | NULL | 32864748.1949649 | NULL | NULL | 67852777.1141167 | NULL | NULL | NULL |  |  | 1 | 0 | 0 | 983000 | Acquired Loans | 90 | 20606935.205 | 0.02372695118491464 | 0.04539487020863615 | 0.02166791902372151 |  | 90 | 20606935.205 | 0.02372695118491463 | 0.04539487020863615 |  |  | 0 | 0 | 0 | 0
1 | 998733 | 998733 | 3 | -171317.285 | -171236.465 | -171236.465 | 3131.196580875 | 3137.381331375 | 3154.521123825 | 0 | 0 | 0 | 998733 |  |  | 1 | 0 | 0 | 983001 | Acquired Loans | 12 | 2831811.18 | 0.02279351470287295 | 0.0427831670798404 | 0.01998965237696745 |  | 12 | 2831811.18 | 0.02279351470287295 | 0.0427831670798404 |  |  | 0 | 0 | 0 | 0
1 | 869000 | 869000 | 6 | 263597.65 | 264754.245 | 264754.245 | 12799.405379765 | 12837.707820455 | 12849.55405275 | 20003.59288895 | 20037.7698789 | 20037.7698789 | 869000 |  |  | 1 | 0 | 0 | 984000 | Acquired Loans | 34 | 5792854.195 | 0.0364628829987555 | 0.04865748440626858 | 0.01219460140751307 |  | 34 | 5792854.195 | 0.0364628829987555 | 0.04865748440626857 |  |  | 0 | 0 | 0 | 0
1 | 998798 | 998798 | 200 | 60117192.22 | 60492872.14 | 60492872.14 | 1572789.55947156 | 1571414.9121695 | 1571406.68895403 | 2670730.70281597 | 2680904.08264357 | 2680904.08264357 | 998798 |  |  | 1 | 0 | 0 | 985000 | Acquired Loans | 296 | 11693184.335 | 0.03384126072558771 | 0.05357763743904068 | 0.01973637671345297 |  | 296 | 11693184.335 | 0.03384126072558766 | 0.05357763743904068 |  |  | 0 | 0 | 5.551115123125783e-17 | 0
1 | 957011 | 957011 | 105 | 124087568.435 | 124367598.51 | 124367598.51 | 3619177.36043022 | 3627830.38310657 | 3627814.672666 | 4795725.7176925 | 4806866.75971 | 4806866.75971 | 957011 |  |  | 1 | 0 | 0 | 987000 | Acquired Loans | 124 | 32505592.28 | 0.03097333573568622 | 0.06710804216812905 | 0.03613470643244283 |  | 124 | 32505592.28 | 0.03097333573568621 | 0.06710804216812905 |  |  | 0 | 0 | 0 | 0
1 | 998774 | 998774 | 105 | 26081498.455 | 26276745.495 | 26276745.495 | 754471.246764817 | 752893.233057639 | 752881.792176629 | 1263112.29412021 | 1268625.70233438 | 1268625.70233438 | 998774 |  |  | 1 | 0 | 0 | 988000 | Acquired Loans | 38 | 5630618.755 | 0.02170892020114954 | 0.05534995397828173 | 0.03364103377713219 |  | 38 | 5630618.755 | 0.02170892020114955 | 0.05534995397828173 |  |  | 0 | 0 | 0 | 0
1 | 998504 | 0 | 223 | 66789.775 | 28442.39 | 28442.39 | 3882.10106263873 | 1653.19066343591 | 1641.91824429441 | 5175.067884 | 0 | 0 | 0 |  |  | 1 | 0 | 0 | 989001 | Acquired Loans | 1755 | 15216433.44 | 0.05592478015037011 | 0.08037705121063574 | 0.02445227106026562 |  | 1755 | 15216433.44 | 0.05592478015037011 | 0.08037705121063572 |  |  | 0 | 0 | 0 | 0
1 | 998520 | 998520 | 902 | 43892095.535 | 43964215.54 | 43964215.54 | 2214778.37623588 | 2214282.68580389 | 2216388.50555789 | 3340881.304754 | 3343066.1739765 | 3343066.1739765 | 998520 |  |  | 1 | 0 | 0 | 991917 | Private Banking | 61 | 14040818.43 | 0.05812468103690428 | 0.0779737640638246 | 0.01984908302692032 |  | 61 | 14040818.43 | 0.05812468103690427 | 0.0779737640638246 |  |  | 0 | 0 | 0 | 0
1 | 998517 | 998503 | 9 | 8537849.29 | 9232382.67 | 9232382.67 | 436374.26642902 | 474629.23209357 | 483320.95115509 | 609741.557767912 | 668400.341607912 | 668232.973080672 | 998503 |  |  | 1 | 0 | 0 | 994860 | 3rd Party Originations | 841 | 393808166.425 | 0.02992120708442238 | 0.04454662178265924 | 0.01462541469823686 |  | 841 | 393808166.425 | 0.02992120708442235 | 0.04454662178265923 |  |  | 0 | 0 | 3.816391647148976e-17 | 0
1 | 970040 | 970040 | 121 | 26977715.65 | 27673037.945 | 27673037.945 | 747005.02800341 | 756345.32192934 | 747307.216323735 | 1415370.27598266 | 1442026.79116739 | 1441004.30381297 | 970040 |  |  | 1 | 0 | 0 | 994861 | Mortgage | 8527 | 3811081476.58 | 0.02411057170175378 | 0.04171912560273106 | 0.01760855390097727 |  | 8527 | 3811081476.58 | 0.02411057170175376 | 0.04171912560273101 |  |  | 0 | 0 | 0 | 0
1 | 944000 | 0 | 6 | 3171.03 | 2885.285 | 2885.285 | 184.313526024894 | 167.704831533204 | 166.561322079087 | 12.295384 | 0 | 0 | 0 |  |  | 1 | 0 | 0 | 994931 | SBA Lending | 3603 | 218972562.730001 | 0.02418226475460589 | 0.04080595078996585 | 0.01662368603535996 |  | 3603 | 218972562.73 | 0.02418226475460603 | 0.04080595078996602 |  |  | 0 | 1.013278961181641e-06 | -1.387778780781446e-16 | -1.665334536937735e-16
2 | 989001 | NULL | 7 | 13928.83 | NULL | NULL | 776.825701885 | NULL | NULL | 1082.67402707 | NULL | NULL | NULL |  |  | 1 | 0 | 0 | 994934 | Controller | 0 | 0 | #[NAME]! | #[NAME]! | #[NAME]! |  | 0 | 0 | #[NAME]! | #[NAME]! |  |  | 0 | 0 | #[NAME]! | #[NAME]!
1 | 957003 | 957003 | 8 | 1203714.325 | 1211711.65 | 1211711.65 | 31781.60715874 | 31971.50856753 | 31971.50856753 | 52411.779225 | 52718.25058125 | 52718.25058125 | 957003 |  |  | 1 | 0 | 0 | 994959 | Acquired Loans | 22 | 1457445.17 | 0.03789276195481165 | 0.05035196864695776 | 0.0124592066921461 |  | 22 | 1457445.17 | 0.03789276195481166 | 0.05035196864695776 |  |  | 0 | 0 | 0 | 0
2 | 998629 | NULL | 54 | 119309868.205 | NULL | NULL | 6800690.84253652 | NULL | NULL | 9622604.44803398 | NULL | NULL | NULL |  |  | 1 | 0 | 0 | 994963 | Corporate Finance | 92 | 622496819.255 | 0.03951551835779316 | 0 | -0.03951551835779316 |  | 92 | 622496819.255 | 0.03951551835779316 | 0 |  |  | 0 | 0 | 0 | 0
1 | 983000 | 983000 | 90 | 20606935.205 | 20608807.345 | 20608807.345 | 488939.745679734 | 481570.557273736 | 479484.440830168 | 935449.14902875 | 927394.85690375 | 927394.85690375 | 983000 |  |  | 1 | 0 | 0 | 994990 | Corporate | 5 | 442680.875000001 | 0.0578246023880556 | 0.005539258465819185 | -0.05228534392223642 |  | 5 | 442680.875000001 | 0.05782460238805583 | 0.005539258465819184 |  |  | 0 | 0 | -2.220446049250313e-16 | 0
1 | 970031 | 970031 | 234 | 18336059.06 | 18509025.09 | 18509025.09 | 680063.172587219 | 687458.155236771 | 694627.735767152 | 1113757.10151999 | 1125681.17074585 | 1117078.39238585 | 970031 |  |  | 1 | 0 | 0 | 997901 | Mortgage | 6 | -1.81898940354586e-12 | -84436353417232.94 | 0 | 84436353417232.94 |  | 6 | -1.81898940354586e-12 | -84436353417232.94 | 0 |  |  | 0 | 0 | 0 | 0
2 | 998516 | NULL | 220 | 587465.78 | NULL | NULL | 33504.4441821509 | NULL | NULL | 35352.96282335 | NULL | NULL | NULL |  |  | 1 | 0 | 0 | 998402 | Managed | 6122 | 0 | #[NAME]! | #[NAME]! | #[NAME]! |  | 6122 | 0 | #[NAME]! | #[NAME]! |  |  | 0 | 0 | #[NAME]! | #[NAME]!
1 | 859000 | 859000 | 498 | 342136265.45 | 341134788.91 | 341134788.91 | 12238293.8229582 | 12140471.4672804 | 12172437.8137282 | 24105155.1862005 | 23976567.294131 | 24145988.3290435 | 859000 |  |  | 1 | 0 | 0 | 998501 | Commercial Banking | 695 | 149943567.86 | 0.03027229760043172 | 0.04268789349318114 | 0.01241559589274942 |  | 695 | 149943567.86 | 0.03027229760043176 | 0.04268789349318108 |  |  | 0 | 0 | -3.816391647148976e-17 | 5.551115123125783e-17
1 | 998609 | 998609 | 7 | -1.01 | -1.01 | -1.01 | -0.01412485 | -0.01412485 | -0.01405819 | 0 | 0 | 0 | 998609 |  |  | 1 | 0 | 0 | 998502 | Commercial Banking | 17086 | 11608215176.7 | 0.02927095529347019 | 0.04191409563204328 | 0.01264314033857308 |  | 17086 | 11608215176.70001 | 0.02927095529347022 | 0.0419140956320432 |  |  | 0 | 0 | 0 | 7.632783294297951e-17
1 | 998781 | 998781 | 89 | 43019924.225 | 43513433.73 | 43513433.73 | 1336053.3307708 | 1349952.05921175 | 1349952.05921109 | 1980109.88765345 | 2002401.455025 | 2002401.455025 | 998781 |  |  | 1 | 0 | 0 | 998503 | Business Banking | 43500 | 11044989296.695 | 0.02923970168680382 | 0.04372206569149691 | 0.01448236400469308 |  | 43500 | 11044989296.69498 | 0.02923970168680388 | 0.04372206569149703 |  |  | 0 | 2.09808349609375e-05 | -6.245004513516506e-17 | -1.249000902703301e-16
1 | 957004 | 957004 | 6 | 1856561.865 | 1864348.105 | 1864348.105 | 63522.750983225 | 63776.42449721 | 63776.42449721 | 99570.80061 | 99973.672555 | 99973.672555 | 957004 |  |  | 1 | 0 | 0 | 998504 | Retail Banking | 609295 | 5866326280.17471 | 0.04125800282386123 | 0.07096591992865023 | 0.029707917104789 |  | 609295 | 5866326280.175001 | 0.04125800282386179 | 0.07096591992864859 |  |  | 0 | -0.0002908706665039062 | -5.620504062164855e-16 | 1.637578961322106e-15
2 | 998619 | NULL | 36 | 48748363.705 | NULL | NULL | 2714660.292721 | NULL | NULL | 4001032.2946954 | NULL | NULL | NULL |  |  | 1 | 0 | 0 | 998505 | Trust | 1 | 0 | #[NAME]! | #[NAME]! | #[NAME]! |  | 1 | 0 | #[NAME]! | #[NAME]! |  |  | 0 | 0 | #[NAME]! | #[NAME]!
1 | 970011 | 970011 | 5 | 5204391.72 | 5211417.215 | 5211417.215 | 226950.878552105 | 227239.955679835 | 227239.955679835 | 308005.30292 | 308427.4318675 | 308427.4318675 | 970011 |  |  | 1 | 0 | 0 | 998507 | Private Banking | 5782 | 510607943.905001 | 0.04386380352798452 | 0.05977788202957344 | 0.01591407850158892 |  | 5782 | 510607943.905 | 0.04386380352798465 | 0.05977788202957366 |  |  | 0 | 1.013278961181641e-06 | -1.318389841742373e-16 | -2.220446049250313e-16
1 | 998660 | 998660 | 67 | 83697456.48 | 77186265.37 | 77186265.37 | 3769636.44897473 | 3430409.54048506 | 3430424.60303562 | 5221068.0730475 | 4778183.02281375 | 4778183.02281375 | 998660 |  |  | 1 | 0 | 0 | 998513 | Private Banking | 1751 | 1143681006.06 | 0.01870058781016035 | 0.03683583264668273 | 0.01813524483652239 |  | 1751 | 1143681006.06 | 0.01870058781016038 | 0.03683583264668282 |  |  | 0 | 0 | -3.469446951953614e-17 | -9.020562075079397e-17
1 | 998517 | 998502 | 1 | 6620492.635 | 6683363.265 | 6683363.265 | 319094.50402173 | 322124.74264647 | 322124.74264647 | 395905.459573 | 399665.123247 | 399665.123247 | 998502 |  |  | 1 | 0 | 0 | 998514 | General Bank | 929 | 70212470.66499999 | 0.05007689975862707 | 0.06423441805142893 | 0.01415751829280186 |  | 929 | 70212470.665 | 0.05007689975862726 | 0.06423441805142892 |  |  | 0 | 0 | -1.873501354054952e-16 | 0
2 | 998775 | NULL | 2 | 760860.52 | NULL | NULL | 39238.95374139 | NULL | NULL | 53807.8540805 | NULL | NULL | NULL |  |  | 1 | 0 | 0 | 998516 | General Bank | 9376 | 92951192.7550003 | 0.03911096720957039 | 0.05487946393916314 | 0.01576849672959275 |  | 9376 | 92951192.755 | 0.0391109672095705 | 0.0548794639391634 |  |  | 0 | 2.980232238769531e-07 | -1.040834085586084e-16 | -2.636779683484747e-16
2 | 994861 | NULL | 72 | 23983412.59 | NULL | NULL | 1289986.69225654 | NULL | NULL | 1707302.0798875 | NULL | NULL | NULL |  |  | 1 | 0 | 0 | 998517 | SBA Lending | 162 | 72240859.32 | 0.04047526268994904 | 0.05266717196910501 | 0.01219190927915597 |  | 162 | 72240859.32000001 | 0.04047526268994899 | 0.05266717196910497 |  |  | 0 | 0 | 0 | 0
1 | 944000 | 944000 | 5480 | 54264834.8249999 | 54327225.505 | 54327225.505 | 3059845.99028312 | 3063217.35627096 | 3172515.74725464 | 4160537.39785181 | 4160506.99024899 | 4160506.99024899 | 944000 |  |  | 1 | 0 | 0 | 998518 | Retail Banking | 3775 | 8097418.77 | 0.05812418237130947 | 0.1940116040934363 | 0.1358874217221268 |  | 3775 | 8097418.77 | 0.05812418237130942 | 0.1940116040934363 |  |  | 0 | 0 | 0 | 0
1 | 994959 | 994959 | 22 | 1457445.17 | 1476638.855 | 1476638.855 | 55226.622889 | 55925.172208655 | 55863.892256815 | 73385.2335045 | 74291.80262125 | 73056.3135438355 | 994959 |  |  | 1 | 0 | 0 | 998519 | Business Banking | 0 | 0 | #[NAME]! | #[NAME]! | #[NAME]! |  | 0 | 0 | #[NAME]! | #[NAME]! |  |  | 0 | 0 | #[NAME]! | #[NAME]!
1 | 998604 | 998604 | 78115 | 2546437000.86004 | 2650154362.98504 | 2650154362.98504 | 147988449.861794 | 154016730.908921 | 152977271.718552 | 18307498.1422021 | 20087073.6412694 | 40722652.4189558 | 998604 |  |  | 1 | 0 | 0 | 998520 | General Bank | 902 | 43892095.535 | 0.05045961805286315 | 0.07611578495016143 | 0.02565616689729828 |  | 902 | 43892095.535 | 0.05045961805286315 | 0.07611578495016143 |  |  | 0 | 0 | 0 | 0
1 | 998503 | 998504 | 1 | 8407.615 | 8549.63 | 8549.63 | 446.19212805 | 453.7288641 | 453.7288641 | 502.775377 | 511.267874 | 511.267874 | 998504 |  |  | 1 | 0 | 0 | 998521 | Other Misc LOB | 0 | 0 | #[NAME]! | #[NAME]! | #[NAME]! |  | 0 | 0 | #[NAME]! | #[NAME]! |  |  | 0 | 0 | #[NAME]! | #[NAME]!
1 | 998516 | 998514 | 33 | 829491.8 | 484960.01 | 484960.01 | 47220.27633702 | 27598.1874626657 | 27600.25537148 | 48606.1258728 | 28283.93584275 | 28283.93584275 | 998514 |  |  | 1 | 0 | 0 | 998522 | Retail Banking | 11675 | 426250573.895 | 0.03855510616929504 | 0.05693013644161877 | 0.01837503027232373 |  | 11675 | 426250573.895 | 0.03855510616929499 | 0.05693013644161867 |  |  | 0 | 0 | 5.551115123125783e-17 | 9.71445146547012e-17
1 | 998517 | 998517 | 142 | 56222061.81 | 56630378.225 | 56630378.225 | 2120178.39009461 | 2135811.99952292 | 2134881.6512637 | 2719790.75337495 | 2723521.15114095 | 2723497.26466911 | 998517 |  |  | 1 | 0 | 0 | 998602 | Industry Corporate Finance | 8 | 55829019.63 | 0.02723865475672065 | 0 | -0.02723865475672065 |  | 8 | 55829019.63 | 0.02723865475672065 | 0 |  |  | 0 | 0 | 0 | 0
1 | 998608 | 998504 | 1 | 8614.56 | 8614.56 | 8614.56 | 500.714256488588 | 500.714256488588 | 497.300094351033 | 0 | 0 | 0 | 998504 |  |  | 1 | 0 | 0 | 998604 | Commercial Finance | 78115 | 2546437000.86004 | 0.05811588891137381 | 0.007189456537121821 | -0.05092643237425199 |  | 78115 | 2546437000.86005 | 0.05811588891137318 | 0.007189456537121781 |  |  | 0 | -1.001358032226562e-05 | 6.38378239159465e-16 | 4.076600168545497e-17
1 | 982000 | 982000 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 982000 |  |  | 1 | 0 | 0 | 998608 | Commercial Finance | 311 | 852294841.685 | 0.04363011217727559 | 0.05433040953876051 | 0.01070029736148492 |  | 311 | 852294841.685 | 0.04363011217727548 | 0.05433040953876047 |  |  | 0 | 0 | 1.040834085586084e-16 | 0
1 | 998518 | 998518 | 3773 | 8094305.915 | 7915409.19 | 7915409.19 | 470474.913172629 | 460076.687303099 | 456939.615838074 | 1570332.034182 | 1534914.307323 | 1534846.909923 | 998518 |  |  | 1 | 0 | 0 | 998609 | Industry Corporate Finance | 7 | -1.01 | 0.013985 | 0 | -0.013985 |  | 7 | -1.01 | 0.013985 | 0 |  |  | 0 | 0 | 0 | 0
1 | 998502 | 998504 | 31 | 258502.19 | 219116.84 | 219116.84 | 15025.2284349429 | 12735.987168785 | 12649.1457724945 | 0 | 0 | 0 | 998504 |  |  | 1 | 0 | 0 | 998610 | Industry Corporate Finance | 105 | 1009383416.46 | 0.05910011371286285 | 0.0824006090857026 | 0.02330049537283975 |  | 105 | 1009383416.46 | 0.05910011371286278 | 0.0824006090857026 |  |  | 0 | 0 | 6.938893903907228e-17 | 0
2 | 994860 | NULL | 81 | 5765604.3 | NULL | NULL | 307713.959217205 | NULL | NULL | 430822.8620159 | NULL | NULL | NULL |  |  | 1 | 0 | 0 | 998611 | Industry Corporate Finance | 957 | 820926764.809999 | 0.03869136163019487 | 0.05314910742208446 | 0.01445774579188959 |  | 957 | 820926764.81 | 0.03869136163019472 | 0.05314910742208432 |  |  | 0 | -9.5367431640625e-07 | 1.52655665885959e-16 | 1.387778780781446e-16
1 | 998624 | 998624 | 7 | 10851184.24 | 10669393.48 | 10669393.48 | 364047.490170406 | 358823.786919396 | 358823.786919396 | 0 | 0 | 0 | 998624 |  |  | 1 | 0 | 0 | 998612 | Industry Corporate Finance | 481 | 1835654101.675 | 0.05892487747158456 | 0.07724579566401987 | 0.01832091819243531 |  | 481 | 1835654101.675 | 0.0589248774715847 | 0.07724579566401975 |  |  | 0 | 0 | -1.318389841742373e-16 | 1.249000902703301e-16
1 | 998664 | 998664 | 114 | 2.5607960196794e-11 | 2.5607960196794e-11 | 2.5607960196794e-11 | 568.08367215 | 568.08367215 | 568.08367215 | 0 | 0 | 0 | 998664 |  |  | 1 | 0 | 0 | 998613 | Industry Corporate Finance | 131 | 609301876.445 | 0.05941472841462865 | 0.08038576177806292 | 0.02097103336343427 |  | 131 | 609301876.445 | 0.05941472841462868 | 0.080385761778063 |  |  | 0 | 0 | 0 | 0
1 | 998505 | 998505 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 998505 |  |  | 1 | 0 | 0 | 998616 | Industry Corporate Finance | 722 | 3016827663.745 | 0.0595175185310068 | 0.08112583876276272 | 0.02160832023175592 |  | 722 | 3016827663.745 | 0.05951751853100697 | 0.08112583876276262 |  |  | 0 | 0 | -1.665334536937735e-16 | 0
1 | 998522 | 998504 | 245 | 6681970.695 | 5653866.8 | 5653866.8 | 318544.602850767 | 259332.833254331 | 259314.676477123 | 431312.58613725 | 359562.1385605 | 359562.1385605 | 998504 |  |  | 1 | 0 | 0 | 998617 | Industry Corporate Finance | 92 | 417202832.605 | 0.05843187025985916 | 0.08652803775821526 | 0.0280961674983561 |  | 92 | 417202832.605 | 0.05843187025985908 | 0.0865280377582152 |  |  | 0 | 0 | 7.632783294297951e-17 | 0
1 | 998699 | 998699 | 3198 | 7954411487.08507 | 7950178746.80003 | 7950178746.80003 | 252843950.006369 | 251374696.679707 | 250655629.184248 | 5658289.49021378 | 5608370.33558462 | 5608370.33558462 | 998699 |  |  | 1 | 0 | 0 | 998618 | Industry Corporate Finance | 114 | 331891474.545 | 0.05962436241595957 | 0.09630937001828252 | 0.03668500760232295 |  | 114 | 331891474.545 | 0.05962436241595959 | 0.09630937001828252 |  |  | 0 | 0 | 0 | 0
1 | 998602 | 998602 | 8 | 55829019.63 | 55615320.175 | 55615320.175 | 1520707.39110775 | 1514931.1717709 | 1514931.1717709 | 0 | 0 | 0 | 998602 |  |  | 1 | 0 | 0 | 998619 | Industry Corporate Finance | 466 | 3398512997.685 | 0.05663557667105713 | 0.07787414530825178 | 0.02123856863719465 |  | 466 | 3398512997.685 | 0.05663557667105714 | 0.07787414530825179 |  |  | 0 | 0 | 0 | 0
2 | 994963 | NULL | 1 | 11500000 | NULL | NULL | 642930.5 | NULL | NULL | 0 | NULL | NULL | NULL |  |  | 1 | 0 | 0 | 998620 | Industry Corporate Finance | 342 | 1976847282.785 | 0.05861527024587173 | 0.08304258056977694 | 0.02442731032390521 |  | 342 | 1976847282.785 | 0.05861527024587197 | 0.0830425805697767 |  |  | 0 | 0 | -2.42861286636753e-16 | 2.359223927328458e-16
2 | 998604 | NULL | 21643 | 20155077.6800001 | NULL | NULL | 1171497.41078023 | NULL | NULL | 65776.53095 | NULL | NULL | NULL |  |  | 1 | 0 | 0 | 998621 | Industry Corporate Finance | 162 | 607412700.89 | 0.06100023518836022 | 0.07930499236200686 | 0.01830475717364664 |  | 162 | 607412700.89 | 0.06100023518836024 | 0.07930499236200685 |  |  | 0 | 0 | 0 | 0
1 | 998504 | 998504 | 609049 | 5866216503.94471 | 5843678954.98977 | 5843678954.98977 | 242026525.579527 | 239239652.104917 | 238740191.012602 | 416299602.668511 | 413185402.533541 | 411938369.559975 | 998504 |  |  | 1 | 0 | 0 | 998623 | Commercial Finance | 0 | 0 | #[NAME]! | #[NAME]! | #[NAME]! |  | 0 | 0 | #[NAME]! | #[NAME]! |  |  | 0 | 0 | #[NAME]! | #[NAME]!
2 | 998781 | NULL | 1 | 150412.685 | NULL | NULL | 7696.61709145 | NULL | NULL | 9475.999155 | NULL | NULL | NULL |  |  | 1 | 0 | 0 | 998624 | Commercial Finance | 7 | 10851184.24 | 0.03354910230244196 | 0 | -0.03354910230244196 |  | 7 | 10851184.24 | 0.03354910230244196 | 0 |  |  | 0 | 0 | 0 | 0
2 | 998504 | NULL | 9809 | 63879232.2449998 | NULL | NULL | 3369003.64398968 | NULL | NULL | 4858838.5673774 | NULL | NULL | NULL |  |  | 1 | 0 | 0 | 998625 | Commercial Segment | 148 | 40677200.79 | 0.05798129818255865 | 0.07074591134643388 | 0.01276461316387523 |  | 148 | 40677200.79000001 | 0.05798129818255863 | 0.07074591134643386 |  |  | 0 | 0 | 0 | 0
1 | 957007 | 957007 | 409 | 45751446.31 | 46075492.64 | 46075492.64 | 1389904.44569832 | 1399612.41703863 | 1394944.93672266 | 2133845.02581975 | 2148903.66344225 | 2128685.658653 | 957007 |  |  | 1 | 0 | 0 | 998626 | Commercial Segment | 47 | 343285127.385 | 0.04815754729252644 | 0.06401035005188331 | 0.01585280275935687 |  | 47 | 343285127.385 | 0.04815754729252653 | 0.0640103500518831 |  |  | 0 | 0 | -8.326672684688674e-17 | 2.081668171172169e-16
1 | 994861 | 994861 | 8463 | 3766794976.515 | 3772134376.29001 | 3772134376.29001 | 90714041.7106747 | 90509156.0802615 | 90488523.3228148 | 157159427.368326 | 157029230.480217 | 156872454.416036 | 994861 |  |  | 1 | 0 | 0 | 998628 | Commercial Segment | 281 | 910819025.360001 | 0.03927336372265528 | 0.04095621731029325 | 0.001682853587637971 |  | 281 | 910819025.36 | 0.03927336372265532 | 0.04095621731029331 |  |  | 0 | 9.5367431640625e-07 | 0 | -5.551115123125783e-17
1 | 311000 | 311000 | 4 | 134052.475 | 138655.815 | 138655.815 | 6040.46832 | 6259.800384 | 6259.800384 | 5242.470725 | 5422.730117 | 5422.730117 | 311000 |  |  | 1 | 0 | 0 | 998629 | Commercial Segment | 377 | 3531801247.505 | 0.05781243146109538 | 0.07738804263280334 | 0.01957561117170796 |  | 377 | 3531801247.505 | 0.0578124314610953 | 0.07738804263280345 |  |  | 0 | 0 | 8.326672684688674e-17 | -1.110223024625157e-16
1 | 998514 | 998520 | 2 | 5305.785 | 0 | 0 | 298.880174835 | 0 | 0 | 557.107425 | 0 | 0 | 998520 |  |  | 1 | 0 | 0 | 998630 | Business Capital | 98671 | 1866231834.85498 | 0.0353680411598658 | 0.09990465774237646 | 0.06453661658251067 |  | 98671 | 1866231834.855 | 0.03536804115986579 | 0.09990465774237452 |  |  | 0 | -2.002716064453125e-05 | 0 | 1.942890293094024e-15
1 | 998671 | 998671 | 4306 | 914129979.759998 | 918775385.814999 | 918775385.814999 | 43588088.0471758 | 43799936.3646234 | 43727793.4927528 | 48048917.6189284 | 48316953.4889841 | 47975284.2518931 | 998671 |  |  | 1 | 0 | 0 | 998631 | Business Capital | 123097 | 3073085689.22502 | 0.03750004671133195 | 0.06301451216433733 | 0.02551446545300538 |  | 123097 | 3073085689.22499 | 0.03750004671133213 | 0.06301451216433815 |  |  | 0 | 3.004074096679688e-05 | -1.804112415015879e-16 | -8.187894806610529e-16
1 | 970041 | 970041 | 15 | 5329525.05 | 5352227.365 | 5352227.365 | 186854.569321395 | 187495.21844358 | 187487.65374196 | 325563.3584115 | 326948.0828365 | 326948.0828365 | 970041 |  |  | 1 | 0 | 0 | 998637 | Commercial Segment | 11 | 307694706.165 | 0.05936044360870845 | 0.08319804894121162 | 0.02383760533250317 |  | 11 | 307694706.165 | 0.05936044360870833 | 0.08319804894121141 |  |  | 0 | 0 | 1.249000902703301e-16 | 2.081668171172169e-16
1 | 964000 | 964000 | 131 | 230852.96 | 242593.57 | 242593.57 | 13418.1395479966 | 14100.552904787 | 14004.4071026209 | 46959.875154 | 49058.665218 | 49058.665218 | 964000 |  |  | 1 | 0 | 0 | 998638 | Commercial Finance | 247 | 693314984.545 | 0.05262210852962346 | 0.06976483362191241 | 0.01714272509228894 |  | 247 | 693314984.5450001 | 0.05262210852962352 | 0.06976483362191231 |  |  | 0 | 0 | -5.551115123125783e-17 | 0
2 | 998618 | NULL | 4 | 1123578.34 | NULL | NULL | 57211.86064613 | NULL | NULL | 99846.150857856 | NULL | NULL | NULL |  |  | 1 | 0 | 0 | 998650 | Corporate | 5 | -0.04 | 0.01397325 | 0 | -0.01397325 |  | 5 | -0.04 | 0.01397325 | 0 |  |  | 0 | 0 | 0 | 0
1 | 989001 | 989001 | 1755 | 15216433.44 | 15407246.41 | 15407246.41 | 850975.69480474 | 861898.804680265 | 858570.868574874 | 1223052.04985011 | 1238948.63644432 | 1243596.7820697 | 989001 |  |  | 1 | 0 | 0 | 998660 | 3rd Party Originations | 67 | 83697456.48 | 0.0450388411728558 | 0.06238024777127014 | 0.01734140659841435 |  | 67 | 83697456.48 | 0.04503884117285585 | 0.06238024777127014 |  |  | 0 | 0 | -5.551115123125783e-17 | 0
2 | 998503 | NULL | 1203 | 114169760.09 | NULL | NULL | 5787694.59961409 | NULL | NULL | 7495047.72913306 | NULL | NULL | NULL |  |  | 1 | 0 | 0 | 998661 | 3rd Party Originations | 166 | 194473936.115 | 0.04215033243514067 | 0.06091683556488035 | 0.01876650312973967 |  | 166 | 194473936.115 | 0.04215033243514062 | 0.06091683556488035 |  |  | 0 | 0 | 0 | 0
2 | 970010 | NULL | 3 | 0 | NULL | NULL | 0 | NULL | NULL | 0 | NULL | NULL | NULL |  |  | 1 | 0 | 0 | 998663 | 3rd Party Originations | 229 | -9.82254277914763e-11 | -145443827897939.9 | 0 | 145443827897939.9 |  | 229 | 2.72848410531878e-12 | 5235977804325848 | 0 |  |  | 0 | -1.009539118967951e-10 | -5381421632223788 | 0
1 | 998504 | 998518 | 5 | 6960.89 | 13600.43 | 13600.43 | 404.596039826625 | 790.513873648229 | 785.123688524384 | 1257.003836 | 2449.330482 | 2449.330482 | 998518 |  |  | 1 | 0 | 0 | 998664 | 3rd Party Originations | 114 | 2.5607960196794e-11 | 22183870475600.06 | 0 | -22183870475600.06 |  | 114 | 3.49018591805361e-11 | 16276602034621.87 | 0 |  |  | 0 | -9.2938989837421e-12 | 5907268440978.189 | 0
1 | 957006 | 957006 | 209 | 74596469.67 | 76069136.145 | 76069136.145 | 3110028.12256626 | 3144108.34287894 | 3098487.23858332 | 4363336.00405617 | 4431094.62134476 | 4379209.95722003 | 957006 |  |  | 1 | 0 | 0 | 998665 | SBA Lending | 821 | 903197633.335001 | 0.03444618669656588 | 0.05515562251153941 | 0.02070943581497352 |  | 821 | 903197633.335 | 0.03444618669656591 | 0.05515562251153936 |  |  | 0 | 9.5367431640625e-07 | 0 | 0
2 | 998660 | NULL | 7 | 3766450 | NULL | NULL | 204982.0022 | NULL | NULL | 264873.3125 | NULL | NULL | NULL |  |  | 1 | 0 | 0 | 998667 | General Bank | 1 | 254564.99 | 0.012593 | 0 | -0.012593 |  | 1 | 254564.99 | 0.012593 | 0 |  |  | 0 | 0 | 0 | 0
1 | 858000 | 858000 | 45 | 5552975.79 | 5790048.095 | 5790048.095 | 19435.415265 | 20265.1683325 | 20265.1683325 | 55529.7579 | 57900.48095 | 57900.48095 | 858000 |  |  | 1 | 0 | 0 | 998671 | Mortgage | 4306 | 914129979.759998 | 0.04768259329884326 | 0.05256245685273718 | 0.004879863553893922 |  | 4306 | 914129979.76 | 0.04768259329884326 | 0.05256245685273722 |  |  | 0 | -2.026557922363281e-06 | 0 | 0
1 | 998617 | 998617 | 92 | 417202832.605 | 421218244.99 | 421218244.99 | 24377941.7868211 | 24602714.0218384 | 24152243.3460567 | 36099742.4524798 | 36788277.7518557 | 36834469.8420823 | 998617 |  |  | 1 | 0 | 0 | 998675 | CAB | 9 | 77476.88 | 0.05812416528007568 | 0 | -0.05812416528007568 |  | 9 | 77476.88 | 0.05812416528007568 | 0 |  |  | 0 | 0 | 0 | 0
2 | 998517 | NULL | 1 | 0 | NULL | NULL | 0 | NULL | NULL | 0 | NULL | NULL | NULL |  |  | 1 | 0 | 0 | 998677 | Community Lending | 175 | 423448215.98 | 0.04773529493662362 | 0.04560767082782834 | -0.002127624108795287 |  | 175 | 423448215.98 | 0.04773529493662363 | 0.04560767082782816 |  |  | 0 | 0 | 0 | 1.804112415015879e-16
2 | 998796 | NULL | 3 | 75317.125 | NULL | NULL | 3852.726865045 | NULL | NULL | 5012.626576 | NULL | NULL | NULL |  |  | 1 | 0 | 0 | 998678 | CAB | 1 | 0 | #[NAME]! | #[NAME]! | #[NAME]! |  | 1 | 0 | #[NAME]! | #[NAME]! |  |  | 0 | 0 | #[NAME]! | #[NAME]!
1 | 994931 | 994931 | 3603 | 218972562.730001 | 225122242.725 | 225122242.725 | 5295252.48593143 | 5393766.73333334 | 5394400.86777368 | 8935383.61911313 | 9159202.31088325 | 9159202.31088325 | 994931 |  |  | 1 | 0 | 0 | 998699 | Rail | 3198 | 7954411487.08507 | 0.03178663191071912 | 0.0007113398017440616 | -0.03107529210897506 |  | 3198 | 7954411487.085 | 0.03178663191071936 | 0.0007113398017440667 |  |  | 0 | 6.961822509765625e-05 | -2.42861286636753e-16 | -5.095750210681871e-18
1 | 998503 | 998503 | 43492 | 11044979719.245 | 10999459046.9951 | 10999459046.9951 | 322951677.981472 | 317790098.083725 | 317395320.663287 | 482909244.816602 | 478060295.178792 | 477523911.568845 | 998503 |  |  | 1 | 0 | 0 | 998733 | Rail | 3 | -171317.285 | -0.01827717839957013 | 0 | 0.01827717839957013 |  | 3 | -171317.285 | -0.01827717839957013 | 0 |  |  | 0 | 0 | 0 | 0
1 | 998507 | 998507 | 5778 | 510607943.905001 | 503873581.03 | 503873581.03 | 22397206.5312771 | 21992964.9596596 | 21951109.670335 | 30523061.4341162 | 30022787.1241948 | 30024695.8551245 | 998507 |  |  | 1 | 0 | 0 | 998772 | CAB | 12 | 749501.785 | 0.01772290916635322 | 0.05511259155973858 | 0.03738968239338536 |  | 12 | 749501.7849999999 | 0.01772290916635329 | 0.05511259155973858 |  |  | 0 | 0 | -7.28583859910259e-17 | 0
1 | 998507 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 1 | 0 | 0 | 998773 | CAB | 160 | 53045093.9 | 0.02911021480333886 | 0.04567525293660947 | 0.01656503813327061 |  | 160 | 53045093.90000001 | 0.02911021480333886 | 0.04567525293660946 |  |  | 0 | 0 | 0 | 0
1 | 998517 | 998504 | 10 | 860455.585 | 635632.44 | 635632.44 | 48320.5973792935 | 35545.3998505835 | 35510.3595831545 | 79283.9902865 | 59119.393857 | 59119.393857 | 998504 |  |  | 1 | 0 | 0 | 998774 | CAB | 105 | 26081498.455 | 0.02892745016420557 | 0.04842943730014342 | 0.01950198713593785 |  | 105 | 26081498.455 | 0.02892745016420556 | 0.04842943730014353 |  |  | 0 | 0 | 0 | -1.110223024625157e-16
2 | 860000 | NULL | 4 | 3939322.555 | NULL | NULL | 227206.119548725 | NULL | NULL | 295004.625703989 | NULL | NULL | NULL |  |  | 1 | 0 | 0 | 998775 | CAB | 128 | 66580285.92 | 0.02586688230959207 | 0.04459105080615505 | 0.01872416849656298 |  | 128 | 66580285.92 | 0.02586688230959207 | 0.04459105080615505 |  |  | 0 | 0 | 0 | 0
1 | 998516 | 998516 | 9295 | 91142157.3750003 | 90613666.9750001 | 90613666.9750001 | 3537502.81027323 | 3481950.41533149 | 3480971.87850505 | 4989368.87351844 | 4920637.33690144 | 4921869.63316244 | 998516 |  |  | 1 | 0 | 0 | 998776 | CAB | 209 | 94550657.54 | 0.03126964877753551 | 0.0461993002869158 | 0.01492965150938028 |  | 209 | 94550657.53999999 | 0.03126964877753546 | 0.0461993002869158 |  |  | 0 | 0 | 0 | 0
1 | 998610 | 998610 | 105 | 1009383416.46 | 1047533652.62 | 1047533652.62 | 59654674.692664 | 61881394.9691045 | 61184267.5365047 | 83173808.3173114 | 86443302.0194808 | 86408668.1623778 | 998610 |  |  | 1 | 0 | 0 | 998778 | CAB | 14 | 5188782.46 | 0.03175910576812677 | 0.0455999257983924 | 0.01384082003026563 |  | 14 | 5188782.46 | 0.03175910576812677 | 0.0455999257983924 |  |  | 0 | 0 | 0 | 0
1 | 998797 | 998797 | 73 | 29983868.95 | 30121527.27 | 30121527.27 | 772892.078168377 | 774025.883790226 | 774024.484227416 | 1341819.0900309 | 1349144.91058815 | 1349144.91058815 | 998797 |  |  | 1 | 0 | 0 | 998779 | CAB | 14 | 5833262.26 | 0.03751670381428727 | 0.05352493390559471 | 0.01600823009130743 |  | 14 | 5833262.26 | 0.03751670381428727 | 0.05352493390559471 |  |  | 0 | 0 | 0 | 0
1 | 998502 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 1 | 0 | 0 | 998780 | CAB | 54 | 26916981.06 | 0.02764043301962587 | 0.04202627724703686 | 0.01438584422741099 |  | 54 | 26916981.06 | 0.02764043301962583 | 0.04202627724703686 |  |  | 0 | 0 | 3.816391647148976e-17 | 0
1 | 998795 | 998795 | 9 | 3246401.84 | 2648315.71 | 2648315.71 | 113257.751223442 | 79130.9912423214 | 79130.9912423214 | 167985.4178134 | 133296.2988839 | 133296.2988839 | 998795 |  |  | 1 | 0 | 0 | 998781 | CAB | 89 | 43019924.225 | 0.03105661748224058 | 0.04602774001407368 | 0.0149711225318331 |  | 89 | 43019924.225 | 0.03105661748224053 | 0.04602774001407368 |  |  | 0 | 0 | 4.163336342344337e-17 | 0
2 | 998616 | NULL | 99 | 223047729.015 | NULL | NULL | 10717688.3472539 | NULL | NULL | 18269730.6438856 | NULL | NULL | NULL |  |  | 1 | 0 | 0 | 998782 | CAB | 160 | 56859864.395 | 0.02794190076309678 | 0.04561078448081655 | 0.01766888371771978 |  | 160 | 56859864.395 | 0.0279419007630967 | 0.04561078448081655 |  |  | 0 | 0 | 8.326672684688674e-17 | 0
1 | 956001 | 956001 | 524 | 7311168.74000001 | 7443697.96500001 | 7443697.96500001 | 392586.770856975 | 399748.921368435 | 399429.94142465 | 609224.363389649 | 621206.20385081 | 623653.91812566 | 956001 |  |  | 1 | 0 | 0 | 998787 | CAB | 126 | 61881228.665 | 0.02681661500596936 | 0.04793541678751426 | 0.02111880178154491 |  | 126 | 61881228.66499999 | 0.02681661500596936 | 0.04793541678751428 |  |  | 0 | 0 | 0 | 0
2 | 998630 | NULL | 22867 | 81291223.2199997 | NULL | NULL | 3331090.31852925 | NULL | NULL | 8104449.81053511 | NULL | NULL | NULL |  |  | 1 | 0 | 0 | 998788 | CAB | 15 | 3465382.23 | 0.02605975936904894 | 0.0488082897677928 | 0.02274853039874386 |  | 15 | 3465382.23 | 0.02605975936904894 | 0.0488082897677928 |  |  | 0 | 0 | 0 | 0
1 | 998522 | 998522 | 11430 | 419568603.2 | 413395933.035 | 413395933.035 | 16115591.5283939 | 15683594.3907088 | 15688990.7354156 | 23835190.7440234 | 23370055.1927151 | 23361716.3985638 | 998522 |  |  | 1 | 0 | 0 | 998789 | CAB | 3 | 118800.66 | 0.04982178586591421 | 0.05468375435961383 | 0.004861968493699617 |  | 3 | 118800.66 | 0.04982178586591422 | 0.05468375435961383 |  |  | 0 | 0 | 0 | 0
1 | 998616 | 998616 | 722 | 3016827663.745 | 2917717264.445 | 2917717264.445 | 179554096.381797 | 174303641.102864 | 167881462.18288 | 244742674.624019 | 236293856.585041 | 236914073.773852 | 998616 |  |  | 1 | 0 | 0 | 998790 | CAB | 39 | 28095812.15 | 0.02551454701592739 | 0.0454337311176463 | 0.01991918410171891 |  | 39 | 28095812.15 | 0.02551454701592739 | 0.04543373111764629 |  |  | 0 | 0 | 0 | 0
2 | 961000 | NULL | 6 | 4655647.5 | NULL | NULL | 257197.083735982 | NULL | NULL | 273783.97975 | NULL | NULL | NULL |  |  | 1 | 0 | 0 | 998791 | CAB | 70 | 24879831.525 | 0.02859811447829895 | 0.04692097180379722 | 0.01832285732549827 |  | 70 | 24879831.525 | 0.02859811447829895 | 0.04692097180379722 |  |  | 0 | 0 | 0 | 0
1 | 998677 | 998677 | 175 | 423448215.98 | 416716501.825 | 416716501.825 | 20213425.4801924 | 19833641.9455083 | 19841939.8924491 | 19312486.847047 | 18857672.1855738 | 18849114.862195 | 998677 |  |  | 1 | 0 | 0 | 998792 | CAB | 97 | 43861195.57 | 0.02936012871821952 | 0.04820238194678262 | 0.0188422532285631 |  | 97 | 43861195.57000001 | 0.02936012871821954 | 0.04820238194678272 |  |  | 0 | 0 | 0 | -1.040834085586084e-16
1 | 970020 | 970020 | 166 | 30850376.27 | 32328071.3 | 32328071.3 | 1053095.52563 | 1127970.46748637 | 1123893.97743488 | 1778217.97637088 | 1875155.94846917 | 1872468.97176076 | 970020 |  |  | 1 | 0 | 0 | 998794 | CAB | 217 | 85293164.875 | 0.02658758645474908 | 0.04470760335823217 | 0.01812001690348309 |  | 217 | 85293164.875 | 0.02658758645474908 | 0.04470760335823216 |  |  | 0 | 0 | 0 | 0
1 | 969001 | 969001 | 5 | 877276.755 | 877140.545 | 877140.545 | 43146.638698915 | 43142.046497785 | 43142.046497785 | 47194.1979577235 | 47181.949564973 | 47181.949564973 | 969001 |  |  | 1 | 0 | 0 | 998795 | CAB | 9 | 3246401.84 | 0.03488716332893713 | 0.05174510922942306 | 0.01685794590048593 |  | 9 | 3246401.84 | 0.03488716332893697 | 0.05174510922942305 |  |  | 0 | 0 | 1.52655665885959e-16 | 0
2 | 998799 | NULL | 1 | 77912.575 | NULL | NULL | 3996.213884325 | NULL | NULL | 4908.492225 | NULL | NULL | NULL |  |  | 1 | 0 | 0 | 998796 | CAB | 72 | 24972132.615 | 0.02584700776035615 | 0.04767290096358277 | 0.02182589320322661 |  | 72 | 24972132.615 | 0.02584700776035615 | 0.04767290096358275 |  |  | 0 | 0 | 0 | 0
1 | 957002 | 957002 | 107 | 46528260.34 | 47002308.795 | 47002308.795 | 1301878.59285542 | 1312958.7064909 | 1306437.92896728 | 2163237.33382367 | 2183760.23549094 | 2160410.23832996 | 957002 |  |  | 1 | 0 | 0 | 998797 | CAB | 73 | 29983868.95 | 0.02577692957027072 | 0.04475136588505201 | 0.01897443631478129 |  | 73 | 29983868.95 | 0.02577692957027072 | 0.04475136588505201 |  |  | 0 | 0 | 0 | 0
1 | 998790 | 998790 | 39 | 28095812.15 | 28364829.935 | 28364829.935 | 716851.920051839 | 722779.540018359 | 722779.540018359 | 1276497.574755 | 1288419.173077 | 1288419.173077 | 998790 |  |  | 1 | 0 | 0 | 998798 | CAB | 200 | 60117192.22 | 0.02616205949399478 | 0.0444254065133711 | 0.01826334701937632 |  | 200 | 60117192.22000001 | 0.02616205949399469 | 0.04442540651337109 |  |  | 0 | 0 | 8.326672684688674e-17 | 0
2 | 998513 | NULL | 16 | 6571211.5 | NULL | NULL | 342586.3226385 | NULL | NULL | 429920.86585 | NULL | NULL | NULL |  |  | 1 | 0 | 0 | 998799 | CAB | 30 | 11308512.61 | 0.02270108335054852 | 0.043386849277104 | 0.02068576592655548 |  | 30 | 11308512.61 | 0.02270108335054852 | 0.043386849277104 |  |  | 0 | 0 | 0 | 0
1 | 957010 | 957010 | 5582 | 2368105609.86501 | 2350547048.26001 | 2350547048.26001 | 48946018.3649782 | 48443186.1592605 | 48300100.8959571 | 87687022.8906856 | 87106864.4206563 | 86861908.0364963 | 957010 |  |  | 1 | 0 | 0 | 998801 | CAB | 112 | 22267923.44 | 0.02855629216573254 | 0.04822525882363102 | 0.01966896665789848 |  | 112 | 22267923.44 | 0.02855629216573254 | 0.04822525882363102 |  |  | 0 | 0 | 0 | 0
1 | 984000 | 984000 | 34 | 5792854.195 | 5827870.705 | 5827870.705 | 211224.164741135 | 212533.562988045 | 212358.53175981 | 281865.712661 | 283492.22634225 | 283492.22634225 | 984000 |  |  | 1 | 0 | 0 | 998802 | CAB | 411 | 115659512.56 | 0.02899274312447137 | 0.04633134225022537 | 0.017338599125754 |  | 411 | 115659512.56 | 0.02899274312447128 | 0.04633134225022537 |  |  | 0 | 0 | 8.673617379884035e-17 | 0
1 | 998789 | 998789 | 3 | 118800.66 | 123278.065 | 123278.065 | 5918.86104324928 | 6128.75107006627 | 6108.93706168627 | 6496.4661092 | 6729.1078175 | 6729.1078175 | 998789 |  |  | 1 | 0 | 0 | 998803 | CAB | 122 | 46598606.585 | 0.02819639775913484 | 0.04751412874892641 | 0.01931773098979157 |  | 122 | 46598606.58499999 | 0.02819639775913489 | 0.04751412874892642 |  |  | 0 | 0 | -5.551115123125783e-17 | 0
1 | 998503 | 0 | 6 | 1169.835 | 0 | 0 | 67.9957028843408 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 1 | 0 | 0 | 998830 | 3rd Party Originations | 1513 | -2.63327137872693e-10 | 34274205039487.21 | 0 | -34274205039487.21 |  | 1513 | -4.54747350886464e-10 | 19846906855678.06 | 0 |  |  | 0 | 1.91420213013771e-10 | 14427298183809.15 | 0
1 | 998518 | 0 | 2 | 3112.855 | 0 | 0 | 180.932151715443 | 0 | 0 | 661.170402 | 0 | 0 | 0 |  |  |  |  |  |  |  | 1115370 | 84151959831.29982 | 0.0384024750922983 | 0.05012299717763569 | 0.0117205220853374
2 | 998677 | NULL | 4 | 7542466.975 | NULL | NULL | 419405.218732534 | NULL | NULL | 264597.236837 | NULL | NULL | NULL
1 | 994963 | 994963 | 92 | 622496819.255 | 604599211.64 | 604599211.64 | 24598284.4889388 | 23532282.3051219 | 23532282.3051219 | 0 | 0 | 0 | 994963 |  |  | Include the New Adds
2 | 998617 | NULL | 10 | 72871159.87 | NULL | NULL | 4361729.56350525 | NULL | NULL | 6372818.27189117 | NULL | NULL | NULL |  |  | Step ID | [NAME] | [NAME] | ResponsibilityCenterCode |  | [NAME] | Balance | FTP Rate | Coupon | Spread |  | [NAME] | Balance | FTP Rate | Coupon | Spread
1 | 956002 | 956002 | 456 | 17989348.425 | 18156851.57 | 18156851.57 | 756716.565760345 | 765023.035744426 | 764826.943063176 | 961264.905239173 | 973991.463812126 | 973764.52196448 | 956002 |  |  | 1 | 0 | 0 | 0 | 0 | 210 | 133254.725 | 0.05812418237130954 | 0.09723032645183878 | 0.03910614408052925 |  | 174 | 28868.79499999998 | 0 | -0.02688985347087686 | -0.02688985347087687
2 | 998780 | NULL | 2 | 1610182.33 | NULL | NULL | 82544.502834805 | NULL | NULL | 101441.48679 | NULL | NULL | NULL |  |  | 1 | 0 | 0 | 113000 | Acquired Loans | 3 | 509906.47 | 0.02972396879582642 | 0.03214874739675298 | 0.002424778600926554 |  | 0 | 0 | 0 | 0 | 0
2 | 859000 | NULL | 6 | 1490834.44 | NULL | NULL | 82651.428249 | NULL | NULL | 119503.181205 | NULL | NULL | NULL |  |  | 1 | 0 | 0 | 181000 | General Bank | 45858 | 1162474804.19001 | 0.02831764618932178 | 0.04549437350518051 | 0.01717672731585873 |  | 1118 | 23283121.54999995 | 0.0004524412216721924 | 0.0004710677325800508 | 1.862651090785844e-05
2 | 998612 | NULL | 25 | 23702753.765 | NULL | NULL | 1135813.34609622 | NULL | NULL | 1994568.19550008 | NULL | NULL | NULL |  |  | 1 | 0 | 0 | 311000 | Acquired Loans | 4 | 134052.475 | 0.0450604759069163 | 0.03910760114649132 | -0.005952874760424977 |  | 0 | 0 | 0 | 0 | 0
1 | 998801 | 998801 | 112 | 22267923.44 | 22525671.445 | 22525671.445 | 635889.327676804 | 640004.790810386 | 640004.606207636 | 1073876.3713588 | 1084714.7460679 | 1084714.7460679 | 998801 |  |  | 1 | 0 | 0 | 796000 | Acquired Loans | 288 | 20621235 | 0.02834030567030273 | 0.04536105876513948 | 0.01702075309483676 |  | 0 | 0 | 0 | 0 | 0
1 | 998613 | 998613 | 131 | 609301876.445 | 610475775.06 | 610475775.06 | 36201505.5115033 | 36487685.1380049 | 36256862.0079693 | 48979195.4908345 | 48816538.9379356 | 48693937.7989431 | 998613 |  |  | 1 | 0 | 0 | 838000 | Acquired Loans | 16 | 494989.28 | 0.01751965861139346 | 0.04258389523708472 | 0.02506423662569126 |  | 0 | 0 | 0 | 0 | 0
1 | 998611 | 998611 | 957 | 820926764.809999 | 1106700750.825 | 1106700750.825 | 31762774.3291696 | 40235266.7959077 | 40145827.8824002 | 43631524.8085509 | 51074401.9247571 | 50192449.7031019 | 998611 |  |  | 1 | 0 | 0 | 858000 | SBA Lending | 45 | 5552975.79 | 0.0035 | 0.01 | 0.006500000000000001 |  | 0 | 0 | 0 | 0 | 0
1 | 998513 | 998513 | 1744 | 1135197740.155 | 1134573470.92 | 1134573470.92 | 21185968.5051276 | 20947793.2343448 | 20910947.3240505 | 41820417.5548689 | 41624375.0930433 | 41561975.5223933 | 998513 |  |  | 1 | 0 | 0 | 859000 | SBA Lending | 504 | 343627099.89 | 0.0358555691770274 | 0.07049693803300194 | 0.03464136885597455 |  | 6 | 1490834.439999998 | 8.533649835594515e-05 | 4.209994532999861e-05 | -4.323655302594653e-05
1 | 970060 | 970060 | 1615 | 374031.155 | 372875.75 | 372875.75 | 21740.2550657715 | 21673.0980948388 | 21525.3182584151 | 67078.6599 | 66841.4549999999 | 66841.4549999999 | 970060 |  |  | 1 | 0 | 0 | 860000 | Commercial Segment | 130 | 853712841.4 | 0.04938463176214819 | 0.06549871289328857 | 0.01611408113114038 |  | 4 | 3939322.554999948 | 3.843862517876467e-05 | 4.352226547406357e-05 | 5.083640295298897e-06
1 | 998802 | 998802 | 411 | 115659512.56 | 116581881.71 | 116581881.71 | 3353286.53755365 | 3356983.16224647 | 3356768.13958914 | 5358660.4609116 | 5384891.4403127 | 5384891.4403127 | 998802 |  |  | 1 | 0 | 0 | 869000 | Acquired Loans | 6 | 263597.65 | 0.04855659896727076 | 0.07588684075502948 | 0.02733024178775872 |  | 0 | 0 | 0 | 0 | 0
2 | 998791 | NULL | 1 | 99723.375 | NULL | NULL | 5485.084795125 | NULL | NULL | 6282.572625 | NULL | NULL | NULL |  |  | 1 | 0 | 0 | 899000 | Acquired Loans | 3 | 25550.835 | 0.00864261537216451 | 0.03946614650754075 | 0.03082353113537624 |  | 0 | 0 | 0 | 0 | 0
1 | 994861 | 994860 | 64 | 44286500.065 | 42586958.36 | 42586958.36 | 1173311.49163306 | 1133468.57773317 | 1134629.52903182 | 1835559.43535675 | 1770725.70647175 | 1770725.70647175 | 994860 |  |  | 1 | 0 | 0 | 935000 | Acquired Loans | 148 | 11075729.2 | 0.0301503267087191 | 0.05509137696039914 | 0.02494105025168004 |  | 0 | 0 | 0 | 0 | 0
1 | 998621 | 998621 | 162 | 607412700.89 | 575649804.76 | 575649804.76 | 37052317.6106871 | 35092796.8103943 | 34169962.2476753 | 48170859.6046674 | 45796958.4329044 | 45859902.36028 | 998621 |  |  | 1 | 0 | 0 | 944000 | Corporate City | 5606 | 54327453.1999999 | 0.05638927377754237 | 0.07672437581369666 | 0.02033510203615429 |  | 120 | 59447.34499999881 | 1.900488291246838e-06 | 5.766164784927474e-05 | 5.576115955802791e-05
1 | 998779 | 998779 | 14 | 5833262.26 | 5873273.635 | 5873273.635 | 218844.77247948 | 220093.278970657 | 220093.034303192 | 312224.9769205 | 314059.2031295 | 314059.2031295 | 998779 |  |  | 1 | 0 | 0 | 944004 | Corporate | 0 | 0 | #[NAME]! | #[NAME]! | #[NAME]! |  | 0 | 0 | 0 | 0 | 0
2 | 998772 | NULL | 1 | 1918.14 | NULL | NULL | 91.3897803 | NULL | NULL | 115.280214 | NULL | NULL | NULL |  |  | 1 | 0 | 0 | 956001 | Acquired Loans | 524 | 7311168.74000001 | 0.05369685543011752 | 0.08332790352061388 | 0.02963104809049636 |  | 0 | 0 | 0 | 0 | 0
2 | 998628 | NULL | 4 | 14330636.815 | NULL | NULL | 794532.557391345 | NULL | NULL | 789042.375525 | NULL | NULL | NULL |  |  | 1 | 0 | 0 | 956002 | Acquired Loans | 456 | 17989348.425 | 0.04206470117109563 | 0.05343522636446867 | 0.01137052519337304 |  | 0 | 0 | 0 | 0 | 0
2 | 998661 | NULL | 1 | 459685.625 | NULL | NULL | 22974.16816625 | NULL | NULL | 39418.04234375 | NULL | NULL | NULL |  |  | 1 | 0 | 0 | 957000 | Mortgage | 13 | 990475.405 | 0.05076627573973429 | 0.05888374804238224 | 0.008117472302647942 |  | 0 | 0 | 0 | 0 | 0
2 | 998502 | NULL | 512 | 84585269.125 | NULL | NULL | 4382692.90519584 | NULL | NULL | 5384222.60319128 | NULL | NULL | NULL |  |  | 1 | 0 | 0 | 957001 | Mortgage | 194 | 31204114.925 | 0.03456847016146797 | 0.04873165276152308 | 0.01416318260005511 |  | 0 | 0 | 0 | 0 | 0
1 | 998626 | 998626 | 47 | 343285127.385 | 344193590.105 | 344193590.105 | 16531769.7568641 | 16577969.8228951 | 16490213.2284734 | 21973801.1715192 | 22033049.5194702 | 22048522.3524 | 998626 |  |  | 1 | 0 | 0 | 957002 | Mortgage | 107 | 46528260.34 | 0.02798038403632737 | 0.04649297691373067 | 0.0185125928774033 |  | 0 | 0 | 0 | 0 | 0
1 | 998402 | 998402 | 6122 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 998402 |  |  | 1 | 0 | 0 | 957003 | Mortgage | 8 | 1203714.325 | 0.02640294835632201 | 0.04354170930465582 | 0.01713876094833381 |  | 0 | 0 | 0 | 0 | 0
1 | 985000 | 985000 | 296 | 11693184.335 | 11828096.515 | 11828096.515 | 395712.099793093 | 399624.3362606 | 395334.700066133 | 626493.1908085 | 632936.90549 | 619281.12019 | 985000 |  |  | 1 | 0 | 0 | 957004 | Mortgage | 6 | 1856561.865 | 0.03421526219015869 | 0.05363182476550546 | 0.01941656257534677 |  | 0 | 0 | 0 | 0 | 0
1 | 998631 | 998631 | 123097 | 3073085689.22502 | 4064482415.38001 | 4064482415.38001 | 115240856.893864 | 145409138.921181 | 145462656.518252 | 193648995.545721 | 258095490.068476 | 255257656.15071 | 998631 |  |  | 1 | 0 | 0 | 957005 | Mortgage | 6 | 1257117.885 | 0.02077705344746567 | 0.04596089947887187 | 0.0251838460314062 |  | 0 | 0 | 0 | 0 | 0
1 | 998516 | 998504 | 47 | 978243.58 | 891957.995 | 891957.995 | 50614.1266210228 | 45547.5454640955 | 45540.576996228 | 63000.131509 | 57657.0660145 | 57657.0660145 | 998504 |  |  | 1 | 0 | 0 | 957006 | Mortgage | 209 | 74596469.67 | 0.04169135800024328 | 0.05849252683617205 | 0.01680116883592877 |  | 0 | 0 | 0 | 0 | 0
2 | 998798 | NULL | 2 | 143904.51 | NULL | NULL | 7307.5237778 | NULL | NULL | 9065.98413 | NULL | NULL | NULL |  |  | 1 | 0 | 0 | 957007 | Mortgage | 409 | 45751446.31 | 0.03037946464644387 | 0.04663994688520591 | 0.01626048223876204 |  | 0 | 0 | 0 | 0 | 0
1 | 998514 | 998504 | 661 | 34341003.745 | 32453593.79 | 32453593.79 | 1799877.85828376 | 1685631.38773517 | 1688116.64867832 | 2387433.0246913 | 2251170.73998785 | 2251170.73998785 | 998504 |  |  | 1 | 0 | 0 | 957008 | Mortgage | 22 | 2800962.73 | 0.05561964575323714 | 0.0878455782855829 | 0.03222593253234576 |  | 0 | 0 | 0 | 0 | 0
1 | 968000 | 968000 | 230 | 19790371.41 | 20137296.93 | 20137296.93 | 1094086.62862058 | 1106653.08454035 | 1106571.64841867 | 1842475.59696775 | 1867269.75524475 | 1867269.75524475 | 968000 |  |  | 1 | 0 | 0 | 957009 | Mortgage | 2852 | 1841960571.665 | 0.01914246289881064 | 0.03356176555455558 | 0.01441930265574494 |  | 0 | 0 | 0 | 0 | 0
1 | 0 | 998503 | 2 | 7389.135 | 8524.84 | 8524.84 | 429.487430306226 | 495.499354846234 | 492.120750952743 | 1693.043672 | 1939.52363 | 1939.52363 | 998503 |  |  | 1 | 0 | 0 | 957010 | 3rd Party Originations | 5582 | 2368105609.86501 | 0.02066884946392585 | 0.03702834135665262 | 0.01635949189272677 |  | 0 | 0 | 0 | 0 | 0
1 | 970003 | 970003 | 42 | 29722066.035 | 29774114.335 | 29774114.335 | 520562.471892715 | 521552.491574975 | 521403.5018548 | 1033586.85348525 | 1035515.4047575 | 1035515.4047575 | 970003 |  |  | 1 | 0 | 0 | 957011 | 3rd Party Originations | 105 | 124087568.435 | 0.02916631702978394 | 0.03864791435738878 | 0.009481597327604847 |  | 0 | 0 | 0 | 0 | 0
1 | 998637 | 998637 | 11 | 307694706.165 | 308536743.05 | 308536743.05 | 18264894.2540056 | 18315678.9905959 | 18262934.3432511 | 25599599.2224674 | 25674653.7834491 | 25663043.0210809 | 998637 |  |  | 1 | 0 | 0 | 961000 | SBA Lending | 120 | 134899407.54 | 0.04678425407730305 | 0.04339111517312821 | -0.003393138904174843 |  | 6 | 4655647.500000015 | 0.0003024028804875165 | 0.0005510455383810411 | 0.0002486426578935247
1 | 998772 | 998772 | 12 | 749501.785 | 746073.84 | 746073.84 | 13283.3520555746 | 13013.9272120103 | 13006.1980204803 | 41306.98575 | 40734.139675 | 40734.139675 | 998772 |  |  | 1 | 0 | 0 | 964000 | General Bank | 134 | 240311.41 | 0.05812418237130942 | 0.2028289681875696 | 0.1447047858162602 |  | 3 | 9458.450000000012 | 0 | -0.0005900183136214598 | -0.0005900183136214598
1 | 998792 | 998792 | 97 | 43861195.57 | 44363498.31 | 44363498.31 | 1287770.3476702 | 1299624.26911064 | 1299509.92608672 | 2114214.10150767 | 2140848.50042337 | 2140848.50042337 | 998792 |  |  | 1 | 0 | 0 | 968000 | Acquired Loans | 230 | 19790371.41 | 0.05528378452097883 | 0.0930995967077583 | 0.03781581218677947 |  | 0 | 0 | 0 | 0 | 0
1 | 998501 | 998501 | 695 | 149943567.86 | 150889044.3 | 150889044.3 | 4539136.30952845 | 4545115.03749125 | 4544482.98497042 | 6400775.05479526 | 6430064.98043309 | 6429688.67273013 | 998501 |  |  | 1 | 0 | 0 | 969000 | Acquired Loans | 247 | 52402579.225 | 0.04037268346923548 | 0.04753168816321082 | 0.007159004693975339 |  | 0 | 0 | 0 | 0 | 0
1 | 957000 | 957000 | 13 | 990475.405 | 994985.82 | 994985.82 | 50282.747523655 | 50507.445151205 | 50507.445151205 | 58322.9041901965 | 58597.722352839 | 58597.722352839 | 957000 |  |  | 1 | 0 | 0 | 969001 | Acquired Loans | 5 | 877276.755 | 0.04918247115633994 | 0.05379624809245459 | 0.004613776936114651 |  | 0 | 0 | 0 | 0 | 0
1 | 838000 | 838000 | 16 | 494989.28 | 502861.935 | 502861.935 | 8672.04320189945 | 8850.55921708222 | 8849.49522619798 | 21078.571643 | 21392.2220165 | 21392.2220165 | 838000 |  |  | 1 | 0 | 0 | 970000 | Acquired Loans | 90 | 7760341.4 | 0.01750945787846962 | 0.04393438144957128 | 0.02642492357110166 |  | 0 | 0 | 0 | 0 | 0
1 | 998665 | 998665 | 821 | 903197633.335001 | 889071336.39 | 889071336.39 | 31111714.3017539 | 30268192.0806711 | 30266739.6878933 | 49816427.7175411 | 48692926.7626915 | 48685947.1781755 | 998665 |  |  | 1 | 0 | 0 | 970001 | Acquired Loans | 6 | 1330986.595 | 0.006756604947024279 | 0.04914312693547451 | 0.04238652198845023 |  | 0 | 0 | 0 | 0 | 0
1 | 998503 | 998507 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 998507 |  |  | 1 | 0 | 0 | 970002 | Acquired Loans | 1150 | 131914836.81 | 0.04522553707407941 | 0.05309747632277695 | 0.007871939248697543 |  | 0 | 0 | 0 | 0 | 0
2 | 991917 | NULL | 2 | 0 | NULL | NULL | 0 | NULL | NULL | 0 | NULL | NULL | NULL |  |  | 1 | 0 | 0 | 970003 | Acquired Loans | 42 | 29722066.035 | 0.0175143434268571 | 0.0347750675295628 | 0.0172607241027057 |  | 0 | 0 | 0 | 0 | 0
1 | 970004 | 970004 | 210 | 46934480.72 | 44897649.5850001 | 44897649.5850001 | 1192618.19779339 | 1119054.58636455 | 1105929.47338775 | 2151259.39566 | 2043789.27869125 | 2027252.69579125 | 970004 |  |  | 1 | 0 | 0 | 970004 | Acquired Loans | 210 | 46934480.72 | 0.02541027789160527 | 0.04583537226061803 | 0.02042509436901276 |  | 0 | 0 | 0 | 0 | 0
1 | 998788 | 998788 | 15 | 3465382.23 | 3531530.03 | 3531530.03 | 90307.0270355782 | 92097.7877762076 | 92082.7922024276 | 169139.380038 | 171683.0914365 | 171683.0914365 | 998788 |  |  | 1 | 0 | 0 | 970010 | Acquired Loans | 457 | 188738171.605 | 0.03353495656680472 | 0.05783552263749345 | 0.02430056607068873 |  | 3 | 0 | 0 | 0 | 0
1 | 998796 | 998796 | 72 | 24972132.615 | 25062877.405 | 25062877.405 | 645454.905492548 | 639026.590986373 | 639025.912919533 | 1190494.00500435 | 1190228.0914836 | 1190228.0914836 | 998796 |  |  | 1 | 0 | 0 | 970011 | Acquired Loans | 5 | 5204391.72 | 0.04360757044477524 | 0.0591818063456607 | 0.01557423590088546 |  | 0 | 0 | 0 | 0 | 0
1 | 987000 | 987000 | 124 | 32505592.28 | 32797982.18 | 32797982.18 | 1006806.62297577 | 1014179.55344481 | 1007452.79953999 | 2181386.65742625 | 2200000.20952 | 2198306.32557 | 987000 |  |  | 1 | 0 | 0 | 970020 | Acquired Loans | 166 | 30850376.27 | 0.03413558124586206 | 0.05764007416985971 | 0.02350449292399764 |  | 0 | 0 | 0 | 0 | 0
2 | 0 | NULL | 174 | 28868.795 | NULL | NULL | 1677.97510541995 | NULL | NULL | 0 | NULL | NULL | NULL |  |  | 1 | 0 | 0 | 970021 | Acquired Loans | 6 | 4288031.235 | 0.04202455045433222 | 0.06791229023165965 | 0.02588773977732743 |  | 0 | 0 | 0 | 0 | 0
1 | 998502 | 998502 | 17054 | 11607956674.51 | 11512417280.195 | 11512417280.195 | 339768522.245733 | 332717969.007086 | 332310620.148732 | 486547841.03354 | 479335025.893377 | 478985752.571947 | 998502 |  |  | 1 | 0 | 0 | 970030 | Acquired Loans | 1950 | 201553971.12 | 0.0288113070175905 | 0.04940929133631326 | 0.02059798431872276 |  | 0 | 0 | 0 | 0 | 0
1 | 970001 | 970001 | 6 | 1330986.595 | 1340498.96 | 1340498.96 | 8992.9506122 | 9057.44341841 | 9028.24553556 | 65408.8431875 | 65823.63375 | 65823.63375 | 970001 |  |  | 1 | 0 | 0 | 970031 | Acquired Loans | 234 | 18336059.06 | 0.0370888406479216 | 0.06074135657370587 | 0.02365251592578427 |  | 0 | 0 | 0 | 0 | 0
2 | 998507 | NULL | 81 | 4196439.95 | NULL | NULL | 236836.380015073 | NULL | NULL | 288215.065895964 | NULL | NULL | NULL |  |  | 1 | 0 | 0 | 970040 | Acquired Loans | 121 | 26977715.65 | 0.0276897064857087 | 0.0524644226496123 | 0.0247747161639036 |  | 0 | 0 | 0 | 0 | 0
1 | 860000 | 860000 | 126 | 849773518.845 | 821824344.18 | 821824344.18 | 41933088.1836075 | 40266878.0730008 | 40140105.4644934 | 55622087.6664682 | 53516612.8051484 | 53496055.4298116 | 860000 |  |  | 1 | 0 | 0 | 970041 | Acquired Loans | 15 | 5329525.05 | 0.03506026664071971 | 0.06108674888609446 | 0.02602648224537475 |  | 0 | 0 | 0 | 0 | 0
1 | 957009 | 957009 | 2852 | 1841960571.665 | 1850137501.98 | 1850137501.98 | 35259661.9041693 | 35425274.9640485 | 35369522.9140198 | 61819448.8669559 | 62107722.2030788 | 61910105.7607476 | 957009 |  |  | 1 | 0 | 0 | 970050 | Corporate | 3 | 0 | #[NAME]! | #[NAME]! | #[NAME]! |  | 0 | 0 | 0 | 0 | 0
1 | 998504 | 998503 | 1 | 6339.21 | 7218.065 | 7218.065 | 368.461398130029 | 419.544126427966 | 416.683429627501 | 0 | 0 | 0 | 998503 |  |  | 1 | 0 | 0 | 970060 | Acquired Loans | 1615 | 374031.155 | 0.05812418237130941 | 0.1793397662288319 | 0.1212155838575225 |  | 0 | 0 | 0 | 0 | 0
1 | 998780 | 998780 | 54 | 26916981.06 | 27202944.85 | 27202944.85 | 743997.012079468 | 751251.001576471 | 751250.548121606 | 1131220.5086808 | 1143358.29561885 | 1143358.29561885 | 998780 |  |  | 1 | 0 | 0 | 970070 | Acquired Loans | 1681 | 348119585.615 | 0.05095037526187853 | 0.05940924521113747 | 0.008458869949258936 |  | 0 | 0 | 0 | 0 | 0
1 | 998638 | 998638 | 247 | 693314984.545 | 687016606.100001 | 687016606.100001 | 36483696.3619412 | 35834848.5442459 | 35625755.2329402 | 48369004.5443607 | 47424663.8004705 | 47385988.2344149 | 998638 |  |  | 1 | 0 | 0 | 978000 | Acquired Loans | 318 | 32898093.465 | 0.05627734393537173 | 0.0547394270515147 | -0.001537916883857023 |  | 0 | 0 | 0 | 0 | 0
1 | 969000 | 969000 | 247 | 52402579.225 | 52558751.305 | 52558751.305 | 2115632.74402246 | 2119728.07576177 | 2132471.7813155 | 2490783.05467065 | 2495645.77654235 | 2495867.44899327 | 969000 |  |  | 1 | 0 | 0 | 980000 | Acquired Loans | 62 | 12250816.995 | 0.05046929444046675 | 0.05531296357371079 | 0.004843669133244036 |  | 0 | 0 | 0 | 0 | 0
1 | 0 | 944000 | 1 | 92.87 | 265.66 | 265.66 | 5.39799281682351 | 15.4412702887621 | 15.3359826927081 | 14.30198 | 40.91164 | 40.91164 | 944000 |  |  | 1 | 0 | 0 | 981000 | Acquired Loans | 16 | 1673118.54 | 0.02103486310284386 | 0.0473264444962758 | 0.02629158139343194 |  | 0 | 0 | 0 | 0 | 0
1 | 998516 | 994761 | 1 | 1300 | 0 | 0 | 73.8387 | 0 | 0 | 136.5 | 0 | 0 | #N/A |  |  | 1 | 0 | 0 | 982000 | Acquired Loans | 2 | 0 | #[NAME]! | #[NAME]! | #[NAME]! |  | 0 | 0 | 0 | 0 | 0
2 | 944000 | NULL | 120 | 59447.345 | NULL | NULL | 3455.32832227015 | NULL | NULL | 7690.243082 | NULL | NULL | NULL |  |  | 1 | 0 | 0 | 983000 | Acquired Loans | 90 | 20606935.205 | 0.02372695118491464 | 0.04539487020863615 | 0.02166791902372151 |  | 0 | 0 | 0 | 0 | 0
1 | 998803 | 998803 | 122 | 46598606.585 | 46407059.36 | 46407059.36 | 1313912.8462921 | 1287103.75038871 | 1287036.17567414 | 2214092.19280026 | 2196212.57643812 | 2196212.57643812 | 998803 |  |  | 1 | 0 | 0 | 983001 | Acquired Loans | 12 | 2831811.18 | 0.02279351470287295 | 0.0427831670798404 | 0.01998965237696745 |  | 0 | 0 | 0 | 0 | 0
1 | 998504 | 998507 | 6 | 7839.84 | 10987.425 | 10987.425 | 455.684289921887 | 638.635094491085 | 634.280507556381 | 1213.417078 | 1770.244958 | 1770.244958 | 998507 |  |  | 1 | 0 | 0 | 984000 | Acquired Loans | 34 | 5792854.195 | 0.0364628829987555 | 0.04865748440626858 | 0.01219460140751307 |  | 0 | 0 | 0 | 0 | 0
2 | 998620 | NULL | 43 | 175913901.17 | NULL | NULL | 8262918.7081279 | NULL | NULL | 13650201.9672035 | NULL | NULL | NULL |  |  | 1 | 0 | 0 | 985000 | Acquired Loans | 296 | 11693184.335 | 0.03384126072558771 | 0.05357763743904068 | 0.01973637671345297 |  | 0 | 0 | 0 | 0 | 0
2 | 998665 | NULL | 34 | 29677722.5 | NULL | NULL | 1605176.5727775 | NULL | NULL | 2192583.142 | NULL | NULL | NULL |  |  | 1 | 0 | 0 | 987000 | Acquired Loans | 124 | 32505592.28 | 0.03097333573568622 | 0.06710804216812905 | 0.03613470643244283 |  | 0 | 0 | 0 | 0 | 0
2 | 998610 | NULL | 6 | 32939788.265 | NULL | NULL | 1952130.98230798 | NULL | NULL | 2577661.76639174 | NULL | NULL | NULL |  |  | 1 | 0 | 0 | 988000 | Acquired Loans | 38 | 5630618.755 | 0.02170892020114954 | 0.05534995397828173 | 0.03364103377713219 |  | 0 | 0 | 0 | 0 | 0
1 | 181000 | 181000 | 44740 | 1139191682.64001 | 1145521512.16499 | 1145521512.16499 | 31743809.7342055 | 31271502.2250594 | 31271388.2001981 | 51290175.4611044 | 50952304.9006805 | 50945349.7314235 | 181000 |  |  | 1 | 0 | 0 | 989001 | Acquired Loans | 1762 | 15230362.27 | 0.05592463957238655 | 0.08037462945240763 | 0.02444998988002108 |  | 7 | 13928.83000000007 | -1.405779835594867e-07 | -2.421758228107751e-06 | -2.281180244548264e-06
1 | 998776 | 998776 | 209 | 94550657.54 | 93603018.62 | 93603018.62 | 2956565.85296084 | 2896438.32547408 | 2896366.59514247 | 4368174.2200158 | 4301459.1087903 | 4301459.1087903 | 998776 |  |  | 1 | 0 | 0 | 991917 | Private Banking | 63 | 14040818.43 | 0.05812468103690428 | 0.0779737640638246 | 0.01984908302692032 |  | 2 | 0 | 0 | 0 | 0
1 | 998663 | 998663 | 229 | -9.82254277914763e-11 | -9.82254277914763e-11 | -9.82254277914763e-11 | 14286.282214905 | 14286.282214905 | 14286.282214905 | 0 | 0 | 0 | 998663 |  |  | 1 | 0 | 0 | 994860 | 3rd Party Originations | 922 | 399573770.725 | 0.03025956793014246 | 0.04498204743034288 | 0.01472247950020042 |  | 81 | 5765604.300000012 | 0.0003383608457200732 | 0.0004354256476836321 | 9.706480196355893e-05
1 | 994990 | 994990 | 5 | 442680.875000001 | 3189995.13 | 3189995.13 | 25597.8455816716 | 185282.98741139 | 184046.109623271 | 2452.1237845 | 2731.44805 | 2731.44805 | 994990 |  |  | 1 | 0 | 0 | 994861 | Mortgage | 8599 | 3835064889.17 | 0.02429615732388041 | 0.04190340803290817 | 0.01760725070902776 |  | 72 | 23983412.59000015 | 0.0001855856221266265 | 0.0001842824301771101 | -1.303191949516419e-06
2 | 998611 | NULL | 668 | 311345217.58 | NULL | NULL | 8457780.24643761 | NULL | NULL | 9214550.13318208 | NULL | NULL | NULL |  |  | 1 | 0 | 0 | 994931 | SBA Lending | 3666 | 221248131.870001 | 0.02444801283799179 | 0.04102267495057913 | 0.01657466211258734 |  | 63 | 2275569.139999986 | 0.0002657480833859055 | 0.0002167241606132811 | -4.902392277262441e-05
1 | 970000 | 970000 | 90 | 7760341.4 | 7863835.295 | 7863835.295 | 135879.370865844 | 137156.50947612 | 136071.552342969 | 340945.7992465 | 345595.75119075 | 344908.84654575 | 970000 |  |  | 1 | 0 | 0 | 994934 | Controller | 0 | 0 | #[NAME]! | #[NAME]! | #[NAME]! |  | 0 | 0 | 0 | 0 | 0
1 | 994860 | 994860 | 841 | 393808166.425 | 356203839.51 | 356203839.51 | 11783215.6991391 | 10399655.8614494 | 10399139.1819669 | 17542823.444657 | 15595799.9878647 | 15595799.9878647 | 994860 |  |  | 1 | 0 | 0 | 994959 | Acquired Loans | 22 | 1457445.17 | 0.03789276195481165 | 0.05035196864695776 | 0.0124592066921461 |  | 0 | 0 | 0 | 0 | 0
1 | 957005 | 957005 | 6 | 1257117.885 | 1276890.2 | 1276890.2 | 26119.20548641 | 26503.308224455 | 26503.308224455 | 57778.268745577 | 58744.3167622665 | 58744.3167622665 | 957005 |  |  | 1 | 0 | 0 | 994963 | Corporate Finance | 93 | 633996819.255 | 0.0398128416773437 | 0 | -0.0398128416773437 |  | 1 | 11500000 | 0.0002973233195505409 | 0 | -0.0002973233195505409
1 | 998787 | 998787 | 126 | 61881228.665 | 62539801.91 | 62539801.91 | 1659445.08520566 | 1677207.65860765 | 1677207.62996596 | 2966302.48738025 | 2997901.68310015 | 2997901.68310015 | 998787 |  |  | 1 | 0 | 0 | 994990 | Corporate | 5 | 442680.875000001 | 0.0578246023880556 | 0.005539258465819185 | -0.05228534392223642 |  | 0 | 0 | 0 | 0 | 0
1 | 961000 | 961000 | 114 | 130243760.04 | 122280730.475 | 122280730.475 | 6053971.07349303 | 5588594.35667587 | 5586868.15167108 | 5579651.7496049 | 5182203.45201368 | 5182203.45201368 | 961000 |  |  | 1 | 0 | 0 | 997901 | Mortgage | 6 | -1.81898940354586e-12 | -84436353417232.94 | 0 | 84436353417232.94 |  | 0 | 0 | 0 | 0 | 0
2 | 181000 | NULL | 1118 | 23283121.55 | NULL | NULL | 1174740.47484832 | NULL | NULL | 1595887.4710775 | NULL | NULL | NULL |  |  | 1 | 0 | 0 | 998402 | Managed | 9681 | 0 | #[NAME]! | #[NAME]! | #[NAME]! |  | 3559 | 0 | 0 | 0 | 0
1 | 113000 | 113000 | 3 | 509906.47 | 507141.755 | 507141.755 | 15156.44400307 | 15059.103988805 | 15059.103988805 | 16392.8543 | 16329.83345 | 16329.83345 | 113000 |  |  | 1 | 0 | 0 | 998501 | Commercial Banking | 705 | 151347798.99 | 0.0305090485377196 | 0.04303235512787856 | 0.01252330659015896 |  | 10 | 1404231.129999995 | 0.0002367509372878766 | 0.0003444616346974169 | 0.0001077106974095403
1 | 998625 | 998625 | 148 | 40677200.79 | 40962822.79 | 40962822.79 | 2358516.9082368 | 2373794.82749503 | 2369600.52391625 | 2877745.64091043 | 2895891.44389433 | 2855550.10524065 | 998625 |  |  | 1 | 0 | 0 | 998502 | Commercial Banking | 17598 | 11692800445.825 | 0.02943403010886505 | 0.04207136399153884 | 0.01263733388267379 |  | 512 | 84585269.125 | 0.0001630748153948584 | 0.0001572683594955673 | -5.806455899291102e-06
2 | 998797 | NULL | 2 | 225203.405 | NULL | NULL | 11404.77964031 | NULL | NULL | 15061.077157 | NULL | NULL | NULL |  |  | 1 | 0 | 0 | 998503 | Business Banking | 44703 | 11159159056.785 | 0.02945919895003525 | 0.04394639352531997 | 0.01448719457528472 |  | 1203 | 114169760.0900002 | 0.0002194972632314288 | 0.0002243278338230625 | 4.830570591633776e-06
1 | 998612 | 998612 | 481 | 1835654101.675 | 1784722561.205 | 1784722561.205 | 108165693.021411 | 104710368.274257 | 105054769.507991 | 141796561.647807 | 136805036.733354 | 141595960.685926 | 998612 |  |  | 1 | 0 | 0 | 998504 | Retail Banking | 619104 | 5930205512.41971 | 0.04138168725572506 | 0.07102082360544408 | 0.02963913634971902 |  | 9809 | 63879232.24499989 | 0.0001236844318638283 | 5.490367679385211e-05 | -6.878075506997622e-05
2 | 998613 | NULL | 10 | 41371283.235 | NULL | NULL | 2302950.32549888 | NULL | NULL | 3177786.87761461 | NULL | NULL | NULL |  |  | 1 | 0 | 0 | 998505 | Trust | 1 | 0 | #[NAME]! | #[NAME]! | #[NAME]! |  | 0 | 0 | 0 | 0 | 0
1 | 998619 | 998619 | 466 | 3398512997.685 | 3369420086.43 | 3369420086.43 | 192476743.447973 | 191301196.012972 | 191086749.074829 | 264656295.013704 | 262250573.846422 | 262021169.054247 | 998619 |  |  | 1 | 0 | 0 | 998507 | Private Banking | 5863 | 514804383.855001 | 0.04396629792039075 | 0.059850454786901 | 0.01588415686651025 |  | 81 | 4196439.949999988 | 0.0001024943924062341 | 7.257275732756169e-05 | -2.99216350786724e-05
2 | 998608 | NULL | 9 | 8571899.365 | NULL | NULL | 485883.40249443 | NULL | NULL | 558820.436155268 | NULL | NULL | NULL |  |  | 1 | 0 | 0 | 998513 | Private Banking | 1767 | 1150252217.56 | 0.01889159009784092 | 0.03699915753828656 | 0.01810756744044564 |  | 16 | 6571211.5 | 0.0001910022876805764 | 0.0001633248916038249 | -2.767739607675151e-05
2 | 998514 | NULL | 145 | 3195346.19 | NULL | NULL | 175879.887611489 | NULL | NULL | 211470.86142025 | NULL | NULL | NULL |  |  | 1 | 0 | 0 | 998514 | General Bank | 1074 | 73407816.85499999 | 0.05029304645036277 | 0.06431914551914582 | 0.01402609906878305 |  | 145 | 3195346.189999998 | 0.0002161466917356969 | 8.472746771688577e-05 | -0.0001314192240188111
1 | 998618 | 998618 | 114 | 331891474.545 | 321003999.1 | 321003999.1 | 19788817.5610383 | 19136022.7240055 | 19065490.245485 | 31964258.8278678 | 30985846.1918735 | 31015598.6510984 | 998618 |  |  | 1 | 0 | 0 | 998516 | General Bank | 9596 | 93538658.5350003 | 0.03922352055904874 | 0.05491274596162429 | 0.01568922540257554 |  | 220 | 587465.7800000012 | 0.0001125533494783504 | 3.328202246114659e-05 | -7.92713270172038e-05
1 | 796000 | 796000 | 288 | 20621235 | 20958065.31 | 20958065.31 | 584412.103199145 | 592485.85649056 | 590806.322013811 | 935401.052644751 | 950979.19069425 | 949138.00619425 | 796000 |  |  | 1 | 0 | 0 | 998517 | SBA Lending | 163 | 72240859.32 | 0.04047526268994904 | 0.05266717196910501 | 0.01219190927915597 |  | 1 | 0 | 0 | 0 | 0
1 | 998629 | 998629 | 377 | 3531801247.505 | 3553705446.04 | 3553705446.04 | 204182017.555594 | 205604747.308826 | 205847679.007903 | 273319185.512505 | 275828731.72443 | 275816616.349149 | 998629 |  |  | 1 | 0 | 0 | 998518 | Retail Banking | 3910 | 8178296.705 | 0.05812418237130947 | 0.1939537035392995 | 0.13582952116799 |  | 135 | 80877.93499999959 | 0 | -5.790055413679163e-05 | -5.790055413679163e-05
2 | 998776 | NULL | 1 | 50407.695 | NULL | NULL | 2550.73018239 | NULL | NULL | 3125.27709 | NULL | NULL | NULL |  |  | 1 | 0 | 0 | 998519 | Business Banking | 0 | 0 | #[NAME]! | #[NAME]! | #[NAME]! |  | 0 | 0 | 0 | 0 | 0
1 | 998514 | 0 | 1 | 94.935 | 0 | 0 | 5.51801925342027 | 0 | 0 | 17.316144 | 0 | 0 | 0 |  |  | 1 | 0 | 0 | 998520 | General Bank | 902 | 43892095.535 | 0.05045961805286315 | 0.07611578495016143 | 0.02565616689729828 |  | 0 | 0 | 0 | 0 | 0
2 | 998518 | NULL | 135 | 80877.935 | NULL | NULL | 4700.96384375491 | NULL | NULL | 15217.729994 | NULL | NULL | NULL |  |  | 1 | 0 | 0 | 998521 | Other Misc LOB | 0 | 0 | #[NAME]! | #[NAME]! | #[NAME]! |  | 0 | 0 | 0 | 0 | 0
1 | 983001 | 983001 | 12 | 2831811.18 | 2846617.17 | 2846617.17 | 64546.92976709 | 64842.556778395 | 64842.556778395 | 121153.8508525 | 121731.2563075 | 121731.2563075 | 983001 |  |  | 1 | 0 | 0 | 998522 | Retail Banking | 11755 | 429669783.805 | 0.03867540190042833 | 0.05699854275753002 | 0.01832314085710169 |  | 80 | 3419209.910000026 | 0.0001202957311332922 | 6.840631591125551e-05 | -5.188941522203672e-05
1 | 998661 | 998661 | 166 | 194473936.115 | 195441486.505 | 195441486.505 | 8197141.05721756 | 8240019.50410533 | 8240036.27761937 | 11846736.7879725 | 11903430.6576175 | 11903430.6576175 | 998661 |  |  | 1 | 0 | 0 | 998602 | Industry Corporate Finance | 8 | 55829019.63 | 0.02723865475672065 | 0 | -0.02723865475672065 |  | 0 | 0 | 0 | 0 | 0
1 | 998773 | 998773 | 160 | 53045093.9 | 53226363.24 | 53226363.24 | 1544154.07769228 | 1533855.18700129 | 1533662.80649124 | 2422848.0809287 | 2420996.26351357 | 2420996.26351357 | 998773 |  |  | 1 | 0 | 0 | 998604 | Commercial Finance | 99758 | 2566592078.54004 | 0.05811595403871937 | 0.007158626735730988 | -0.05095732730298838 |  | 21643 | 20155077.68000031 | 6.512734555819133e-08 | -3.082980139083348e-05 | -3.089492873638994e-05
1 | 899000 | 899000 | 3 | 25550.835 | 29774.065 | 29774.065 | 220.826039342639 | 264.632957185278 | 264.493688717111 | 1008.3929975 | 1195.6732025 | 1195.6732025 | 899000 |  |  | 1 | 0 | 0 | 998608 | Commercial Finance | 320 | 860866741.05 | 0.04376008638384174 | 0.05443856290174932 | 0.01067847651790758 |  | 9 | 8571899.36500001 | 0.0001299742065661511 | 0.0001081533629888123 | -2.182084357733871e-05
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 | 0 | 998609 | Industry Corporate Finance | 7 | -1.01 | 0.013985 | 0 | -0.013985 |  | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 | 0 | 998610 | Industry Corporate Finance | 111 | 1042323204.725 | 0.05910528077634607 | 0.08226955870787438 | 0.0231642779315283 |  | 6 | 32939788.26499999 | 5.167063483225987e-06 | -0.0001310503778282207 | -0.0001362174413114467
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 | 0 | 998611 | Industry Corporate Finance | 1625 | 1132271982.389999 | 0.03552199047680196 | 0.04667259789488522 | 0.01115060741808327 |  | 668 | 311345217.5799999 | -0.003169371153392914 | -0.006476509527199234 | -0.00330713837380632
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 | 0 | 998612 | Industry Corporate Finance | 506 | 1859356855.44 | 0.0587845770690651 | 0.0773337992772131 | 0.018549222208148 |  | 25 | 23702753.7650001 | -0.0001403004025194651 | 8.800361319322159e-05 | 0.0002283040157126867
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 | 0 | 998613 | Industry Corporate Finance | 141 | 650673159.6800001 | 0.05917633955569737 | 0.08015849676986803 | 0.02098215721417065 |  | 10 | 41371283.23500001 | -0.0002383888589312794 | -0.0002272650081948935 | 1.112385073638589e-05
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 | 0 | 998616 | Industry Corporate Finance | 821 | 3239875392.76 | 0.05872811811041945 | 0.08117979038812613 | 0.02245167227770668 |  | 99 | 223047729.0149999 | -0.0007894004205873453 | 5.395162536341036e-05 | 0.0008433520459507557
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 | 0 | 998617 | Industry Corporate Finance | 102 | 490073992.475 | 0.05864353504086924 | 0.08666560841123927 | 0.02802207337037003 |  | 10 | 72871159.87 | 0.0002116647810100833 | 0.0001375706530240134 | -7.40941279860699e-05
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 | 0 | 998618 | Industry Corporate Finance | 118 | 333015052.885 | 0.05959499202739599 | 0.09628425112001872 | 0.03668925909262272 |  | 4 | 1123578.339999974 | -2.937038856357099e-05 | -2.51188982638012e-05 | 4.251490299769789e-06
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 | 0 | 998619 | Industry Corporate Finance | 502 | 3447261361.39 | 0.05662216562018646 | 0.07793355337585188 | 0.02131138775566542 |  | 36 | 48748363.70499992 | -1.341105087066669e-05 | 5.940806760010298e-05 | 7.281911847076966e-05
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 | 0 | 998620 | Industry Corporate Finance | 385 | 2152761183.955 | 0.05766378423607937 | 0.08259750456636734 | 0.02493372033028797 |  | 43 | 175913901.1699998 | -0.0009514860097923558 | -0.0004450760034095946 | 0.0005064100063827612
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 | 0 | 998621 | Industry Corporate Finance | 178 | 640395961.4449999 | 0.06048872997265473 | 0.07935209785420001 | 0.01886336788154529 |  | 16 | 32983260.55499995 | -0.0005115052157054975 | 4.710549219315296e-05 | 0.0005586107078986505
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 | 0 | 998623 | Commercial Finance | 0 | 0 | #[NAME]! | #[NAME]! | #[NAME]! |  | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 | 0 | 998624 | Commercial Finance | 8 | 10846184.24 | 0.03354536185256669 | 0 | -0.03354536185256669 |  | 1 | -5000 | -3.740449875277996e-06 | 0 | 3.740449875277996e-06
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 | 0 | 998625 | Commercial Segment | 148 | 40677200.79 | 0.05798129818255865 | 0.07074591134643388 | 0.01276461316387523 |  | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 | 0 | 998626 | Commercial Segment | 47 | 343285127.385 | 0.04815754729252644 | 0.06401035005188331 | 0.01585280275935687 |  | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 | 0 | 998628 | Commercial Segment | 285 | 925149662.175001 | 0.03952383157110458 | 0.04117468326039673 | 0.001650851689292146 |  | 4 | 14330636.81500006 | 0.0002504678484493011 | 0.0002184659501034761 | -3.200189834582506e-05
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 | 0 | 998629 | Commercial Segment | 431 | 3651111115.71 | 0.05778589084575218 | 0.07749470804739333 | 0.01970881720164116 |  | 54 | 119309868.2049999 | -2.654061534320545e-05 | 0.0001066654145899931 | 0.0001332060299331986
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 | 0 | 998630 | Business Capital | 121538 | 1947523058.07498 | 0.03560217394091701 | 0.09989596874501237 | 0.06429379480409536 |  | 22867 | 81291223.21999979 | 0.0002341327810512148 | -8.688997364086903e-06 | -0.0002428217784153086
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 | 0 | 998631 | Business Capital | 216798 | 4096522113.93501 | 0.03615398647184712 | 0.06383506920914582 | 0.0276810827372987 |  | 93701 | 1023436424.70999 | -0.001346060239484831 | 0.0008205570448084898 | 0.002166617284293321
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 | 0 | 998637 | Commercial Segment | 11 | 307694706.165 | 0.05936044360870845 | 0.08319804894121162 | 0.02383760533250317 |  | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 | 0 | 998638 | Commercial Finance | 266 | 718643491.37 | 0.05255351447280684 | 0.06938003736016163 | 0.01682652288735478 |  | 19 | 25328506.82500005 | -6.859405681661906e-05 | -0.0003847962617507805 | -0.0003162022049341615
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 | 0 | 998650 | Corporate | 5 | -0.04 | 0.01397325 | 0 | -0.01397325 |  | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 | 0 | 998660 | 3rd Party Originations | 74 | 87463906.48 | 0.0454429559704561 | 0.06272234578044998 | 0.01727938980999388 |  | 7 | 3766450 | 0.0004041147976003023 | 0.0003420980091798365 | -6.201678842046587e-05
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 | 0 | 998661 | 3rd Party Originations | 167 | 194933621.74 | 0.04216879136605636 | 0.06097539626165595 | 0.01880660489559959 |  | 1 | 459685.625 | 1.845893091569073e-05 | 5.856069677560166e-05 | 4.010176585991093e-05
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 | 0 | 998663 | 3rd Party Originations | 229 | -9.82254277914763e-11 | -145443827897939.9 | 0 | 145443827897939.9 |  | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 | 0 | 998664 | 3rd Party Originations | 114 | 2.5607960196794e-11 | 22183870475600.06 | 0 | -22183870475600.06 |  | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 | 0 | 998665 | SBA Lending | 855 | 932875355.835001 | 0.03507102065660965 | 0.05575129682034392 | 0.02068027616373427 |  | 34 | 29677722.5 | 0.000624833960043765 | 0.0005956743088045141 | -2.915965123925085e-05
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 | 0 | 998667 | General Bank | 1 | 254564.99 | 0.012593 | 0 | -0.012593 |  | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 | 0 | 998671 | Mortgage | 4306 | 914129979.759998 | 0.04768259329884326 | 0.05256245685273718 | 0.004879863553893922 |  | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 | 0 | 998675 | CAB | 9 | 77476.88 | 0.05812416528007568 | 0 | -0.05812416528007568 |  | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 | 0 | 998677 | Community Lending | 179 | 430990682.955 | 0.04787303186570096 | 0.04542345080329278 | -0.002449581062408175 |  | 4 | 7542466.975000024 | 0.0001377369290773353 | -0.000184220024535553 | -0.0003219569536128883
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 | 0 | 998678 | CAB | 1 | 0 | #[NAME]! | #[NAME]! | #[NAME]! |  | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 | 0 | 998699 | Rail | 3240 | 7997789877.73007 | 0.03190708819693986 | 0.0007074816388924328 | -0.03119960655804743 |  | 42 | 43378390.64500046 | 0.0001204562862207395 | -3.858162851628805e-06 | -0.0001243144490723699
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 | 0 | 998733 | Rail | 3 | -171317.285 | -0.01827717839957013 | 0 | 0.01827717839957013 |  | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 | 0 | 998772 | CAB | 13 | 751419.925 | 0.01779929090365098 | 0.05512532285326344 | 0.03732603194961246 |  | 1 | 1918.140000000014 | 7.638173729775793e-05 | 1.273129352485913e-05 | -6.36504437728988e-05
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 | 0 | 998773 | CAB | 165 | 54059583.89 | 0.02951085632891578 | 0.04606222503581502 | 0.01655136870689924 |  | 5 | 1014489.990000002 | 0.0004006415255769155 | 0.0003869720992055459 | -1.366942637136964e-05
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 | 0 | 998774 | CAB | 105 | 26081498.455 | 0.02892745016420557 | 0.04842943730014342 | 0.01950198713593785 |  | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 | 0 | 998775 | CAB | 130 | 67341146.44 | 0.0261573119391791 | 0.04488626829245811 | 0.01872895635327901 |  | 2 | 760860.5199999958 | 0.0002904296295870301 | 0.0002952174863030538 | 4.787856716023664e-06
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 | 0 | 998776 | CAB | 210 | 94601065.235 | 0.03127994992225978 | 0.04620771960915013 | 0.01492776968689035 |  | 1 | 50407.69499999285 | 1.030114472426458e-05 | 8.41932223433206e-06 | -1.881822489932516e-06
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 | 0 | 998778 | CAB | 14 | 5188782.46 | 0.03175910576812677 | 0.0455999257983924 | 0.01384082003026563 |  | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 | 0 | 998779 | CAB | 14 | 5833262.26 | 0.03751670381428727 | 0.05352493390559471 | 0.01600823009130743 |  | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 | 0 | 998780 | CAB | 56 | 28527163.39 | 0.02897384165451275 | 0.04321011446595146 | 0.01423627281143871 |  | 2 | 1610182.330000002 | 0.00133340863488688 | 0.001183837218914602 | -0.0001495714159722786
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 | 0 | 998781 | CAB | 90 | 43170336.91 | 0.03112669587600515 | 0.04608687421078664 | 0.0149601783347815 |  | 1 | 150412.6850000024 | 7.007839376457076e-05 | 5.913419671296771e-05 | -1.094419705160304e-05
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 | 0 | 998782 | CAB | 165 | 57268049.56500001 | 0.02809742390246061 | 0.04572266948626958 | 0.01762524558380897 |  | 5 | 408185.1700000018 | 0.0001555231393638307 | 0.000111885005453026 | -4.363813391080468e-05
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 | 0 | 998787 | CAB | 129 | 62182049.18 | 0.02692839646328434 | 0.04797261861747557 | 0.02104422215419123 |  | 3 | 300820.5150000006 | 0.0001117814573149863 | 3.720182996130861e-05 | -7.457962735367765e-05
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 | 0 | 998788 | CAB | 15 | 3465382.23 | 0.02605975936904894 | 0.0488082897677928 | 0.02274853039874386 |  | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 | 0 | 998789 | CAB | 3 | 118800.66 | 0.04982178586591421 | 0.05468375435961383 | 0.004861968493699617 |  | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 | 0 | 998790 | CAB | 39 | 28095812.15 | 0.02551454701592739 | 0.0454337311176463 | 0.01991918410171891 |  | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 | 0 | 998791 | CAB | 71 | 24979554.9 | 0.02870352805797456 | 0.04698516249754114 | 0.01828163443956658 |  | 1 | 99723.375 | 0.0001054135796756152 | 6.419069374392211e-05 | -4.122288593169307e-05
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 | 0 | 998792 | CAB | 97 | 43861195.57 | 0.02936012871821952 | 0.04820238194678262 | 0.0188422532285631 |  | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 | 0 | 998794 | CAB | 217 | 85293164.875 | 0.02658758645474908 | 0.04470760335823217 | 0.01812001690348309 |  | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 | 0 | 998795 | CAB | 9 | 3246401.84 | 0.03488716332893713 | 0.05174510922942306 | 0.01685794590048593 |  | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 | 0 | 998796 | CAB | 75 | 25047449.74 | 0.0259231035134355 | 0.04772967483676244 | 0.02180657132332695 |  | 3 | 75317.125 | 7.609575307934366e-05 | 5.677387317967741e-05 | -1.932187989966624e-05
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 | 0 | 998797 | CAB | 75 | 30209072.355 | 0.02596229531950112 | 0.04491631359091761 | 0.0189540182714165 |  | 2 | 225203.4050000012 | 0.0001853657492303963 | 0.0001649477058656076 | -2.041804336478867e-05
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 | 0 | 998798 | CAB | 202 | 60261096.73 | 0.02622084842446511 | 0.04446976295424569 | 0.01824891452978059 |  | 2 | 143904.5099999979 | 5.878893047032985e-05 | 4.435644087459611e-05 | -1.443248959573373e-05
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 | 0 | 998799 | CAB | 31 | 11386425.185 | 0.02289671226735101 | 0.04352105391568513 | 0.02062434164833412 |  | 1 | 77912.57499999925 | 0.0001956289168024913 | 0.0001342046385811244 | -6.142427822136698e-05
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 | 0 | 998801 | CAB | 113 | 22418335.9 | 0.02872073637183588 | 0.04832438773204392 | 0.01960365136020804 |  | 1 | 150412.4600000009 | 0.000164444206103339 | 9.912890841290434e-05 | -6.531529769043462e-05
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 | 0 | 998802 | CAB | 417 | 116047915.115 | 0.02906305168709971 | 0.04638552527044768 | 0.01732247358334797 |  | 6 | 388402.5550000072 | 7.030856262834131e-05 | 5.418302022230231e-05 | -1.6125542406039e-05
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 | 0 | 998803 | CAB | 125 | 47105843.545 | 0.02843117486940801 | 0.04767384113920892 | 0.0192426662698009 |  | 3 | 507236.9600000009 | 0.000234777110273178 | 0.0001597123902825071 | -7.506471999067094e-05
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 | 0 | 998830 | 3rd Party Originations | 1513 | -2.63327137872693e-10 | 34274205039487.21 | 0 | -34274205039487.21 |  | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1272143 | 86858309868.72485 | 0.03849508842328484 | 0.05060205263372781 | 0.01210696421044299 |  | 156773 | 2706350037.425034 | 9.261333098654206e-05 | 0.0004790554560921145 | 0.0003864421251055863