Conclusions & predictions from $349 billion PPP SBA loan program

[addtoany]

With the Protection Payroll Program (PPP) out of funding and the SBA releasing data on $342 billion of loans, a mosaic is starting to emerge of the winner and losers in the program. We were able to draw some conclusions and make some predictions we hope you find useful.

 

Conclusions

1) Banks prioritized – Not only did banks prioritize their customers over non-customers, they also put their bigger customers ahead of their smaller ones. Businesses with over 200 employees were over 3 times more likely to have their loan processed and approved than small companies with 15 or fewer employees – a whopping 79% percent of business with over 200 employees had their loans approved. Only 24% of businesses under 15 employees received a PPP loan. While businesses under 15 employees did receive 74% of the loans that were issued, there are 5.1M firms this size.  Also, businesses over 200 employees only received 2% of the loans issued, but there are only 32K of them and 20K or 79% of these firms did receive loans.

The “bigger is better” preference was really pronounced with the top 3 large SBA lenders who did 80K loans totally $34 billion between the three of them, which equates to an average loan size of $422,456. This equates to an average company size of 35 – 45 FTEs for these banks. JP Morgan Chase’s, the #1 PPP lender in dollars, average loan was $515,000.

Many small companies who did not have strong banking relationships with banks participating in the PPP program or self-employeds who couldn’t enroll prior to April 10th were left scrambling to find a lender to take their applications. The Treasury’s move to allow FinTechs (such as Paypal, Square, and Intuit) to join the PPP program will help those lightly banked if there is a second tranche of funding, but we note that even most FinTechs are starting with the their existing customers first before branching out to non-customers in desperate need of financing.

 

 

Table 1: PPP SBA loans by firm size

Firm Size in FTEsLoan Size# of PPP Loans% of Loans$$$ ApprovedFTEs coveredAvg FTE/Firm# of FirmsLoans/Firms
~ 1 to 15<$150K1,229,89374.0%$58,321,791,7616,286,70855,156,17624%
~16 to 200$150K-$350K224,06113.5%$50,926,354,6755,579,74725
~16 to 200$350K-$1M140,1978.4%$80,628,410,7968,036,32157
~16 to 200$1M-$2M41,2382.5%$57,187,983,4645,189,943126
Subtotal405,49624.4%$188,742,748,93518,806,01246822,62049%
~200+$2M-$5M21,5661.3%$64,315,474,8255,572,299258
~200+>$5M4,4120.3%$30,897,983,5822,673,298606
Subtotal25,9781.6%$95,213,458,4078,245,59731732,90279%
Grand Total1,661,367100%$342,277,999,10333,338,317206,011,69828%

 

2) Rural ruled – Rural states (e.g., Nebraska, North Dakota, and South Dakota) had a much higher percentage of its small businesses receive PPP loans than urban states (e.g., New York, California, and New Jersey). Pure speculation on our part, but this could be do to a higher concentration of community banks in rural states so throughput was much higher (and wait times lower) than urban borrowers waiting in long online portal lines.

 

Table 2: PPP SBA loans by state

StateAvg Loan# of PPP LoansApproved PPP Loan $$Firms in State% Firms w/loansEmployment
North Dakota$140,73711,002$1,548,384,03518,88558%195,312
Nebraska$127,31123,477$2,988,890,48942,12956%412,587
South Dakota$120,94811,324$1,369,616,33921,47853%209,403
Oklahoma$129,81235,557$4,615,708,45070,66350%710,271
Mississippi$119,57820,748$2,481,000,60642,67649%437,242
Iowa$146,67229,424$4,315,688,44461,23548%649,796
Kansas$163,40826,245$4,288,652,10855,68247%605,147
Hawaii$177,13611,553$2,046,450,98224,56447%275,908
Maine$129,68914,993$1,944,425,54933,05645%293,872
Arkansas$125,16021,754$2,722,726,55749,08944%490,680
Wyoming$109,8747,618$837,018,37217,33244%128,883
Montana$109,26713,456$1,470,300,13631,89942%245,758
Missouri$162,38546,481$7,547,822,023112,28341%1,163,782
Wisconsin$191,67443,395$8,317,705,842106,26041%1,267,087
Vermont$143,2236,983$1,000,127,47817,25440%157,322
Minnesota$194,34046,383$9,014,060,040116,49040%1,259,012
New Hampshire$173,27411,582$2,006,858,47729,45239%300,628
Alabama$174,15327,922$4,862,690,12071,72439%802,920
Kentucky$174,36923,797$4,149,467,68464,76837%712,477
Idaho$135,76213,627$1,850,034,02638,45235%325,294
Tennessee$192,21534,035$6,542,045,08996,04435%1,116,870
Indiana$208,15435,990$7,491,445,351106,39534%1,232,838
Louisiana$191,49726,635$5,100,534,50179,14334%905,147
Rhode Island$172,7607,732$1,335,777,80123,08133%229,212
Massachusetts$220,74146,937$10,360,907,178140,72133%1,507,965
Ohio$235,93559,800$14,108,889,927179,74333%2,180,337
Utah$173,84421,257$3,695,399,45964,47133%590,417
West Virginia$171,8897,861$1,351,223,32825,43631%269,789
Texas$211,402134,737$28,483,710,273436,54631%4,768,938
Pennsylvania$225,64869,567$15,697,648,689225,75131%2,512,633
Colorado$177,56641,635$7,392,960,359136,28931%1,140,757
Alaska$190,4024,842$921,927,50416,50229%137,271
South Carolina$166,03122,933$3,807,578,39780,38229%817,008
Illinois$228,52969,893$15,972,578,071251,66728%2,476,958
Georgia$195,82248,332$9,464,475,442176,39127%1,677,662
Delaware$210,8715,171$1,090,415,84819,04127%187,221
Virginia$216,02640,371$8,721,170,223149,78027%1,557,962
Connecticut$225,22018,435$4,151,934,45168,92327%745,085
Michigan$238,99143,438$10,381,310,070170,73325%1,892,394
New Mexico$172,0928,277$1,424,408,71132,90525%339,731
Maryland$250,79526,068$6,537,733,687107,01524%1,155,541
North Carolina$202,57539,520$8,005,752,270173,96623%1,710,890
Oregon$203,18718,732$3,806,104,47692,69220%871,241
Washington$228,77930,421$6,959,680,159152,48820%1,404,077
Florida$200,71788,997$17,863,199,837448,39720%3,494,174
DC$383,4063,253$1,247,218,72716,96619%250,345
Arizona$251,39819,280$4,846,959,062106,50118%1,065,720
New York$250,94981,075$20,345,681,101460,78918%4,110,264
New Jersey$284,25133,519$9,527,794,260191,29118%1,836,164
Nevada$232,1818,674$2,013,939,88950,32617%503,144
California$295,783112,967$33,413,693,192757,45815%7,224,945
U.S. Territories$228,3653,662$836,274,017
Grand Total$9,986,7941,661,367$342,277,999,1066,063,20427%60,556,081

 

3) Disproportionate industry participation – Some industries participated disproportionately more than others – manufacturing, retail, and construction participated heavily; wholesale trade, management companies, and finance and insurance didn’t. Some of this discrepancy can be explained by what industries were not allowed to participate (many financial firms were excluded via the CARES Act).

 

Table 3: PPP SBA loans by industry

NAICS CodeNAICS DescriptionAvg LoanApproved $$$# of LoansFirms% Firms w/loansEmployment
11Agriculture, Forestry, Fishing and Hunting$94,409$4,374,343,87746,33422,535206%136,591
21Mining, Quarrying, and Oil and Gas Extraction$348,746$3,894,793,20711,16818,72060%244,367
22Utilities$316,469$1,027,575,1373,2475,75256%111,747
31-33Manufacturing$375,906$40,922,240,021108,863244,09845%5,039,772
71Arts, Entertainment, and Recreation$124,509$4,939,280,13839,670129,28731%1,428,531
72Accommodation and Food Services$188,418$30,500,417,573161,876537,44330%8,542,661
51Information$292,470$6,675,630,27622,82578,43029%984,379
44-45Retail Trade$157,799$29,418,369,063186,429645,68529%5,526,296
62Health Care and Social Assistance$217,348$39,892,493,481183,542650,68928%8,984,159
61Educational Services$319,972$8,062,652,28825,19892,14827%1,645,962
53Real Estate and Rental and Leasing$134,656$10,743,430,22779,784308,10626%1,451,546
54Professional, Scientific, and Technical Services$207,788$43,294,713,938208,360807,93226%5,190,980
52Finance and Insurance$135,980$8,177,041,99560,134236,65725%1,909,993
23Construction$252,419$44,906,538,010177,905700,39325%5,373,702
48-49Transportation and Warehousing$238,615$10,598,076,23144,415182,68824%1,685,388
81Other Services (except Public Administration)$114,005$17,707,077,167155,319695,26822%4,697,878
42Wholesale Trade$299,478$19,489,410,47265,078294,90922%3,413,157
56Administrative & Support and Waste Management & Remediation$211,016$15,285,814,28672,439343,79121%3,754,463
55Management of Companies and Enterprises$364,605$1,170,748,1303,21119,13417%423,295
Public Administration$1,197,353,5865,570
GRAND TOTAL$206,022$342,277,999,1031,661,3676,013,66528%60,544,867

Predictions

4) Loans will stay – Many businesses will not see their entire SBA loan forgiven without Congressional tweaks to the program. Some may owe between 10% to 30% or more of the loan amount after the 8-week period due to:

1) Lack of demand – Many businesses will not see robust demand for their products or services while coronavirus rages and will be reluctant to rehire laid off workers in the weeks and possible months ahead dampening the achievement level of the program in the first place – rehiring workers.

2) Lack of supply – Many businesses will have difficulty rehiring due to robust federal and state unemployment compensation that in many cases is more than their pre-coronavirus wages. In some states workers will earn roughly $1,000 a week from unemployment.

3) The math – The calculation of the maximum SBA loan amount is based on 2.5x months of payroll costs (~76 days), whereas the loan forgiveness calculation (forgiveness calculator here) is based on eight weeks (56 days). So the debt forgiveness period is 74% shorter than the maximum debt calculation period. We will look to see if Congress addresses this math problem in the legislation that extends the program by the $250 billion being proposed by Treasury.

Businesses that are most negatively impacted are those with very low rents and utilities (e.g., a home-based business or a rural business) since they don’t have non-payroll costs that can offset the 74% shorter period. There are politicians in Washington that are aware of this “math problem” so Congress may take action to alleviate this pain point by allowing more than 8 weeks of costs to be included in the debt reduction but as of this writing that relief has not been enacted.

 

5)  Applications are backed up – Plenty of loan applications backed up in the queue at the various banks. Bank of America, one of the largest banks in America and the first of the four big banks to accept PPP applications aggressively, tweeted on April 4th (the second day of the PPP program) that it had received over 145K loan applications totally $30B. Fast forward to April 16th and the #2 lender per the SBA only did 32K loans totaling $10B. We assume this #2 lenders was BofA.  This translates to less than 1/3 of the applicant dollars BofA received the first 2 days of the program actually turned into SBA loans with E-tran numbers. Note that JP Morgan was #1 lender in terms of loan volume with 27K loans totally $14B.

 

6) $277 billion more needed – The Senate passed another $310 billion for the PPP program. The National Federation of Independent Businesses (NFIB) believes an additional $400 billion is needed to cover all small businesses in America wanting a loan. We believe the maximum potential needed is closer to $277 billion (before SBA processing fees paid to banks). Obviously 100% of businesses will not participate in the PPP program due to a variety of reasons such as ineligibility, out of business already, or opted for an EIDL loan.

Table 4: PPP Maximum dollars needed for PPP SBA loans phase 4

Firm Size in FTEsLoan Size# of PPP Loans$$$ ApprovedFTEs coveredFTEs uncovered$$$ Needed
~ 1 to 15<$150K1,229,893$58,321,791,7616,286,70811,142,076$103,365,037,407
~16 to 200$150K-$350K224,061$50,926,354,6755,579,7475,640,473$51,480,593,265
~16 to 200$350K-$1M140,197$80,628,410,7968,036,3215,759,225$57,782,302,222
~16 to 200$1M-$2M41,238$57,187,983,4645,189,9432,987,364$32,917,762,369
Subtotal405,496$188,742,748,93518,806,01214,387,061$142,180,657,856
~200+$2M-$5M21,566$64,315,474,8255,572,299
~200+>$5M4,412$30,897,983,5822,673,298
Subtotal25,978$95,213,458,4078,245,5971,688,627$19,503,636,789
Subtotal1,661,367$342,277,999,10333,338,31727,217,764$265,049,332,052
NAICS Code 722,218,220$11,727,010,969
Total $$$Needed33,338,31729,435,984$276,776,343,021

 

7) $60 billion is symbolic – Congress set aside $60 billion to be allocated “small, rural, and community banks,” which is defined per the legislation as banks with less than $50 billion in assets. Congress recognized that the large banks with their large customers bases and technology prowess could overwhelm the smaller banks in the footrace for the PPP SBA loan funds since the program is still a first come, first serve affair. The $60 billion is largely symbolic as we must realize there are over 4,000 lenders participating in the PPP program — all but the top 38 financial institutions – are considered small. Put another way, Congress is stating that the top 38 banks can’t do more than 80% of the loans, and the remaining 4,000+ lenders can do 20% or more.

This symbolic move does not address the core problem with the musical chairs aspect of the PPP program – non-customers of banks have little to no avenues to obtain a loan. What is really needed is a protected allocation of funds to financial institutions who will lend PPP money to non-customers.

 

We may be able to answer any questions you have regarding our methodology if you contact us.

 

Sources/Footnotes

 

SBA’s 4/13/20 Paycheck Protection Program Report (“PPP Report”)

U.S. Census Bureau’s 2017 Data by Enterprise Employment Size Report (“Employment Size Report”)

Table 1: Firm Size, Loan Size, # of Loans, $$$ Approved  are sourced from PPP Report. FTEs Covered is $$$ Approved / Average Payroll Cost (“APC”) per FTEs. We used an blended APC of $10,300 and adjusted per FTE per employer size based on Employment Size Report data (e.g., FTEs at companies with >400 employees make ~25% more than FTEs at companies with <15 FTEs). Data from tweets on April 10th from Edward Lawrence and Senator Marco Rubio indicate average per FTE of $9,800 and $10,300, respectively.  Avg FTE/Firm and # of Firms are from Census Bureau’s Employment Size Report. % Approved is # of Loans / # of Firms.

Table 2: State, Approved PPP Loan $$, and # of PPP Loans are sourced from PPP Report; Avg Loan is Approved PPP Loan $$ / # of PPP Loans. Firms in State and Employment are from Employment Size Report. % Firms w/loans is # of PPP Loans  / Firms in State.

Table 3: NAICS, NAICS Description, Approved $$$, and # of Loans are from PPP Report. Avg Loan is Approved $$$ / # of Loans. Firms, Firms w/loans, and Employment are from Employment Size Report. The anomaly with over 100%  of Agriculture, Forestry, Fishing and Hunting firms applying for loans likely caused by NAICS classification code differences between the PPP Report and Employment Size Report.