Derived table · PPP lender fees
PPP processing fees by originating lender, modeled loan by loan
Applied loan by loan to SBA's September 30, 2024 PPP file, SBA's fee schedule comes to $38.24 billion across 4,688 originating lenders. JPMorgan Chase leads at $1.79 billion on $44.11 billion of loans, a 4.06% take. Prestamos CDFI, LLC is third at $1.06 billion on $6.85 billion, 15.4% of what it lent, because the schedule paid most on the smallest loans.
Download CSV 930 KBData dictionary CSVAt a glancePreviewColumnsHow to useBefore you quote a row
At a glance
Measured on the file on 2026-10-17; the checksum above is the file these numbers describe.
OriginatingLender · unique; one row has no nameWhat it is
One row per originating lender in SBA's PPP loan file: how many loans it made, their approved dollars, the jobs its borrowers reported, and the processing fee SBA's schedule assigns to those loans, in total and split by program round and by loan-size band. Rows run from the largest modeled fee to the smallest.
The fee is a percentage of each loan, and the percentage fell as loans got larger. In the 2021 rounds a loan of $50,000 or less paid the lesser of $2,500 and half the loan. So the $6,849,909,472 Prestamos CDFI lent earns a modeled $1,055,074,366, while JPMorgan Chase's $44,111,851,717 earn $1,790,545,416.
4,688 rows carry a lender name. One row, 28 loans for $658,902.94, has a blank lender field in SBA's file and is kept as SBA left it.
How it was built
Each loan is priced on the schedule of its approval date. Loans approved before January 1, 2021 take the 2020 schedule: 5% up to $350,000, 3% up to $2 million, 1% above. Loans approved from January 1, 2021 take the 2021 schedule: the lesser of $2,500 and 50% up to $50,000, then 5%, 3% and 1% at the same breakpoints; second-draw loans were capped at $2 million, so they never reach the 1% band.
SBA's file codes 17 loans approved between April and July 2020 as second-draw loans. Second draws did not exist until December 27, 2020, so those 17 are priced and counted as 2020 loans.
The fee is applied to CurrentApprovalAmount. A loan whose undisbursed amount equals or exceeds its approved amount earns no fee and is left out; that drops 4 of SBA's 11,468,210 loans. The results are summed by OriginatingLender.
Preview
| OriginatingLender | loans | dollars | fees | jobs | fee_per_loan | fee_per_job | fees_PPP1 | fees_PPP2_FD | fees_PPP2_SD | fees_lte50k | fees_50to350k | fees_350kto2M | fees_2Mplus | loans_lte50k | loans_50to350k | loans_350kto2M | loans_2Mplus |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| JPMorgan Chase Bank, National Association | 452892 | 44111851716.68999 | 1790545416.2535877 | 7100912.0 | 3953.5814636902123 | 252.15710548920867 | 1093383063.2986755 | 104790613.55000114 | 592371739.4044995 | 451892046.8277576 | 808236306.7304065 | 445107458.9292061 | 85309603.76400007 | 297868 | 132158 | 20777 | 2089 |
| Bank of America, National Association | 491034 | 34411968884.59003 | 1491130977.6498222 | 4222159.0 | 3036.716352940575 | 353.16788819412585 | 946532709.149663 | 40884066.190000005 | 503714202.30995786 | 479997349.6729146 | 654127758.3155501 | 301228727.3433008 | 55777142.31710002 | 361453 | 114257 | 13926 | 1398 |
| Prestamos CDFI, LLC | 444780 | 6849909471.86 | 1055074365.5830001 | 452201.0 | 2372.1263671545485 | 2333.1977717497307 | 1250674.032999998 | 1008967983.7199999 | 44855707.83000003 | 1053108920.9229996 | 1500340.9699999993 | 390507.8400000001 | 74595.85 | 444485 | 272 | 22 | 1 |
| Cross River Bank | 478866 | 12894672292.929684 | 1034617269.100648 | 1438370.0 | 2160.556959777157 | 719.2984205042152 | 293984900.3300422 | 500222978.9399975 | 240409389.82999814 | 778299005.9371667 | 209842858.017488 | 45745345.916699946 | 730059.229 | 437981 | 38571 | 2295 | 19 |
| Harvest Small Business Finance, LLC | 408173 | 8186742159.749964 | 1002631927.0989039 | 600427.0 | 2456.389636499484 | 1669.8648246979299 | 39041928.51270017 | 641727126.9712002 | 321862871.6149998 | 935166182.0715015 | 35697106.80849987 | 27143835.635400012 | 4624802.583500001 | 401501 | 5392 | 1187 | 93 |
| Capital Plus Financial, LLC | 395359 | 6213416269.31 | 937325953.9259998 | 410309.0 | 2370.8223511441493 | 2284.439176147732 | 0.0 | 818266707.7569997 | 119059246.169 | 930854079.42 | 2994844.298000003 | 3088641.047999998 | 388389.16 | 394792 | 455 | 104 | 8 |
| Benworth Capital | 311022 | 4222794691.5299997 | 697409428.0240002 | 329148.0 | 2242.3154247095067 | 2118.832342970336 | 1139891.0055000004 | 559253790.8189999 | 137015746.19950005 | 692311335.343 | 4105345.2195000066 | 992747.4615000002 | 0.0 | 310285 | 684 | 53 | 0 |
| Wells Fargo Bank, National Association | 280717 | 13777713764.689999 | 690064426.7044284 | 1747245.0 | 2458.221008006029 | 394.94428469071505 | 420685221.3345815 | 79831342.56000039 | 189547862.80999815 | 293096976.651034 | 294195250.9834802 | 89469133.97999997 | 13303065.090000007 | 223058 | 52857 | 4471 | 331 |
| Fountainhead SBF LLC | 272227 | 4126997776.8999996 | 640621923.2325002 | 344545.0 | 2353.263721939779 | 1859.3272960933991 | 15524081.147500003 | 438211430.8449996 | 186886411.23999977 | 618181014.8959999 | 17207880.65299993 | 4953588.583499998 | 279439.1 | 269102 | 2875 | 243 | 7 |
| PNC Bank, National Association | 119352 | 17321532877.14 | 606847472.0410048 | 1755025.0 | 5084.518667814572 | 345.7771097511459 | 392000388.53099996 | 39292025.93 | 175555057.57999521 | 115011206.6665 | 246859654.06298488 | 192258490.61399952 | 52718120.6975 | 70362 | 39404 | 8292 | 1294 |
First 10 of 4689 rows · cells longer than 60 characters are cut with an ellipsis · shown as text, unformatted.
Files
| File | Rows | Size | SHA-256 | |
|---|---|---|---|---|
ppp-lender-fee-model.csvCSV, UTF-8, header row | 4,689 | 951,895 B | 7e4c668c7942ec6ea2274827066952e855b0299b487a56ebc104861cb120c499 | Download ↓ |
dictionary.csvdata dictionary, 18 rows | 18 | — | built with this page | Download ↓ |
Columns
| Column | Type, measured | Blank | Distinct | Range / values | Meaning |
|---|---|---|---|---|---|
OriginatingLender | text | 1 | 4,688 | JPMorgan Chase Bank, National Associatio (1), Bank of America, National Association (1), Prestamos CDFI, LLC (1) | Originating lender, as SBA's file prints it. One exception: SBA's file stops Zions Bank's name at "Zions Bank, A Division of"; this file gives the full name, Zions Bank, a division of Zions Bancorporation, National Association. |
loans | integer | 0 | 1,842 | 1 – 491K · median 400 | Loans priced for this lender. |
dollars | number | 0 | 4,689 | 2.5K – 44.1B · median 18.7M | Sum of CurrentApprovalAmount on those loans, in dollars. |
fees | number | 0 | 4,688 | 125.00 – 1.8B · median 1.1M | Modeled processing fee on those loans, in dollars. |
jobs | number | 0 | 3,538 | 1.00 – 7.1M · median 2.4K | Sum of JobsReported on those loans. |
fee_per_loan | number | 0 | 4,686 | 125.00 – 41.2K · median 2.7K | fees divided by loans, in dollars. |
fee_per_job | number | 0 | 4,688 | 42.07 – 2.5K · median 437.45 | fees divided by jobs, in dollars. |
fees_PPP1 | number | 0 | 4,620 | 0.00 – 1.1B · median 452.9K | Modeled fee on loans approved before January 1, 2021 (2020 schedule). |
fees_PPP2_FD | number | 0 | 4,287 | 0.00 – 1.0B · median 207.6K | Modeled fee on 2021 first-draw loans. |
fees_PPP2_SD | number | 0 | 4,379 | 0.00 – 592.4M · median 338.5K | Modeled fee on 2021 second-draw loans. |
fees_lte50k | number | 0 | 4,679 | 0.00 – 1.1B · median 506.5K | Modeled fee on loans of $50,000 or less. |
fees_50to350k | number | 0 | 4,535 | 0.00 – 808.2M · median 369.4K | Modeled fee on loans over $50,000 up to $350,000. |
fees_350kto2M | number | 0 | 3,606 | 0.00 – 445.1M · median 124.4K | Modeled fee on loans over $350,000 and under $2 million. |
fees_2Mplus | number | 0 | 1,685 | 0.00 – 85.3M · median 0.00 | Modeled fee on loans of $2 million or more. |
loans_lte50k | integer | 0 | 1,583 | 0 – 444.5K · median 304 | Loans of $50,000 or less. |
loans_50to350k | integer | 0 | 923 | 0 – 132.2K · median 64 | Loans over $50,000 up to $350,000. |
loans_350kto2M | integer | 0 | 413 | 0 – 20.8K · median 6 | Loans over $350,000 and under $2 million. |
loans_2Mplus | integer | 0 | 141 | 0 – 2.1K · median 0 | Loans of $2 million or more. |
Type, blanks, distinct count, and range are measured on the file. The same table as CSV: dictionary.csv.
How to use it
Specific to this file, measured on it: keys, joins, encodings, units, and the values that will trip a naive count.
- Join on the name SBA prints. OriginatingLender is SBA's text, cut short where SBA cut it ("Community Banks of Colorado, A Division of"). Only Zions Bank's name is completed here.
- Round before you compare. dollars, fees and the per-loan and per-job columns are unrounded sums; round fees to the dollar to match the rankings page.
- The splits add up. The three round columns, and the four size-band columns, each sum to fees within a cent on every row; the four loan-count columns sum to loans exactly.
- One lender name, one row. A bank that merged after 2021 keeps its own row under its PPP-era name; the acquirer's row does not include it.
- LF line endings, UTF-8, 951,895 bytes.
Before you quote a row
- Modeled, not paid. SBA has not published what it paid each lender. Every figure is the published schedule applied to a published loan amount.
- Approved amount, not disbursed or forgiven. Fees clawed back or netted after payment are not in the model.
- The lender of record. Where a technology firm found and processed loans a bank originated, the fee sits with the bank; the split between them is not in any public file.
PPP processing fees by originating lender, modeled from SBA's September 30, 2024 loan file. Pandemic Darlings, https://pandemicdarlings.com/data/ppp-lender-fee-model/, SHA-256 7e4c668c7942ec6ea2274827066952e855b0299b487a56ebc104861cb120c499