Derived table · Federal Reserve facilities
Peak PPPLF funding against bank equity, 30 largest borrowers
First Bank of the Lake had $868.71 million of PPPLF money outstanding on March 31, 2021 against $25.78 million of total equity capital on its call report for the same date: 33.70 times its equity. Cross River Bank had $10.01 billion against $440.88 million on March 31, 2021: 22.71 times. Citibank, with a $3.08 billion peak and $153.36 billion of equity, stood at 0.02 times. Thirty rows, the 30 largest PPPLF borrowers by peak balance; 19 file call reports and get a ratio.
Download CSV 3 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.
institution_rssd · uniqueWhat it is
One row for each of the 30 PPPLF borrowers with the largest peak balance. Each row holds the peak and its report date, the call-report quarter-end on or before that date, the bank's total equity capital on that call report, and peak divided by equity. The 11 rows without a call report are the nonbank lenders, Harvest Small Business Finance's $11.52 billion peak among them; they have no equity figure here and no ratio.
The ratio passes 10 for 6 banks: First Bank of the Lake 33.70, Cross River 22.71, Quontic 17.10, WebBank 12.33, First Home 11.14 and Celtic 10.90. Quontic Bank's $51.16 million of equity on September 30, 2020 stood behind an $874.69 million peak the next month. The large banks on the list sit below one: Customers 4.19, MidFirst 0.47, Citibank 0.02.
Equity is the whole bank's, not the PPP desk's, and it is the figure on one quarter's report. Northeast Bank's peak fell on February 28, 2021, so its equity is from the December 31, 2020 call report, the last quarter-end before it; the ratio is 8.56.
How it was built
Peak balance and date come from the combined PPPLF table, one row per RSSD, the 30 largest peaks taken. For each, the quarter-end on or before the peak date was looked up in the FFIEC bulk call-report file for that quarter, Schedule RC, by IDRSSD. Total bank equity capital is item RCFD3210 for banks filing the FFIEC 031 and RCON3210 for the 041, reported in thousands and printed here in dollars. A borrower with no Schedule RC row in that file has no call report and is left blank.
Ratio = peak balance divided by equity, two decimals. Rows are sorted by peak balance, largest first.
Preview
| institution_rssd | institution_name | ppplf_peak_outstanding_usd | ppplf_peak_date | call_report_quarter | total_equity_capital_usd | peak_ppplf_over_equity | ppplf_n_advances | ppplf_gross_advances_usd |
|---|---|---|---|---|---|---|---|---|
| 5500251 | PPPLF HARVEST SMALL BUS FNC | 11518536906.04 | 2021-06-30 | 120 | 12727880180.55 | |||
| 3783313 | CROSS RIVER BK | 10011245136.22 | 2021-04-30 | 2021-03-31 | 440875000 | 22.71 | 309 | 18805308340.69 |
| 5511408 | PPPLF THE LOAN SOURCE | 9161408154.17 | 2021-06-30 | 1063 | 36179541720.92 | |||
| 5503636 | PPPLF PRESTAMOS CDFI | 7162941713.30 | 2021-07-31 | 127 | 7170529098.55 | |||
| 5511314 | PPPLF CAPITAL PLUS | 6397994161.64 | 2021-07-31 | 205 | 6459179299.43 | |||
| 2354985 | CUSTOMERS BK | 4811009450.02 | 2020-09-30 | 2020-09-30 | 1149007000 | 4.19 | 204 | 7368139542.66 |
| 5502433 | PPPLF ITRIA VENTS LLC | 4770125283.35 | 2021-05-31 | 208 | 4905099619.79 | |||
| 5499672 | PPPLF FOUNTAINHEAD SBF LLC | 4685738180.74 | 2021-05-31 | 362 | 5486440402.63 | |||
| 5501164 | PPPLF BENWORTH CAP PTNRS LLC | 4197908018.65 | 2021-07-31 | 150 | 4304482271.81 | |||
| 2998576 | CELTIC BK CORP | 3284050754.79 | 2021-03-31 | 2021-03-31 | 301270000 | 10.90 | 147 | 3652475078.10 |
| 476810 | CITIBANK NA | 3078422216.09 | 2020-06-30 | 2020-06-30 | 153360000000 | 0.02 | 52 | 3158816625.79 |
| 2576134 | WEBBANK | 2747159896.48 | 2021-04-30 | 2021-03-31 | 222889000 | 12.33 | 256 | 3650686437.50 |
| 5509834 | PPPLF READYCAP LEND LLC | 2286623735.40 | 2021-06-30 | 181 | 2384538667.61 | |||
| 339858 | BOKF NA | 2013413695.80 | 2020-09-30 | 2020-09-30 | 5026240000 | 0.40 | 95 | 2410730643.35 |
| 3650808 | LIVE OAK BKG CO | 1742084718.00 | 2020-09-30 | 2020-09-30 | 529126000 | 3.29 | 189 | 2328255880.84 |
| 468806 | NORTHEAST BK | 1557010839.00 | 2021-02-28 | 2020-12-31 | 181962000 | 8.56 | 54 | 2393419307.96 |
| 5505014 | PPPLF KABBAGE | 1519227119.00 | 2020-08-31 | 136 | 1622821666.00 | |||
| 197478 | EAST WEST BK | 1428416734.72 | 2020-06-30 | 2020-06-30 | 4685071000 | 0.30 | 11 | 1437269412.72 |
| 804963 | BANK OF THE WEST | 1347754173.61 | 2020-06-30 | 2020-06-30 | 13783738000 | 0.10 | 16 | 1396034365.00 |
| 595270 | MIDFIRST BK | 1175958535.21 | 2021-04-30 | 2021-03-31 | 2500192000 | 0.47 | 11 | 1568603161.88 |
| 2797724 | TOWNEBANK | 1118299086.87 | 2020-07-31 | 2020-06-30 | 1707595000 | 0.65 | 78 | 1561604732.87 |
| 917742 | ASSOCIATED BK NA | 1022257380.11 | 2020-08-31 | 2020-06-30 | 4053943000 | 0.25 | 110 | 1103194480.00 |
| 2771694 | FIRST HOME BK | 957413181.34 | 2021-03-31 | 2021-03-31 | 85978000 | 11.14 | 212 | 1873954982.96 |
| 165628 | FIRST FNCL BK | 882986270.34 | 2020-07-31 | 2020-06-30 | 2232874000 | 0.40 | 24 | 890974805.89 |
| 3340725 | QUONTIC BK | 874688799.69 | 2020-10-31 | 2020-09-30 | 51158000 | 17.10 | 106 | 890260240.48 |
| 758851 | FIRST BK OF THE LAKE | 868714079.61 | 2021-03-31 | 2021-03-31 | 25781000 | 33.70 | 165 | 1091058422.88 |
| 5510755 | PPPLF SQ CAP LLC | 860128950.82 | 2021-04-30 | 136 | 1160890672.69 | |||
| 995076 | CACHE VALLEY BK | 855297210.77 | 2020-06-30 | 2020-06-30 | 171103000 | 5.00 | 178 | 1329790755.86 |
| 506922 | SANDY SPRING BK | 845026053.36 | 2020-06-30 | 2020-06-30 | 1528812000 | 0.55 | 14 | 921289057.42 |
| 5506123 | PPPLF AMUR FNC EQUIP | 836004173.63 | 2021-07-31 | 202 | 927930166.06 |
First 30 of 30 rows · cells longer than 60 characters are cut with an ellipsis · shown as text, unformatted.
Files
| File | Rows | Size | SHA-256 | |
|---|---|---|---|---|
ppplf-bank-leverage.csvCSV, UTF-8, header row | 30 | 2,739 B | 68813d43511845fd7d4dbeff2239070eb69f5c47dc89cf2dd257f75f6be7fe20 | Download ↓ |
dictionary.csvdata dictionary, 9 rows | 9 | — | built with this page | Download ↓ |
Columns
| Column | Type, measured | Blank | Distinct | Range / values | Meaning |
|---|---|---|---|---|---|
institution_rssd | integer | 0 | 30 | 165.6K – 5.5M · median 2.9M | Federal Reserve RSSD identifier of the PPPLF borrower; IDRSSD in the call-report file. |
institution_name | text | 0 | 30 | PPPLF HARVEST SMALL BUS FNC (1), CROSS RIVER BK (1), PPPLF THE LOAN SOURCE (1) | Name as the Fed's disclosures print it. |
ppplf_peak_outstanding_usd | number | 0 | 30 | 836.0M – 11.5B · median 1.6B | Largest PPPLF balance on any one report date, dollars. |
ppplf_peak_date | text | 0 | 11 | 2020-06-30 (5), 2021-04-30 (4), 2021-07-31 (4) | Report date of that peak. |
call_report_quarter | text | 11 | 4 | 2020-06-30 (8), 2021-03-31 (6), 2020-09-30 (4) | Quarter-end on or before the peak date whose call report supplied the equity; blank for nonbanks. |
total_equity_capital_usd | integer | 11 | 19 | 25.8M – 153.4B · median 1.1B | Total bank equity capital on that call report (RCFD3210 or RCON3210), dollars; blank for nonbanks. |
peak_ppplf_over_equity | number | 11 | 18 | 0.02 – 33.70 · median 3.29 | ppplf_peak_outstanding_usd divided by total_equity_capital_usd, two decimals; blank for nonbanks. |
ppplf_n_advances | integer | 0 | 28 | 11 – 1.1K · median 141 | Distinct PPPLF advances across the 70 disclosures. |
ppplf_gross_advances_usd | number | 0 | 30 | 890.3M – 36.2B · median 2.4B | Original amounts of those advances added up, dollars. |
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.
- Blank is nonbank, not zero. The 11 rows without equity are lenders that file no call report; sort them out before averaging the ratio.
- A comparison, not a capital measure. Peak Fed funding over total equity says how large the facility was beside the bank. Regulatory capital ratios are a different measure, and the PPP loans pledged carried an SBA guarantee.
- Sorted by peak balance, largest first. Sort on
peak_ppplf_over_equityfor the leverage view. - LF line endings, UTF-8, 2,739 bytes.
Before you quote a row
- One quarter's equity. A bank that raised capital after its peak quarter shows the smaller, earlier figure; a bank whose peak fell mid-quarter is measured against the quarter-end before it.
- Thirty by peak. The cut is the 30 largest peak balances; a bank with a smaller peak and a higher ratio is not on the list.
- Nonbank lenders. Harvest, The Loan Source, Prestamos, Capital Plus, Itria, Fountainhead, Benworth, ReadyCap, Kabbage, Square Capital and Amur hold 11 rows with no equity figure; what stood behind their Fed balances is not in a call report.
PPPLF bank leverage: peak Federal Reserve PPPLF funding over total bank equity capital, the 30 largest borrowers. Pandemic Darlings, https://pandemicdarlings.com/data/ppplf-bank-leverage/, SHA-256 68813d43511845fd7d4dbeff2239070eb69f5c47dc89cf2dd257f75f6be7fe20