Pandemic Darlings The pandemic economy, in original documents
Home Data downloads PPP lender processing fees by lender, loan size and draw, modeled

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.

Rows4689
Columns15
Files1 · 583 KB
FormatCSV
Source vintageSBA PPP FOIA 2024-09-30
Published byPandemic Darlings
Acquired / built2026-10-15
Built fromSBA PPP FOIA loan-level files
SHA-25667c269c0f3b47d025435e68888e4780e05bd4e70c533f97483dec445b76a3807
RightsDerived from U.S. government public data and published fee rules; attribution to Pandemic Darlings requested.
Dictionarydictionary.csv

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.

Rows4689
Columns15
Keyoriginating_lender · unique
Cells left blank1 of 70,335 · 0.0%
Disbursed loans11,468,206
Disbursed, billions$792.6B
Modeled fees$38.24B
2020 first draw · 2021 first draw · second draw$18.17B · $8.34B · $11.72B

What 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_lenderloansamount_usdmodeled_fees_usdfees_2020_first_draw_usdfees_2021_first_draw_usdfees_second_draw_usdloans_50k_or_lessloans_50k_to_350kloans_350k_to_2mloans_2m_and_abovefees_50k_or_less_usdfees_50k_to_350k_usdfees_350k_to_2m_usdfees_2m_and_above_usd
JPMorgan Chase Bank, National Association45289244111851716.691790545416.251093383063.30104790613.55592371739.40297868132158207772089451892046.83808236306.73445107458.9385309603.76
Bank of America, National Association49103434411968884.591491138677.80946528326.3040884066.19503726285.31361453114257139261398480005049.82654127758.32301228727.3455777142.32
Prestamos CDFI, LLC4447806849909471.861055074365.581250674.031008967983.7244855707.834444852722211053108920.921500340.97390507.8474595.85
Cross River Bank47886612894672292.931034618127.00293983258.23500222978.94240411889.8343798138571229519778299863.84209842858.0245745345.92730059.23
Harvest Small Business Finance, LLC4081738186742159.751002631927.1039041928.51641727126.97321862871.614015015392118793935166182.0735697106.8127143835.644624802.58
Capital Plus Financial, LLC3953596213416269.31937325953.930.00818266707.76119059246.173947924551048930854079.422994844.303088641.05388389.16
Benworth Capital3110224222794691.53697409428.021139891.01559253790.82137015746.20310285684530692311335.344105345.22992747.460.00
Wells Fargo Bank, National Association28071713777713764.69690066187.95420681466.5379831342.56189553378.86223058528574471331293098737.90294195250.9889469133.9813303065.09
Fountainhead SBF LLC2722274126997776.90640621923.2315524081.15438211430.84186886411.2426910228752437618181014.9017207880.654953588.58279439.10
PNC Bank, National Association11935217321532877.14606847472.04392000388.5339292025.93175555057.58703623940482921294115011206.67246859654.06192258490.6152718120.70

First 10 of 4689 rows · cells longer than 60 characters are cut with an ellipsis · shown as text, unformatted.

Files

FileRowsSizeSHA-256
ppp-modeled-lender-fees-by-loan-size.csv
CSV, UTF-8, header row
4,689597,009 B67c269c0f3b47d025435e68888e4780e05bd4e70c533f97483dec445b76a3807Download ↓
dictionary.csv
data dictionary, 15 rows
15—built with this pageDownload ↓

Columns

ColumnType, measuredBlankDistinctRange / valuesMeaning
originating_lendertext14,688JPMorgan 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.
loansinteger01,8421 – 491K · median 400Disbursed loans originated by the lender.
amount_usdnumber04,6892.5K – 44.1B · median 18.7MCurrent approved amount of those loans, in dollars.
modeled_fees_usdnumber04,688125.00 – 1.8B · median 1.1MModeled processing fees on those loans, in dollars (computed from loan amounts, not fees SBA paid).
fees_2020_first_draw_usdnumber04,6200.00 – 1.1B · median 452.9KModeled fees on first-draw loans approved in 2020, under the CARES Act schedule.
fees_2021_first_draw_usdnumber04,2860.00 – 1.0B · median 207.6KModeled fees on first-draw loans approved in 2021, under the Economic Aid Act schedule.
fees_second_draw_usdnumber04,3790.00 – 592.4M · median 338.5KModeled 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_lessinteger01,5830 – 444.5K · median 304Loans of $50,000 or less.
loans_50k_to_350kinteger09230 – 132.2K · median 64Loans over $50,000 up to $350,000.
loans_350k_to_2minteger04130 – 20.8K · median 6Loans over $350,000 and under $2 million.
loans_2m_and_aboveinteger01410 – 2.1K · median 0Loans of $2 million and above.
fees_50k_or_less_usdnumber04,6790.00 – 1.1B · median 506.5KModeled fees on loans of $50,000 or less.
fees_50k_to_350k_usdnumber04,5340.00 – 808.2M · median 369.4KModeled fees on loans over $50,000 up to $350,000.
fees_350k_to_2m_usdnumber03,6060.00 – 445.1M · median 124.4KModeled fees on loans over $350,000 and under $2 million.
fees_2m_and_above_usdnumber01,6850.00 – 85.3M · median 0.00Modeled 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 to loans on every row, and the four band fee columns and the three draw fee columns each sum to modeled_fees_usd within 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.
Cite this table. Name the source vintage; the numbers depend on it.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
Back to top