Bank of America Financial Model
Banking Company Financials Example (Free Excel Download)
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.
professionals from Deloitte
Used by professionals from
About this model
This model evaluates the equity valuation and capital return capacity of Bank of America Corporation (BAC) to help an equity research analyst forecast Net Interest Income (NII) sensitivity, credit loss provisions, and shareholder distributions under varying macroeconomic and interest rate scenarios.
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. The company operates a diversified, spread-based and fee-based business model that benefits from a massive low-cost deposit base and global scale.
Business segments include:
- Consumer Banking (approx. 38% of revenue): Retail banking, deposits, and consumer lending.
- Global Wealth & Investment Management (GWIM) (approx. 22% of revenue): Merrill Lynch and Bank of America Private Bank.
- Global Banking (approx. 21% of revenue): Corporate lending, global transaction services, and investment banking.
- Global Markets (approx. 21% of revenue): Sales and trading services for institutional clients.
The bank operates primarily in the United States for consumer operations, with a significant global footprint in its wholesale and markets businesses. Bank of America holds a top-two market share position in US retail deposits and competes directly with JPMorgan Chase, Wells Fargo, and Citigroup. Recent major events include navigating a high interest rate environment that boosted NII but created unrealised losses on Held-to-Maturity (HTM) securities, alongside preparations for the Basel III endgame regulatory capital rules.
The downloadable Bank of America 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 & AssumptionsBank of America financial modelCompany, Historicals & Assumptions used
Source: SEC EDGAR · values in USD
| Line item | FY2021 | FY2022 | FY2023 | FY2024 | FY2025 |
|---|---|---|---|---|---|
| Revenue | $89.11B | $94.95B | $102.77B | $105.86B | $113.10B |
| Net interest income | $42.93B | $52.46B | $56.93B | $56.06B | $60.10B |
| Total noninterest income | $46.18B | $42.49B | $41.65B | $45.83B | $53.00B |
| Net income | $31.98B | $27.53B | $26.30B | $26.97B | $30.51B |
Forecast assumptions
Defaults used in the downloadable model. Forecast horizon: FY2026–FY2030.
See 8 moreSee less
How to build a detailed financial model for Bank of America
A complete walkthrough of every driver, margin, working-capital input, and capital-allocation assumption used in the downloadable model.
Revenue Deep Dive
Consumer Banking
- Revenue driver formula: (Average Deposits + Average Loans) x Net Interest Yield + Noninterest Income (Card fees, service charges).
- Historical growth rate: 3-6% CAGR, highly sensitive to the Fed Funds rate.
- Key growth levers and headwinds: Digital banking adoption (over 58 million verified users), deposit beta (how much interest is passed to depositors), and consumer credit health.
- Pricing dynamics: Regulated fee structures (e.g., overdraft fee reductions) and highly competitive deposit pricing.
- Seasonality: Relatively stable, though card income peaks in the fourth quarter holiday season.
Global Wealth & Investment Management (GWIM)
- Revenue driver formula: (Average AUM x Blended Fee Yield) + (Brokerage Volume x Commission Rate) + NII on sweep deposits.
- Historical growth rate: 4-8% CAGR.
- Key growth levers and headwinds: Market appreciation, net new household generation, and advisor productivity.
- Pricing dynamics: Fee compression in asset management offset by volume growth.
- Seasonality: First quarter often sees higher seasonal tax-related client activity.
Global Banking
- Revenue driver formula: Investment Banking Fees (Advisory + Underwriting) + Corporate Loan NII + Treasury Services Fees.
- Historical growth rate: 2-5% CAGR, highly cyclical.
- Key growth levers and headwinds: M&A volumes, capital markets issuance activity, and corporate loan demand.
- Pricing dynamics: Competitive league table pricing for IB fees; floating rate dynamics for corporate loans.
- Seasonality: Deal closures often skew towards the fourth quarter.
Global Markets
- Revenue driver formula: FICC Trading Revenue + Equities Trading Revenue (excluding Net DVA).
- Historical growth rate: Flat to 5% CAGR, volatile.
- Key growth levers and headwinds: Market volatility, client hedging demand, and bid-ask spreads.
- Pricing dynamics: Spot pricing based on market liquidity.
- Seasonality: First quarter is typically the strongest due to client capital deployment.
Cost Structure
Variable Costs / COGS
Unlike standard corporates, banks do not have traditional COGS. The primary "variable" costs are Interest Expense (which is netted against Interest Income to form Net Interest Income) and the Provision for Credit Losses.
- Provision for Credit Losses: Driven by Net Charge-Offs (NCOs) and changes in the Allowance for Credit Losses (ACL).
- Interest Expense: Scales with the Fed Funds rate and the bank's deposit beta.
Operating Expenses (Noninterest Expense)
- Compensation and Benefits: The largest expense category, representing roughly 50-55% of total noninterest expense. Highly variable in GWIM and Global Markets due to revenue-linked bonus pools.
- Technology and Equipment: Significant ongoing investment (approx. $3-4 billion annually) to maintain digital banking leadership.
- Occupancy: Costs associated with the network of approx. 3,600 financial centres.
- Restructuring / one-time charges: Occasional FDIC special assessments or severance charges, though not a regular feature of core operations.
Margin Profile
- Efficiency Ratio: The standard bank margin metric (Noninterest Expense / Total Revenue). Bank of America typically targets an efficiency ratio below 60%, with recent years ranging from 60% to 63%.
- Net Interest Margin (NIM): Typically ranges from 1.90% to 2.40%, expanding in rising rate environments and compressing when rates fall.
- Return on Tangible Common Equity (ROTCE): Typically ranges from 13% to 16%.
Balance Sheet Structure
- Total assets: Approximately $3.4 trillion.
- Key asset categories: Cash and cash equivalents, Investment Securities (Available-for-Sale and Held-to-Maturity), and Loans and Leases (approx. $1.19 trillion).
- Goodwill & intangibles: Approximately $69 billion, largely stemming from historical acquisitions of Merrill Lynch, Countrywide, and MBNA.
- Working capital profile: Not applicable for banks. The critical liquidity metric is the Loan-to-Deposit ratio, which typically runs at a conservative 55% to 65% (approx. $1.19 trillion in loans vs. $2.02 trillion in deposits).
- PP&E: Minimal relative to total assets, consisting mainly of branch real estate and data centres.
Capital Expenditure & Investment
- Capex as % of revenue: Typically 2-4% of revenue, categorised under technology and equipment investments.
- Maintenance vs. growth: Heavily skewed towards growth and efficiency (digital platform enhancements, AI integration, and branch modernisation).
- M&A pattern: Bank of America is restricted from acquiring other US depository institutions because it holds more than 10% of all US retail deposits. Growth is entirely organic.
Debt & Capital Structure
- Total debt: Long-term debt is approximately $280-300 billion, used for holding company liquidity and TLAC (Total Loss-Absorbing Capacity) requirements.
- Capital Ratios: Common Equity Tier 1 (CET1) ratio is the primary constraint, recently sitting at 11.4%, well above regulatory minimums.
- Credit rating: A- to A+ range across major rating agencies.
- Share repurchase programme: Highly active. The bank regularly repurchases shares, returning excess capital to shareholders (e.g., $6.3 billion repurchased in Q4 2025 alone).
- Dividend policy: Progressive dividend policy, recently paying $0.26 per quarter with a payout ratio typically between 25% and 30% of net income.
Cash Flow Characteristics
- Operating cash flow: Not a primary valuation metric for banks. Cash flows are heavily distorted by changes in trading assets, trading liabilities, and customer deposits.
- Free cash flow: Analysts use Free Cash Flow to Equity (FCFE) or a Dividend Discount Model (DDM) based on capital return capacity rather than traditional FCF.
- Capital return capacity: Driven by Net Income minus the capital required to fund Risk-Weighted Asset (RWA) growth and maintain the target CET1 ratio.
- Effective tax rate: Typically 8-12% on a reported basis, benefiting from tax-exempt income (municipal bonds) and ESG-related tax credits (affordable housing and renewable energy).
Sheet Structure
- Assumptions: Macroeconomic drivers (Fed Funds rate, GDP growth), segment growth rates, NIM, efficiency ratio, and capital return targets.
- Summary & Scenarios: Dashboard showing EPS, ROTCE, CET1, and valuation under Base, Bull, and Bear interest rate scenarios.
- Income Statement: Consolidated view splitting Net Interest Income and Noninterest Income, Provision for Credit Losses, and Noninterest Expense.
- Balance Sheet: Consolidated view focusing on Average Earning Assets, Loans, Deposits, and Equity.
- Segment - Consumer Banking: Revenue (NII and Noninterest), Provision, Noninterest Expense, and allocated capital.
- Segment - GWIM: AUM roll-forward, fee yields, brokerage revenue, and segment margins.
- Segment - Global Banking: Investment banking fees, corporate loan balances, and treasury services revenue.
- Segment - Global Markets: FICC and Equities trading revenue (excluding DVA), and trading-related expenses.
- Loan Book & Credit Quality: Loan balances by category (Consumer, Commercial), Net Charge-Offs, and Allowance for Credit Losses (ACL) roll-forward.
- Capital & Returns: Risk-Weighted Assets (RWA) calculation, CET1 ratio roll-forward, dividend payouts, and share repurchases.
- Valuation: Dividend Discount Model (DDM) and Price to Tangible Book Value (P/TBV) regression.
Key Financial Relationships
- Consolidated NII = Average Earning Assets x Net Interest Margin (NIM).
- Total Revenue = Net Interest Income (FTE basis) + Noninterest Income.
- Provision for Credit Losses = Net Charge-Offs + Change in Allowance for Credit Losses.
- Efficiency Ratio = Total Noninterest Expense / Total Revenue (net of interest expense).
- GWIM Asset Management Fees = Average AUM x Blended Fee Yield.
- Global Markets Revenue = FICC Revenue + Equities Revenue + Net DVA.
- Tangible Common Equity = Total Shareholders' Equity - Preferred Stock - Goodwill - Intangible Assets.
- Return on Tangible Common Equity (ROTCE) = (Net Income - Preferred Dividends) / Average Tangible Common Equity.
- CET1 Capital = Tangible Common Equity + Regulatory Adjustments (e.g., AOCI filters depending on Basel III rules).
- CET1 Ratio = CET1 Capital / Risk-Weighted Assets.
- Capital Generation = Net Income - Dividends Paid - Share Repurchases.
- Ending Share Count = Beginning Share Count - (Share Repurchases / Average Share Price).
Cross-Sheet Dependencies
- The Assumptions sheet dictates the interest rate environment, which feeds the Balance Sheet (deposit pricing) and Income Statement (NIM).
- The four Segment sheets aggregate to feed the Consolidated Income Statement.
- The Loan Book & Credit Quality sheet calculates the Provision for Credit Losses, which feeds directly into the Income Statement and alters the Allowance for Credit Losses on the Balance Sheet.
- The Income Statement generates Net Income, which flows to the Capital & Returns sheet to determine dividend capacity and share repurchases.
- Share repurchases from the Capital & Returns sheet reduce the share count, which loops back to calculate EPS on the Summary sheet.
Sign Convention
- Assets and Revenue are entered and displayed as positive numbers.
- Liabilities and Equity are entered as positive numbers.
- Expenses (Noninterest Expense, Interest Expense) are entered as positive numbers and subtracted in formulas.
- Provision for Credit Losses is entered as a positive number and subtracted from Pre-Tax Pre-Provision Income.
- Contra-assets (such as the Allowance for Credit Losses) are entered as negative numbers and summed with gross loans to yield net loans.
- Net Charge-Offs are entered as positive numbers but reduce the ACL balance in the roll-forward.
Things Most Likely to Go Wrong
- Attempting to model Bank of America using EBITDA or standard Free Cash Flow. These metrics are meaningless for banks.
- Failing to adjust for Fully Taxable Equivalent (FTE) NII. The bank reports NII on an FTE basis to account for tax-exempt municipal bond income. The model must reconcile FTE revenue to GAAP revenue.
- Misunderstanding the Provision for Credit Losses. The provision is not just actual defaults (NCOs); it includes forward-looking reserve builds or releases based on macroeconomic forecasts (CECL accounting).
- Ignoring the impact of Debit Valuation Adjustments (DVA) in Global Markets. DVA should be excluded when assessing the core operating performance of the trading business.
- Double-counting interest expense. Interest expense is already deducted to arrive at Net Interest Income. It should not be deducted again in operating expenses.
- Overestimating capital return capacity. Share buybacks are strictly constrained by the CET1 ratio. If Risk-Weighted Assets grow rapidly, the bank must retain more capital, reducing buybacks.
- Miscalculating Tangible Book Value. Goodwill and intangibles must be stripped out of total equity, as bank valuations (P/TBV) rely heavily on tangible metrics.
- Ignoring AOCI (Accumulated Other Comprehensive Income). Unrealised losses on Available-for-Sale securities impact tangible book value and must be tracked in the equity roll-forward.
Validation Checks
- Balance sheet must balance: Total Assets = Total Liabilities + Shareholders' Equity in every period.
- Efficiency Ratio should remain between 58% and 65%. Flag if it drops below 55% or exceeds 68%.
- CET1 Ratio must remain above the regulatory minimum plus management buffer (typically flag if it drops below 10.5%).
- Loan-to-Deposit ratio should remain between 55% and 70%.
- Net Interest Margin (NIM) should stay within the historical bound of 1.90% to 2.40%.
- Return on Tangible Common Equity (ROTCE) should be in the 12% to 17% range.
- Dividend payout ratio should not exceed 35% of net income without triggering a warning.
- Total Revenue must equal the sum of the four operating segments plus the "All Other" corporate segment.
Key Assumptions (Default Values)
| Assumption | Default Value | Unit | Rationale |
|---|---|---|---|
| Total Revenue Growth | 5.0 | % | Blended expectation based on recent 7% growth and normalised NII outlook. |
| Net Interest Margin (NIM) | 2.10 | % | Reflects current interest rate environment and deposit beta stabilisation. |
| Efficiency Ratio | 62.0 | % | Aligns with recent FY2025 reported efficiency ratio. |
| Net Charge-Off Ratio | 0.40 | % | Normalised consumer and commercial credit loss rate. |
| Effective Tax Rate | 10.0 | % | Reflects historical average benefiting from tax-exempt investments and ESG credits. |
| CET1 Target Ratio | 11.4 | % | Matches the bank's actual Q4 2025 reported CET1 ratio. |
| Annual Dividend Per Share | 1.04 | $ | Based on the recent $0.26 quarterly dividend rate. |
| Annual Share Repurchases | 20.0 | $B | Assumes continuation of strong capital return (approx. $5-6B per quarter). |
| Cost of Equity (Ke) | 10.0 | % | Standard assumption for a G-SIB (Global Systemically Important Bank) in the current rate environment. |
| Terminal P/TBV Multiple | 1.5 | x | Historical average trading multiple for BAC generating ~14% ROTCE. |
Data Sources & Benchmarks
- Filings: SEC EDGAR (10-K, 10-Q), Bank of America Investor Relations website (Earnings Releases, Financial Supplements).
- Key Peers: JPMorgan Chase (JPM), Wells Fargo (WFC), Citigroup (C), Morgan Stanley (MS), Goldman Sachs (GS).
- Industry Data: Federal Reserve H.8 (Assets and Liabilities of Commercial Banks), FDIC Quarterly Banking Profile.
- Consensus Estimates: Bloomberg, FactSet, or Visible Alpha for NII and EPS consensus.
Sources
Do more with the Bank of America model
Frequently asked
What is Bank of America's primary business model?+
Bank of America operates a diversified, spread-based and fee-based business model, serving individual consumers, small and middle-market businesses, and large corporations. It offers a full range of banking, investing, asset management, and risk management products, benefiting from a massive low-cost deposit base and global scale.
How does Bank of America generate its revenue across different segments?+
Bank of America generates revenue through Consumer Banking, Global Wealth & Investment Management (GWIM), Global Banking, and Global Markets segments. Its business model benefits from both net interest income on its massive low-cost deposit base and various fee-based services from its diversified operations.
What are the key assumptions for Bank of America's financial model regarding revenue growth and capital expenditure?+
The financial model for Bank of America assumes a revenue growth rate of approximately 3.02%. Capital expenditure is projected at 3% of revenue, heavily skewed towards growth and efficiency investments such as digital platform enhancements and AI integration.
What is the purpose of the Bank of America financial model for equity analysts?+
The Bank of America financial model helps equity research analysts evaluate the company's equity valuation and capital return capacity. It is used to forecast Net Interest Income sensitivity, credit loss provisions, and shareholder distributions under varying macroeconomic and interest rate scenarios.
Can I download an Excel financial model for Bank of America (BAC)?+
Yes, an Excel financial model for Bank of America (BAC) is available for download. This model provides a forecast horizon from FY2026 to FY2030, offering detailed projections for the company's financial performance.
What is Bank of America's strategy for growth given its M&A restrictions?+
Bank of America is restricted from acquiring other US depository institutions because it holds more than 10% of all US retail deposits. Therefore, its growth strategy is entirely organic, focusing on internal investments like digital platforms and branch modernization.
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.
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.
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.
