Morgan Stanley Financial Model
Banking Company Financials Example (Free Excel Download)
Morgan Stanley is a premier global financial services firm providing investment banking, securities, wealth management, and investment management services.
professionals from Deloitte
Used by professionals from
About this model
This model provides a sum-of-the-parts valuation and dividend discount analysis for Morgan Stanley to determine its intrinsic equity value, helping an equity research analyst assess whether the stock is a buy or sell based on wealth management asset gathering and capital markets recovery.
Morgan Stanley is a premier global financial services firm providing investment banking, securities, wealth management, and investment management services. The firm has successfully transitioned from a traditional, volatile investment bank into a more stable, asset-gathering powerhouse following strategic acquisitions.
Business segments include:
- Wealth Management (WM): Approximately 46% of net revenues. Provides financial advisory, brokerage, and banking services to high-net-worth individuals and institutions.
- Institutional Securities (ISG): Approximately 45% of net revenues. Encompasses investment banking, equity and fixed income sales and trading, and corporate lending.
- Investment Management (IM): Approximately 9% of net revenues. Offers institutional and retail asset management products across equities, fixed income, and alternatives.
The business model is a hybrid of capital-intensive trading and lending (ISG) and capital-light, fee-based asset management (WM and IM). Morgan Stanley holds a top-tier competitive position globally, competing directly with Goldman Sachs in investment banking and Bank of America (Merrill Lynch) or UBS in wealth management. Recent major events include the seamless CEO transition to Ted Pick in 2024 and the continued integration and realisation of synergies from the transformational acquisitions of E*TRADE (2020) and Eaton Vance (2021).
The downloadable Morgan Stanley 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 & AssumptionsMorgan Stanley financial modelCompany, Historicals & Assumptions used
Source: SEC EDGAR · values in USD
| Line item | FY2021 | FY2022 | FY2023 | FY2024 | FY2025 |
|---|---|---|---|---|---|
| Revenue | $59.76B | $53.67B | $54.14B | $61.76B | $70.64B |
| Income before provision for income taxes | $19.67B | $14.09B | $11.81B | $17.60B | $21.95B |
| Total non-interest expenses | $40.08B | $39.30B | $41.80B | $43.90B | $48.34B |
| Net income | $15.03B | $11.03B | $9.09B | $13.39B | $16.86B |
Forecast assumptions
Defaults used in the downloadable model. Forecast horizon: FY2026–FY2030.
See 8 moreSee less
How to build a detailed financial model for Morgan Stanley
A complete walkthrough of every driver, margin, working-capital input, and capital-allocation assumption used in the downloadable model.
Revenue Deep Dive
Institutional Securities (ISG)
- Segment name: Institutional Securities
- Revenue driver formula: Investment Banking (Advisory + Equity Underwriting + Debt Underwriting) + Equity (Sales & Trading) + Fixed Income (Sales & Trading) + Other
- Historical growth rate: Highly cyclical, ranging from -15% to +20% year-over-year depending on macroeconomic conditions.
- Key growth levers and headwinds: M&A pipeline, IPO market health, market volatility (drives trading volumes), and corporate debt issuance.
- Pricing dynamics: Competitive fee structures for banking; bid-ask spreads for trading.
- Revenue recognition notes: Advisory fees recognised upon deal completion; trading revenues recognised on a mark-to-market basis.
- Seasonality: First quarter is typically the strongest for trading revenues due to client portfolio rebalancing.
Wealth Management (WM)
- Segment name: Wealth Management
- Revenue driver formula: Asset Management (Fee-Based Client Assets x Average Fee Rate) + Transactional Revenues + Net Interest Income (Average Bank Deposits x Net Interest Margin)
- Historical growth rate: 5% to 10% CAGR, driven by consistent net new asset generation.
- Key growth levers and headwinds: Net new asset (NNA) inflows, market appreciation, and interest rate movements impacting sweep deposit yields.
- Pricing dynamics: Asset management fees are typically contractual basis points on AUM; NII depends on the spread between asset yields and deposit costs.
- Revenue recognition notes: Asset management fees are billed quarterly based on beginning-of-quarter or average asset values.
- Seasonality: Less seasonal, though market performance in Q4 sets the baseline for Q1 fee billing.
Investment Management (IM)
- Segment name: Investment Management
- Revenue driver formula: Asset Management and Related Fees (AUM x Average Fee Rate) + Performance-Based Income
- Historical growth rate: 3% to 8% CAGR.
- Key growth levers and headwinds: Fund performance, institutional allocations to private credit and alternatives, and fee compression in active public equities.
- Pricing dynamics: Base management fees plus carried interest or performance fees on alternative funds.
- Revenue recognition notes: Performance fees are only recognised when it is probable that a significant reversal will not occur (often at the end of the performance period).
- Seasonality: Performance fees often crystallise in the fourth quarter.
Cost Structure
Variable Costs / COGS
As a financial institution, Morgan Stanley does not report traditional Cost of Goods Sold (COGS) or Gross Margin. The primary direct cost is compensation.
- Compensation and Benefits: The largest expense, historically running at 42% to 45% of net revenues. This includes salaries, bonuses, and deferred compensation.
- Deferred Compensation Plans (DCP): Mark-to-market gains or losses on DCP investments impact both revenues and compensation expense equally, creating a neutral bottom-line effect but distorting top-line and expense ratios.
Operating Expenses (Non-Compensation)
- Brokerage, clearing and exchange fees: Scales directly with trading volumes in ISG and WM.
- Information processing and communications: Heavy technology spend, relatively fixed but growing with data needs.
- Professional services: Legal, consulting, and audit fees.
- Marketing and business development: Client acquisition costs, particularly for the E*TRADE direct-to-consumer channel.
- Provision for credit losses: Driven by macroeconomic forecasts and loan growth in the WM and ISG lending portfolios.
Margin Profile
- Pre-tax Margin: The primary profitability metric for the firm. The consolidated pre-tax margin typically ranges from 25% to 29%.
- Segment Margins: Wealth Management targets a 30% pre-tax margin (achieved 27.2% in 2024). ISG margins are more volatile, typically 25% to 30%. IM margins range from 15% to 20%.
- Margin trend: Expanding over the long term due to the shift towards higher-margin, scalable Wealth Management revenues, though short-term fluctuations occur based on NII and trading environments.
Balance Sheet Structure
- Total assets: Approximately $1.2 trillion.
- Key asset categories: Cash and equivalents, Trading assets (derivatives, equities, fixed income), Securities borrowed or purchased under agreements to resell, and Loans (primarily high-net-worth mortgages and securities-based lending in WM).
- Goodwill & intangibles: Significant balance (over $20 billion) resulting from the E*TRADE, Eaton Vance, and Smith Barney acquisitions.
- Working capital profile: Traditional corporate working capital metrics (DSO, DIO, DPO) do not apply to banks. Liquidity is managed via the Global Liquidity Reserve and regulatory metrics like the Liquidity Coverage Ratio (LCR).
- PP&E: Minimal relative to total assets. Consists mainly of leasehold improvements, capitalised software, and IT equipment.
- Right-of-use assets: Operating leases for global office space are material but small relative to financial assets.
Capital Expenditure & Investment
- Capex as % of revenue: Typically 2% to 4% of net revenues.
- Maintenance vs. growth: Heavily skewed towards technology infrastructure, cybersecurity, and platform integration (growth/efficiency).
- Capitalised software: Material component of total capex, amortised over 3 to 5 years.
- M&A pattern: Historically transformational (Smith Barney, E*TRADE, Eaton Vance) to pivot the business model. Currently focused on organic growth and bolt-on capabilities rather than large-scale acquisitions.
Debt & Capital Structure
- Total debt: Long-term borrowings are approximately $230 billion to $250 billion.
- Capital Ratios: The critical metric is the Common Equity Tier 1 (CET1) ratio. Morgan Stanley operates with a CET1 ratio of approximately 15.0% to 15.5%, well above its regulatory requirement.
- Credit rating: A-tier ratings across major agencies (e.g., A1/A-).
- Key debt instruments: Senior unsecured notes, subordinated debt, and preferred stock.
- Maturity profile: Laddered maturities to manage refinancing risk, with regular issuance in the global medium-term note programme.
- Share repurchase programme: Highly active. The firm regularly buys back shares to return excess capital, subject to Federal Reserve stress test (CCAR) results.
- Dividend policy: Progressive dividend policy. The current quarterly dividend is $0.925 per share (annualised $3.70), representing a payout ratio of approximately 45% to 50% of net income.
Cash Flow Characteristics
- Operating cash flow: Traditional OCF is not a meaningful valuation metric for banks, as operating cash flows are heavily distorted by changes in trading assets, deposits, and loans.
- Free cash flow: Replaced by "Free Cash Flow to Equity" (FCFE) or "Dividend Paying Capacity", defined as Net Income minus the increase in Required Equity (driven by Risk-Weighted Asset growth).
- Major non-cash items: Depreciation, amortisation of intangibles, provision for credit losses, and stock-based compensation.
- Cash tax rate: Typically 22% to 24%, closely mirroring the GAAP effective tax rate.
Sheet Structure
- Assumptions: Hardcoded drivers for macroeconomic indicators, segment growth rates, fee rates, margins, and capital return policies.
- ISG Segment: Revenue build for Investment Banking, Equity, and Fixed Income based on market wallet share and trading volumes.
- WM Segment: Roll-forward of Client Assets (Beginning Balance + Net New Assets + Market Impact = Ending Balance), calculation of Asset Management fees, and NII build (Deposits x NIM).
- IM Segment: Roll-forward of AUM, calculation of base management fees, and performance fee estimates.
- Consolidated Income Statement: Aggregation of segment revenues (including intersegment eliminations), firm-wide compensation expense, non-compensation expenses, provision for credit losses, and taxes to reach Net Income.
- Balance Sheet & RWA: High-level balance sheet focusing on Earning Assets, Deposits, Long-Term Debt, and Total Equity. Includes a schedule for Risk-Weighted Assets (RWA) to drive capital requirements.
- Capital & Shareholder Return: Calculation of required CET1 capital, excess capital generation, dividend payouts, and share repurchases. Tracks the ending share count.
- Valuation: Dividend Discount Model (DDM) projecting dividends and share repurchases over 5 years with a terminal P/TBV multiple, plus a Sum-of-the-Parts (SOTP) P/E valuation.
Key Financial Relationships
- `WM Asset Management Revenue = Average Fee-Based Client Assets x Average Fee Rate (historically ~70-75 bps)`
- `WM Net Interest Income = Average Bank Deposits x Net Interest Margin`
- `IM Asset Management Revenue = Average AUM x Average Fee Rate`
- `Consolidated Net Revenues = ISG Revenues + WM Revenues + IM Revenues + Intersegment Eliminations`
- `Compensation Expense = Consolidated Net Revenues x Compensation Ratio (target 42% - 45%)`
- `Pre-Tax Income = Consolidated Net Revenues - Compensation Expense - Non-Compensation Expense - Provision for Credit Losses`
- `Net Income Applicable to MS = Pre-Tax Income x (1 - Effective Tax Rate) - Preferred Dividends`
- `Required Common Equity = Risk-Weighted Assets (RWA) x Target CET1 Ratio`
- `Capital Available for Distribution = Net Income Applicable to MS - (Change in Required Common Equity)`
- `Ending Shares Outstanding = Beginning Shares Outstanding - (Share Repurchases / Average Share Price) + Shares Issued for Stock-Based Comp`
- `Return on Tangible Common Equity (ROTCE) = (Net Income Applicable to MS - Amortisation of Intangibles) / Average Tangible Common Equity`
Cross-Sheet Dependencies
- The Assumptions sheet feeds all segment build sheets (ISG Segment, WM Segment, IM Segment).
- The segment sheets feed the top line of the Consolidated Income Statement.
- The Consolidated Income Statement generates Net Income, which feeds Retained Earnings on the Balance Sheet & RWA sheet and serves as the starting point for the Capital & Shareholder Return sheet.
- The Capital & Shareholder Return sheet calculates dividends and buybacks, which reduce Cash and Equity on the Balance Sheet & RWA sheet.
- The Capital & Shareholder Return sheet also calculates the ending share count, which loops back to the Consolidated Income Statement to calculate EPS. (Note: To avoid circularity, use beginning-of-period shares or a macro to resolve average share price for buybacks).
- The Valuation sheet pulls Net Income, Dividends, and Share Repurchases from the Capital & Shareholder Return and Consolidated Income Statement sheets.
Sign Convention
- Revenues: Positive.
- Expenses: Positive (subtracted in formulas to calculate profit).
- Assets: Positive.
- Liabilities and Equity: Positive.
- Cash Outflows (Dividends, Buybacks): Positive when stated as a quantum of return, but subtracted from equity balances.
- Net New Assets / Flows: Positive for inflows, negative for outflows.
Things Most Likely to Go Wrong
- Applying a standard DCF model. Banks must be valued using a Dividend Discount Model (DDM) or Residual Income Model because cash flows cannot be cleanly separated from operating financial assets.
- Failing to include intersegment eliminations. Morgan Stanley reports combined segment revenues that are higher than consolidated revenues due to internal revenue sharing; the model must include an elimination line (historically negative $200m to $300m annually).
- Mismodelling the Deferred Compensation Plan (DCP). Market gains on DCP assets increase revenues but equally increase compensation expense. The model should treat this as a pass-through that inflates the compensation ratio but does not impact pre-tax income.
- Overestimating Net Interest Income in a falling rate environment. Wealth Management sweep deposits are highly sensitive to rate cuts, which can compress NII faster than expected.
- Ignoring preferred stock dividends. Net Income must be reduced by preferred dividends to calculate Net Income Applicable to Morgan Stanley Common Shareholders.
- Using total assets instead of Risk-Weighted Assets (RWA) to determine capital requirements. Capital return is dictated by RWA growth, not total asset growth.
- Double-counting Wealth Management and Investment Management assets. Some WM client assets are invested in IM products; the model must track them separately based on segment reporting.
- Miscalculating Tangible Book Value. Goodwill and intangible assets (over $20 billion) must be subtracted from Total Equity to calculate ROTCE and P/TBV multiples accurately.
Validation Checks
- "Total Assets must equal Total Liabilities plus Equity in every period."
- "Consolidated Compensation Ratio should remain between 42.0% and 45.0%; flag if outside this band."
- "Wealth Management Pre-Tax Margin should be between 26.0% and 30.0%."
- "CET1 Ratio must remain above the regulatory minimum plus management buffer (typically >14.0%)."
- "Dividend payout ratio should not exceed 60% of Net Income to ensure sustainable capital retention."
- "Return on Tangible Common Equity (ROTCE) should align with management's target of 18% to 20%."
- "Intersegment eliminations must be negative and offset segment revenue overstatements."
- "Total Client Assets in WM should grow by at least the assumed Net New Asset (NNA) run rate plus market appreciation."
Key Assumptions (Default Values)
| Assumption | Default Value | Unit | Rationale |
|---|---|---|---|
| ISG Revenue Growth | 5.0 | % | Assumes moderate recovery in investment banking and stable trading. |
| WM Net New Assets (Annual) | 250 | $ Billions | Based on 2024 actuals and management target of $1T every 3-4 years. |
| WM Fee-Based Asset Yield | 72 | bps | Historical average fee rate on advisory accounts. |
| WM Pre-Tax Margin Target | 27.5 | % | Aligns with 2024 actuals (27.2%) and progress towards 30% target. |
| IM AUM Growth | 4.0 | % | Moderate market appreciation and flat to slightly positive net flows. |
| Compensation Ratio | 42.5 | % | Aligns with 2024 actuals (42.4%) and historical norms. |
| Non-Compensation Ratio | 28.5 | % | Aligns with 2024 actuals (28.7%) and efficiency initiatives. |
| Effective Tax Rate | 23.0 | % | Standard corporate tax rate plus state and local taxes. |
| Target CET1 Ratio | 15.0 | % | Management target, providing a buffer over regulatory minimums. |
| Annual Dividend per Share | 3.70 | $ | Current annualised dividend based on Q4 2024 payout. |
| Share Repurchases | 5.0 | $ Billions | Estimated annual buyback capacity based on excess capital generation. |
| Cost of Equity (Ke) | 10.0 | % | Standard discount rate for large-cap US financial institutions. |
| Terminal P/TBV Multiple | 2.5 | x | Historical trading range for MS given 18-20% ROTCE profile. |
Data Sources & Benchmarks
- Filings: SEC EDGAR (10-K, 10-Q) and Morgan Stanley Investor Relations page (Financial Supplements, Earnings Presentations).
- Key Peers: Goldman Sachs (GS) for ISG benchmarking; Bank of America (BAC) and UBS (UBS) for Wealth Management benchmarking.
- Industry Data: Dealogic for investment banking league tables and M&A volumes; Federal Reserve H.8 data for banking sector loan and deposit trends.
- Consensus Estimates: Bloomberg or FactSet for sell-side consensus on EPS, ROTCE, and segment revenues.
Sources
Do more with the Morgan Stanley model
Frequently asked
What is Morgan Stanley's primary business model?+
Morgan Stanley is a premier global financial services firm providing investment banking, securities, wealth management, and investment management services. The firm operates a hybrid business model, combining capital-intensive trading and lending with capital-light, fee-based asset management.
What are the main revenue drivers for Morgan Stanley?+
Morgan Stanley's primary revenue drivers are its Wealth Management segment, which accounts for approximately 46% of net revenues, and its Institutional Securities Group, contributing about 45%. The firm also generates revenue from its Investment Management segment, making up around 9% of net revenues.
What is a typical capital expenditure assumption for Morgan Stanley's financial model?+
Capital expenditure for Morgan Stanley is typically assumed to be between 2% to 4% of net revenues in the financial model. This spending is heavily skewed towards technology infrastructure, cybersecurity, and platform integration, with capitalized software being a material component.
How is Morgan Stanley's intrinsic equity value determined in the financial model?+
The financial model determines Morgan Stanley's intrinsic equity value using a sum-of-the-parts valuation and a dividend discount analysis. This approach helps an equity research analyst assess whether the stock is a buy or sell based on wealth management asset gathering and capital markets recovery.
Can I download an Excel financial model for Morgan Stanley?+
Yes, an Excel financial model for Morgan Stanley is available for download. This model provides a forecast horizon from FY2026 to FY2030 and is designed for financial services analysis to determine intrinsic equity value.
What are some key financial assumptions used in Morgan Stanley's forecast model?+
Key assumptions in Morgan Stanley's financial forecast model include a revenue growth rate of approximately 6.85% and COGS as a percentage of revenue at 55%. Other important assumptions cover SGA as a percentage of revenue at 15% and a tax rate of about 21.27%.
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.
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.
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.
Explore more Financial Services financial model templates.
