Northern Trust Financial Model
Banking Company Financials Example (Free Excel Download)
Northern Trust Corporation is a leading provider of wealth management, asset servicing, asset management, and banking solutions to corporations, institutions, affluent families, and individuals.
professionals from Deloitte
Used by professionals from
About this model
This model projects Northern Trust Corporation's future earnings, capital adequacy, and shareholder returns to determine its equity valuation and assess its capacity for continued share repurchases in varying interest rate and equity market environments.
Northern Trust Corporation is a leading provider of wealth management, asset servicing, asset management, and banking solutions to corporations, institutions, affluent families, and individuals. The firm operates primarily as a custody bank and wealth manager, generating the majority of its revenue from fee-based services tied to the assets it safeguards and manages.
The business is divided into two primary reporting segments: Asset Servicing (approximately 55% of trust fees) and Wealth Management (approximately 45% of trust fees). Geographically, while headquartered in Chicago, the firm has a massive global footprint, servicing clients across North America, Europe, the Middle East, and the Asia-Pacific region. Northern Trust operates an asset-light, highly scalable business model where proprietary technology and global scale drive operating leverage. The firm holds a top-tier competitive position, ranking among the largest global custodians with approximately $17.4 trillion in Assets Under Custody/Administration (AUC/A) and $1.8 trillion in Assets Under Management (AUM) as of late 2025. Recent major events include significant notable items in 2024 and 2025 related to Visa Class B share monetisation and swap expenses, as well as targeted severance and restructuring programmes to drive productivity.
The downloadable Northern Trust 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 & AssumptionsNorthern Trust financial modelCompany, Historicals & Assumptions used
Source: SEC EDGAR · values in USD
| Line item | FY2021 | FY2022 | FY2023 | FY2024 | FY2025 |
|---|---|---|---|---|---|
| Revenue | $4.36B | $4.43B | $4.36B | $4.73B | $5.02B |
| Net Interest Income | $1.38B | $1.89B | $1.98B | $2.18B | $2.41B |
| Net Interest Income after Provision for Credit Losses | $1.46B | $1.88B | $1.96B | $2.18B | $2.42B |
| Net income | $1.55B | $1.34B | $1.11B | $2.03B | $1.74B |
Forecast assumptions
Defaults used in the downloadable model. Forecast horizon: FY2026–FY2030.
See 8 moreSee less
How to build a detailed financial model for Northern Trust
A complete walkthrough of every driver, margin, working-capital input, and capital-allocation assumption used in the downloadable model.
Revenue Deep Dive
Asset Servicing Trust, Investment and Other Servicing Fees
- Segment name: Asset Servicing
- Revenue driver formula: Asset Servicing AUC/A and AUM x Effective Blended Fee Rate (bps)
- Historical growth rate: 4% to 8% CAGR
- Key growth levers and headwinds: Driven by global equity and fixed income market appreciation, net new business wins from large institutional clients, and cross-selling of data analytics and foreign exchange services. Headwinds include intense fee pressure from rival custody banks and unfavourable foreign currency translation.
- Pricing dynamics: Highly competitive and tiered. Rates fall below 20 basis points for large mandates, with volume discounts heavily utilised.
- Revenue recognition notes: Fees are primarily calculated on a one-month and one-quarter lagged basis using the market value of assets.
- Seasonality: Generally stable, but Q1 often sees a slight uptick due to annual performance fees and securities lending seasonality.
Wealth Management Trust, Investment and Other Servicing Fees
- Segment name: Wealth Management (includes Central, East, West, and Global Family Office)
- Revenue driver formula: Wealth Management AUM and AUC x Effective Blended Fee Rate (bps)
- Historical growth rate: 5% to 9% CAGR
- Key growth levers and headwinds: Driven by equity market performance, generational wealth transfers, and ultra-high-net-worth client acquisition. Headwinds include clients shifting cash into higher-yielding off-balance-sheet products.
- Pricing dynamics: Premium pricing compared to institutional custody, reflecting high-touch advisory, estate planning, and bespoke tax services.
- Revenue recognition notes: Billed quarterly in arrears based on lagged asset values.
- Seasonality: Q4 often sees higher activity due to year-end tax and estate planning execution.
Net Interest Income (NII)
- Segment name: Net Interest Income (FTE basis)
- Revenue driver formula: Average Earning Assets x Net Interest Margin (NIM)
- Historical growth rate: Highly variable based on central bank rate cycles; grew 10% to 14% year-over-year in late 2025.
- Key growth levers and headwinds: Driven by deposit volumes, loan growth, and the yield curve. Headwinds include deposit migration to interest-bearing accounts and higher funding costs.
- Pricing dynamics: Spread business dependent on the gap between asset yields (loans, securities) and liability costs (deposits, wholesale funding).
- Revenue recognition notes: Accrued daily; reported on a Fully Taxable Equivalent (FTE) basis to account for tax-exempt securities.
- Seasonality: Not highly seasonal, but day-count conventions make Q1 slightly lower than Q4.
Cost Structure
Variable Costs / COGS
As a financial institution, Northern Trust does not report traditional COGS. The closest equivalent is Interest Expense, which scales directly with deposit volumes and interest rates.
- Line-by-line breakdown: Interest on deposits, interest on short-term borrowings, and interest on senior/subordinated debt.
- Gross margin range: Not applicable for banks. Net Interest Margin (NIM) typically ranges from 1.50% to 1.85%.
- Key input costs: Central bank policy rates and wholesale funding spreads.
- How COGS scales: Scales linearly with the liability base and prevailing interest rate environment.
Operating Expenses (Noninterest Expense)
- Compensation and Employee Benefits: The largest expense category. Driven by headcount, base salaries, and performance-based incentives linked to fee revenue.
- Outside Services: Includes consulting, legal, and sub-custodian fees. Scales with transaction volumes and regulatory compliance requirements.
- Equipment and Software: Represents the firm's heavy investment in technology, cloud migration, and digital asset servicing. Runs at approximately 15% of total operating expenses.
- Stock-Based Compensation: Embedded within compensation; generally stable as a percentage of revenue but sensitive to executive retirement vesting schedules.
- Restructuring / one-time charges: Frequent in recent years. 2025 included $58.8 million in severance-related charges to drive productivity.
Margin Profile
- Pre-tax margin: 28% to 33% (excluding notable items).
- Margin trend: Expanding. The firm delivered over 200 basis points of positive operating leverage in 2025 by keeping expense growth below revenue growth.
- Segment-level margins: Wealth Management typically generates higher pre-tax margins than Asset Servicing due to higher fee realisations on AUM.
Balance Sheet Structure
- Total assets: Approximately $130 billion to $140 billion.
- Key asset categories: Interest-bearing deposits with banks, investment securities (available-for-sale and held-to-maturity), and loans/leases.
- Goodwill & intangibles: Relatively small percentage of total assets, as Northern Trust relies primarily on organic growth rather than transformational M&A.
- Working capital profile: Not evaluated via traditional corporate working capital metrics (DSO/DIO/DPO). Instead, liquidity is measured by the Liquidity Coverage Ratio (LCR) and deposit stability.
- PP&E: Minimal relative to total assets. Consists of corporate real estate and capitalised software/technology infrastructure.
- Right-of-use assets: Material due to global office leases, but insignificant relative to the massive financial asset base.
Capital Expenditure & Investment
- Capex as % of revenue: Technology and software capitalisation represents the bulk of investment, with total tech spend around $450 million annually.
- Maintenance capex vs. growth capex: Heavily skewed toward growth and efficiency, specifically AI-driven reconciliation, cloud infrastructure, and digital asset (crypto/tokenisation) custody platforms.
- Major capex programmes underway: Enterprise Chief Operating Office (ECOO) modernisation and digital asset custody expansion.
- Capitalised software: Highly material. The firm capitalises significant internal development costs for its proprietary custody and wealth management platforms.
- M&A pattern: Bolt-on acquirer. The firm rarely engages in large M&A, preferring organic growth and occasional small technology or boutique wealth acquisitions.
Debt & Capital Structure
- Total debt: Primarily consists of senior notes and subordinated debt used for regulatory capital purposes, alongside massive deposit liabilities.
- Capital Ratios: Common Equity Tier 1 (CET1) ratio of 12.6% as of Q4 2025, well above the management target of 11% to 12%.
- Credit rating: Highly rated (typically AA- band), reflecting its systemic importance and low-risk custody model.
- Key debt instruments: Unsecured senior debt, subordinated debt, and Federal Home Loan Bank (FHLB) advances.
- Interest rate profile: The firm actively manages interest rate risk using interest rate swaps, aiming to maintain a relatively neutral sensitivity to rate shocks.
- Share repurchase programme: Highly active. The firm repurchased a record $1.3 billion in shares in 2025, reducing the share count by 5%.
- Dividend policy: Progressive dividend policy. The firm paid out approximately $600 million in dividends in 2025, resulting in a total payout ratio (dividends plus buybacks) of 111%.
Cash Flow Characteristics
- Operating cash flow conversion: Not a primary valuation metric for banks. Cash flows are heavily distorted by client deposit inflows and outflows.
- Free cash flow margin: Replaced by "Capital Generation" in bank modelling. The firm generates substantial excess capital due to its high Return on Equity (14.8% in 2025) and low risk-weighted asset intensity.
- Major non-cash items: Provision for credit losses, depreciation and amortisation of software, and stock-based compensation.
- Working capital cash flow impact: Driven entirely by changes in client deposits and the corresponding deployment into investment securities or loans.
- Capex intensity: Low relative to total assets, but technology spend is a significant portion of noninterest expense.
- Cash tax rate vs. GAAP effective tax rate: The effective tax rate typically sits around 23% to 25%. FTE adjustments gross up both revenue and tax expense to account for tax-exempt income.
Sheet Structure
- Assumptions: Hardcoded drivers for macro variables, AUC/A growth, AUM growth, fee realisations, NIM, and capital return targets.
- Scenarios: Interest rate and equity market shock scenarios (e.g., Base, Bull, Bear) driving the asset base and NIM.
- Assets Under Custody & Management: Roll-forward of AUC/A and AUM by segment (Asset Servicing, Wealth Management) including market appreciation and net flows.
- Revenue Schedule: Calculation of Trust, Investment and Other Servicing Fees based on lagged asset values, plus NII (FTE) and Other Noninterest Income.
- Expense Schedule: Line-item build of Noninterest Expense (Compensation, Outside Services, Equipment/Software) and FTE adjustments.
- Income Statement: Consolidated P&L down to Net Income and Earnings Allocated to Common Shares.
- Average Balance Sheet: Average earning assets, average deposits, and average borrowings used to calculate NII and NIM.
- Period-End Balance Sheet: Standard bank balance sheet (Cash, Securities, Loans, Deposits, Debt, Equity).
- Capital & RWA Schedule: Calculation of Risk-Weighted Assets, Tier 1 Capital, CET1 ratio, and excess capital available for distribution.
- Shareholder Returns: Dividend payout, share repurchase schedule, and ending share count calculation.
- Valuation: Dividend Discount Model (DDM) and Price/Tangible Book Value (P/TBV) multiples.
Key Financial Relationships
- `Asset Servicing Trust Fees = Average Asset Servicing AUC/A (Lagged) x Asset Servicing Fee Realisation Rate`
- `Wealth Management Trust Fees = Average Wealth Management AUM (Lagged) x Wealth Management Fee Realisation Rate`
- `Net Interest Income (FTE) = Average Earning Assets x Net Interest Margin (FTE)`
- `Reported Net Interest Income = Net Interest Income (FTE) - FTE Adjustment`
- `Total Revenue (FTE) = Trust, Investment and Other Servicing Fees + Net Interest Income (FTE) + Other Noninterest Income`
- `Total Noninterest Expense = Compensation + Outside Services + Equipment and Software + Occupancy + Other Operating Expense`
- `Pre-Tax Income = Total Revenue (FTE) - Total Noninterest Expense - Provision for Credit Losses - FTE Adjustment`
- `Net Income = Pre-Tax Income - Provision for Income Taxes`
- `Return on Average Common Equity (ROE) = (Net Income - Preferred Dividends) / Average Common Equity`
- `CET1 Ratio = Common Equity Tier 1 Capital / Total Risk-Weighted Assets`
- `Total Capital Distributed = Common Dividends Paid + Share Repurchases`
- `Ending Shares Outstanding = Beginning Shares Outstanding - (Share Repurchases / Average Share Price) + Shares Issued for Compensation`
Cross-Sheet Dependencies
- The Assets Under Custody & Management sheet feeds the Revenue Schedule to calculate fee income.
- The Average Balance Sheet feeds the Revenue Schedule to calculate Net Interest Income.
- The Revenue Schedule and Expense Schedule feed the Income Statement.
- Net Income from the Income Statement feeds the Capital & RWA Schedule (via retained earnings) and the Shareholder Returns sheet.
- The Shareholder Returns sheet calculates buybacks, which reduces the share count on the Income Statement (boosting EPS) and reduces equity on the Period-End Balance Sheet.
- A circularity exists between Shareholder Returns and the Capital & RWA Schedule: buybacks reduce capital, which impacts the CET1 ratio, which in turn dictates how much excess capital is available for buybacks. This must be managed with a circuit breaker or iterative macro.
Sign Convention
- Revenue and Asset balances are positive.
- Expenses, Provision for Credit Losses, and Taxes are positive in their specific schedules but subtracted in the Income Statement totals.
- Contra-asset accounts (e.g., Allowance for Credit Losses) are positive numbers subtracted from gross loans.
- Cash outflows (dividends, repurchases) are positive numbers subtracted from equity balances.
- The builder must strictly subtract expenses from revenues; do not rely on negative hardcodes for expenses.
Things Most Likely to Go Wrong
- Lagged Asset Values: Trust fees are billed on one-month and one-quarter lagged asset values. Applying current-quarter market shocks directly to current-quarter fee revenue will overstate volatility.
- FTE Adjustments: Northern Trust reports NII and Total Revenue on a Fully Taxable Equivalent basis, but GAAP net income requires subtracting the FTE adjustment. Failing to reconcile FTE will cause the tax line to break.
- Notable Items: Historical data contains massive distortions from Visa Class B swap expenses and monetisation gains, as well as FDIC special assessments. The model must exclude these to calculate true operating leverage.
- AUM vs. AUC/A Confusion: The firm reports both. Wealth Management fees are heavily driven by AUM, while Asset Servicing fees are driven by a mix of AUC/A and AUM. Do not apply a single fee yield to total assets.
- Share Count Reductions: The firm aggressively buys back stock (5% reduction in 2025). Failing to model the declining share count will severely understate future EPS.
- Capital Constraints: Buybacks cannot exceed the capital generated above the firm's 11-12% CET1 target. Hardcoding historical buyback amounts into perpetuity will cause the bank to breach regulatory capital minimums.
Validation Checks
- "CET1 Ratio must remain above the 11.0% management target minimum; flag if buybacks cause a breach."
- "Pre-tax margin should remain in the 28% to 33% range based on recent adjusted performance."
- "Return on Equity (ROE) should track between 13.0% and 15.5%."
- "Total Payout Ratio (Dividends + Buybacks) should not exceed 115% of Net Income over a full fiscal year."
- "Net Interest Margin (FTE) should remain between 1.50% and 1.90%."
- "Balance sheet must balance: Total Assets = Total Liabilities + Shareholders' Equity in every period."
- "Expense growth should be lower than revenue growth (positive operating leverage) in the base case scenario."
Key Assumptions (Default Values)
| Assumption | Default Value | Unit | Rationale |
|---|---|---|---|
| Asset Servicing AUC/A Growth | 6.0 | % | Blended expectation of market appreciation and net new business. |
| Wealth Management AUM Growth | 8.0 | % | Driven by equity market tailwinds and ultra-high-net-worth inflows. |
| Asset Servicing Fee Yield | 2.5 | bps | Calculated based on $17.4T AUC/A and historical fee revenues. |
| Wealth Management Fee Yield | 45.0 | bps | Calculated based on $1.3T AUM and premium advisory pricing. |
| Net Interest Margin (FTE) | 1.80 | % | Aligns with Q4 2025 reported NIM of 1.81%. |
| Noninterest Expense Growth | 4.5 | % | Management target to keep expense growth below 5%. |
| Effective Tax Rate | 24.0 | % | Standard corporate rate plus state taxes, adjusted for tax-exempt securities. |
| Target CET1 Ratio | 12.0 | % | Management's stated target range is 11-12%; 12% provides a buffer. |
| Dividend Payout Ratio | 35.0 | % | Based on ~$600M dividends on ~$1.7B net income. |
| Share Repurchase Target | 100.0 | % | Excess capital above 12% CET1 is deployed to buybacks, targeting ~100%+ total payout. |
| Cost of Equity (Ke) | 9.5 | % | Standard assumption for a systemically important, low-credit-risk custody bank. |
| Terminal Growth Rate | 2.5 | % | Aligns with long-term global GDP and inflation expectations. |
Data Sources & Benchmarks
- Filings: SEC EDGAR (Form 10-K, 10-Q) and Northern Trust Investor Relations page for quarterly earnings supplements and call transcripts.
- Key Peers: State Street (STT), Bank of New York Mellon (BK), and JPMorgan Chase (JPM - Securities Services division).
- Industry Data: Federal Reserve H.8 data for commercial bank deposit trends; global equity indices (S&P 500, MSCI World) as proxies for lagged asset value calculations.
- Consensus Estimates: FactSet or Bloomberg for forward EPS, NII, and fee revenue consensus.
Sources
- Northern Trust Q4 2025 Earnings Release and Financial Supplement (northerntrust.com)
- Northern Trust 2024 and 2025 Form 10-K Filings (sec.gov)
- The Motley Fool: Northern Trust Q4 2025 Earnings Transcript
- Matrix BCG: Marketing Mix and BCG Matrix Analysis of Northern Trust
- Investing.com: Northern Trust SWOT Analysis and Earnings Coverage
- Seeking Alpha: Northern Trust Earnings and Capital Return Analysis
- DCFmodeling.com: Northern Trust Business Model and Revenue Drivers
Do more with the Northern Trust model
Frequently asked
What is Northern Trust's primary business model and how does it generate revenue?+
Northern Trust operates primarily as a custody bank and wealth manager, offering wealth management, asset servicing, asset management, and banking solutions. The firm generates most of its revenue from fee-based services linked to the assets it safeguards and manages for clients.
How does Northern Trust's Assets Under Custody/Administration (AUC/A) impact its financial performance?+
Northern Trust's financial performance is significantly driven by its Assets Under Custody/Administration (AUC/A) and Assets Under Management (AUM). These metrics directly influence the fee-based services that constitute the majority of its revenue base.
What are the key capital expenditure assumptions in Northern Trust's financial model?+
The financial model assumes capital expenditure as approximately 3.05% of revenue, with a significant portion dedicated to technology and software capitalization. This investment is heavily skewed towards growth and efficiency initiatives like AI-driven reconciliation and digital asset custody platforms.
What are the projected revenue growth and cost of goods sold assumptions for Northern Trust?+
The financial model forecasts Northern Trust's revenue growth at approximately 3.16% for the projection period. Cost of Goods Sold (COGS) is assumed to be 55% of revenue, reflecting the firm's operational cost structure.
What is the main purpose of the Northern Trust financial model regarding valuation?+
The primary purpose of the Northern Trust financial model is to project future earnings, capital adequacy, and shareholder returns. This analysis helps determine the company's equity valuation and assesses its capacity for continued share repurchases.
For what forecast period is the downloadable Northern Trust financial model available?+
The downloadable Excel financial model for Northern Trust provides projections for the forecast horizon from fiscal year 2026 through fiscal year 2030. This allows users to analyze the company's future performance over a five-year period.
Have more financial modelling questions? Contact us
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.
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.
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.
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.
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.
Capital One
Capital One Financial Corporation (COF) is a diversified financial services holding company and one of the largest banks in the United States.
Fifth Third Bancorp
Fifth Third Bancorp is a diversified financial services company and regional bank headquartered in Cincinnati, Ohio.
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.
Huntington Bancshares
Huntington Bancshares Incorporated (HBAN) is a diversified regional bank holding company headquartered in Columbus, Ohio, providing commercial, consumer, and mortgage banking services.
Explore more Financial Services financial model templates.
