Wells Fargo Financial Model

For a bank, revenue is split into Net Interest Income and Noninterest Income.

Net Interest Income (NII)

• Segment name: Net Interest Income (Consolidated, but driven by segment loan and deposit balances).
• Revenue driver formula: Average Interest-Earning Assets x Net Interest Margin (NIM).
• Historical growth rate: Highly variable based on the rate cycle; recently flat to slightly down as deposit costs caught up with asset yields.
• Key growth levers and headwinds: Loan volume growth (unlocked by asset cap removal), deposit betas, and Federal Reserve interest rate policy.
• Pricing dynamics: Floating rate commercial loans reprice quickly, whilst fixed-rate mortgages and securities portfolios lag.
• Revenue recognition notes: Interest income is recognised over the life of the loan using the effective interest method.
• Seasonality: Minimal, though day-count conventions make Q1 slightly lower than Q4.

Noninterest Income

• Segment name: Noninterest Income (comprising Investment advisory fees, Investment banking fees, Card fees, Trading revenue).
• Revenue driver formula: Assets Under Management x Blended Fee Rate (for WIM) plus Transaction Volumes x Take Rate (for Cards and Investment Banking).
• Historical growth rate: 3% to 5% CAGR over the last three years.
• Key growth levers and headwinds: Equity market valuations driving AUM, capital markets activity (M&A and debt issuance), and consumer spending volumes.
• Pricing dynamics: Highly competitive in wealth management; investment banking fees are cyclical and deal-dependent.
• Revenue recognition notes: Recognised when performance obligations are satisfied (e.g., upon deal closure for advisory, or monthly for AUM fees).
• Seasonality: Q4 is typically strong for investment banking and card spending.

• Total assets: Approximately $2.1 trillion as of year-end 2025.
• Key asset categories: Loans ($986 billion), Investment Securities (Available-for-Sale and Held-to-Maturity), and Cash/Short-term investments.
• Goodwill & intangibles: Minor relative to total assets, stemming from historical acquisitions like Wachovia.
• Working capital profile: Not applicable for banks. Focus is on the Loan-to-Deposit ratio, which sits around 69% to 70%.
• Allowance for Credit Losses (ACL): A critical contra-asset account, currently sitting at 1.45% of total loans.
• PP&E: Represents bank branches and corporate offices; relatively small compared to financial assets.

• Capex as % of revenue: Not a primary metric for banks. Focus is on capitalised software and branch refurbishments.
• Maintenance vs. growth: Heavily skewed towards technology investments for digital banking and risk management infrastructure.
• Major programmes: Core system modernisation and artificial intelligence integration.
• M&A pattern: Historically a major acquirer, but restricted from M&A for years due to regulatory issues. Currently focused on organic growth following the asset cap removal.

• Total debt: Long-term debt is used for structural funding and Total Loss Absorbing Capacity (TLAC) requirements.
• Capital ratios: Common Equity Tier 1 (CET1) ratio of 10.6% as of Q4 2025.
• Regulatory minimum: Total CET1 requirement is 8.5% (including a 2.5% Stress Capital Buffer and 1.5% G-SIB surcharge).
• Covenants: Regulatory capital minimums act as the primary constraints rather than traditional debt covenants.
• Share repurchase programme: Highly active. The bank repurchased $18 billion in 2025 and authorised a new $40 billion programme.
• Dividend policy: Quarterly dividend of $0.40 per share, yielding approximately 2.0% to 2.5%, with a payout ratio target of around 30%.

• Operating cash flow: Less relevant for banks than industrial companies.
• Valuation basis: Dividend Discount Model (DDM) or Free Cash Flow to Equity (FCFE) is used instead of traditional unlevered free cash flow.
• FCFE definition: Net Income minus Change in Regulatory Capital Required.
• Major non-cash items: Provision for credit losses (adds back to cash flow, whilst actual net charge-offs reduce capital).
• Cash tax rate: Generally tracks the statutory rate, adjusted for tax-exempt municipal bond income and low-income housing tax credits.

1. Assumptions: Hardcoded drivers for loan growth, deposit betas, NIM, fee income growth, efficiency ratio, and capital return targets.
2. Summary: Dashboard showing EPS, ROTCE, CET1 ratio, and valuation outputs.
3. Average Balances: Projection of average interest-earning assets and interest-bearing liabilities, which drives NII.
4. Income Statement: Consolidated P&L showing NII, noninterest income by segment, noninterest expense, and provision for credit losses.
5. Credit Quality: Roll-forward of the Allowance for Credit Losses (Beginning ACL + Provision - Net Charge-Offs = Ending ACL).
6. Balance Sheet: Period-end assets, liabilities, and equity.
7. Capital & RWA: Calculation of Risk-Weighted Assets, CET1 capital, and excess capital available for share repurchases.
8. Valuation: Dividend Discount Model and Price/Tangible Book Value multiple valuation.

1. Net Interest Income = Average Interest-Earning Assets x Net Interest Margin.
2. Consumer Banking Revenue = Consumer Net Interest Income + Consumer Noninterest Income.
3. Total Noninterest Expense = Total Revenue x Efficiency Ratio.
4. Pre-Tax Pre-Provision Income (PTPP) = Total Revenue - Total Noninterest Expense.
5. Ending ACL = Beginning ACL + Provision for Credit Losses - Net Charge-Offs.
6. Provision for Credit Losses = Net Charge-Offs + (Ending Total Loans x Target Reserve Coverage Ratio) - Beginning ACL.
7. Net Income = PTPP - Provision for Credit Losses - Taxes.
8. Tangible Common Equity = Total Common Equity - Goodwill - Intangible Assets.
9. ROTCE = Annualised Net Income / Average Tangible Common Equity.
10. CET1 Ratio = CET1 Capital / Risk-Weighted Assets.
11. Share Repurchases = Net Income - Common Dividends - (Change in RWA x Target CET1 Ratio).
12. Ending Share Count = Beginning Share Count - (Share Repurchases / Average Share Price).

The Average Balances sheet feeds the Income Statement to calculate Net Interest Income. The Income Statement generates Net Income, which flows to the Capital & RWA sheet to determine organic capital generation. The Capital & RWA sheet calculates excess capital, which dictates the Share Repurchases line. Share Repurchases flow back to the Balance Sheet to reduce Common Equity and to the Summary sheet to reduce the share count for EPS calculations. This creates a circular reference between share count, EPS, and share price, which must be managed with a circuit breaker or iterative calculation.

• Assets and Liabilities: Positive on the balance sheet.
• Revenue and Net Interest Income: Positive.
• Noninterest Expense: Positive (subtracted in PTPP formulas).
• Provision for Credit Losses: Positive (subtracted from PTPP to reach pre-tax income).
• Net Charge-Offs: Positive (subtracted from the ACL roll-forward).
• Share Repurchases: Positive (subtracted from equity in the balance sheet).

• Confusing period-end balances with average balances when calculating Net Interest Income.
• Failing to link the Provision for Credit Losses on the Income Statement to the ACL roll-forward on the Balance Sheet.
• Ignoring the impact of Accumulated Other Comprehensive Income (AOCI) on tangible book value and regulatory capital.
• Creating an unresolvable circular reference when modelling share repurchases based on a target CET1 ratio.
• Overestimating loan growth without proportionally increasing Risk-Weighted Assets and the required capital buffer.
• Applying a generic tax rate instead of accounting for the bank's historical tax-advantaged investments.
• Miscalculating ROTCE by using total equity instead of tangible common equity.
• Forgetting that the asset cap was lifted in mid-2025, meaning historical growth rates from 2018 to 2024 are artificially depressed and not indicative of future performance.

• Balance sheet must balance: Total Assets = Total Liabilities + Total Equity in every period.
• CET1 Ratio must remain above the 8.5% regulatory minimum in all forecast periods.
• Efficiency Ratio should remain between 60% and 68%; flag if it drops below 60% as this is historically unprecedented for this bank.
• Reserve Coverage Ratio (ACL / Total Loans) should remain near the 1.45% historical average unless a severe recession is modelled.
• Loan-to-Deposit ratio should not exceed 85% (currently around 69%).
• Dividend payout ratio should remain between 25% and 35% of net income.
• ROTCE should trend towards the management target of 17% to 18%.

• Where to find filings: SEC EDGAR database and the Wells Fargo Investor Relations page (financial supplements are critical for average balances).
• Key peers for benchmarking: JPMorgan Chase (JPM), Bank of America (BAC), Citigroup (C).
• Industry data sources: Federal Reserve H.8 data (Assets and Liabilities of Commercial Banks) for macro loan growth trends.
• Consensus estimates source: Bloomberg or FactSet for forward EPS and NIM expectations.

• Wells Fargo 2025 Annual Report and Form 10-K (filed February 2026)
• Wells Fargo Q4 2025 Earnings Release and Financial Supplement (January 14, 2026)
• Morningstar DBRS Credit Rating Report for Wells Fargo (March 2026)
• Federal Reserve press releases regarding the lifting of the Wells Fargo asset cap (mid-2025)