Charles Schwab Financial Model
Capital Markets Company Financials Example (Free Excel Download)
The Charles Schwab Corporation (SCHW) is a leading American financial services firm providing wealth management, securities brokerage, banking, asset management, custody, and financial advisory services.
professionals from Deloitte
Used by professionals from
About this model
This model forecasts Charles Schwab’s earnings, balance sheet trajectory, and equity valuation to determine if the stock is mispriced, focusing specifically on the expansion of its Net Interest Margin (NIM) as high-cost supplemental funding rolls off and client cash sorting stabilises.
The Charles Schwab Corporation (SCHW) is a leading American financial services firm providing wealth management, securities brokerage, banking, asset management, custody, and financial advisory services. The company operates a massive platform serving individual investors and independent registered investment advisors (RIAs), monetising client assets primarily through interest spreads, asset management fees, and trading activity.
- Business segments: Net Interest Revenue (~49% of net revenues), Asset Management and Administration Fees (~25%), Trading Revenue (~18%), and Other Revenue (~8%).
- Key geographies: Primarily the United States, with a growing but small international footprint.
- Business model type: Asset-light wealth management platform attached to an asset-heavy banking subsidiary (Charles Schwab Bank).
- Competitive position: The largest publicly traded U.S. retail brokerage by client assets ($11.90 trillion as of year-end 2025), competing with Morgan Stanley, Fidelity, and interactive brokers.
- Recent major events: The aggressive paydown of high-cost supplemental bank borrowings (from ~$50 billion in late 2024 to $5.1 billion in Q4 2025), and the March 2026 acquisition of private markets platform Forge Global.
The downloadable Charles Schwab 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 & AssumptionsCharles Schwab financial modelCompany, Historicals & Assumptions used
Source: SEC EDGAR · values in USD
| Line item | FY2021 | FY2022 | FY2023 | FY2024 | FY2025 |
|---|---|---|---|---|---|
| Revenue | $18.52B | $20.76B | $18.84B | $19.61B | $23.92B |
| Income before taxes on income | $7.71B | $9.39B | $6.38B | $7.69B | $11.46B |
| Total expenses excluding interest | $10.81B | $11.37B | $12.46B | $11.91B | $12.46B |
| Net income | $5.9M | $7.2M | $5.1M | $5.9M | $8.9M |
Forecast assumptions
Defaults used in the downloadable model. Forecast horizon: FY2026–FY2030.
See 8 moreSee less
How to build a detailed financial model for Charles Schwab
A complete walkthrough of every driver, margin, working-capital input, and capital-allocation assumption used in the downloadable model.
Revenue Deep Dive
Net Interest Revenue (NIR)
- Segment name: Net Interest Revenue
- Revenue driver formula: Average Interest-Earning Assets x Net Interest Margin (NIM)
- Historical growth rate: Highly cyclical based on interest rates; grew 25% YoY in Q4 2025.
- Key growth levers and headwinds: Driven by client cash sweep balances, bank loan originations (e.g., Pledged Asset Lines), and the yield curve. Headwinds include "cash sorting" (clients moving uninvested cash into higher-yielding money market funds, forcing Schwab to use expensive short-term wholesale funding).
- Pricing dynamics: Highly sensitive to the Federal Funds rate and the spread between asset yields (mortgages, agency MBS) and deposit costs.
- Seasonality: Minor seasonality; more dependent on macroeconomic rate cycles than calendar quarters.
Asset Management and Administration Fees (AMAF)
- Segment name: Asset Management and Administration Fees
- Revenue driver formula: Average Client Assets in Managed Funds/Solutions x Average Fee Rate (bps)
- Historical growth rate: 10-15% CAGR (grew 15% YoY in Q4 2025).
- Key growth levers and headwinds: Market appreciation of underlying equities/bonds and core net new asset (NNA) inflows.
- Pricing dynamics: Fee compression is a long-term industry trend, but Schwab offsets this by shifting clients into proprietary ETFs, mutual funds, and advisory solutions.
Trading Revenue
- Segment name: Trading Revenue
- Revenue driver formula: Total Trades x Average Revenue per Trade (or modelled as a % of total client assets)
- Historical growth rate: Volatile; grew 22% YoY in Q4 2025 due to strong market engagement.
- Key growth levers and headwinds: Market volatility (VIX) and retail engagement drive volumes. Zero-commission trading on equities means revenue is heavily reliant on options, futures, and fixed-income trading spreads.
Cost Structure
Variable Costs / COGS
As a financial institution, Schwab does not report traditional COGS or Gross Margin. The closest equivalent is Interest Expense, which is netted against Interest Income to produce Net Interest Revenue.
Operating Expenses
- Compensation and Benefits: The largest expense line, driven by headcount, salary inflation, and incentive compensation tied to financial performance.
- Professional Services: Consulting, legal, and outsourced technology services.
- Occupancy and Equipment: Branch network leases, data centres, and physical infrastructure.
- Advertising and Market Development: Client acquisition costs, highly variable and can be dialled back during market downturns.
- Communications and Data Processing: Market data feeds, clearing fees, and cloud infrastructure.
- Depreciation & Amortisation: Capitalised software and intangible amortisation from acquisitions (e.g., TD Ameritrade, Forge Global).
Margin Profile
- Pre-tax Profit Margin: 47.9% GAAP / 50.0% Adjusted for full-year 2025.
- Margin trend: Expanding. Pre-tax margins expanded from 43.3% in Q4 2024 to 50.2% in Q4 2025 due to the runoff of expensive supplemental funding and operating leverage on higher asset bases.
Balance Sheet Structure
- Total assets: ~$465 billion to $490 billion as of year-end 2025.
- Key asset categories: Available-for-Sale (AFS) securities, Held-to-Maturity (HTM) securities, Bank Loans ($58.0 billion), Margin Loans, and Cash/Cash Equivalents.
- Goodwill & intangibles: Significant, stemming from the TD Ameritrade and Forge Global acquisitions.
- Working capital profile: Not applicable in the traditional corporate sense. Liquidity is managed via the bank's deposit base, FHLB advances, and broker-dealer cash.
- Client Cash Allocation: A critical metric; client cash sat at 9.6% of average assets in late 2025, below the historical 11.4% average.
Capital Expenditure & Investment
- Capex as % of revenue: Typically 3-5%, heavily skewed towards capitalised software development and technology infrastructure.
- Maintenance capex vs. growth capex: Majority is growth capex for platform enhancements, AI-driven service efficiency, and trading infrastructure.
- M&A pattern: Transformational and bolt-on. Acquired TD Ameritrade (transformational) and recently acquired Forge Global for $45/share in cash (closed March 2026) to expand private market access.
Debt & Capital Structure
- Total debt: Comprises corporate senior notes and bank supplemental funding (FHLB advances). Supplemental funding was aggressively paid down to $5.1 billion by Q4 2025.
- Credit rating: S&P rating of A- with a stable outlook.
- Tier 1 Leverage Ratio: Ended Q2 2025 at 9.8%, representing strong regulatory capital.
- Share repurchase programme: Highly active. Repurchased 29.2 million shares for $2.7 billion in Q4 2025 alone.
- Dividend policy: 1.3% yield, with a payout ratio in the low-20% range. Increased dividend by 8% to $0.27 per share per quarter in early 2025.
Cash Flow Characteristics
- Operating cash flow: Heavily distorted by client cash movements (payables to brokerage clients) and trading asset fluctuations.
- Free cash flow: For financial institutions, dividend discount models (DDM) or residual income models are preferred over traditional unlevered free cash flow due to the regulatory capital requirements tied to asset growth.
- Major non-cash items: Depreciation, amortisation of intangibles, stock-based compensation, and provision for credit losses.
Sheet Structure
- Assumptions: Hardcoded drivers for client assets, NIM, fee rates, and expense growth.
- Client Metrics: Roll-forward of Total Client Assets (Beginning Balance + Net New Assets + Market Appreciation = Ending Balance) and Active Brokerage Accounts.
- Average Balances & Yields: Detailed schedule of interest-earning assets (investments, margin loans, bank loans) and interest-bearing liabilities (deposits, supplemental funding) with associated yields/costs to calculate Net Interest Revenue.
- Income Statement: Segment revenues (NIR, AMAF, Trading, Other), detailed operating expenses, pre-tax income, taxes, and net income.
- Balance Sheet: Assets (Cash, Investments, Loans, Goodwill) and Liabilities (Deposits, Payables to Clients, Debt, Equity).
- Capital & Dividends: Tracking of Tier 1 Leverage, risk-weighted assets, share repurchases, and dividend payouts.
- Valuation (DDM / P/E): Dividend Discount Model and forward P/E multiple valuation based on adjusted EPS.
Key Financial Relationships
- `Total Client Assets = Prior Period Client Assets + Core Net New Assets + Market Impact`
- `Asset Management and Administration Fees = Average Total Client Assets x Implied AMAF Yield (bps)`
- `Net Interest Revenue = (Average Interest-Earning Assets x Asset Yield) - (Average Interest-Bearing Liabilities x Liability Cost)`
- `Net Interest Margin (NIM) = Annualised Net Interest Revenue / Average Interest-Earning Assets`
- `Trading Revenue = Active Brokerage Accounts x Average Trades per Account x Revenue per Trade`
- `Total Net Revenues = Net Interest Revenue + AMAF + Trading Revenue + Other Revenue`
- `Total Expenses Excluding Interest = Compensation + Professional Services + Occupancy + Advertising + Communications + D&A`
- `Pre-Tax Income = Total Net Revenues - Total Expenses Excluding Interest`
- `Adjusted Net Income = GAAP Net Income + Acquisition/Integration Costs (after-tax) + Amortisation of Acquired Intangibles (after-tax)`
- `Ending Shares Outstanding = Beginning Shares - (Share Repurchase Amount / Average Share Price)`
Cross-Sheet Dependencies
- Client Metrics feeds Average Balances & Yields (client cash sweep balances dictate deposit levels) and Income Statement (total assets drive AMAF).
- Average Balances & Yields feeds the Income Statement (calculates Net Interest Revenue).
- Income Statement feeds Balance Sheet (Retained Earnings) and Capital & Dividends (Net Income drives organic capital generation).
- Capital & Dividends feeds Balance Sheet (reduces Cash and Equity via share repurchases and dividends).
Sign Convention
- Revenues: Positive
- Expenses: Positive (subtracted in subtotal formulas: `Revenue - Expenses`)
- Assets: Positive
- Liabilities & Equity: Positive (Balance Sheet check: `Assets - (Liabilities + Equity) = 0`)
- Net Outflows/Repurchases: Positive inputs, subtracted in ending balance formulas.
Things Most Likely to Go Wrong
- Mismodelling Cash Sorting: Assuming client cash allocations return to historical averages (11.4%) too quickly; they are currently depressed at ~9.6%.
- Supplemental Funding Drag: Failing to remove the interest expense drag of FHLB advances, which were largely paid down by the end of 2025.
- AOCI / Unrealised Losses: Ignoring the impact of unrealised losses on the HTM/AFS portfolio, which affects tangible book value (though regulatory capital rules for Schwab currently filter some of this out).
- GAAP vs. Adjusted EPS: Confusing GAAP net income with Adjusted net income. Schwab excludes acquisition-related costs and intangible amortisation from its adjusted figures, which the Street uses for valuation.
- NIM Calculation: Calculating NIM using total assets rather than *Average Interest-Earning Assets*.
- Asset Growth vs. Capital: Forecasting massive balance sheet growth without accounting for the regulatory capital (Tier 1 Leverage) required to support it, which would restrict share repurchases.
- Interest Rate Sensitivity: Hardcoding a static NIM rather than linking it to a dynamic yield curve and deposit beta assumption.
- M&A Stub Periods: Failing to account for the mid-quarter close of the Forge Global acquisition (March 2026).
Validation Checks
- "Net Interest Margin (NIM) should be between 2.70% and 3.00% based on 2025/2026 guidance; flag if outside this band."
- "Pre-tax profit margin should be ~50%; flag if it drops below 45% or exceeds 55%."
- "Client cash as a percentage of total client assets should remain between 9.0% and 11.5%."
- "Tier 1 Leverage Ratio must remain above the regulatory minimum (target ~9.5% - 10.0%)."
- "Balance sheet must balance: Total Assets = Total Liabilities + Stockholders' Equity in every period."
- "Core Net New Assets (NNA) organic growth rate should be in the 4.0% - 6.0% range (historically ~5.1%)."
- "Effective tax rate should be approximately 23-24%."
Key Assumptions (Default Values)
| Assumption | Default Value | Unit | Rationale |
|---|---|---|---|
| Total Client Assets (Starting 2026) | 11.90 | $ Trillions | Actual year-end 2025 figure |
| Core Net New Assets (NNA) Growth | 5.1 | % | Actual 2025 organic growth rate |
| Net Interest Margin (NIM) | 2.90 | % | Q4 2025 actual, aligns with 2026 guidance of 2.85%-2.95% |
| Client Cash Allocation | 9.6 | % of Assets | Actual late 2025 allocation |
| AMAF Effective Fee Rate | 14.5 | bps | Implied from 2025 run-rate on total assets |
| Expense Growth Ceiling | 5.5 | % YoY | Management guidance for 2026 |
| Pre-Tax Margin (Adjusted) | 50.0 | % | Actual full-year 2025 adjusted margin |
| Bank Loans Growth | 15.0 | % YoY | Conservative step-down from 28% growth in 2025 |
| Supplemental Funding Balance | 5.1 | $ Billions | Q4 2025 ending balance |
| Share Repurchases | 2.7 | $ Billions / Qtr | Q4 2025 actual run-rate |
| Dividend per Share | 0.27 | $ / Qtr | Actual Q1 2025 increased dividend |
| Effective Tax Rate | 23.5 | % | Historical average for US-centric financial |
| Target P/E Multiple | 18.0 | x | Historical forward multiple for SCHW |
Data Sources & Benchmarks
- SEC EDGAR: The Charles Schwab Corporation (CIK: 0000316709) for 10-K, 10-Q, and 8-K filings.
- Investor Relations: aboutschwab.com for monthly activity reports (critical for tracking NNA and client cash balances).
- Key Peers: Morgan Stanley (MS) - specifically the E*TRADE/Wealth Management division, Bank of America (BAC) - Merrill Edge, Interactive Brokers (IBKR), and Robinhood (HOOD).
- Industry Data: Federal Reserve H.8 data for banking industry loan and deposit trends; SIFMA for retail trading volume benchmarks.
Sources
- mlq.ai: Charles Schwab Reports Q4 2025 Revenue Below Expectations Despite Profit Gains
- macrotrends.net: Charles Schwab Total Assets 2012-2025
- macrotrends.net: Charles Schwab Total Current Assets 2012-2025
- companiesmarketcap.com: Charles Schwab (SCHW) - Total assets
- aboutschwab.com: Schwab Reports Record 4Q and Full Year 2025 Results
- quartr.com: Charles Schwab (SCHW) Q4 2025 earnings summary
- seekingalpha.com: Buy Shares Where You Invest: Charles Schwab
- ft.com: Schwab Reports Record 4Q and Full Year 2025 Results
- morningstar.com: Charles Schwab Earnings: Sluggish Client Cash Recovery
- tikr.com: Charles Schwab Closes Forge Acquisition as Analysts Set $120 Mean Target for 2026
- schwab.com: FORM 10-Q THE CHARLES SCHWAB CORPORATION (Nov 2025)
- schwab.com: FORM 10-Q THE CHARLES SCHWAB CORPORATION (Aug 2025)
Do more with the Charles Schwab model
Frequently asked
What services does Charles Schwab Corporation provide?+
Charles Schwab Corporation (SCHW) is a leading financial services firm offering wealth management, securities brokerage, banking, asset management, custody, and financial advisory services. It operates a large platform serving individual investors and independent registered investment advisors (RIAs).
How does Charles Schwab generate its revenue?+
Charles Schwab monetizes client assets primarily through interest spreads, asset management fees, and trading activity. Its main business segments include Net Interest Revenue, Asset Management and Administration Fees, and Trading Revenue.
What is Charles Schwab's typical capital expenditure profile?+
Charles Schwab's capital expenditure typically ranges from 3-5% of revenue, heavily focused on capitalized software development and technology infrastructure. The majority of this capex is growth-oriented, funding platform enhancements and AI-driven service efficiency.
What is a key focus for the Charles Schwab financial model regarding profitability?+
The financial model specifically focuses on the expansion of Charles Schwab's Net Interest Margin (NIM). This expansion is anticipated as high-cost supplemental funding rolls off and client cash sorting stabilizes.
What is the purpose of the Charles Schwab financial model available for download?+
The downloadable financial model forecasts Charles Schwab’s earnings, balance sheet trajectory, and equity valuation. Its primary purpose is to determine if the SCHW stock is mispriced based on these projections.
Can I download an Excel financial model for Charles Schwab (SCHW)?+
Yes, an Excel financial model for Charles Schwab is available for download. This model provides forecasts for the company from FY2026 through FY2030.
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 Capital Markets Company Financial Models
Browse another company in the same sector.
Cboe Global Markets
Cboe Global Markets is a leading provider of market infrastructure and tradable products, operating derivatives and securities exchange networks globally.
CME Group
CME Group operates the world's leading derivatives marketplace, enabling clients to trade futures, options, cash, and over-the-counter products through an electronic trading platform and central clearing house.
Coinbase
Coinbase operates a financial technology platform providing end-to-end financial infrastructure for the cryptoeconomy, allowing retail users, institutions, and ecosystem partners to trade, stake, store, and transfer crypto assets.
FactSet
FactSet provides financial data, analytics, and open technology platforms to global investment professionals, including asset managers, wealth managers, and investment banks.
Robinhood Markets
Robinhood Markets operates a financial services platform that pioneered commission-free stock, options, and cryptocurrency trading for retail investors, generating revenue from order flow, net interest, and subscriptions.
Interactive Brokers
Interactive Brokers Group, Inc.
Intercontinental Exchange
Intercontinental Exchange (ICE) is a leading global provider of market infrastructure, data services, and technology solutions to a broad range of customers including financial institutions, corporations, and government entities.
Moody's
Moody's Corporation is a global integrated risk assessment firm that provides credit ratings, research, data, and analytical tools to financial markets.
Explore more Financial Services financial model templates.
