# Morgan Stanley (MS) Financial Model Free Excel 3-statement financial model and company analysis for Morgan Stanley. - Canonical: https://finamodel.com/companies/morgan-stanley - Industry: Banking - Downloadable model: Yes - Excel download: https://finamodel.com/company-models/MS.xlsx ## Model Purpose 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. ## Company Overview 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). ## 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 1. **Assumptions**: Hardcoded drivers for macroeconomic indicators, segment growth rates, fee rates, margins, and capital return policies. 2. **ISG Segment**: Revenue build for Investment Banking, Equity, and Fixed Income based on market wallet share and trading volumes. 3. **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). 4. **IM Segment**: Roll-forward of AUM, calculation of base management fees, and performance fee estimates. 5. **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. 6. **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. 7. **Capital & Shareholder Return**: Calculation of required CET1 capital, excess capital generation, dividend payouts, and share repurchases. Tracks the ending share count. 8. **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 1. `WM Asset Management Revenue = Average Fee-Based Client Assets x Average Fee Rate (historically ~70-75 bps)` 2. `WM Net Interest Income = Average Bank Deposits x Net Interest Margin` 3. `IM Asset Management Revenue = Average AUM x Average Fee Rate` 4. `Consolidated Net Revenues = ISG Revenues + WM Revenues + IM Revenues + Intersegment Eliminations` 5. `Compensation Expense = Consolidated Net Revenues x Compensation Ratio (target 42% - 45%)` 6. `Pre-Tax Income = Consolidated Net Revenues - Compensation Expense - Non-Compensation Expense - Provision for Credit Losses` 7. `Net Income Applicable to MS = Pre-Tax Income x (1 - Effective Tax Rate) - Preferred Dividends` 8. `Required Common Equity = Risk-Weighted Assets (RWA) x Target CET1 Ratio` 9. `Capital Available for Distribution = Net Income Applicable to MS - (Change in Required Common Equity)` 10. `Ending Shares Outstanding = Beginning Shares Outstanding - (Share Repurchases / Average Share Price) + Shares Issued for Stock-Based Comp` 11. `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 * Morgan Stanley Fourth Quarter and Full Year 2024 Earnings Release (January 16, 2025). https://www.morganstanley.com * Morgan Stanley 2023 Annual Report on Form 10-K. https://www.sec.gov * Morgan Stanley Q1 2024 Form 10-Q. https://www.sec.gov --- ## Frequently asked questions ### 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%. [Interactive forecast calculator](https://finamodel.com/companies/morgan-stanley/forecast)