Huntington Bancshares logo
Huntington Bancshares Financial Model

Banking Company Financials Example (Free Excel Download)

Huntington Bancshares Incorporated (HBAN) is a diversified regional bank holding company headquartered in Columbus, Ohio, providing commercial, consumer, and mortgage banking services.

Loading...

Used by professionals from

KPMG logoWharton logoColumbia logoESSEC logoPwC logoHEC logo

About this model

This model provides a comprehensive equity valuation and forecasting tool for an equity research analyst covering Huntington Bancshares, focusing on net interest margin trajectory, loan growth, and the financial integration of the recent Veritex Holdings acquisition.

Huntington Bancshares Incorporated (HBAN) is a diversified regional bank holding company headquartered in Columbus, Ohio, providing commercial, consumer, and mortgage banking services. The company operates primarily through two main business segments: Consumer & Regional Banking and Commercial Banking. The business model is asset heavy, relying on gathering low cost deposits to fund commercial and consumer lending while generating fee income through wealth management and capital markets activities. Huntington holds a strong competitive position in the Midwest and is the nation's leading originator of Small Business Administration (SBA) loans by volume. A major recent event is the acquisition of Dallas based Veritex Holdings, which closed in January 2026, significantly expanding Huntington's footprint into the high growth Texas market and transforming it into a super regional bank.

The downloadable Huntington Bancshares financial model includes SEC-sourced historical financials, forecast assumptions, core operating schedules, and valuation outputs in an Excel workbook built for review and scenario analysis.

A turnkey financial model

Live formulas, no hardcoded values

Outputs are driven by live formulas, so the workbook updates from its assumptions instead of relying on hardcoded results.

All assumptions in one tab

Inputs are clearly marked in the Assumptions tab and separated from calculations, making it clear what to change and what to leave intact.

Statements always balancing

For integrated-statement models, the balance sheet, cash flow, and supporting schedules tie through properly.

Distinct schedules for clarity

Debt, working capital, taxes, and cash flow can get messy quickly. We group calculations in clear schedules, not across disconnected tabs.

No hidden macros or external links

There are no unexplained external workbook links or macros to undermine auditability or portability.

Changes flow through the model

Update a key driver and see the impact carry through the forecast, financing, and return outputs. We never use hardcoded numbers in formulas.

Historicals & AssumptionsHuntington Bancshares financial model

Source: SEC EDGAR · values in USD

Line itemFY2021FY2022FY2023FY2024FY2025
Revenue$1.11B$1.32B$1.40B$1.47B$1.56B
Net interest income$4.10B$5.27B$5.44B$5.34B$5.99B
Net interest income after provision for credit losses$4.08B$4.98B$5.04B$4.92B$5.53B
Net income$1.29B$2.24B$1.95B$1.94B$2.21B

Forecast assumptions

Defaults used in the downloadable model. Forecast horizon: FY2026–FY2030.

Revenue growth
10.5%
COGS % of revenue
55.0%
R&D % of revenue
0.0%
SG&A % of revenue
8.2%
D&A % of revenue
30.0%
Effective tax rate
17.1%
See 8 more
Capex % of revenue
14.7%
Net working capital % of revenue
0.0%
Other assets % of revenue
500.0%
Other liabilities % of revenue
500.0%
Annual debt paydown
5.0%
Interest rate on debt
6.0%
Dividend payout ratio
52.3%
Buybacks % of net income
18.5%

How to build a detailed financial model for Huntington Bancshares

A complete walkthrough of every driver, margin, working-capital input, and capital-allocation assumption used in the downloadable model.

Revenue Deep Dive

Huntington generates revenue through two primary streams rather than traditional product sales:

Net Interest Income (NII)

  • Segment/Line Item: Net Interest Income (reported on a Fully Taxable Equivalent or FTE basis).
  • Revenue Driver Formula: Average Earning Assets x Net Interest Margin (NIM).
  • Historical Growth Rate: Highly cyclical, driven by Federal Reserve interest rate policy and loan demand. NII grew 14% year over year in Q4 2025 due to organic growth and the Veritex acquisition.
  • Key Growth Levers and Headwinds: Loan volume growth (especially commercial and industrial loans), deposit beta (how fast deposit costs rise relative to benchmark rates), and the yield curve shape.
  • Pricing Dynamics: Floating rate commercial loans reprice quickly, while fixed rate consumer loans and mortgages lag.
  • Seasonality: Generally not highly seasonal, though day count in a quarter slightly impacts interest accruals.

Noninterest Income

  • Segment/Line Item: Noninterest Income (includes wealth and asset management revenue, service charges on deposit accounts, card and payment processing income, and capital markets fees).
  • Revenue Driver Formula: Assets Under Management x Fee Rate (for wealth), Transaction Volume x Fee per Transaction (for payments).
  • Historical Growth Rate: 3% to 5% historically, with Q4 2025 showing a 4% year over year increase.
  • Key Growth Levers and Headwinds: Equity market performance (drives AUM fees), consumer spending volumes, and regulatory pressure on overdraft and non sufficient funds fees.
  • Revenue Recognition Notes: Recognized as services are performed or transactions are executed.

Cost Structure

Variable Costs / Interest Expense

  • Line by line breakdown: Interest on deposits, interest on short term borrowings, and interest on long term debt.
  • Margin Range: Net Interest Margin (NIM) typically ranges from 2.90% to 3.30%. In Q4 2025, NIM was 3.15%.
  • Key Input Costs: The Federal Funds rate and competitive pressure for retail deposits.

Operating Expenses (Noninterest Expense)

  • Personnel Costs: The largest expense, covering salaries, benefits, and stock based compensation.
  • Outside Data Processing and Equipment: Costs for core banking systems and digital banking platforms.
  • FDIC Assessment Fees: Regulatory costs based on the bank's risk profile and asset base.
  • Amortisation of Intangibles: Significant due to historical M&A (TCF Financial, Veritex).
  • Restructuring / One time charges: Frequent due to M&A. Q4 2025 included $130 million in pre tax notable items primarily related to acquisition expenses.

Margin Profile

  • Efficiency Ratio: Noninterest Expense divided by Total Revenue. Historically ranges from 58% to 64%. Q4 2025 saw an elevated efficiency ratio of 64.2% due to acquisition costs.
  • Margin Trend: NIM expanded in late 2025 due to optimized funding costs, while the efficiency ratio spiked temporarily due to integration expenses.

Balance Sheet Structure

  • Total Assets: Approximately $225 billion post Veritex acquisition.
  • Key Asset Categories: Loans and Leases (the largest component, split between commercial and consumer), Investment Securities (available for sale and held to maturity), and Cash.
  • Allowance for Credit Losses (ACL): A contra asset account representing expected lifetime credit losses. Stood at $2.7 billion or 1.83% of total loans at the end of 2025.
  • Goodwill & Intangibles: Material percentage of assets due to the TCF and Veritex acquisitions.
  • Working Capital Profile: Not applicable for banks. Banks manage liquidity ratios (e.g., Loan to Deposit ratio) rather than traditional working capital.
  • PP&E: Minimal relative to total assets; consists mainly of branch real estate and corporate offices.

Capital Expenditure & Investment

  • Capex as % of Revenue: Minimal (typically 1% to 2%), focused on capitalized software, digital banking enhancements, and branch network optimization.
  • Maintenance vs. Growth: Heavily skewed toward technology growth and digital transformation.
  • M&A Pattern: Transformational and bolt on acquirer. Acquired TCF Financial in 2021 and Veritex Holdings in 2026.
  • Typical Acquisition Multiple: Usually 1.5x to 2.0x tangible book value, paid primarily in stock.

Debt & Capital Structure

  • Capital Ratios: Common Equity Tier 1 (CET1) ratio was 10.4% at the end of 2025.
  • Total Debt: Includes senior notes, subordinated debt, and Federal Home Loan Bank (FHLB) advances.
  • Credit Rating: Investment grade (typically BBB+ to A- range depending on the agency).
  • Maturity Profile: Laddered maturities for wholesale borrowings to manage refinancing risk.
  • Interest Rate Profile: A mix of fixed rate debt and floating rate advances, managed via interest rate swaps.
  • Share Repurchase Programme: Active but paused or moderated around major acquisitions.
  • Dividend Policy: Strong dividend payer with a yield around 3.5% to 4.0% and a target payout ratio of 40% to 50% of earnings.

Cash Flow Characteristics

  • Operating Cash Flow: Not a meaningful metric for banks. Cash flows are driven by deposit gathering and loan origination.
  • Free Cash Flow: Replaced by "Free Cash Flow to Equity" or residual income in bank modelling, defined as Net Income minus the capital required to fund asset growth and maintain regulatory capital ratios.
  • Major Non Cash Items: Provision for credit losses, depreciation, and amortization of intangibles.
  • Cash Tax Rate: Often lower than the statutory 21% rate due to investments in low income housing tax credits and tax exempt municipal securities.

Sheet Structure

  1. Assumptions: Hardcoded drivers for macroeconomic variables, interest rates, loan growth, deposit growth, and margin assumptions.
  2. Summary & Scenarios: Dashboard showing EPS, Return on Tangible Common Equity (ROTCE), CET1 ratio, and toggle for base/bull/bear cases.
  3. Average Balance Sheet: Tracks average balances for Earning Assets (Commercial Loans, Consumer Loans, Securities) and Interest Bearing Liabilities (Deposits, Borrowings). Calculates FTE yields and costs.
  4. Income Statement: Projects Net Interest Income (using outputs from the Average Balance Sheet), Noninterest Income, Noninterest Expense, and Net Income.
  5. Credit & Asset Quality: Models Net Charge Offs (NCOs), the Allowance for Credit Losses (ACL), and calculates the Provision for Credit Losses.
  6. Period End Balance Sheet: Reconciles ending balances for all asset, liability, and equity accounts.
  7. Capital & RWA: Calculates Risk Weighted Assets (RWA) and regulatory capital ratios (CET1, Tier 1 Capital) to determine excess capital available for dividends and buybacks.
  8. Valuation: Dividend Discount Model (DDM) and Residual Income model based on projected dividend payouts and terminal ROTCE.

Key Financial Relationships

  1. "Net Interest Income = (Average Earning Assets x Earning Asset Yield) - (Average Interest Bearing Liabilities x Cost of Funds)"
  2. "Net Interest Margin (NIM) = Net Interest Income / Average Earning Assets"
  3. "Provision for Credit Losses = Net Charge Offs + (Ending ACL - Beginning ACL)"
  4. "Ending ACL = Ending Total Loans x Target ACL Percentage"
  5. "Efficiency Ratio = Noninterest Expense / (Net Interest Income + Noninterest Income)"
  6. "Return on Average Assets (ROAA) = Net Income / Average Total Assets"
  7. "Return on Tangible Common Equity (ROTCE) = (Net Income - Preferred Dividends - Intangible Amortization) / Average Tangible Common Equity"
  8. "Tangible Common Equity = Total Equity - Preferred Stock - Goodwill - Intangible Assets"
  9. "CET1 Capital = Tangible Common Equity + Qualifying Adjustments (e.g., CECL phase in)"
  10. "CET1 Ratio = CET1 Capital / Risk Weighted Assets"
  11. "Risk Weighted Assets = Total Assets x Average Risk Weighting Percentage"
  12. "Dividends Paid = Net Income - (Target CET1 Capital - Beginning CET1 Capital)"

Cross-Sheet Dependencies

  • The Average Balance Sheet is the foundational sheet; it feeds the Income Statement to calculate Net Interest Income.
  • The Credit & Asset Quality sheet calculates the Provision for Credit Losses, which flows into the Income Statement as an expense.
  • Net Income from the Income Statement flows into the Period End Balance Sheet (Retained Earnings) and the Capital & RWA sheet.
  • The Capital & RWA sheet determines how much capital is required to support loan growth. Any excess capital flows to the Valuation sheet as distributable dividends.
  • Circularity risk exists if share repurchases are modeled to reduce equity, which increases the need for retained earnings, altering the share count and EPS. This should be broken using a circuit breaker toggle.

Sign Convention

  • Assets are positive.
  • Liabilities and Equity are positive.
  • Revenue (NII and Noninterest Income) is positive.
  • Expenses (Noninterest Expense, Provision for Credit Losses, Taxes) are positive and subtracted in total income formulas.
  • Net Charge Offs are positive.
  • Dividends and Share Repurchases are positive numbers subtracted from Retained Earnings.

Things Most Likely to Go Wrong

  • "Failing to adjust Net Interest Income to a Fully Taxable Equivalent (FTE) basis will cause a mismatch with reported NIM figures; the model must gross up tax exempt income."
  • "The Veritex acquisition closed in January 2026; historical data prior to Q1 2026 will not be comparable, requiring pro forma adjustments for loan and deposit base growth."
  • "Provision for Credit Losses is not the same as Net Charge Offs; the model must calculate the change in the ACL reserve to accurately project the income statement provision."
  • "Using a standard DCF for a bank is incorrect; the builder must use a Dividend Discount Model (DDM) or Residual Income model driven by regulatory capital constraints."
  • "Deposit beta assumptions are critical; if the model assumes deposit costs fall as fast as the Fed Funds rate, it will artificially inflate NIM."
  • "Goodwill and intangibles from the Veritex deal will depress GAAP ROE; the model must calculate ROTCE (Return on Tangible Common Equity) as the primary profitability metric."
  • "The efficiency ratio calculation must exclude amortization of intangibles to match management's 'adjusted' reporting metrics."
  • "Average balances differ from period end balances; interest income must be calculated on average balances, not period end balances."

Validation Checks

  • "NIM should remain in the 2.90% to 3.30% range based on historical performance; flag if outside this band."
  • "Efficiency ratio should normalize to 58% to 62%; flag if it remains above 65% post integration."
  • "CET1 ratio must remain above the regulatory minimum plus management buffer (target > 9.5%); flag if it drops below 9.0%."
  • "ACL as a percentage of total loans should remain between 1.50% and 2.00% (currently 1.83%)."
  • "Net Charge Offs should run between 0.15% and 0.35% of average loans in a base case scenario."
  • "Balance sheet must balance: Total Assets = Total Liabilities + Equity in every period."
  • "Dividend payout ratio should remain within the 40% to 50% target range."

Key Assumptions (Default Values)

AssumptionDefault ValueUnitRationale
Commercial Loan Growth8.0%Reflects organic growth plus Veritex integration in Texas.
Consumer Loan Growth2.0%Slower growth expected in auto and mortgage lending.
Net Interest Margin (NIM)3.15%Based on Q4 2025 actual reported NIM.
Noninterest Income Growth4.0%Aligns with recent historical growth rates.
Efficiency Ratio61.0%Normalizing from Q4 2025 spike (64.2%) as integration costs fade.
Net Charge Off (NCO) Ratio0.25%Based on Q4 2025 actuals (0.24%) with slight normalization.
ACL to Total Loans1.83%Held flat to Q4 2025 actual reserve levels.
Effective Tax Rate19.0%Lower than statutory 21% due to tax advantaged investments.
Target CET1 Ratio10.0%Management target, slightly below Q4 2025 actual of 10.4%.
Dividend Payout Ratio45.0%Midpoint of historical management target range.
Cost of Equity (Ke)10.0%Standard assumption for regional bank valuation.
Terminal ROTCE15.0%Long term profitability assumption for residual income model.

Data Sources & Benchmarks

  • Filings: SEC EDGAR (Form 10-K, 10-Q), Huntington Investor Relations website for quarterly financial supplements and slide decks.
  • Key Peers: Fifth Third Bancorp (FITB), KeyCorp (KEY), Citizens Financial Group (CFG), Regions Financial (RF).
  • Industry Data: FDIC Quarterly Banking Profile, Federal Reserve H.8 data (Assets and Liabilities of Commercial Banks).
  • Consensus Estimates: FactSet or Bloomberg for EPS and NIM consensus.

Sources

Frequently asked

What kind of bank is Huntington Bancshares (HBAN)?+

Huntington Bancshares Incorporated (HBAN) is a diversified regional bank holding company headquartered in Columbus, Ohio. It provides commercial, consumer, and mortgage banking services primarily through its Consumer & Regional Banking and Commercial Banking segments, holding a strong competitive position in the Midwest.

How does Huntington Bancshares (HBAN) generate its revenue?+

Huntington Bancshares generates revenue through two primary streams: Net Interest Income (NII) and Noninterest Income. NII is driven by average earning assets and net interest margin, while Noninterest Income includes fees from wealth and asset management, deposit services, and capital markets activities.

What is the assumed Capital Expenditure as a percentage of revenue for Huntington Bancshares in a financial model?+

The financial model for Huntington Bancshares assumes Capital Expenditure (Capex) as a percentage of revenue is approximately 14.66%. This capex is heavily skewed toward technology growth, digital banking enhancements, and optimizing the branch network rather than traditional property and equipment.

What are important considerations for valuing Huntington Bancshares (HBAN)?+

Key considerations for valuing Huntington Bancshares include its net interest margin trajectory, loan growth, and the financial integration of recent acquisitions like Veritex Holdings. The company's asset-heavy business model, reliance on low-cost deposits, and liquidity ratios are also crucial for a comprehensive valuation.

Can I download an Excel financial model for Huntington Bancshares (HBAN)?+

Yes, an Excel financial model for Huntington Bancshares is available for download, providing a comprehensive equity valuation and forecasting tool. This model covers a forecast horizon from FY2026 to FY2030, focusing on key banking metrics and assumptions.

How has the Veritex Holdings acquisition impacted Huntington Bancshares (HBAN)?+

The acquisition of Veritex Holdings, which closed in January 2026, significantly expanded Huntington's footprint into the high-growth Texas market. This strategic move transformed Huntington into a super regional bank and increased its total assets to approximately $225 billion post-acquisition.

Have more financial modelling questions? Contact us

Alex Tapio, ex-Deloitte financial modelling expert

Created by ex-finance professionals

Hey, I’m Alex and I created Finamodel.

Over my years in the finance industry I kept building the same models over and over again. Same structure, same assumptions, different logo. So I started building frameworks to turn them into clean, reusable templates.

Every model here is one I’d actually use for a client, and I personally vet each one before it goes up.

I’m not an expert in every industry, but I’ve built enough models to know what belongs in one. And when something is completely foreign to me, I reach out to my network for experts to work on our models with us.

Having a template library on hand cuts a first build from hours to minutes.

Need help finding your model? You’ll find me in the Finamodel app!

Other Banking Company Financial Models

Browse another company in the same sector.

BAC.xlsx
Metric
2026
2027
Revenue
--
--
EBITDA
--
--
Bank of America logo

Bank of America

Bank of America is one of the world's largest financial institutions, serving individual consumers, small and middle-market businesses, and large corporations with a full range of banking, investing, asset management, and risk management products.

BK.xlsx
Metric
2026
2027
Revenue
--
--
EBITDA
--
--
BNY Mellon logo

BNY Mellon

The Bank of New York Mellon Corporation (BNY Mellon) is a globally systemic financial services institution that primarily operates as a trust bank, providing investment management, investment services, and wealth management to institutions and high-net-worth individuals.

C.xlsx
Metric
2026
2027
Revenue
--
--
EBITDA
--
--
Citigroup logo

Citigroup

Citigroup is a globally diversified financial services holding company providing consumer and corporate banking, investment banking, wealth management, and markets services across international markets.

CFG.xlsx
Metric
2026
2027
Revenue
--
--
EBITDA
--
--
Citizens Financial Group logo

Citizens Financial Group

Citizens Financial Group (CFG) is one of the largest regional banks in the United States, providing retail and commercial banking products and services to individuals, small businesses, middle-market companies, and large corporations.

COF.xlsx
Metric
2026
2027
Revenue
--
--
EBITDA
--
--
Capital One logo

Capital One

Capital One Financial Corporation (COF) is a diversified financial services holding company and one of the largest banks in the United States.

FITB.xlsx
Metric
2026
2027
Revenue
--
--
EBITDA
--
--
Fifth Third Bancorp logo

Fifth Third Bancorp

Fifth Third Bancorp is a diversified financial services company and regional bank headquartered in Cincinnati, Ohio.

GS.xlsx
Metric
2026
2027
Revenue
--
--
EBITDA
--
--
Goldman Sachs logo

Goldman Sachs

Goldman Sachs is a leading global financial institution that delivers a broad range of financial services across investment banking, securities, investment management, and consumer banking to a large and diversified client base.

JPM.xlsx
Metric
2026
2027
Revenue
--
--
EBITDA
--
--
JPMorgan Chase logo

JPMorgan Chase

JPMorgan Chase is a leading global financial services firm and the largest bank in the United States by total assets, providing investment banking, consumer and commercial banking, financial transaction processing, and asset management.

Explore more Financial Services financial model templates.

Go further

Build the financial model you need with Fina

Browse templates, examples, and downloadable Excel models for the analysis you are trying to build. If you can't find your model, ask Fina to build a model for your specific needs.

Start for free
Excel financial model spreadsheet preview showing Customer Rollforward
Fina interactive chat interface preview