
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 FTEs | Loan Size | # of PPP Loans | % of Loans | $$$ Approved | FTEs covered | Avg FTE/Firm | # of Firms | Loans/Firms |
---|---|---|---|---|---|---|---|---|
~ 1 to 15 | <$150K | 1,229,893 | 74.0% | $58,321,791,761 | 6,286,708 | 5 | 5,156,176 | 24% |
~16 to 200 | $150K-$350K | 224,061 | 13.5% | $50,926,354,675 | 5,579,747 | 25 | ||
~16 to 200 | $350K-$1M | 140,197 | 8.4% | $80,628,410,796 | 8,036,321 | 57 | ||
~16 to 200 | $1M-$2M | 41,238 | 2.5% | $57,187,983,464 | 5,189,943 | 126 | ||
Subtotal | 405,496 | 24.4% | $188,742,748,935 | 18,806,012 | 46 | 822,620 | 49% | |
~200+ | $2M-$5M | 21,566 | 1.3% | $64,315,474,825 | 5,572,299 | 258 | ||
~200+ | >$5M | 4,412 | 0.3% | $30,897,983,582 | 2,673,298 | 606 | ||
Subtotal | 25,978 | 1.6% | $95,213,458,407 | 8,245,597 | 317 | 32,902 | 79% | |
Grand Total | 1,661,367 | 100% | $342,277,999,103 | 33,338,317 | 20 | 6,011,698 | 28% |
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
State | Avg Loan | # of PPP Loans | Approved PPP Loan $$ | Firms in State | % Firms w/loans | Employment |
---|---|---|---|---|---|---|
North Dakota | $140,737 | 11,002 | $1,548,384,035 | 18,885 | 58% | 195,312 |
Nebraska | $127,311 | 23,477 | $2,988,890,489 | 42,129 | 56% | 412,587 |
South Dakota | $120,948 | 11,324 | $1,369,616,339 | 21,478 | 53% | 209,403 |
Oklahoma | $129,812 | 35,557 | $4,615,708,450 | 70,663 | 50% | 710,271 |
Mississippi | $119,578 | 20,748 | $2,481,000,606 | 42,676 | 49% | 437,242 |
Iowa | $146,672 | 29,424 | $4,315,688,444 | 61,235 | 48% | 649,796 |
Kansas | $163,408 | 26,245 | $4,288,652,108 | 55,682 | 47% | 605,147 |
Hawaii | $177,136 | 11,553 | $2,046,450,982 | 24,564 | 47% | 275,908 |
Maine | $129,689 | 14,993 | $1,944,425,549 | 33,056 | 45% | 293,872 |
Arkansas | $125,160 | 21,754 | $2,722,726,557 | 49,089 | 44% | 490,680 |
Wyoming | $109,874 | 7,618 | $837,018,372 | 17,332 | 44% | 128,883 |
Montana | $109,267 | 13,456 | $1,470,300,136 | 31,899 | 42% | 245,758 |
Missouri | $162,385 | 46,481 | $7,547,822,023 | 112,283 | 41% | 1,163,782 |
Wisconsin | $191,674 | 43,395 | $8,317,705,842 | 106,260 | 41% | 1,267,087 |
Vermont | $143,223 | 6,983 | $1,000,127,478 | 17,254 | 40% | 157,322 |
Minnesota | $194,340 | 46,383 | $9,014,060,040 | 116,490 | 40% | 1,259,012 |
New Hampshire | $173,274 | 11,582 | $2,006,858,477 | 29,452 | 39% | 300,628 |
Alabama | $174,153 | 27,922 | $4,862,690,120 | 71,724 | 39% | 802,920 |
Kentucky | $174,369 | 23,797 | $4,149,467,684 | 64,768 | 37% | 712,477 |
Idaho | $135,762 | 13,627 | $1,850,034,026 | 38,452 | 35% | 325,294 |
Tennessee | $192,215 | 34,035 | $6,542,045,089 | 96,044 | 35% | 1,116,870 |
Indiana | $208,154 | 35,990 | $7,491,445,351 | 106,395 | 34% | 1,232,838 |
Louisiana | $191,497 | 26,635 | $5,100,534,501 | 79,143 | 34% | 905,147 |
Rhode Island | $172,760 | 7,732 | $1,335,777,801 | 23,081 | 33% | 229,212 |
Massachusetts | $220,741 | 46,937 | $10,360,907,178 | 140,721 | 33% | 1,507,965 |
Ohio | $235,935 | 59,800 | $14,108,889,927 | 179,743 | 33% | 2,180,337 |
Utah | $173,844 | 21,257 | $3,695,399,459 | 64,471 | 33% | 590,417 |
West Virginia | $171,889 | 7,861 | $1,351,223,328 | 25,436 | 31% | 269,789 |
Texas | $211,402 | 134,737 | $28,483,710,273 | 436,546 | 31% | 4,768,938 |
Pennsylvania | $225,648 | 69,567 | $15,697,648,689 | 225,751 | 31% | 2,512,633 |
Colorado | $177,566 | 41,635 | $7,392,960,359 | 136,289 | 31% | 1,140,757 |
Alaska | $190,402 | 4,842 | $921,927,504 | 16,502 | 29% | 137,271 |
South Carolina | $166,031 | 22,933 | $3,807,578,397 | 80,382 | 29% | 817,008 |
Illinois | $228,529 | 69,893 | $15,972,578,071 | 251,667 | 28% | 2,476,958 |
Georgia | $195,822 | 48,332 | $9,464,475,442 | 176,391 | 27% | 1,677,662 |
Delaware | $210,871 | 5,171 | $1,090,415,848 | 19,041 | 27% | 187,221 |
Virginia | $216,026 | 40,371 | $8,721,170,223 | 149,780 | 27% | 1,557,962 |
Connecticut | $225,220 | 18,435 | $4,151,934,451 | 68,923 | 27% | 745,085 |
Michigan | $238,991 | 43,438 | $10,381,310,070 | 170,733 | 25% | 1,892,394 |
New Mexico | $172,092 | 8,277 | $1,424,408,711 | 32,905 | 25% | 339,731 |
Maryland | $250,795 | 26,068 | $6,537,733,687 | 107,015 | 24% | 1,155,541 |
North Carolina | $202,575 | 39,520 | $8,005,752,270 | 173,966 | 23% | 1,710,890 |
Oregon | $203,187 | 18,732 | $3,806,104,476 | 92,692 | 20% | 871,241 |
Washington | $228,779 | 30,421 | $6,959,680,159 | 152,488 | 20% | 1,404,077 |
Florida | $200,717 | 88,997 | $17,863,199,837 | 448,397 | 20% | 3,494,174 |
DC | $383,406 | 3,253 | $1,247,218,727 | 16,966 | 19% | 250,345 |
Arizona | $251,398 | 19,280 | $4,846,959,062 | 106,501 | 18% | 1,065,720 |
New York | $250,949 | 81,075 | $20,345,681,101 | 460,789 | 18% | 4,110,264 |
New Jersey | $284,251 | 33,519 | $9,527,794,260 | 191,291 | 18% | 1,836,164 |
Nevada | $232,181 | 8,674 | $2,013,939,889 | 50,326 | 17% | 503,144 |
California | $295,783 | 112,967 | $33,413,693,192 | 757,458 | 15% | 7,224,945 |
U.S. Territories | $228,365 | 3,662 | $836,274,017 | |||
Grand Total | $9,986,794 | 1,661,367 | $342,277,999,106 | 6,063,204 | 27% | 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 Code | NAICS Description | Avg Loan | Approved $$$ | # of Loans | Firms | % Firms w/loans | Employment |
---|---|---|---|---|---|---|---|
11 | Agriculture, Forestry, Fishing and Hunting | $94,409 | $4,374,343,877 | 46,334 | 22,535 | 206% | 136,591 |
21 | Mining, Quarrying, and Oil and Gas Extraction | $348,746 | $3,894,793,207 | 11,168 | 18,720 | 60% | 244,367 |
22 | Utilities | $316,469 | $1,027,575,137 | 3,247 | 5,752 | 56% | 111,747 |
31-33 | Manufacturing | $375,906 | $40,922,240,021 | 108,863 | 244,098 | 45% | 5,039,772 |
71 | Arts, Entertainment, and Recreation | $124,509 | $4,939,280,138 | 39,670 | 129,287 | 31% | 1,428,531 |
72 | Accommodation and Food Services | $188,418 | $30,500,417,573 | 161,876 | 537,443 | 30% | 8,542,661 |
51 | Information | $292,470 | $6,675,630,276 | 22,825 | 78,430 | 29% | 984,379 |
44-45 | Retail Trade | $157,799 | $29,418,369,063 | 186,429 | 645,685 | 29% | 5,526,296 |
62 | Health Care and Social Assistance | $217,348 | $39,892,493,481 | 183,542 | 650,689 | 28% | 8,984,159 |
61 | Educational Services | $319,972 | $8,062,652,288 | 25,198 | 92,148 | 27% | 1,645,962 |
53 | Real Estate and Rental and Leasing | $134,656 | $10,743,430,227 | 79,784 | 308,106 | 26% | 1,451,546 |
54 | Professional, Scientific, and Technical Services | $207,788 | $43,294,713,938 | 208,360 | 807,932 | 26% | 5,190,980 |
52 | Finance and Insurance | $135,980 | $8,177,041,995 | 60,134 | 236,657 | 25% | 1,909,993 |
23 | Construction | $252,419 | $44,906,538,010 | 177,905 | 700,393 | 25% | 5,373,702 |
48-49 | Transportation and Warehousing | $238,615 | $10,598,076,231 | 44,415 | 182,688 | 24% | 1,685,388 |
81 | Other Services (except Public Administration) | $114,005 | $17,707,077,167 | 155,319 | 695,268 | 22% | 4,697,878 |
42 | Wholesale Trade | $299,478 | $19,489,410,472 | 65,078 | 294,909 | 22% | 3,413,157 |
56 | Administrative & Support and Waste Management & Remediation | $211,016 | $15,285,814,286 | 72,439 | 343,791 | 21% | 3,754,463 |
55 | Management of Companies and Enterprises | $364,605 | $1,170,748,130 | 3,211 | 19,134 | 17% | 423,295 |
Public Administration | $1,197,353,586 | 5,570 | |||||
GRAND TOTAL | $206,022 | $342,277,999,103 | 1,661,367 | 6,013,665 | 28% | 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 FTEs | Loan Size | # of PPP Loans | $$$ Approved | FTEs covered | FTEs uncovered | $$$ Needed |
---|---|---|---|---|---|---|
~ 1 to 15 | <$150K | 1,229,893 | $58,321,791,761 | 6,286,708 | 11,142,076 | $103,365,037,407 |
~16 to 200 | $150K-$350K | 224,061 | $50,926,354,675 | 5,579,747 | 5,640,473 | $51,480,593,265 |
~16 to 200 | $350K-$1M | 140,197 | $80,628,410,796 | 8,036,321 | 5,759,225 | $57,782,302,222 |
~16 to 200 | $1M-$2M | 41,238 | $57,187,983,464 | 5,189,943 | 2,987,364 | $32,917,762,369 |
Subtotal | 405,496 | $188,742,748,935 | 18,806,012 | 14,387,061 | $142,180,657,856 | |
~200+ | $2M-$5M | 21,566 | $64,315,474,825 | 5,572,299 | ||
~200+ | >$5M | 4,412 | $30,897,983,582 | 2,673,298 | ||
Subtotal | 25,978 | $95,213,458,407 | 8,245,597 | 1,688,627 | $19,503,636,789 | |
Subtotal | 1,661,367 | $342,277,999,103 | 33,338,317 | 27,217,764 | $265,049,332,052 | |
NAICS Code 72 | 2,218,220 | $11,727,010,969 | ||||
Total $$$ | Needed | 33,338,317 | 29,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.