Skip to main content

19 posts tagged with "Community Bank"

View All Tags

What Happens to Securities When Rates Rise

Bond Math and the Balance Sheet

· 4 min read

The Fed raised rates again this week, the seventh increase this year. The federal funds rate is now 4.25 to 4.50 percent. That's 425 basis points in nine months. I've been paying more attention to the securities line on the balance sheet lately, and now I'm trying to understand what all these rate hikes actually do to that portfolio.

What Happens to Securities When Rates Rise

Visualizing Deposit Trends Over Time

Using Matplotlib to See What the Numbers Hide

· 5 min read

Exploring transaction data with pandas gave me a baseline. Counting things, grouping things, building a sense of what normal looks like. That was useful, but it left me staring at tables of numbers. What I wanted was to see the shape of what's happening over time.

Visualizing Deposit Trends Over Time

What Community Banks Are Actually Worried About

A Reality Check

· 4 min read

I've spent time thinking about stablecoins, the Terra collapse, and the regulatory questions surrounding both. It gave me a better sense of where the industry might be headed and why regulators are taking a careful approach. But it also highlighted something I'd been noticing. The conversations happening around banking and the conversations happening inside a bank are very different.

What Community Banks Are Actually Worried About

Exploring Transaction Data with Pandas

A Million Bank Transactions from a Public Dataset

· 5 min read

I wanted to try the same data tools on transaction-level records. Mortgage lending data is useful, but the day-to-day activity of a bank lives in its transactions. Deposits, withdrawals, transfers, loan payments. Every client interaction with their account generates a record.

Exploring Transaction Data with Pandas

Reading a Bank's Balance Sheet

Loans as Assets, Deposits as Liabilities

· 3 min read

Schedule RC, the balance sheet section of the public call report, is where a bank lays out what it owns and owes, so I pulled one up to see how it is put together. I've read balance sheets before from my startup days, but a bank's looks different in several ways.

Reading a Bank's Balance Sheet