Value Packs / Banking / Liquidity & Maturity Early-Warning / Wisdom

Which states are replacing less of their maturing deposit money than we expect over the next thirty days, and how much is maturing in each?

N
Done See how Wisdom analyzed this

Three states are not replacing what they have maturing

IN A NUTSHELL

Three states are booking less new deposit money than they have maturing. Texas is furthest — $1.42B matures there in the next thirty days and only $1.16B of new money is coming in to replace it, leaving it $261M short. Arizona is $72M short on $640M maturing and Nevada $30M short on $385M. The other 45 states are booking at least as much as they have maturing.

New money booked against money maturing, by state, next thirty days

TXAZNVBOOKING LESS THAN THEY HAVE MATURINGTexas$1.42B maturing in thirty days−18.4 ppArizona$640M−11.2 ppNevada$385M−7.9 ppThe other 45 statesat or above replacing what matures

Only the three states booking less than they have maturing are shaded — the darker the shading, the bigger the gap between what is maturing and what is coming in to replace it.

Texas has $1.42B maturing against $1.03B across Arizona and Nevada together, so it is both the largest maturity wall and the widest shortfall. Every other state is booking at least as much as it has maturing.

Ask a follow-up

How has the share of maturing money that Texas replaces moved week by week against what we expect? How has Arizona moved week by week? Which states are replacing more than they have maturing?

How has the share of maturing money that Texas replaces moved week by week against what we expect?

N
Done See how Wisdom analyzed this

Below expectation for four weeks, and lower each week

IN A NUTSHELL

Texas replaced between 95.8% and 103.6% of what matured every week through week 11, inside what we expect of it. It fell below the range at week 12 and has been lower every week since — 94.2%, 90.1%, 85.8% and 81.6%. The slide from week 11 to now is 19.1 points, and each of the last three weeks gave up between 4.1 and 4.3 points.

New money against money maturing, by week · Texas

80%90%100%110%week 12 — first week beloww1w4w7w10w13w15latest weekNew money against maturingExpected range

A reading of 100% means every dollar that matured was replaced by a new one — anything under it is money that came due and did not come back.

Weeks 1 to 11 sit either side of expectation by no more than 4.3 points and never in the same direction twice running. From week 12 the shortfall runs 5.7, 9.5, 14.2 and 18.1 points, widening in each of the four.

Wisdom noticed

“That’s the second question in a row on Texas. Shall I save it as your scope?”
Yes, save it as my scope No, ask me each time

Ask a follow-up

Is it the long-held deposits not being replaced, or the newer ones? How much matures in Texas over the next four weeks? How does Texas compare with Arizona week by week?

Is it the long-held deposits not being replaced, or the newer ones?

N
Done See how Wisdom analyzed this

It is the twelve-month money

IN A NUTSHELL

Money maturing out of twelve-month deposits is being replaced at 72.9% against a usual 99.6% — 26.7 points down, on $690M. Six-month money is 14.1 points down on $420M, and three-month or shorter 5.8 points down on $310M. The longer the deposit that is maturing, the less of it is coming back. Twelve-month money is 49% of what matures and 70% of the shortfall, which is $184M of the $261M Texas is short.

Replacement rate by the tenor the money is maturing from · Texas

Being replaced nowBelow usualUsually replacedMaturing from twelve-month deposits−26.7$690M maturingMaturing from six-month deposits−14.1$420MMaturing from three-month or shorter−5.8$310M0.0%50.0%100.0%150.0%

Each tenor is read against what it usually replaces — all three normally bring in at least as much as they have maturing, and the twelve-month book is the one that has moved.

All three tenors normally replace what they have maturing almost exactly. The three-month book still nearly does. The twelve-month book is $690M of the $1.42B maturing and has moved furthest, so it decides the total.

Ask a follow-up

Put the maturity report together. Which branches hold the twelve-month money? How much of it has already matured?

Put the maturity report together.

N
Done See how Wisdom analyzed this

The report lists everything maturing in the next thirty days by state, branch and tenor, with how much of each has been replaced so far and how much has not. One row per maturity date, so the days with the most money coming due are visible.

XLSX

maturities_next_thirty_days.xlsx

One row per maturity date and tenor, sorted by the money not yet replaced. Texas, Arizona and Nevada, with the fifteen weeks behind each.

71 KB · 186 rows · 3 states · 30 days ahead

Download

Ask a follow-up

Which weeks have more than $50M maturing? Can I see this grouped by branch rather than by tenor? Which tenors are still replacing what matures? How many customers sit behind each maturity date?