ALCO In Practice: Essential Reports Analysis and Risk Management
Download MP3Hey everyone.
This is mark Treichel with another episode
of, with flying colors today, I'm going
to chat with Todd Miller of my team.
And this episode is
called outgo in practice.
Essential reports analysis
and risk management.
Todd has tremendous background in
this, including being a director
of special actions that examiner.
A capital market specialist
and supervising the entire west
coast one-third of the countries.
Capital market specialists at NCUA.
So Todd, last week we discussed Alco
governance, essentials and building an
effective committee structure who should
be on the committee, et cetera, et cetera.
Now we're going to pivot to ALM or
Alco reporting and policies, et cetera.
So with that, , I'm going to give
you free reign to share your wisdom.
Todd Miller: So this should
be all laid out in policies.
I'm going to go through some general
things and that I think should be
part of most ALCO report packages
and part of most ALCOs functionings.
This shouldn't be intended to
be an inclusive list that this
is the only things you need.
If you want to add other
reports, feel free to do that.
Some of this is, how do you
lay out your business plan?
And how does the board layout
performance key performance
indicators and key risk indicators.
So this can change it a little bit, but
I'm going to lay out what I think is
should be in a typical Elko package.
And some of what I lay out here might
not be in the package every month.
It might be in once a quarter.
We'll even talk about model validations.
That might only have to occur a
couple times a year, but we'll
go through just some general
things that I think should be in.
Most Elko packages out there,
even though it's not in an
exhaustive, all inclusive list.
1st, 1, credit unions operate
in an environment out there.
So somewhere within our Elko and our
organization, we should have some basic
economic data that we're keeping track of.
What's going on nationally and
more important, what's going on
locally, and especially with managing
credit risk, what's happening
in our local housing market.
If you're a business lender, what's
happening in our local commercial real
estate market, what are employment trends
within our local area and our fields
of membership, there should be just
some general economic information that
shared across the committee, because
they're going to be determining tactics.
Thanks.
And while credit unions should not
make huge bets on the economy, they
do have to take a position and make
reasonable decisions on how they're
going to operate their lending and
investment programs, their deposit
gathering programs, and that's going to
be influenced by their local economic
factors or their expectations of which
direction the economy is going to go.
You can't really manage any risk out
within the organization unless you
have some basic information about your
financial statements and your budgets.
And how are you doing on budgets
and comparisons along that line?
They're the biggest ones that responsible.
How do we address
variances in our budgets?
Do we need to change strategy?
Do we need to change tactics?
Do we need to change pricing if things
aren't going as the board expects?
I'm a big believer in compliance
dashboards and within this,
there's lots of things.
So there's key performance indicators, key
risk indicators, gives you an exam report.
It has key ratios.
I do think each board, as they lay
out their business plans, they should
lay out what are the key performance
indicators and key risk indicators
for them and that strategic plan.
You can get really carried away with
these and maybe overburden the committee,
but you also need to have enough where,
what's going on with each of those risk
areas in the organization and have a
way to measure your performance against
your strategic and business plans
within those performance indicators.
Risk indicators.
I'm a big believer that
especially concentration risk is
important for most organizations.
And, I think a lot of organizations,
they will have these types of
ratios, but they're spread out.
I really think to be effective with an
outgo and even for boards of directors,
and, we've talked about board governance
before that these 1 spot where
people can see them all in 1 place.
Liquidity reports, and there's
different kinds of liquidity reports.
A lot of people use historical
measures for liquidity, and I think
that's fine for compliance purposes.
For an ALCO type, someone
who's responsible for managing
liquidity and interest rate risk,
they need cash flow forecasts.
And especially they need to
be looking at them out there
three to six months from now.
How are we going to be deploying
the funds available to us
into loans and investments?
How are we going to be
gathering up those deposits?
What's our risk of deposits leasing?
What's going on with our borrowed money?
Those become very important indicators.
And I'll just throw
something else out here.
Some ALCOs, they will get reports like
this from various places, so they might
generate an in house cash flow forecast.
Their ALM vendor might
give them another one.
And you'll see some of this with
interest rate risk reports too.
They'll get them from multiple vendors.
I'm a big believer there needs
to be one version of the truth
though in the organization.
And which of these reports
are you going to use?
It's not let's use this one today,
this other one tomorrow, which
everyone makes us look good.
Let's lay out in policy which
of these reports, Is going to
be our decision making tool.
We can use other reports as a model
validation type thing and other
source of information, but you do
have to be careful that you have
1 version of the truth going on.
We've seen clients written
up for this, especially with.
In their loan portfolio and their
credit risk management where they
have different systems, giving them
different versions of the truth.
What does that say
about your organization?
When you have different
versions of the truth?
It's not looks well.
It doesn't necessarily look very well
when you have different versions of
the truth inside the organization.
It's cashflow reports.
Very important interest rate risk reports.
This is traditionally
the role of the Alco.
How, what does our net interest
income and what does our NAV numbers
look like under various scenarios?
Cardings typically don't do these
every month unless you're really
large but quarterly is quite common.
Along the lines with the interest
rate risk report, at the ELCO
level, ELCO members need to have a
good general understanding of the
model assumptions in those reports.
Do they need to see all 2, 000
of them that are in a report?
No, but they do need to have a good
general understanding of which assumptions
move the numbers the most and at
least occasionally they need to have
some good documentation of what those
numbers and those assumptions look like.
And that ELCO should be actively
involved in establishing change
control procedures for those numbers.
Now it's an important piece and
examiners will criticize credit unions
at the ELCO level if they don't have
a good Handle around what those model
assumptions might be investment portfolios
and see ways regulation lays out.
Here's required investment reports.
Typically those flow to Elko.
It's pretty common for Elko
to actually be the party that.
Sets investment strategy inside
that business plan based on
other things that are going on.
There should be some good reports
related to that whole investment
portfolio and their analysis.
Another piece of this and
credit unions will hear this
all the time from examiners.
They want scenario and sensitivity
testing of their models.
Backtesting of liquidity models.
I think that scenario and sensitivity
analysis is an important piece of this.
Like I said, members of the ALCO
committee, they should know which
variables will move these numbers the
most and which ones they need to pay
attention to in terms of their member
behavior, the scenario analysis, it's
really important for your capital planning
and building your, whole strategic plan.
What does our results look like
if A happens or if B happens?
Do we want to have our loan
portfolio be 60 percent real
estate and 40 percent consumer?
Or do we want to be a business lender
where it's 60 percent business loans
and 20 percent consumer loans and
20 percent residential real estate?
Those things make a difference,
and credit unions need to build
those into scenario analysis.
What happens if, what happens if all
these CDs that we've gathered up in
the last couple years walk back out
the door and we can't replace them?
What happens if our whole
deposit structure changes?
Those types of things should be laid
out in scenario analysis, especially as
we're building up our business plans.
Increasingly, we're seeing
examiners ask credit unions to
stress test their loan portfolios.
This is a new thing to credit unions.
It's not a new thing.
In fact, the first time I've seen a
stress test was way back in the 1990s.
They had an egg lender where they had
an in house database where they could
actually just change the price of
commodities and it would spit out, here's
all your farmers that were not going
to make money or make money under this.
And that was way back in 1990.
So it's not a new thing, but it's new
that examiners are increasingly asking
credit unions to do these stress and
scenario analysis on their loan portfolio,
especially if they have concentrations
of member business loans, because
everyone's reading that commercial real
estate buildings are empty or less full
than they used to be in certain markets.
So that scenario type
of testing and analysis.
It informs your decision
making in a very positive way.
Another key part of Elko, and sometimes
Elko re delegates this, but I think Elko
really needs to stay on top of it, and
that's your pricing decisions support.
How do we price our assets and our,
and liabilities, and what are we
going to use to base that pricing on?
Now, just about every credit union will
have surveys of what competitors have for
loan and share rates, but If you follow
competitors, you're going to get their
results and their expenses and capital
might be very different than yours.
So I think you need just a
little bit more than that.
And it's, where here's an analysis of the
yields and returns on our loan portfolio.
Here's analysis of our cost of funds.
Here's our analysis of our
borrowing and deposit structure.
You don't see this very often, but I
think it's very critical is what's our
marginal costs and marginal yields so
many times as a problem case officer
and a director of special actions, you
get into institutions that have earnings
problems and what you really find out
is they've mispriced things that price
things to meet the competition, but it
doesn't meet the needs of the institution.
And if you go back to the
last recession in 2008.
Before it hit, a lot of the folks had
problems is because they followed the
market in terms of pricing loans and
the entire market underpriced for risk.
And do you want to have control
of that decision or not?
And, cost accounting
systems come into this.
It really depends on size and complexity.
But in general, you need a good pricing
decision support set of reports, whatever
that might be for your organization that
you need to understand, because pricing
decisions, even through the last little
bit here, when interest rates shot up, a
lot of cratings got into some earnings.
issues for a short period of time.
Most of them adjusted pretty well
and have adjusted today, but there's
still some that are still having
some challenging issues with earnings
because they made poor pricing decisions
in the past before that even hit.
This isn't in all ALCOs, but I do think
more and more it's becoming a big piece
of ALCO, is they need a comprehensive
set of credit risk management reports.
Now, do they need to be having discussions
at ALCO about individual borrowers?
No.
Should they have a general idea of
what's going on in their Loan portfolios.
Absolutely.
Yes.
How do you build that out so
you don't cross the line into
getting into the weeds, so to
speak, that becomes an individual
credit union's kind of challenge.
But I do think in general, it's
very hard for a credit union to
manage liquidity and interest rate
risk without assessing credit risk.
I just don't see how you
can manage those two without
having a handle on credit risk.
But that's Todd Miller's take on
ELCO and that they need to have.
control of that credit
risk assessment as well.
Agendas in minutes are really a key
thing and the way I would lay out
what does your agenda in minutes
do and what should they accomplish.
They should make it really transparent
what you're using to make decisions, the
decisions you made, why decisions were
made And if you've got adverse trends,
why are you not doing nothing about it?
So I'm trying to see things
not going the way they're at.
And I okay, we'll just watch
that for a while, but we're
not going to change anything.
Your minutes should really be transparent
that you made that decision intentionally
and did so for specific reasons.
And I think a lot of places miss this.
They have their agenda.
They don't put a thought into it.
I think trender reporting is a big
piece of this in getting it right.
We have one, we have more than one
client, they'll rate their risk categories
and you should put that on the agenda.
Liquidity risk this month,
right on the agenda.
Moderate increasing, moderate
stable, high increasing, high stable.
Really where you spend your time
should get dictated by, where your risk
is at and where your risk is going.
So those are critical things to me.
And a lot of times when you get
issues with examiners, questioning
a credit union's decision, it's
because as they go through their exam
process, and they read your minutes,
and they look at your reports, it's
not clear and transparent to them.
What decisions you made
and why you made them.
So it's critical that you lay out in
your minutes, your Elko minutes that we
made these decisions for these reasons,
and we weren't operating in a vacuum.
You can avoid a lot of issues
with your examiners and from a
board governance perspective.
It should be clear and transparent.
So if your board picks up these
minutes and looks through it.
They should be able to understand
why you did what you did with the
authority they've given you as well.
So you don't do it just for the examiners.
You do it for the benefit of the
organization and it's the way you
keep everyone on the same page.
It's really unfortunate.
There's a few times we've been
involved with credit unions that
end up in court with the vendor.
They end up in court because of accuso.
They end up in court because of, some
investment broker did something to
them and you start deposing people.
And it's they don't remember why
and they look at their own minutes
and it's why did you do that?
I don't remember.
I don't know.
That's really not a good place to be in as
an organization when you don't understand
why you made the decisions you made.
So that kind of covers the reporting.
I just want to talk about model risk a
little bit in line with the reporting,
because a lot of what Elko's does and
bases their decision on are based on
forward looking models, be that cash
flow forecast, interest rate risk models.
All the scenario stuff we talked about
in sensitivity testing, those are all
done as part of forward looking models,
credit stresses on your loan portfolio.
That's all models.
Model risk is something that
is a challenge for everyone.
I do think for ALCO committees, committee
members needed general understanding of
key assumptions in all of these models.
If they're basing decisions on them,
they should have a basic understanding.
Do they need to be an expert on
the model and know everything?
No, but they should have a
good general understanding.
The second piece of this is model
validations, and this happens in different
places and different size credit unions,
and some really large credit unions.
It's a whole separate function
of internal audit and the.
ERM process in smaller credit
unions, it actually falls a lot of
times to the ALCO committee itself
to validate their own models.
And sometimes it's even down to the
finance department to just validate
their own cash flow forecast.
It doesn't really.
There's right, there's different
answers to who handles model validation
and different size organizations.
The point I want to make is community
members should be comfortable with the
efforts made to validate their models.
How frequently do we do it, within
an organization from a governance
perspective, it can be happening
in different departments and
be driven by different people.
But at the end of the day, the
folks using those models to make
decisions should be comfortable.
With what their organization has done
to validate those critical models
and make sure they're accurate.
That covers most of what I have to say.
I think that gives people a good
general understanding of things.
Maybe 1 of these days, you
can get another person to.
Do a podcast just on the whole credit
risk reporting piece of it because
it can be as big as the other pieces.
And I think it's a ever
growing important piece.
And we see more and more examiners
want justification for concentration
risks, whether that's in your investment
portfolio, loan portfolio, and CUA
hasn't really talked about liability
concentrations, but I guarantee you it
will be coming in the future on their
part as they get comfortable with.
Their whole concentration risk on the
asset side of the balance sheet today,
Treichel: Todd, as you're talking
through that I'm envisioning a couple
different listeners, not specific
people, but someone out, for a walk,
listening to this on their iPhone.
Versus someone sitting at their laptop
versus someone driving in their car.
And there, you had so much
information packed in there.
I know that some of the listeners
are going to go when I get to my
laptop, I need to relisten to this
and I need to take some notes.
And when I get to my laptop, I
need to forward this episode to my
committee, et cetera, because there
was just tons of information there.
I wrote a lot of different things down.
And the listeners can't see this, but you
might not even be able if I hold it here,
you can see I got two different pens.
I got a black one and a red one.
And as you were talking on some
things that I wanted to, I didn't
want to interrupt you because I don't
want to break your flow because that
was fabulous, but I wrote a couple
different things down that link to
things that it triggered for me.
I'm going to walk through.
Some of those, I'm going to ramble with
some of those and then you can pivot
and see if there's anything that I
said that that you want to respond to.
So you talked about, stress testing and,
everybody's hearing that there's empty
buildings and that's a type of commercial
loan risk and that you need to have better
tools that are doing stress testing.
And I believe we've given
guidance and, or NCOA.
Has criticized credit unions that when
you're doing that stress testing, you
don't want to just stress commercial
over here and then stress real estate,
residential real estate over here and
then stress your visa over here and
then stress your deposits over here.
There needs to be some sort of
cascading effect where you might.
You might stress two
factors or three factors.
That was one thing I wanted to mention.
And there, we, I also want to
mention that we have a separate,
you and I did a separate podcast
with the sole topic of model risk.
And so if someone is listening and you
want to hear more about what Todd said
relative to model risk, I think we
probably have a 20 Or 30 minute podcast
that we did specifically on model risk.
Scenario and sensitivity analysis.
I think if I'm linking this right
to some of our conversations.
We've had situations where a document
resolution or an examiner finding was
given to a credit union where they said
that you need to update those and you
need to be reevaluating those things.
And careful what you ask for and is
what we've seen because people have
come through this cycle and they have.
Re evaluated what the reality is
and then projecting that forward.
And I'm going to get some of this
wrong, but I think you're going to
get the point I'm trying to make here.
But when NCOA asks you to do some
backtesting, that backtesting
sometimes will actually work the
opposite of what NCOA thought.
And your assumptions might show
that your deposits are more sticky.
So that's something that I
wanted to throw out there.
To governance, many of these things,
if any NCA, you hit on governance
and a couple different points.
We have a separate podcast on governance.
We are seeing NCUA almost link every
examiner finding, maybe not examiner
finding, but document resolution.
If NCUA is unhappy about something
that happened since the last exam,
they seem to always now link it
back to corporate governance.
Which makes some sense in most instances,
but it just Impresses upon me that
the corporate governance is even
more important that it's ever been.
I've said another podcast.
It almost seems has done training
on a national level or pointed out
that they need to do this because
we're seeing it so consistently.
And then here's my last comment,
and then I'll let you respond
to any of these that you might.
Might want to when I'm going back to
when I was actually doing exams, you
go in and so he doesn't do an audit.
There's the supervisory committee
or the CPA audit, but you'd
have your regular trial balance.
And, loans totaled up to 15.
24179 million dollars.
And you'd compare that to the
regular loan trial balance.
Then you'd have the visa trial
balance, which was different.
Then you'd have the commercial loan trial
balance, which might have been different.
Then you might have the real
estate loan trial balance.
And then on top of that, you've got
these big systems that credit union
seems to have sometime where they where
they're doing analysis and loss analysis.
And I don't want to name particular
companies, but there are other
vendors out there that will
provide these other analyses.
And we saw in some situations
where an examiner said, Hey, you
have all this ALM stuff that says.
That this loan type is X at the end
of March and it's off by, 4, 000 on a
multimillion dollar program because it's
purpose isn't to be that trial balance.
And.
In that instance, we gave some guidance
to this credit union that they might
want to get those ALM reports as
of April instead of as of March so
that the examiner doesn't try and
link it back to their call report.
And there's no requirement that
those ALM reports be linked.
And I think you might have said
even, you've seen some situations
so there's a lot of workload
tied to that for that vendor.
The vendor might give you a discount.
Not only do you have the added
advantage of NSUA, not trying to link
it to something that it shouldn't.
And that doesn't happen that often.
That was really more of a one off.
But, alright, that's those are the
brain dump of what I wrote and read on
different things I wanted to mention
relative to the notes I have here.
Did that, any of that trigger any
clarification or follow ups from what I
said that you might want to add there?
Todd Miller: Think I'll respond
to all of them just briefly.
And we'll do the last 1
1st balancing reports.
And this is back to my 1
version of the truth type thing.
You do need within your organization
processes to reconcile reports.
Now, you might run credit risk
things, that might be done at
a mid month or not a quarter.
And you build this workflow in there
and, most organizations now have large
data warehouses, information is lodged
in a couple of different places.
It might be off a little bit from
your accounting reports, and it's
probably okay for them to be off a
little bit, but examiners just want
to reconcile things to the penny.
And that's just.
A waste of their time when you're
in, a 1 or 2 or a 5 billion dollar
organization, or even a 500 million dollar
organization, but ratings themselves
should have internal controls to reconcile
these different reports and make sure
they're appropriate reports here.
People capital markets.
Who's ever looking at a lamb?
I always looked at them and
tied them to a balance sheet.
The, these roughly look good.
Okay.
Within, and this happens almost all
the time, within your loan type codes
and your vendors, ALM type codes,
sometimes things just don't map exactly.
Small errors never bothered me.
Simple things were investment
securities, where you know exactly what
the balance is on exactly that day.
Those should tie exactly every time.
And it didn't happen often in
my career, but it did happen
once or twice, where there were
material errors in an ALM model.
And some of this was intentional on the
part of the credit he not giving their
vendor actually accurate information
about items on their balance sheet.
And see way tends to want to reconcile
this stuff to the penny, because
even though they don't catch very
much fraud, it's usually caught.
or otherwise by internal audit or
an employee writing out another
employee, or caught by accident.
But a lot of times when NCAA does catch
fraud, it is because these reports don't
reconcile or they'll see strange things
they get their share alone download and
that's not tying with a general ledger.
Or there's a funky account
within that trial balance.
That's been used to hide errors.
So that's why MCUA is sensitive
to that issue is because
the frauds they have caught.
It's been caught for that reason.
Not the point of our thing here today.
We'll go back to sensitivity
scenario analysis.
You see this a lot in exam reports.
They want you to beef up
sensitivity scenario analysis.
As an ALCO, though, you need to keep
in mind those are two totally separate
things, even though examiners often use
the words interchangeably, sensitivity
analysis is about determining which
factors move those model results
the most and which assumptions
move it the most scenario analysis.
You're trying to figure out what could or
might happen under different conditions.
It's not related to, those
core basic assumptions at all
two very different purposes.
We go back to this credit modeling and
you mentioned, we stress this credit
portfolio, real estate differently
from the consumer differently from the
residential real estate and yeah, they're.
But more and more, you're seeing
for credit unions to really
justify their capital adequacy.
They're almost going down
to a capital planning path.
And, so you get into the ones credit
unions and they're over 10 billion.
They're required to do
this combined stress test.
And, the Federal Reserve even sets
the conditions for those stress tests.
Here's what the interest rate
scenario is going to look like.
Here's what the economy
is going to look like.
And those are very technical and very
precise, but I think for a lot of
credit unions, the scenario analysis
and different concentration levels.
They can do that on a less precise
way and probably need to do a
combined analysis of some of these
stresses to determine if they're.
capital is adequate.
You have regulatorily
required capital levels.
The reality is in many marketplaces
and depending on the way your balance
sheet structured is, those regulatory
capital levels are probably not
sufficient for you to be competitive
and optimally serve your members.
You're going to need more capital than
that regulatory capital in the real world.
And as your competitors have more
capital, you're going to need
more capital to keep up with them.
Yeah, capital planning is Unnecessary
part of every organization and, I can see
a day where these required tests for 10
billion get moved down to credits at 5
billion and examiners are going to start
wanting people at 1 billion to do it,
even though the reg might not require it.
It's just an evolution that
examiners go through where.
Best practices, they tend to
filter it down to smaller and
smaller organizations, and I don't
necessarily see that as a bad thing.
In many ways, it's a good thing.
And I just started out the whole thing.
Large organizations have
committee charters and small
organizations put it in policy.
And I said it's Even these small
organizations, you should think
about having committee charters.
So it's just a natural
evolution of things.
So I think more and more you're
going to see examiners push
organizations of all size to.
Go to a comprehensive capital
planning type, and, we help
people out with some of that.
You see it consistently in exam reports.
They want support for concentration
risk, which is really another way to say,
prove you have enough capital to do this.
It's just the other side of the coin.
Which words do you use?
Prove you have enough capital or prove
you can support your concentration risk.
It's the same question.
Just different sides to it.
Did I hit all the points
you had written down there?
You
Treichel: did.
You did fabulous.
Yeah, you hit them all.
I have different
Todd Miller: color pens too and
I have notes and I always say I'm
going to check off on my notes.
When I address something, but
I get talking and I never do.
So I make it and then I just don't really
look at him very much during our podcast
Treichel: that that
just makes me smile too.
Cause it reminds me of my dad.
I used to go to a lot of
race horse races with my dad.
And he had the daily racing form, and he
had four different colored highlighters,
and he had three different colored
pens and every one meant something,
and, and then you'd get there you'd do
all your handicapping, which is almost
as fun as going to the race, and then
you'd get there, and you'd see the
odds, and you'd do something different.
And then you'd go back and you'd look at
in blue, he said he wanted blue as his
top horse, for example, in each race.
And then you only went with that, like
half the time you'd go home and you'd
do the debrief of the, all that color
coding and and you'd realize that you
were onto something you just needed
to follow with your convictions and
the assumptions you had going in.
So that's a total non sequitur
to this, but all that color
code made me think of that.
So that made my heart smile.
All right, Todd.
So what else as we wrap this up, is
there any final thoughts you want to make
relative to what we've discussed here?
Todd Miller: No, I think we'll just go
reiterate something at the beginning.
There's no one right
answer for all of this.
You're trying to accomplish the
same general things, but really
you make all this fit and work
within your corporate culture.
It's all part of your corporate culture.
You build this around the knowledge,
skills and abilities of your
staff and a good reason to do it.
Do this and have this in a very formal
way is it improves the knowledge, skills
and abilities of the rest of your staff.
And I guess that kind of leads to 1
thing that examiners do bring this up.
Occasionally is it's important to continue
the training of all your staff that
they have ongoing training and various
areas that they're responsible for.
Listening to our podcast
as part of that, but
Treichel: that's right.
That's
Todd Miller: right that is an
important piece for committee members
and it's an important piece for
any organization that you Dedicate
resources to improving those knowledge
skills abilities of your staff members
Treichel: Fantastic, this is going to
be an instant classic episode I got
a feeling that that people are again
going to want to listen to this more
than once There's a lot of really good
Advice and counsel in this and I want
to thank you for your time today, Todd.
Todd Miller: It was my pleasure mark.
I enjoy doing these
Treichel: These are fun.
These are very fun.
And listeners, I want to
thank you for listening.
I hope you'll listen again soon.
This is Mark Treichel signing
off with Flying Colors.
