BNY Mellon logo
BNY Mellon Financial Model

Banking Company Financials Example (Free Excel Download)

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.

Loading...

Used by professionals from

KPMG logoWharton logoColumbia logoESSEC logoPwC logoHEC logo

About this model

This model forecasts BNY Mellon’s earnings, capital trajectory, and intrinsic equity value to help an equity research analyst determine a target price and assess the bank's sensitivity to interest rate changes, equity market levels, and deposit mix shifts.

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. Unlike traditional commercial banks, BNY Mellon takes very little credit risk; instead, it acts as the central nervous system for global capital markets by custodying assets, clearing trades, and managing collateral.

Business Segments:

  • Securities Services (~45% of revenue): Includes Asset Servicing and Issuer Services.
  • Market and Wealth Services (~30% of revenue): Includes Pershing, Clearance and Collateral Management, and Treasury Services.
  • Investment and Wealth Management (~15% of revenue): Includes Investment Management and Wealth Management.
  • Other (~10% of revenue): Corporate treasury, leasing portfolio, and corporate-level allocations.

Key Geographies: Global operations, but heavily weighted towards the Americas (approx. 65% of revenue), followed by EMEA (25%) and APAC (10%). Business Model Type: Asset-light, fee-driven trust bank and platform model. Competitive Position: The world's largest custodian bank (over $50 trillion in Assets Under Custody/Administration) and a top-15 global asset manager (over $2 trillion in Assets Under Management). Key competitors include State Street, Northern Trust, and JPMorgan Chase (Securities Services). Recent Major Events: Transition to a "platforms" operating model under CEO Robin Vince, significant focus on operating leverage, and the $1.2 billion acquisition of Archer in late 2024 to bolster its digital asset and retail wealth custody platform.

The downloadable BNY Mellon 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 & AssumptionsBNY Mellon financial model

Source: SEC EDGAR · values in USD

Line itemFY2021FY2022FY2023FY2024FY2025
Revenue$15.93B$16.53B$17.70B$18.62B$20.08B
Income before income taxes$4.65B$3.33B$4.09B$5.85B$7.06B
Net income$3.77B$2.56B$3.29B$4.54B$5.58B
Net income$3.76B$2.56B$3.30B$4.53B$5.55B

Forecast assumptions

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

Revenue growth
1.8%
COGS % of revenue
55.0%
R&D % of revenue
0.0%
SG&A % of revenue
15.0%
D&A % of revenue
10.3%
Effective tax rate
21.5%
See 8 more
Capex % of revenue
7.5%
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
7.3%
Dividend payout ratio
34.0%
Buybacks % of net income
61.5%

How to build a detailed financial model for BNY Mellon

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

Revenue Deep Dive

Securities Services

  • Revenue Driver Formula: (Average AUC/A x Custody Fee Yield) + Transaction Volumes + FX Trading Revenue
  • Historical Growth Rate: 2-4% CAGR
  • Key Growth Levers and Headwinds: Driven by global equity and fixed income market appreciation, net new business, and cross-border investment flows. Headwinds include fee compression and client internalization.
  • Pricing Dynamics: Highly competitive, institutional pricing with long-term contracts. Often priced in basis points on assets plus per-transaction fees.
  • Seasonality: Q1 is typically strong for securities lending and depositary receipts.

Market and Wealth Services

  • Revenue Driver Formula: (Pershing Client Assets x Fee Rate) + (Tri-party Repo Balances x Clearance Rate) + Treasury Services Payment Volumes
  • Historical Growth Rate: 5-8% CAGR
  • Key Growth Levers and Headwinds: Benefited heavily from higher interest rates (clearing balances). Growth is driven by broker-dealer outsourcing to Pershing and U.S. government securities clearing volumes.
  • Pricing Dynamics: Transaction-based and balance-based. Clearance fees are highly sticky due to BNY's near-monopoly in U.S. tri-party repo clearing.
  • Seasonality: Generally stable, though Q4 can see spikes in collateral management volumes.

Investment and Wealth Management

  • Revenue Driver Formula: Average AUM x Blended Management Fee Rate (bps)
  • Historical Growth Rate: Flat to low single-digits (impacted by outflows)
  • Key Growth Levers and Headwinds: Market appreciation drives AUM up, but the segment has faced persistent active management net outflows.
  • Pricing Dynamics: Fee compression in active management; wealth management fees are stickier and higher margin.
  • Seasonality: Performance fees typically crystallise in Q4.

Net Interest Income (NII)

  • Revenue Driver Formula: Average Interest-Earning Assets x Net Interest Margin (NIM)
  • Historical Growth Rate: Highly cyclical (peaked in 2023/2024 due to rate hikes, declining in 2025 as rates normalise).
  • Key Growth Levers and Headwinds: Driven by central bank policy rates and deposit beta. A shift from non-interest-bearing to interest-bearing deposits compresses NIM.

Cost Structure

Variable Costs / COGS

As a bank, BNY Mellon does not report traditional COGS. The closest equivalent is distribution and servicing expense (sub-advisory fees, broker-dealer commissions), which scales linearly with certain wealth and investment management revenues.

Operating Expenses

  • Staff Expense: The largest expense line (~55% of total noninterest expense). Driven by headcount, wage inflation, and performance-based incentive compensation.
  • Professional, Legal, and Other Purchased Services: ~15% of expenses. Includes consulting, legal, and outsourced processing.
  • Software and Equipment: ~15% of expenses. Reflects heavy ongoing investment in technology, AI, and platform resilience. Capitalisation of internally developed software smooths this line.
  • Net Occupancy: ~5% of expenses. Trending down due to real estate footprint rationalisation.
  • Restructuring / Severance: Frequent "efficiency initiatives" result in periodic severance charges (e.g., $100-$200m annually in recent years).

Margin Profile

  • Pre-tax Operating Margin: 25% - 30% (highly sensitive to NII and market levels).
  • Return on Tangible Common Equity (ROTCE): 18% - 24% (target range >20%).
  • Margin Trend: Expanding slightly due to strict expense discipline (positive operating leverage) and share repurchases reducing the equity base.

Balance Sheet Structure

  • Total Assets: ~$400 billion - $450 billion.
  • Key Asset Categories:
  • Interest-bearing deposits with central banks (~$100 billion)
  • Investment securities (Agency RMBS, Treasuries) (~$150 billion)
  • Loans (~$60 billion, mostly margin loans and wealth management mortgages, very low credit risk)
  • Goodwill & Intangibles: ~$18 billion (legacy of the Bank of New York and Mellon Financial merger, plus bolt-on acquisitions).
  • Working Capital: Not applicable for a bank. Liquidity is measured via the Liquidity Coverage Ratio (LCR), typically >115%.
  • Liabilities: Driven by client deposits (~$270 billion). These are largely operational deposits tied to custody and clearing services, making them stickier than retail deposits.

Capital Expenditure & Investment

  • Capex as % of Revenue: Not a standard banking metric. Instead, focus on technology spend, which runs at ~$3.5 billion annually (expensed and capitalised).
  • Capitalised Software: Material. Amortisation of software is a significant non-cash expense.
  • M&A Pattern: Bolt-on acquisitions focused on technology and wealth platforms (e.g., Archer acquisition for $1.2B).

Debt & Capital Structure

  • Total Debt: Long-term debt is typically ~$30 billion - $35 billion.
  • Capital Ratios: Common Equity Tier 1 (CET1) ratio is the critical metric, currently running at 11.5% - 11.9% (target is typically 10.5% - 11.0%).
  • Credit Rating: Aa1 (Moody's) / AA- (S&P) for the primary bank subsidiary.
  • Share Repurchase Programme: Highly active. BNY Mellon frequently returns >100% of its net income to shareholders via dividends and buybacks (e.g., repurchasing ~$800m - $1B per quarter).
  • Dividend Policy: Payout ratio typically targets 30% - 40% of earnings.

Cash Flow Characteristics

  • Operating Cash Flow: Not a primary valuation metric for banks due to the commingling of operating and financing cash flows in working capital (deposits/loans).
  • Free Cash Flow: Replaced by "Free Capital Generation" in bank modelling. Calculated as Net Income less RWA growth capital requirements.
  • Major Non-Cash Items: Provision for credit losses (usually very small for BNY, <$50m per quarter), depreciation and amortisation, stock-based compensation.
  • Cash Tax Rate: Typically 22% - 24%, closely mirroring the GAAP effective tax rate.

Sheet Structure

  1. Assumptions: Hardcoded macroeconomic inputs, rate curves, segment growth rates, fee yields, and capital return targets.
  2. AUM & AUC/A Roll-forward: Beginning balances, net flows, market impact, FX impact, ending balances. Calculates average balances.
  3. Average Balance Sheet & NIM: Interest-earning assets, interest-bearing liabilities, yield/cost assumptions, and calculation of Net Interest Income.
  4. Segment Revenue: Calculates fee revenue for Securities Services, Market & Wealth Services, and Investment & Wealth Management based on drivers from Sheets 2 and 3.
  5. Consolidated Income Statement: Aggregates NII and Fee Revenue, subtracts Noninterest Expense and Provision for Credit Losses to calculate Net Income and EPS.
  6. Consolidated Balance Sheet: Period-end assets, liabilities, and equity.
  7. Capital & RWA Schedule: Calculates Risk-Weighted Assets, CET1 capital, Tier 1 Leverage, and models share repurchases based on excess capital above target ratios.
  8. Valuation (Dividend Discount Model / Residual Income): Bank-specific valuation using cost of equity and projected capital distributions.

Key Financial Relationships

  1. `Ending AUC/A = Beginning AUC/A + Net New Business + Market Appreciation/Depreciation + FX Translation`
  2. `Ending AUM = Beginning AUM + Net Flows + Market Impact + FX Impact`
  3. `Investment Services Fees = Average AUC/A x Blended Custody Fee Yield (bps)`
  4. `Investment Management Fees = Average AUM x Blended Management Fee Rate (bps)`
  5. `Net Interest Income = (Average Interest-Earning Assets x Asset Yield) - (Average Interest-Bearing Liabilities x Liability Cost)`
  6. `Net Interest Margin (NIM) = Net Interest Income / Average Interest-Earning Assets`
  7. `Total Revenue = Total Fee and Other Revenue + Net Interest Income`
  8. `Pre-Tax Income = Total Revenue - Provision for Credit Losses - Total Noninterest Expense`
  9. `Net Income Applicable to Common = Pre-Tax Income - Provision for Income Taxes - Preferred Dividends`
  10. `CET1 Capital = Total Common Equity - Goodwill & Intangibles - AOCI Adjustments`
  11. `CET1 Ratio = CET1 Capital / Risk-Weighted Assets (RWA)`
  12. `Share Repurchases = Net Income - Common Dividends - (Target CET1 Ratio x Change in RWA)`
  13. `Ending Share Count = Beginning Share Count - (Share Repurchases / Average Share Price)`
  14. `EPS = Net Income Applicable to Common / Average Diluted Shares Outstanding`
  15. `ROTCE = (Net Income - Preferred Dividends) / Average Tangible Common Equity`

Cross-Sheet Dependencies

  • AUM & AUC/A Roll-forward feeds directly into Segment Revenue to calculate fee income.
  • Average Balance Sheet & NIM feeds Net Interest Income into the Consolidated Income Statement.
  • Consolidated Income Statement generates Net Income, which feeds Retained Earnings on the Consolidated Balance Sheet and capital generation on the Capital & RWA Schedule.
  • Capital & RWA Schedule calculates share repurchases, which feeds back into the Consolidated Income Statement to calculate EPS (reducing share count) and impacts the Consolidated Balance Sheet (reducing cash and equity). *Note: This creates a minor circularity if share price is dynamically linked to EPS; builder should use a hardcoded forward P/E multiple or static share price for buyback math to avoid Excel errors.*

Sign Convention

  • Revenues: Positive.
  • Expenses: Positive on the expense build schedules, subtracted (negative impact) in the Income Statement.
  • Provision for Credit Losses: Positive number represents an expense (reduces income). A negative number represents a reserve release (increases income).
  • Net Flows (AUM/AUC): Positive for inflows, negative for outflows.
  • Dividends and Share Repurchases: Positive numbers representing outflows of capital.

Things Most Likely to Go Wrong

  1. Confusing AUM and AUC/A: BNY Mellon has ~$55T in AUC/A and ~$2T in AUM. Applying the wrong fee yield to the wrong base will result in revenue errors in the billions.
  2. NII Sensitivity: BNY Mellon's NII is highly sensitive to the mix of non-interest-bearing vs. interest-bearing deposits. Assuming a static deposit mix during a rate-cutting cycle will overstate NII.
  3. AOCI Volatility: Unrealised losses on the available-for-sale (AFS) securities portfolio impact tangible book value. The model must account for AOCI (Accumulated Other Comprehensive Income) amortisation as bonds pull to par.
  4. Fee Waivers: In zero-interest-rate environments, BNY Mellon has to waive fees on money market funds to prevent negative yields for clients. The model must have a toggle for money market fee waivers if rates approach zero.
  5. Operating Leverage Calculation: BNY Mellon management is compensated on generating positive operating leverage (Revenue Growth % minus Expense Growth %). The model must explicitly track this metric.
  6. Foreign Exchange Translation: A strong US Dollar depresses reported AUC/A and AUM (as international assets are translated to fewer dollars). The model should include an FX overlay for asset balances.
  7. Capital Return Constraints: The model cannot assume infinite share buybacks. Buybacks must be constrained by the 10.5% - 11.0% CET1 regulatory minimum plus a management buffer.
  8. Provision for Credit Losses: Unlike JPMorgan or Bank of America, BNY Mellon has very little credit risk. Do not model provisions as a standard % of total assets; they should be negligible unless modelling a specific macro stress event.

Validation Checks

  1. "CET1 Ratio must remain above 11.0%; flag if capital distributions push ratio below this threshold."
  2. "Total Assets must equal Total Liabilities + Equity."
  3. "NIM should be in the 1.10% - 1.40% range based on recent historicals."
  4. "Pre-tax operating margin should remain between 25% and 32%."
  5. "ROTCE should be between 18% and 25%; flag if it drops below cost of equity (~10%)."
  6. "Fee revenue should constitute 70% - 80% of Total Revenue (this is a trust bank, not a commercial bank)."
  7. "Effective tax rate should be between 22% and 24%."
  8. "Dividend payout ratio should not exceed 45% of Net Income."

Key Assumptions (Default Values)

AssumptionDefault ValueUnitRationale
AUC/A Annual Growth Rate6.0%Long-term equity market appreciation plus modest net new business.
AUM Annual Growth Rate4.0%Market appreciation offset by slight active management outflows.
Securities Services Fee Yield0.85bpsBlended yield on AUC/A; highly competitive pricing environment.
Investment Management Fee Yield14.5bpsBlended yield on AUM; reflects mix of active, passive, and cash.
Net Interest Margin (NIM)1.25%Normalised NIM in a mid-rate environment (down from 2023/2024 peaks).
Interest-Earning Asset Growth2.0%Modest balance sheet growth aligned with global GDP.
Staff Expense Growth3.0%Wage inflation offset by headcount rationalisation and AI efficiencies.
Non-Staff Expense Growth2.5%Strict expense discipline under the new platforms operating model.
Effective Tax Rate23.0%Historical average GAAP tax rate.
Target CET1 Ratio11.5%Management target, providing a buffer over regulatory minimums.
Dividend Payout Ratio35.0%Stated management policy for capital return.
Share Buyback Allocation100.0%% of excess capital (above target CET1 and dividends) used for buybacks.
Cost of Equity (Ke)9.5%Standard CAPM assumption for a systemically important, low-credit-risk trust bank.
Terminal Growth Rate2.0%Long-term GDP growth rate for terminal value calculation.

Data Sources & Benchmarks

  • SEC Filings: BNY Mellon Investor Relations website (investors.bnymellon.com) for 10-K, 10-Q, and Financial Supplements.
  • Call Reports: FFIEC Central Data Repository for detailed bank-level regulatory data.
  • Key Peers: State Street (STT), Northern Trust (NTRS), JPMorgan Chase (JPM - Securities Services division).
  • Industry Data: S&P Global Market Intelligence for global AUM/AUC league tables.
  • Consensus Estimates: FactSet or Bloomberg for forward EPS, NII, and fee revenue consensus.

Sources

Frequently asked

What kind of financial services does BNY Mellon provide?+

BNY Mellon primarily operates as a trust bank, offering investment management, investment services, and wealth management to institutions and high-net-worth individuals. Unlike traditional commercial banks, it focuses on custodying assets, clearing trades, and managing collateral, taking very little credit risk.

How does BNY Mellon generate its revenue?+

BNY Mellon's business model is asset-light and fee-driven, deriving revenue from its role as a trust bank and platform. Its primary segments include Securities Services, Market and Wealth Services, and Investment and Wealth Management, which collectively account for the vast majority of its revenue.

What are the key expense assumptions in a financial model for BNY Mellon?+

Key expense assumptions in a BNY Mellon financial model include COGS as 55% of revenue, SGA as 15% of revenue, and D&A as approximately 10.29% of revenue. Additionally, the model considers Capex as a percentage of revenue at about 7.55%.

What is the purpose of the BNY Mellon financial model for equity analysts?+

The BNY Mellon financial model helps equity research analysts forecast earnings, capital trajectory, and intrinsic equity value. This enables them to determine a target price and assess the bank's sensitivity to factors like interest rate changes, equity market levels, and deposit mix shifts.

Can I download an Excel financial model for BNY Mellon (BK)?+

Yes, an Excel financial model for BNY Mellon (BK) is available for download. This model provides forecasts for the company's financials from FY2026 through FY2030.

How does BNY Mellon's balance sheet differ from a traditional commercial bank?+

BNY Mellon's balance sheet is characterized by very low credit risk, with loans primarily consisting of margin loans and wealth management mortgages. Its liabilities are largely driven by operational client deposits, which are considered stickier than typical retail deposits.

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.

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.

HBAN.xlsx
Metric
2026
2027
Revenue
--
--
EBITDA
--
--
Huntington Bancshares logo

Huntington Bancshares

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

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