Derived table · Paycheck Protection Program
PPP lender processing fees by lender, loan size and draw, modeled
One row for each of the 4,689 lenders that originated a disbursed PPP loan, with the SBA processing fee each loan would earn under its fee schedule, summed by loan-size band and by draw. Fees sum to $38.24 billion, the same total as the program-wide fee-schedule table. These are modeled amounts computed from loan sizes, not a ledger of fees the SBA paid.
Download CSV 583 KBData dictionary CSVAt a glancePreviewColumnsHow to useBefore you quote a row
At a glance
Measured on the file on 2026-10-15; the checksum above is the file these numbers describe.
originating_lender · uniqueWhat it is
SBA paid each PPP lender a processing fee set by the size of the loan. The 2020 CARES Act schedule paid 5% on loans up to $350,000, 3% above that and below $2 million, and 1% at $2 million and above. The 2021 Economic Aid Act schedule paid the lesser of $2,500 or 50% on loans of $50,000 or less, then the same 5% and 3%.
The band columns show where each lender's fees came from. Readycap Lending, LLC is modeled at $307.5 million on 106,252 loans, and $169.1 million of it, 55.0%, came from the 86,880 loans of $50,000 or less. JPMorgan Chase Bank, the largest row at $1.79 billion, took 25.2% of its fees from that band. Newtek Small Business Finance, Inc. sits between them: $35.6 million of $87.8 million, 40.6%.
How it was built
Every loan in SBA's FOIA release of September 30, 2024 with a positive current approved amount, and an undisbursed amount below it, is priced on that current approved amount. Loans SBA processed as second draws (processing method PPS) take the second-draw schedule; other loans approved before January 1, 2021 take the 2020 schedule, and the rest the 2021 first-draw schedule. Fees are then summed by the originating lender named on the loan. SBA's file dates the approval of 17 of the second-draw loans, $2,408,796 in all, between April and July 2020. This table prices them on the second-draw schedule, at $97,840.95 in fees, while the program-wide fee-schedule table prices them on the 2020 schedule, at $80,574.70. Both totals round to $38.24 billion; they differ by $17,266.25.
The bands are $50,000 or less; over $50,000 to $350,000; over $350,000 and under $2 million; and $2 million and above. Second-draw loans were capped at $2 million and their schedule has no 1% tier, so a $2 million second-draw loan sits in the top band at 3%.
Preview
| originating_lender | loans | amount_usd | modeled_fees_usd | fees_2020_first_draw_usd | fees_2021_first_draw_usd | fees_second_draw_usd | loans_50k_or_less | loans_50k_to_350k | loans_350k_to_2m | loans_2m_and_above | fees_50k_or_less_usd | fees_50k_to_350k_usd | fees_350k_to_2m_usd | fees_2m_and_above_usd |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| JPMorgan Chase Bank, National Association | 452892 | 44111851716.69 | 1790545416.25 | 1093383063.30 | 104790613.55 | 592371739.40 | 297868 | 132158 | 20777 | 2089 | 451892046.83 | 808236306.73 | 445107458.93 | 85309603.76 |
| Bank of America, National Association | 491034 | 34411968884.59 | 1491138677.80 | 946528326.30 | 40884066.19 | 503726285.31 | 361453 | 114257 | 13926 | 1398 | 480005049.82 | 654127758.32 | 301228727.34 | 55777142.32 |
| Prestamos CDFI, LLC | 444780 | 6849909471.86 | 1055074365.58 | 1250674.03 | 1008967983.72 | 44855707.83 | 444485 | 272 | 22 | 1 | 1053108920.92 | 1500340.97 | 390507.84 | 74595.85 |
| Cross River Bank | 478866 | 12894672292.93 | 1034618127.00 | 293983258.23 | 500222978.94 | 240411889.83 | 437981 | 38571 | 2295 | 19 | 778299863.84 | 209842858.02 | 45745345.92 | 730059.23 |
| Harvest Small Business Finance, LLC | 408173 | 8186742159.75 | 1002631927.10 | 39041928.51 | 641727126.97 | 321862871.61 | 401501 | 5392 | 1187 | 93 | 935166182.07 | 35697106.81 | 27143835.64 | 4624802.58 |
| Capital Plus Financial, LLC | 395359 | 6213416269.31 | 937325953.93 | 0.00 | 818266707.76 | 119059246.17 | 394792 | 455 | 104 | 8 | 930854079.42 | 2994844.30 | 3088641.05 | 388389.16 |
| Benworth Capital | 311022 | 4222794691.53 | 697409428.02 | 1139891.01 | 559253790.82 | 137015746.20 | 310285 | 684 | 53 | 0 | 692311335.34 | 4105345.22 | 992747.46 | 0.00 |
| Wells Fargo Bank, National Association | 280717 | 13777713764.69 | 690066187.95 | 420681466.53 | 79831342.56 | 189553378.86 | 223058 | 52857 | 4471 | 331 | 293098737.90 | 294195250.98 | 89469133.98 | 13303065.09 |
| Fountainhead SBF LLC | 272227 | 4126997776.90 | 640621923.23 | 15524081.15 | 438211430.84 | 186886411.24 | 269102 | 2875 | 243 | 7 | 618181014.90 | 17207880.65 | 4953588.58 | 279439.10 |
| PNC Bank, National Association | 119352 | 17321532877.14 | 606847472.04 | 392000388.53 | 39292025.93 | 175555057.58 | 70362 | 39404 | 8292 | 1294 | 115011206.67 | 246859654.06 | 192258490.61 | 52718120.70 |
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-modeled-lender-fees-by-loan-size.csvCSV, UTF-8, header row | 4,689 | 597,009 B | 67c269c0f3b47d025435e68888e4780e05bd4e70c533f97483dec445b76a3807 | Download ↓ |
dictionary.csvdata dictionary, 15 rows | 15 | — | built with this page | Download ↓ |
Columns
| Column | Type, measured | Blank | Distinct | Range / values | Meaning |
|---|---|---|---|---|---|
originating_lender | text | 1 | 4,688 | JPMorgan Chase Bank, National Associatio (1), Bank of America, National Association (1), Prestamos CDFI, LLC (1) | Originating lender as named in the SBA file. One row has a blank name. |
loans | integer | 0 | 1,842 | 1 – 491K · median 400 | Disbursed loans originated by the lender. |
amount_usd | number | 0 | 4,689 | 2.5K – 44.1B · median 18.7M | Current approved amount of those loans, in dollars. |
modeled_fees_usd | number | 0 | 4,688 | 125.00 – 1.8B · median 1.1M | Modeled processing fees on those loans, in dollars (computed from loan amounts, not fees SBA paid). |
fees_2020_first_draw_usd | number | 0 | 4,620 | 0.00 – 1.1B · median 452.9K | Modeled fees on first-draw loans approved in 2020, under the CARES Act schedule. |
fees_2021_first_draw_usd | number | 0 | 4,286 | 0.00 – 1.0B · median 207.6K | Modeled fees on first-draw loans approved in 2021, under the Economic Aid Act schedule. |
fees_second_draw_usd | number | 0 | 4,379 | 0.00 – 592.4M · median 338.5K | Modeled fees on second-draw loans (SBA processing method PPS), under the second-draw schedule; includes 17 loans the SBA file dates to 2020. |
loans_50k_or_less | integer | 0 | 1,583 | 0 – 444.5K · median 304 | Loans of $50,000 or less. |
loans_50k_to_350k | integer | 0 | 923 | 0 – 132.2K · median 64 | Loans over $50,000 up to $350,000. |
loans_350k_to_2m | integer | 0 | 413 | 0 – 20.8K · median 6 | Loans over $350,000 and under $2 million. |
loans_2m_and_above | integer | 0 | 141 | 0 – 2.1K · median 0 | Loans of $2 million and above. |
fees_50k_or_less_usd | number | 0 | 4,679 | 0.00 – 1.1B · median 506.5K | Modeled fees on loans of $50,000 or less. |
fees_50k_to_350k_usd | number | 0 | 4,534 | 0.00 – 808.2M · median 369.4K | Modeled fees on loans over $50,000 up to $350,000. |
fees_350k_to_2m_usd | number | 0 | 3,606 | 0.00 – 445.1M · median 124.4K | Modeled fees on loans over $350,000 and under $2 million. |
fees_2m_and_above_usd | number | 0 | 1,685 | 0.00 – 85.3M · median 0.00 | Modeled fees on loans of $2 million and above. |
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.
- Rows are sorted by
modeled_fees_usd, largest first. The key is the lender name as the SBA file spells it; one row (28 loans) has no name at all. - The splits add up. The four
loans_*columns sum toloanson every row, and the four band fee columns and the three draw fee columns each sum tomodeled_fees_usdwithin five cents. - Money columns are dollars with two decimals. Divide by 1e6 for millions; round before quoting.
- LF line endings, UTF-8, 597,009 bytes; lender names that contain commas are quoted.
Before you quote a row
- Modeled, not observed. Fees on loans later canceled or found ineligible are not netted out.
- Originating lender only. Fees are credited to the lender that originated the loan. Agents and service providers paid out of those fees do not appear, and a loan sold or serviced elsewhere stays with its originator.
- Population. 11,468,206 disbursed loans are the 11,468,210 rows of the September 30, 2024 release less 4 rows the disbursement filter removes, the same population as the fee-schedule table.
PPP lender processing fees by lender, loan size and draw, modeled on SBA PPP FOIA loan-level data (2024-09-30 vintage). Pandemic Darlings, https://pandemicdarlings.com/data/ppp-modeled-lender-fees-by-loan-size/, SHA-256 67c269c0f3b47d025435e68888e4780e05bd4e70c533f97483dec445b76a3807