# SHELTER FINANCIAL BANK
COLUMBIA, MO · FDIC certificate 35002 · asset band <$300M · latest filing 2012-12 · stopped filing (departed)

**Verdict on the desk:** this could be *credit-stressed*. Composite score 10 (one point per flag, capital below 5% counted twice; 7 or more is where departures cluster).

## What the filing shows (filed dollars, derived ratios; band percentiles in parentheses)

| Measure | Value | Band median |
|---|---|---|
| Total assets | $144.2M | |
| Deposits | $63.0M | |
| Loans and leases | $139.2M | |
| Total equity | $17.0M | |
| Loans / deposits | 218.45% (p100 of band) | 68.02% |
| Liquid assets / assets | 1.26% (p0 of band) | |
| Uninsured deposits / deposits | 2.50% (p11 of band) | 8.86% |
| Brokered deposits | 5.62% | |
| Wholesale funding | 49.61% (p100 of band) | |
| FHLB advances / assets | 43.99% | |
| Tier 1 leverage | 11.81% (p73 of band) | 10.05% |
| Unrealized securities loss / equity | 0.00% (p8 of band) | 3.01% |
| AOCI / equity | 0.00% (p47 of band) | |
| ROA (annualized) | -0.40% (p8 of band) | 0.76% |
| Net interest margin | 1.29% (p2 of band) | 3.75% |
| Efficiency ratio | 167.92% (p99 of band) | |
| Noncurrent loans | 0.28% (p24 of band) | 1.21% |
| Net charge-offs (annualized) | 0.07% (p44 of band) | |
| Reserve coverage of noncurrent | 408.97% | |
| Real estate % of loans | 66% | |
| Construction % of loans | 0.00% (p7 of band) | |
| Auto loans | $41.0M (29.47% of loans; DQ 0.23%, NCO 0.02%) | |
| Loans to nondepository financials | $0 (0% of equity) (p48 of band) | |
| Deposits YoY | -44.9% | |
| Employees | 11 | |

## Flags firing in the latest filing

- **loans exceed deposits** (`liq_ltd`)
- **wholesale funding >15%** (`liq_wholesale`)
- **liquid assets <10%** (`liq_thin`)
- **losing money** (`earn_negative`)
- **expense ratio p90** (`earn_efficiency`)
- **NIM <2.5%** (`earn_nim`)
- **auto book souring** (`conc_auto`)
- **deposits shrinking** (`shrink_deposits`)
- **assets shrinking** (`shrink_assets`)
- **uninsured deposits leaving** (`flight_uninsured`)

## Warning timeline

| Quarter | Score | Flags that first fired | Flags that cleared |
|---|---|---|---|
| 2011-03 | 4 | loans exceed deposits, brokered >10%, wholesale funding >15%, liquid assets <10% |  |
| 2011-06 | 4 |  |  |
| 2011-09 | 4 |  |  |
| 2011-12 | 4 |  |  |
| 2012-03 | 5 | auto book souring |  |
| 2012-06 | 7 | deposits shrinking, assets shrinking, uninsured deposits leaving | auto book souring |
| 2012-09 | 7 |  |  |
| 2012-12 | 10 | losing money, expense ratio p90, NIM <2.5%, auto book souring | brokered >10% |

## In the news (Google News, unfiltered, newest first; check the city)

- 2024-01-08 [Dodd–Frank’s Unintended Consequences for Housing - Cato Institute](https://news.google.com/rss/articles/CBMilwFBVV95cUxOeW9oNVBqcjVvR09rSFFzMUg0cHJMeGlUY2xudWVHZmZYODctdUJFaEx6YmF5Y0VNV0hyZlgyalE3T0dkb0dOTGZFQXdJQXdEbTI0Q0pVMFh5bjdOYV8wdUtKb2FwS0R1V0w5NTdpVnBRNERqNndubzcxUWVGSDNwbGdqZDE4dDJIT1N1LWlaOV9qaldLeTB3?oc=5) · Cato Institute

## How to verify

- Page: https://getbookiq.com/bank-desk/#bank=35002 (click any number for its formula and FFIEC field codes)
- Latest row, JSON: https://getbookiq.com/bank-desk/data/summary.json · history: https://getbookiq.com/bank-desk/data/h/58.json (key "35002", columns cycle, ASSET, DEP, LNLSGR, EQTOT, ltd, liquid_pct, unins_pct, lev, aoci_pct_eq, sec_loss_eq, roa, nim, eff, nc_pct, nco_pct, LNAUTO, auto_dq, auto_nco, LNNDEPD, ndfi_eq, wholesale_pct, dep_yoy, score, flags)
- Field definitions: https://getbookiq.com/dictionary/#bank-LNNDEPD and the rest of the bank dictionary
- Source: FDIC call report via BankFind, dollars in thousands as filed. Departed means stopped filing, which is usually a merger; FAILED is the FDIC's own list.

---
Rendered 2026-09-10 from the desks' own data files. Full guide: https://getbookiq.com/guide