Marsh McLennan Financial Model
Insurance Company Financials Example (Free Excel Download)
Marsh & McLennan Companies, Inc. (ticker: MMC) is a global professional services firm offering advice and solutions in risk, strategy, and people.
professionals from Deloitte
Used by professionals from
About this model
This model provides a comprehensive equity valuation and scenario analysis framework for an analyst determining whether to recommend Marsh McLennan stock, focusing on the impact of macroeconomic interest rate shifts on fiduciary income, organic growth sustainability, and the accretion of recent large-scale acquisitions.
Marsh & McLennan Companies, Inc. (ticker: MMC) is a global professional services firm offering advice and solutions in risk, strategy, and people. The company acts as an intermediary between clients and insurance/reinsurance companies, whilst also providing extensive human capital and management consulting services.
- Business segments: Risk and Insurance Services (approximately 64% of total revenue) and Consulting (approximately 36% of total revenue).
- Key geographies: United States and Canada (49%), EMEA (32%), Asia Pacific (11%), and Latin America (4%).
- Business model type: Asset-light, human-capital intensive, fee and commission-based intermediary and advisory model.
- Competitive position: The world's largest insurance broker by revenue, operating in an oligopoly alongside primary peers Aon and Willis Towers Watson.
- Recent major events: In 2024, the company completed its largest acquisition to date by purchasing McGriff Insurance Services for $7.75 billion, funded via $7.25 billion in senior notes. The company also recently launched the "Thrive" restructuring programme, targeting $400 million in savings over three years with $500 million in associated restructuring charges.
The downloadable Marsh McLennan 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 & AssumptionsMarsh McLennan financial modelCompany, Historicals & Assumptions used
Source: SEC EDGAR · values in USD
| Line item | FY2021 | FY2022 | FY2023 | FY2024 | FY2025 |
|---|---|---|---|---|---|
| Revenue | $19.82B | $20.72B | $22.74B | $24.46B | $26.98B |
| Income before income taxes | $4.21B | $4.08B | $5.03B | $5.48B | $5.54B |
| Operating income | $4.31B | $4.28B | $5.28B | $5.82B | $6.22B |
| Net income | $3.14B | $3.05B | $3.76B | $4.06B | $4.16B |
Forecast assumptions
Defaults used in the downloadable model. Forecast horizon: FY2026–FY2030.
See 8 moreSee less
How to build a detailed financial model for Marsh McLennan
A complete walkthrough of every driver, margin, working-capital input, and capital-allocation assumption used in the downloadable model.
Revenue Deep Dive
Risk and Insurance Services (RIS)
- Segment name: Risk and Insurance Services (comprising Marsh and Guy Carpenter).
- Revenue driver formula: (Base Renewal Commissions + New Business Commissions) + Fiduciary Interest Income.
- Historical growth rate: 4% to 8% underlying organic growth over the last 3 years.
- Key growth levers and headwinds: Driven by global commercial property and casualty (P&C) insurance pricing, inflation (which increases insured exposure values), and macroeconomic stability. A softening P&C pricing cycle acts as a headwind.
- Pricing dynamics: Highly dependent on primary insurance and reinsurance premium rates, as brokers typically earn a percentage commission on the premium placed.
- Revenue recognition notes: Commission revenue is generally recognised at the later of the policy effective date or when the premium is billed.
- Seasonality: The first and fourth quarters are typically the strongest due to the timing of commercial insurance and reinsurance policy renewals (especially 1 January renewals for Guy Carpenter).
Consulting
- Segment name: Consulting (comprising Mercer and Oliver Wyman Group).
- Revenue driver formula: (Billable Hours x Average Realised Rate) + (Assets Under Management x Management Fee Rate).
- Historical growth rate: 3% to 6% underlying organic growth.
- Key growth levers and headwinds: Driven by corporate discretionary spending, M&A activity (which drives Oliver Wyman strategy consulting), and equity market performance (which drives Mercer's wealth and investment management fees).
- Pricing dynamics: Primarily time-and-materials or fixed-fee contractual pricing for consulting, and basis-point fees on AUM for wealth management.
- Revenue recognition notes: Recognised over time as services are delivered.
- Seasonality: Generally less seasonal than the RIS segment, though fourth-quarter project completions can drive a slight uptick in Oliver Wyman revenue.
Cost Structure
Variable Costs / COGS
- Line-by-line breakdown: As a professional services firm, MMC does not report traditional COGS. The primary direct cost is "Compensation and benefits", which functions as the variable cost of revenue.
- Gross margin range: Not explicitly reported, but the Compensation and benefits ratio typically runs between 55% and 58% of total revenue.
- Key input costs and commodity exposures: Highly exposed to wage inflation and the competitive market for specialised broker and consultant talent.
- How COGS scales with revenue: Largely linear, though the company has demonstrated consistent operating leverage by growing revenue faster than headcount costs.
Operating Expenses
- R&D: Not material and not separately disclosed.
- SG&A: Reported as "Other operating expenses". This includes IT, rent, professional fees, and travel. It typically runs at 18% to 20% of revenue.
- Depreciation & Amortisation: Typically 4% to 5% of revenue, heavily weighted towards the amortisation of intangible assets acquired through serial M&A.
- Stock-Based Compensation: Embedded within Compensation and benefits, typically running at 1% to 2% of revenue.
- Restructuring / one-time charges: Frequent due to continuous M&A integration and efficiency programmes. The current "Thrive" programme will incur $500 million in charges through 2027.
Margin Profile
- Gross margin, EBITDA margin, operating margin, net margin: Adjusted operating margin has expanded for 18 consecutive years, reaching approximately 23.7% in late 2025. Net margin typically ranges from 14% to 16%.
- Margin trend: Expanding steadily due to scale efficiencies, technology investments, and the high-margin nature of fiduciary interest income.
- Segment-level margins: RIS adjusted operating margin is highly profitable at approximately 32%, whilst Consulting adjusted operating margin sits lower at approximately 21%.
Balance Sheet Structure
- Total assets: Approximately $45 billion to $50 billion.
- Key asset categories: Fiduciary assets (cash collected from clients but not yet paid to insurers) and Goodwill/Intangible assets.
- Goodwill & intangibles as % of total assets: Extremely high, typically exceeding 50% of total assets due to the acquisitive nature of the business (e.g., JLT, McGriff).
- Working capital profile:
- Days Sales Outstanding (DSO): 60 to 70 days.
- Days Inventory Outstanding (DIO): Not applicable.
- Days Payable Outstanding (DPO): Not meaningful in a traditional sense, but fiduciary liabilities offset fiduciary assets.
- Net working capital as % of revenue: Structurally negative operating working capital when including fiduciary funds, providing a massive cash flow advantage.
- Is working capital positive or negative? The company collects premiums before remitting them to underwriters, generating a float that funds operations and generates interest income.
- PP&E: Minimal (less than 5% of assets), consisting mostly of leasehold improvements and IT equipment.
- Right-of-use assets / operating leases: Material due to a massive global office footprint, typically representing $1.5 billion to $2 billion in assets.
Capital Expenditure & Investment
- Capex as % of revenue: Very low, consistently ranging between 1.5% and 2.5%.
- Maintenance capex vs. growth capex: Almost entirely growth and efficiency capex, focused on IT infrastructure, digital client platforms, and capitalised software.
- Major capex programmes underway or planned: Investments in AI tools and digital brokerage platforms like LINQ and Bluestream.
- Capitalised software / development costs if material: Represents a significant portion of total capex, amortised over 3 to 5 years.
- M&A pattern: A serial acquirer executing both transformational deals (JLT in 2019, McGriff in 2024) and continuous bolt-on acquisitions through the Marsh McLennan Agency (MMA) platform.
- Typical acquisition multiple paid: Generally 12x to 15x EBITDA for high-quality brokerage assets.
Debt & Capital Structure
- Total debt: Approximately $18 billion to $20 billion following the McGriff acquisition.
- Debt/EBITDA ratio: Typically managed around 2.0x to 2.5x, spiking temporarily after large acquisitions before rapid deleveraging.
- Credit rating: Solid investment grade (typically A- or equivalent).
- Key debt instruments: Predominantly fixed-rate senior notes, supported by a multi-currency revolving credit facility.
- Maturity profile: Well-laddered, with average maturities extending beyond 7 years.
- Interest rate profile: Mostly fixed-rate debt, which provides a natural hedge since the company's fiduciary interest income rises with floating rates whilst its debt costs remain fixed.
- Covenants: Standard investment-grade covenants, primarily interest coverage and maximum leverage ratios.
- Share repurchase programme: Highly active, typically repurchasing $1 billion to $1.5 billion annually, adjusted downwards in years with major M&A.
- Dividend policy: Progressive dividend policy with an 11% CAGR over the last decade, yielding approximately 1.2% to 1.5% with a payout ratio of 35% to 40%.
Cash Flow Characteristics
- Operating cash flow conversion: Exceptionally strong, typically exceeding 1.1x net income.
- Free cash flow margin: Consistently high, ranging from 15% to 18% of total revenue ($4 billion to $5 billion annually).
- Major non-cash items that bridge net income to OCF: Depreciation, massive intangible amortisation, and stock-based compensation.
- Working capital cash flow impact: Fiduciary float generates positive cash flow during periods of premium growth.
- Capex intensity: Extremely low, making free cash flow closely mirror operating cash flow.
- Cash tax rate vs. GAAP effective tax rate: Cash taxes generally align closely with the adjusted effective tax rate of 25% to 26%.
Sheet Structure
- Assumptions: Contains all hardcoded inputs, macroeconomic drivers, segment growth rates, and margin targets.
- Revenue Build: Detailed schedules for Marsh, Guy Carpenter, Mercer, and Oliver Wyman, including fiduciary interest income calculations.
- Income Statement: Mirrors the company's reported P&L, specifically breaking out "Compensation and benefits" and "Other operating expenses".
- Balance Sheet: Includes specific lines for "Fiduciary assets" and "Fiduciary liabilities", alongside massive Goodwill and Intangible asset lines.
- Cash Flow Statement: Standard indirect method, highlighting the add-back of intangible amortisation and changes in fiduciary funds.
- Debt Schedule: Tracks the laddered senior notes, revolving credit facility, and calculates interest expense.
- Working Capital: Schedules out standard operating current assets and liabilities, strictly separating them from fiduciary funds.
- Intangibles & Capex: Tracks PP&E depreciation and the heavy amortisation schedule of acquired intangibles.
- DCF Valuation: Unlevered free cash flow build, WACC calculation, and terminal value using the perpetuity growth method.
Key Financial Relationships
- `Total Revenue = Risk and Insurance Services Revenue + Consulting Revenue`
- `Risk and Insurance Services Revenue = Marsh Revenue + Guy Carpenter Revenue + RIS Fiduciary Interest Income`
- `Consulting Revenue = Mercer Revenue + Oliver Wyman Revenue`
- `Fiduciary Interest Income = Average Fiduciary Assets x Average Short-Term Interest Rate`
- `Compensation and Benefits Expense = Total Revenue x Compensation Ratio (historically 55-58%)`
- `Other Operating Expenses = Total Revenue x Other OpEx Ratio (historically 18-20%)`
- `Adjusted Operating Income = Total Revenue - Compensation and Benefits - Other Operating Expenses`
- `GAAP Operating Income = Adjusted Operating Income - Intangible Amortisation - Restructuring Charges`
- `Fiduciary Assets = Fiduciary Liabilities (these must perfectly offset in the working capital schedule)`
- `Free Cash Flow = Cash from Operations - Capital Expenditures`
- `Interest Expense = Average Debt Balance x Weighted Average Interest Rate`
- `Net Debt = Total Debt - Cash and Cash Equivalents (excluding Fiduciary Assets)`
Cross-Sheet Dependencies
- The Assumptions sheet drives the Revenue Build and expense ratios on the Income Statement.
- The Revenue Build feeds the top line of the Income Statement and drives the DSO calculations on the Working Capital sheet.
- The Working Capital sheet calculates changes in operating assets and liabilities, which feed directly into the Cash Flow Statement.
- The Debt Schedule calculates interest expense, which feeds the Income Statement, whilst the ending debt balances feed the Balance Sheet.
- Fiduciary assets on the Balance Sheet drive the Fiduciary Interest Income calculated in the Revenue Build. This creates a slight circularity if fiduciary assets are modelled as a percentage of revenue, so fiduciary assets should be driven by prior-year revenue or calculated iteratively.
- The Cash Flow Statement determines the ending cash balance, which flows to the Balance Sheet and serves as the plug to ensure the balance sheet balances.
Sign Convention
- Revenue, assets, and equity are entered and displayed as positive numbers.
- Expenses (Compensation and benefits, Other operating expenses, Interest expense) are entered as negative numbers in the Income Statement build to allow for simple summation.
- Capital expenditures are entered as negative numbers in the Cash Flow Statement.
- Debt paydowns are negative, whilst debt issuances are positive in the Cash Flow Statement.
- Dividends and share repurchases are negative in the Cash Flow Statement.
Things Most Likely to Go Wrong
- Fiduciary Asset Mismatch: Fiduciary assets and fiduciary liabilities must always be equal. If the model grows one without the other, the balance sheet will break.
- Interest Rate Sensitivity: Fiduciary interest income is highly sensitive to central bank rate cuts. Failing to link this revenue line to a macroeconomic interest rate assumption will overstate future revenue in a declining rate environment.
- Intangible Amortisation Add-backs: The company's adjusted EPS excludes intangible amortisation. If the model does not add this back, the calculated EPS will severely miss consensus estimates.
- Restructuring Noise: The "Thrive" programme will create $500 million in GAAP expenses through 2027. These must be modelled as GAAP expenses but excluded from Adjusted Operating Income.
- M&A Revenue vs Organic Growth: Historical revenue growth includes acquired revenue (like McGriff). The model must separate underlying organic growth from acquired growth to avoid overestimating the baseline trajectory.
- Compensation Ratio Rigidity: The compensation ratio is the biggest driver of margins. A 100 basis point error here swings operating income by hundreds of millions of dollars.
- Debt Spikes: Failing to model the $7.25 billion debt issuance for the McGriff acquisition will result in an understated interest expense and an incorrect capital structure.
- Cash vs Fiduciary Cash: The model must strictly separate corporate cash and cash equivalents from cash held in a fiduciary capacity. Fiduciary cash cannot be used to pay corporate dividends or service corporate debt.
Validation Checks
- "Compensation and benefits as a % of revenue should remain between 55% and 58%; flag if outside this band."
- "Adjusted Operating Margin should be in the 22% to 25% range; flag if the model shows margin degradation without a specific catalyst."
- "Fiduciary Assets must exactly equal Fiduciary Liabilities in every forecast period."
- "Free Cash Flow margin (FCF / Total Revenue) should consistently exceed 15%."
- "Effective tax rate should remain between 25% and 26% based on management guidance."
- "Debt/EBITDA should trend downwards towards 2.0x following the McGriff acquisition spike."
- "Balance sheet must balance: Total Assets = Total Liabilities + Equity in every period."
- "Capex as a % of revenue should not exceed 3%."
Key Assumptions (Default Values)
| Assumption | Default Value | Unit | Rationale |
|---|---|---|---|
| Marsh Underlying Growth | 4.0 | % | Reflects normalising P&C pricing and recent 2025 performance |
| Guy Carpenter Underlying Growth | 5.0 | % | Reflects strong reinsurance demand but softening pricing |
| Mercer Underlying Growth | 4.0 | % | Steady growth in health and wealth advisory |
| Oliver Wyman Underlying Growth | 6.0 | % | Higher growth strategy consulting segment |
| Fiduciary Interest Yield | 3.5 | % | Assumes moderate central bank rate cuts from 2024 peaks |
| Compensation & Benefits Ratio | 56.5 | % | Historical average, adjusted for Thrive programme efficiencies |
| Other Operating Expenses Ratio | 19.0 | % | Historical average reflecting ongoing IT and rent costs |
| Intangible Amortisation | 4.5 | % of Rev | Reflects heavy amortisation from McGriff and JLT deals |
| Effective Tax Rate | 25.5 | % | Management guidance for adjusted effective tax rate |
| Capex as % of Revenue | 2.0 | % | Historical average for this asset-light business |
| Dividend Payout Ratio | 38.0 | % | Consistent with historical progressive dividend policy |
| Share Repurchases | 1,200 | $ Millions | Annual run-rate, balancing cash flow with debt reduction |
| Weighted Average Interest Rate | 4.8 | % | Blended rate on senior notes including recent 2024 issuances |
| WACC | 7.5 | % | Standard discount rate for a low-beta, stable cash flow broker |
| Terminal Growth Rate | 2.5 | % | Aligns with long-term global GDP and inflation expectations |
Data Sources & Benchmarks
- Filings: SEC EDGAR (Form 10-K, Form 10-Q), Marsh McLennan Investor Relations website.
- Key peers for benchmarking: Aon plc (AON), Willis Towers Watson (WTW), Arthur J. Gallagher & Co. (AJG), Brown & Brown (BRO).
- Industry data sources: Council of Insurance Agents & Brokers (CIAB) pricing surveys, Marsh Global Insurance Market Index.
- Consensus estimates source: FactSet or Bloomberg for adjusted EPS and organic growth consensus.
Sources
Do more with the Marsh McLennan model
Frequently asked
What services does Marsh McLennan provide?+
Marsh McLennan is a global professional services firm that offers expert advice and solutions across risk, strategy, and people. The company serves as an intermediary between clients and insurance/reinsurance companies, while also delivering extensive human capital and management consulting services.
How does Marsh McLennan generate its revenue?+
Marsh McLennan generates its revenue primarily through its Risk and Insurance Services segment, which accounts for approximately 64% of total revenue, and its Consulting segment, contributing about 36%. Its business model is asset-light, human-capital intensive, and based on fee and commission-driven intermediary and advisory services.
What are the typical capital expenditure requirements for Marsh McLennan?+
Marsh McLennan's capital expenditure as a percentage of revenue is consistently very low, ranging between 1.5% and 2.5%. This capex is almost entirely focused on growth and efficiency, directed towards IT infrastructure, digital client platforms, and capitalized software.
What are some key financial model assumptions for Marsh McLennan?+
Key financial model assumptions for Marsh McLennan include a revenue growth rate of approximately 8.1% and a tax rate around 25.5%. The model also considers COGS as 55% of revenue and SGA as 15% of revenue.
Is a financial model for Marsh McLennan available for download?+
Yes, a comprehensive equity valuation and scenario analysis framework for Marsh McLennan is available for download. This model is designed to assist analysts in evaluating the stock, considering factors like macroeconomic interest rate shifts, organic growth, and the impact of acquisitions.
How does Marsh McLennan's working capital structure benefit the company?+
Marsh McLennan's working capital profile shows structurally negative operating working capital when fiduciary funds are included, which provides a significant cash flow advantage. This is because the company collects premiums from clients before remitting them to underwriters, creating a float that helps fund operations and generates interest income.
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 Insurance Company Financial Models
Browse another company in the same sector.
Arch Capital Group
Arch Capital Group is a Bermuda-based global provider of specialty property and casualty insurance, reinsurance, and mortgage insurance, dynamically allocating capital across underwriting opportunities.
Aflac
Aflac Incorporated is a leading provider of supplemental health and life insurance products, designed to pay cash benefits directly to policyholders for costs not covered by primary health insurance.
American International Group
American International Group (AIG) is a leading global insurance organisation providing property casualty insurance solutions to businesses and individuals in over 200 countries and jurisdictions.
Assurant
Assurant is a global provider of risk management solutions, protecting consumer purchases such as mobile devices, vehicles, and homes through B2B2C partnerships with brands, telecom providers, and financial institutions.
Arthur J. Gallagher & Co.
Arthur J.
Allstate
The Allstate Corporation is one of the largest publicly held personal lines property and casualty insurers in the United States.
Aon
Aon plc is a leading global professional services firm providing a broad range of risk, retirement, and health solutions.
Berkshire Hathaway
Berkshire Hathaway is a multinational conglomerate holding company overseen by Warren Buffett.
Explore more Financial Services financial model templates.
