8 Trend Analysis Examples Every Bank Executive Needs
Brian's Banking Blog
If your bank's balances are growing, how do you know management is winning business rather than moving with the market?
Most banks collect quarterly data. Far fewer convert it into decisions. A quarter-end snapshot tells directors where the institution stands, but it doesn't explain whether funding pressure is accelerating, credit weaknesses are spreading, or competitors are capturing the relationships management expected to win.
Trend analysis connects those observations to an executive choice. The discipline is straightforward: establish a consistent history, define a credible comparison group, isolate the drivers, and decide what evidence warrants action. The hard part is resisting convenient explanations. A falling margin isn't automatically a rate-cycle problem, and rising loan balances aren't necessarily evidence of stronger demand.
The most useful trend analysis examples address decisions about margin performance, deposit pricing, concentration risk, operating efficiency, credit migration, funding stability, small business demand, and market share. Each requires internal detail alongside external benchmarks. Each also requires someone accountable for responding.
For boards, ALCOs, and relationship managers, the standard should be practical: What changed, why does it matter, and what should we do differently? The worked scenarios below are hypothetical, not reported bank results or promised outcomes. They show how to move from a visible pattern to a defensible decision, while distinguishing a useful early warning from a signal that still needs investigation.
1. Peer-Relative Net Interest Margin Trend Analysis
The decision is whether to change deposit pricing, asset production, or both. Track net interest margin over rolling eight- to twelve-quarter periods using consistent FDIC Call Report and FFIEC UBPR definitions. Compare the bank with institutions matched by asset size, charter type, and business mix.
Industry context matters. The FDIC's fourth-quarter 2025 Quarterly Banking Profile reported that industry NIM rose 5 basis points to 3.39%, its highest level since 2019. An institution moving against that direction needs an explanation beyond general market conditions.

Separate the Rate Cycle From Execution
Consider a hypothetical $2.5 billion bank reporting Q4 NIM of 3.10%, compared with a peer median of 3.45%. Its shortfall has widened from 0.20 percentage points two years earlier to 35 basis points.
Decompose that movement into earning-asset yields, interest-bearing funding costs, and balance-sheet mix. Suppose deposit repricing explains the widening gap while asset yields track peers. Management should review rate exceptions and money market tiers before changing lending strategy.
- Define the comparison: Document peer-selection criteria and identify merger-related changes.
- Track the gap: A narrowing shortfall can demonstrate progress even when absolute NIM remains weak.
- Test the intervention: Pair the margin trend with deposit beta, retention, and relationship profitability.
In a hypothetical follow-through, repricing a money market tier recovers 15 basis points within two quarters. Treat that as a scenario to test, not a forecast to promise.
The discipline of repeatable comparisons also underlies Scrappey's scraper benchmarking guide, although banking comparisons require financial and business-model controls. A peer gap identifies where to investigate; it doesn't establish the cause.
2. Deposit Beta and Funding Cost Trajectory Analysis
A bank can retain deposits and still overpay for them. Deposit beta measures how much of a market-rate change the institution passes through to depositors, making it useful for deciding where pricing discretion should stop.
In a hypothetical 300-basis-point tightening cycle, a bank's interest-bearing deposit costs rise 144 basis points, producing a cumulative beta of 48%, against a peer median of 39%. That difference warrants investigation, but it doesn't prove customers are leaving. The bank may be paying aggressively to retain balances, attracting expensive new money, or shifting toward certificates.
Calculate beta using the same market-rate reference, starting date, and deposit-cost definition across institutions. During an easing cycle, examine downward repricing separately rather than assuming customer behavior will mirror the tightening period.
Practical rule: A higher beta is a pricing signal. Balance movements and customer behavior determine whether it's also a retention problem.
Put Product-Level Guardrails Before ALCO
Aggregate beta can conceal opposing behaviors. In another hypothetical product breakdown, time deposit beta reaches 62%, while savings beta is 22%. That supports testing relationship savings offers rather than automatically matching every certificate promotion.
- Escalate exceptions: A hypothetical peer gap of 8 percentage points can serve as an internal ALCO review trigger, not a universal limit.
- Inspect customer cohorts: Separate existing balances, promotional inflows, and accounts with negotiated rates.
- Measure retention: Check whether customers receiving exceptions maintain balances and broader relationships.
Use a consistent cost-of-funds framework to connect product pricing with the bank's overall funding economics. A lower beta isn't success if valuable operating relationships leave.
The executive action is specific: approve product-level pricing bands, assign exception authority, and require evidence that premium rates purchase durable relationship value.
3. Commercial Real Estate Concentration Trend Monitoring
Should management slow originations now, or wait until concentration becomes a board-level constraint? A forward-looking CRE dashboard should answer that question before the next quarter closes.
Consider a hypothetical bank with $1.8 billion in total risk-based capital and $5.2 billion in CRE loans, a concentration ratio of approximately 289%. Its trailing 36-month CRE growth is 46%, and its current production forecast would push the ratio above an illustrative 300% management review trigger within two quarters.
These are scenario assumptions, not a complete statement of supervisory criteria. The 2006 Interagency Guidance on Concentrations in Commercial Real Estate Lending distinguishes construction and land-development exposures from broader CRE exposures. The broader supervisory screen combines concentration and growth conditions; it shouldn't be reduced to a universal lending cap.

Forecast Both Loans and Capital
Project concentration using committed draws, expected originations, repayments, participations, retained earnings, and distributions. Holding capital constant while forecasting loan growth can produce a misleading crossing date.
Build the commercial real estate intelligence view around property type, geography, borrower relationships, and repayment conditions. A stable aggregate ratio can hide deteriorating debt service coverage within a concentrated segment.
- Report the projected crossing date: Show base and adverse scenarios with their assumptions.
- Keep exposure definitions consistent: Don't move loans between categories merely to improve the displayed ratio.
- Connect concentration with credit: Add delinquency, refinancing exposure, and borrower cash-flow trends.
Management might slow multifamily production, sell participations, retain more capital, or redirect capacity toward owner-occupied lending where underwriting supports it. The action should reduce the identified risk, not merely improve the reported percentage.
4. Efficiency Ratio and Expense Growth Trend Analysis
Start with a hypothetical $4.0 billion bank whose efficiency ratio is 67.5%, versus a peer median of 61.0%. Technology expense has grown 14% annually for three years, while revenue has grown 3% annually.
An across-the-board spending freeze would be easy to announce. It would also avoid asking which investments are failing to produce operating value.
Calculate the efficiency ratio using a consistent revenue definition, then decompose noninterest expense into personnel, occupancy, technology, and professional fees. Track the spread between revenue growth and expense growth quarterly. Separate recurring costs from conversion charges, severance, and other unusual items before comparing peers.
Find the Cost That Management Can Change
The hypothetical technology trend supports a vendor and application review. Inventory overlapping systems, unused licenses, manual workarounds, renewal dates, and termination costs. Don't assume that canceling a contract removes the underlying work.
A separate hypothetical occupancy analysis might show costs increasing 9% annually while branch transactions decline 18%. Management could evaluate consolidating four branches over 18 months, but transaction counts alone wouldn't establish that closures are sensible. Relationship revenue, customer access, deposit retention, and replacement service costs belong in the decision.
A lower expense line isn't an efficiency gain if management shifts the work to another department or damages revenue.
Assign a named owner to each expense category and require a benefits case for major changes. A hypothetical platform consolidation saving $1,200,000 annually should include migration costs, control testing, and the expected timing of realized savings.
The executive action is targeted accountability: renegotiate redundant technology contracts, redesign an expensive workflow, or reconsider a location. Broad cuts should follow evidence, not substitute for it.
5. Credit Quality Migration and Charge-Off Trend Analysis
A reassuring noncurrent-loan ratio can coexist with worsening borrower conditions. Migration analysis examines the movement that precedes the headline result.
Suppose a hypothetical bank reports noncurrent loans equal to 0.65% of total loans, below a peer median of 0.80%. Meanwhile, pass-to-special-mention migration has increased for three consecutive quarters, concentrated in equipment finance. The appropriate response is a segment review, not reassurance based on the aggregate ratio.

Build migration matrices using comparable beginning and ending populations. Track pass, special mention, and classified grades separately from nonaccrual status, which is an accounting status rather than another internal risk grade.
Distinguish Deterioration From Better Recognition
A grading-policy change or more rigorous review can increase reported downgrades without indicating an equivalent change in borrower economics. Compare migration with borrower cash flow, covenant compliance, collateral coverage, and payment behavior.
- Measure downgrade velocity: Track both balances and borrower counts so a large relationship doesn't obscure broader movement.
- Control for vintage and segment: Compare similar exposures and origination periods.
- Connect leading and lagging measures: Pair migration with segment charge-offs and the non-performing loans ratio.
In a hypothetical agricultural equipment portfolio, two consecutive quarters of downgrades could trigger updated collateral reviews and tighter repayment assumptions. That doesn't justify indiscriminate withdrawal from otherwise sound borrowers.
The chief credit officer should assign review ownership, revise underwriting where evidence supports it, and share segment findings with lenders monthly. The purpose is earlier intervention with identifiable borrowers, not an alert that leaves everyone uncertain about the next step.
6. Deposit Mix and Noninterest-Bearing Concentration Trend Analysis
Deposit stability and deposit affordability are related, but they aren't interchangeable. A bank can preserve total balances while replacing operating deposits with more expensive, less relationship-driven funding.
Consider a hypothetical institution whose noninterest-bearing deposits fall from 34% to 26% of total deposits over six quarters, while brokered deposits rise from 2% to 7%. The board should ask what changed underneath the stable balance-sheet total.
Calculate both dollar movements and mix percentages. A declining noninterest-bearing share may reflect actual outflows, growth in other deposit categories, or both. Separate internal transfers from money that left the bank.
Trace the Change to Relationships
Map deposit movement by industry, relationship tier, account purpose, and customer concentration. A hypothetical 15% year-over-year decline in healthcare operating balances would justify treasury outreach, but management should first distinguish seasonal cash use from competitive losses.
Review payment activity, payroll relationships, receivables services, and rate negotiations. Relationship managers need account-level reasons for contact, not a broad instruction to gather deposits.
- Track cost alongside mix: Show whether the changing composition is raising total deposit expense.
- Connect funding to liquidity planning: Link wholesale-funding limits to contingency funding actions and available capacity.
- Set institution-specific guardrails: A hypothetical 8% brokered-deposit ceiling is a management assumption, not a regulatory threshold.
Don't treat every brokered deposit as unstable or every noninterest-bearing account as dependable. Evaluate maturity, concentration, withdrawal behavior, and the economics of replacement funding.
The executive action may be a focused treasury campaign, revised wholesale-funding limits, or relationship-specific retention offers. Paying more across the entire deposit base is a blunt response to a problem that may be concentrated in a small customer group.
7. Small Business Lending Pipeline Trend Analysis Using SBA and UCC Data
Flat originations don't establish weak demand. Management may be declining applications, losing opportunities, or failing to reach borrowers who are financing purchases elsewhere.
The Federal Reserve's July 2025 Senior Loan Officer Opinion Survey reported tighter standards and weaker demand for commercial and industrial loans across firms of all sizes during the second quarter of 2025. Those separate observations illustrate why executives should distinguish credit supply from borrower demand.
Combine internal applications and conversion rates with SBA program activity, UCC filings, and local economic indicators. Use comparable reporting periods and investigate changes in filing practices before interpreting growth as a business opportunity.
Turn a Local Signal Into a Sales Test
In a hypothetical three-county market, UCC filings associated with equipment-intensive businesses rise 22% over four quarters, while the bank's equipment finance originations remain flat. That supports investigation, not an immediate conclusion that an equivalent amount of unmet demand exists.
UCC filings can reflect refinancing, amendments, continuations, blanket liens, or transactions already funded by competitors. Sample the filings, remove duplicates, and identify relevant borrowers and secured parties before assigning prospects.
- Validate the activity: Distinguish new financing signals from administrative filings.
- Check lending capacity: Confirm product fit, credit appetite, pricing, and relationship-manager coverage.
- Measure the sales test: Track qualified conversations, applications, approvals, and booked relationships separately.
A hypothetical regional lender could target a county where SBA 504 activity grew 30% over two years, then set a $12,000,000 qualified-pipeline objective over six months. That is a sales hypothesis, not a predicted result.
The executive decision is where to deploy relationship-manager time. Reallocate coverage only after filing-level validation and a controlled outreach test demonstrate that the opportunity fits the bank.
8. Market Share and Branch Footprint Trend Analysis Using Deposit and Mortgage Data
Should the bank relocate a branch, strengthen digital acquisition, or add lending capacity? Market-share trends help distinguish those choices, provided management examines the underlying dollars and customers.
The FDIC's BankFind Suite historical series recorded 3,806 insured commercial banks and 69,167 branches in 2025. A national footprint count supplies context, but local investment decisions require county, metro, and branch-level analysis.
Use FDIC Summary of Deposits balances alongside HMDA mortgage applications and originations. Align geography and reporting periods, and account for mergers, branch transfers, and changes in reporting coverage.
Compare Channels Before Committing Capital
In a hypothetical core county, the bank's deposit share falls from 10.8% to 9.2% over three years, while a competitor rises from 6.1% to 9.4%. The bank's mortgage origination share also falls, from 7.5% to 4.9%.
That combined movement supports a competitive review, but it doesn't establish that another branch is the answer. Deposit bookings may be concentrated at particular offices, and mortgage performance may reflect product pricing, loan-officer turnover, or application abandonment.
Board question: Are we losing local relationships, or are reporting conventions and product mix making our position look weaker?
Examine branch contribution, household acquisition, digital completion rates, mortgage conversion, and relationship profitability. Falling share in a rapidly growing market can coexist with rising balances; rising share in a shrinking market can conceal deterioration.
In a separate hypothetical county, mortgage share increases from 3.1% to 6.4% over three years. Adding a loan officer may be justified if demand, conversion, and capacity support the investment.
Allocate capital to the demonstrated constraint. Relocate a poorly positioned office, repair digital onboarding, or add productive coverage rather than funding an across-the-board expansion.
Eight Trend Analysis Examples for Bank Executives at a Glance
| Focus Area | Primary Data Source | Key Decision Supported | Signal Strength |
|---|---|---|---|
| Peer-relative net interest margin trends | FDIC Call Reports; FFIEC UBPR | Adjust deposit pricing and balance sheet strategy | Moderate; quarterly data lag |
| Deposit beta and funding cost trajectory | FDIC Call Reports; market benchmark rates | Set deposit pricing guardrails and target at-risk accounts | Moderate; benchmark- and cycle-sensitive |
| Commercial real estate concentration trends | FFIEC Call Report Schedule RC-C; capital and origination trends | Adjust CRE originations, participations, or capital plans | Moderate; projections depend on assumptions |
| Efficiency ratio and expense growth trends | FFIEC UBPR; bank expense and revenue data | Target cost reductions and operating investments | Moderate; affected by one-time items and reporting differences |
| Credit quality migration and charge-offs | FFIEC Call Report asset quality schedules; internal risk ratings | Tighten underwriting and review stressed loan segments | Strong early warning; depends on consistent ratings |
| Deposit mix and noninterest-bearing concentration | FDIC Summary of Deposits; FFIEC Call Report deposit schedules | Strengthen deposit relationships and manage wholesale funding reliance | Moderate; mix changes require context |
| Small business lending pipeline trends | SBA program data; state UCC filings; BLS and BEA data | Target lending outreach by market and industry | Moderate; leading indicators require validation |
| Market share and branch footprint trends | FDIC Summary of Deposits; HMDA data | Relocate, consolidate, or invest in branches and digital channels | Moderate; annual deposit data and market changes can lag |
From Quarterly Snapshots to Decisive Action
A single data point tells directors where the bank stands. A trend helps them identify what needs investigation and when a decision can no longer wait. The distinction matters because a visible pattern is not automatically an actionable finding.
Across these trend analysis examples, the strongest decisions follow the same discipline: define the comparison, examine the drivers, test competing explanations, and assign responsibility. Management should be able to explain why a margin gap warrants repricing, why credit migration requires a portfolio review, or why a local demand signal deserves additional sales coverage.
Make the Evidence Defensible
Every material signal should travel with an audit trail. Preserve source fields, calculation logic, reporting dates, peer-selection criteria, adjustments, assumptions, and management's interpretation. Show what would weaken the conclusion as clearly as what supports it.
The SAS banking trends overview identifies fragmented legacy data, inconsistent definitions, and weak lineage as obstacles to dependable analysis. Those are operational issues before they are modeling issues. A complex forecast won't resolve a mismatch between internal portfolio definitions and external benchmarks.
- Name the owner: Specify who validates the signal and who can authorize a response.
- State the uncertainty: Separate observed changes from inferred causes and scenario assumptions.
- Set a review point: Establish when management will assess whether the intervention worked.
- Retain the outcome: Record the decision, supporting evidence, and subsequent results.
Unified data should span the sources relevant to the decision, including FDIC Call Reports, FFIEC UBPR, NCUA 5300, SBA, UCC, HMDA, and macroeconomic series. Internal account and borrower detail supplies the context that public benchmarks cannot.
Our Bank Intelligence and Action System brings multi-sourced banking data into decision-ready analysis. Bank Performance supports comparisons against 4,600+ institutions over the past decade, while our broader historical coverage extends 30+ years. Most core datasets refresh quarterly, with some updated monthly or weekly, and reporting includes executive dashboards, annotated charts, and export-ready reports.
The objective isn't to eliminate spreadsheets or automate executive judgment. It's to reduce reconciliation work, make comparisons repeatable, and ensure that important findings reach the person who can act.
Choose a live decision for the next board or ALCO meeting. Establish the baseline, define the trigger, and agree on the response before the next reporting cycle. Data becomes useful when management turns it into an accountable choice.
Visbanking offers historical performance analysis, peer benchmarking, and executive reporting to help banks connect trends with decisions. Visit Visbanking to benchmark your bank's margin, funding, growth, and credit performance, then identify which gaps deserve management's attention first.
Latest Articles

Brian's Banking Blog
Annual Contract Value Explained: Formula and Examples

Brian's Banking Blog
8 Case Study Examples Banking Executives Can Reuse

Brian's Banking Blog
Configure Price Quote Explained for Bank Executives

Brian's Banking Blog
Bank Marketing Regulations: A Guide for Bank Executives

Brian's Banking Blog
What Is Predictive Analytics? a Guide for Bank Leaders

Brian's Banking Blog