# Charles Schwab (SCHW) Financial Model Free Excel 3-statement financial model and company analysis for Charles Schwab. - Canonical: https://finamodel.com/companies/charles-schwab - Industry: Capital Markets - Downloadable model: Yes - Excel download: https://finamodel.com/company-models/SCHW.xlsx ## Model Purpose 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. ## Company Overview 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. ## 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 1. **Assumptions**: Hardcoded drivers for client assets, NIM, fee rates, and expense growth. 2. **Client Metrics**: Roll-forward of Total Client Assets (Beginning Balance + Net New Assets + Market Appreciation = Ending Balance) and Active Brokerage Accounts. 3. **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. 4. **Income Statement**: Segment revenues (NIR, AMAF, Trading, Other), detailed operating expenses, pre-tax income, taxes, and net income. 5. **Balance Sheet**: Assets (Cash, Investments, Loans, Goodwill) and Liabilities (Deposits, Payables to Clients, Debt, Equity). 6. **Capital & Dividends**: Tracking of Tier 1 Leverage, risk-weighted assets, share repurchases, and dividend payouts. 7. **Valuation (DDM / P/E)**: Dividend Discount Model and forward P/E multiple valuation based on adjusted EPS. ## Key Financial Relationships 1. `Total Client Assets = Prior Period Client Assets + Core Net New Assets + Market Impact` 2. `Asset Management and Administration Fees = Average Total Client Assets x Implied AMAF Yield (bps)` 3. `Net Interest Revenue = (Average Interest-Earning Assets x Asset Yield) - (Average Interest-Bearing Liabilities x Liability Cost)` 4. `Net Interest Margin (NIM) = Annualised Net Interest Revenue / Average Interest-Earning Assets` 5. `Trading Revenue = Active Brokerage Accounts x Average Trades per Account x Revenue per Trade` 6. `Total Net Revenues = Net Interest Revenue + AMAF + Trading Revenue + Other Revenue` 7. `Total Expenses Excluding Interest = Compensation + Professional Services + Occupancy + Advertising + Communications + D&A` 8. `Pre-Tax Income = Total Net Revenues - Total Expenses Excluding Interest` 9. `Adjusted Net Income = GAAP Net Income + Acquisition/Integration Costs (after-tax) + Amortisation of Acquired Intangibles (after-tax)` 10. `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) --- ## Frequently asked questions ### 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. [Interactive forecast calculator](https://finamodel.com/companies/charles-schwab/forecast)