How to Analyze a Bank Part 3: Stressing Out

Bricks stressed outAfter running our bank solvency test on our target bank, we have a rough idea of just how good a bank it is.  Now, we get to stress test it.  It’s time to make the clouds thunder and the winds blow with the stress test from Morningstar’s Bank Credit Methodology acting as our Prospero.  Fortunately, this section of their methodology doesn’t require a lot of editing to be useful for small banks, but you do have to make a few extra assumptions.  It’s a pretty good model for a severe banking downturn AND has the added benefit of helping get a better understanding of a bank’s asset portfolio as the different types of loans have different write-off rates.  So let’s get started.

Are You Ready to Rumble?

You’ll need a snapshot of the current bank’s loan portfolio by type.  Once again, get this from a call report at the FFIEC or via BankRegData.com, then fire up Excel or Google Spreadsheet and start inputing values.  Once again using our lovely little example of a bank, Westamerica, we’ll see how well a good bank does during a harsh financial downturn.

First off, Westamerica is a good underwriter, so thankfully we can use the first column write-off percentages for stress tests, the low column.  If your bank has a history of good underwriting for at least ten years, we can go ahead and use the low column.  If there’s any doubt, stick to the middle, and if your bank has faced serious problems previously, go ahead and use high.  Most banks that are worth being interested in are in the low write-off category as the others are likely too unpredictable and determining a margin of safety is likely too difficult.

For Westamerica, I’m using their latest 2011 Q1 data.  Westamerica’s first lien mortgage loans are nearly all prime rated, so we’ll be using the 3.0% write off here, the same amount Wells Fargo experienced in the early 90s.

Westamerica has a number of FDIC loss share agreements (LSAs) on the books.  You can read more about loss share agreements here on the FDIC’s website.  Westamerica has FDIC LSAs of about $330 million in commercial real estate loans, $115 million in commercial and industrial loans, $63 million in individual other consumer loans, $38 million in miscellaneous loans, and some smaller ones from there.  All total about $660 million in loss shared loans and $21 million in real estate owned (REO).  The FDIC generally takes about 80% of the loss on these for the life of the agreement.  I generally add back 80% of the expected loss from each of these loans during the stress test.

Some banks have loans completely guaranteed by the government.  Obviously, be sure to subtract those from your loan amounts.  Westamerica has very few of these type of guaranteed loans, so I didn’t alter their loans because of loan guarantees.

Another large assumption I make is that interest income remains proportional to asset value, and as asset value shrinks, interest income shrinks proportionally.  I also assume interest expense, non-interest expense, and non-interest income remain constant, so no new business coming in.  Obviously, interest income should drop a little more as the interest of loans that are souring are often higher than the bank’s average interest income rate, but I make up for this by assuming that the assets sour immediately at the beginning of the year and no new business is added.

A final assumption I make is I include initial loan loss provisions with tangible common equity in the final computation of the ratios.  If you want to be even more conservative, you can exclude the provisions.

As always, since we’re ultimately looking for large margins of safety, perfect models are not necessary.

Now It’s Time for the Show

Let’s see how the numbers play out. Here are our estimates of loan loss assumptions:

Ultimately, Westamerica is about to take a $325 million hit in write-offs before figuring in pre-tax pre-provision earnings.  Here are what final ratios would look like:

WABC Loss under Stress

So, it’s clear Westamerica can take two brutal years in a row.  What was surprising (or not so surprising if you knew what line of banking they were in) was that they don’t do it perfectly.  They have a lot of commercial real estate, which even for good underwriters can sour quickly in a bad environment.  Fortunately, they don’t have many construction loans on the books.  High exposure to commercial real estate can hurt.  Contstruction loans kill.  Large exposure to construction loans is reason to not buy a bank no matter how good they are.  Don’t make my previous mistakes.

If we look at the final scores of Westamerica of 6.46% TCE + LL  / Assets and 11.88% TCE + LL / Risk Assets, they are actually below Morningstar’s high end scores and are right in the middle. In other words, Westamerica would only get a slightly above average grade of 6.2 on a scale of 10.  Passable, but they might actually have to raise some equity at the wrong time if more than two years of ruin occurred.  Obviously this is a worst case scenario, but that is EXACTLY the sort of scenario you run as a value investor.

One might claim that the annual write-off percentages may be too severe for a good underwriter like Westamerica, but good underwriting depends on good management, and that can unfortunately change before it shows up in the numbers, so it’s better to keep the stress test pretty harsh, even for good underwriters.

This stress test is helpful in analyzing a bank’s portfolio of loans and getting a better read on a bank’s asset quality.  Westamerica is definitely an amazing bank, one I would likely still buy at a good price, but they could use some extra tangible common equity because of their exposure to commercial loans.

Next post, we’ll take a closer look at some of the more qualitative aspects of banks.

Photo Credit: photocase.com / Nordreisender

Full Disclosure: I have no position in WABC

 

Tags:

3 Responses to “How to Analyze a Bank Part 3: Stressing Out”

  1. Nate Tobik July 13, 2011 at 11:18 am #

    I just wanted to write and say I’ve really enjoyed this series on valuing bank stocks. You have provided some great examples and your writing makes it very accessible. Keep up the great work.

    • truelson July 13, 2011 at 10:10 pm #

      Awesome! Want to take all these bank valuation posts and ultimately turn it into one of the foundational articles on the site. 🙂 Will try to keep useful stuff coming.

Trackbacks/Pingbacks

  1. How to Analyze a Bank Part 4: The Fuzzy Edition | Valuable Behavior - August 11, 2011

    […] crunching side of analyzing a bank like how to assess a banks earnings, assets, and liabilities and modeling how a bank would handle a difficult downturn.  Now it’s time for the lighter, fuzzier side.  Questions like: how can I assess […]