Marsh & McLennan Companies, Inc. (MMC) DCF Valuation
- ✓ Entièrement Modifiable: Adapté À Vos Besoins Dans Excel Ou Sheets
- ✓ Conception Professionnelle: Modèles Fiables Et Conformes Aux Normes Du Secteur
- ✓ Pré-Construits Pour Une Utilisation Rapide Et Efficace
- ✓ Aucune Expertise N'Est Requise; Facile À Suivre
Marsh & McLennan Companies, Inc. (MMC) Bundle
Explore the financial outlook of Marsh & McLennan Companies, Inc. (MMC) with our user-friendly DCF Calculator! Enter your assumptions regarding growth, margins, and expenses to calculate the intrinsic value of Marsh & McLennan Companies, Inc. (MMC) and refine your investment approach.
Discounted Cash Flow (DCF) - (USD MM)
| Year | AY1 2019 |
AY2 2020 |
AY3 2021 |
AY4 2022 |
AY5 2023 |
FY1 2024 |
FY2 2025 |
FY3 2026 |
FY4 2027 |
FY5 2028 |
|---|---|---|---|---|---|---|---|---|---|---|
| Revenue | 16,652.0 | 17,224.0 | 19,820.0 | 20,720.0 | 22,736.0 | 24,599.1 | 26,614.8 | 28,795.8 | 31,155.4 | 33,708.4 |
| Revenue Growth, % | 0 | 3.44 | 15.07 | 4.54 | 9.73 | 8.19 | 8.19 | 8.19 | 8.19 | 8.19 |
| EBITDA | 3,589.0 | 4,064.0 | 5,499.0 | 5,690.0 | 6,317.0 | 6,304.2 | 6,820.8 | 7,379.7 | 7,984.4 | 8,638.7 |
| EBITDA, % | 21.55 | 23.59 | 27.74 | 27.46 | 27.78 | 25.63 | 25.63 | 25.63 | 25.63 | 25.63 |
| Depreciation | 13,509.0 | 13,639.0 | 15,160.0 | 15,793.0 | 713.0 | 15,554.3 | 16,828.9 | 18,207.9 | 19,700.0 | 21,314.3 |
| Depreciation, % | 81.13 | 79.19 | 76.49 | 76.22 | 3.14 | 63.23 | 63.23 | 63.23 | 63.23 | 63.23 |
| EBIT | -9,920.0 | -9,575.0 | -9,661.0 | -10,103.0 | 5,604.0 | -9,250.2 | -10,008.2 | -10,828.3 | -11,715.6 | -12,675.6 |
| EBIT, % | -59.57 | -55.59 | -48.74 | -48.76 | 24.65 | -37.6 | -37.6 | -37.6 | -37.6 | -37.6 |
| Total Cash | 1,155.0 | 2,089.0 | 1,752.0 | 1,442.0 | 3,358.0 | 2,441.9 | 2,642.0 | 2,858.4 | 3,092.7 | 3,346.1 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 5,236.0 | 5,326.0 | 5,586.0 | 5,852.0 | 6,418.0 | 7,233.2 | 7,825.9 | 8,467.2 | 9,161.0 | 9,911.7 |
| Account Receivables, % | 31.44 | 30.92 | 28.18 | 28.24 | 28.23 | 29.4 | 29.4 | 29.4 | 29.4 | 29.4 |
| Inventories | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Inventories, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Accounts Payable | 2,746.0 | 2,532.0 | 3,165.0 | 2,993.0 | 3,332.0 | 3,751.8 | 4,059.3 | 4,391.9 | 4,751.8 | 5,141.2 |
| Accounts Payable, % | 16.49 | 14.7 | 15.97 | 14.44 | 14.66 | 15.25 | 15.25 | 15.25 | 15.25 | 15.25 |
| Capital Expenditure | -421.0 | -348.0 | -406.0 | -470.0 | -416.0 | -526.2 | -569.3 | -615.9 | -666.4 | -721.0 |
| Capital Expenditure, % | -2.53 | -2.02 | -2.05 | -2.27 | -1.83 | -2.14 | -2.14 | -2.14 | -2.14 | -2.14 |
| Tax Rate, % | 25.27 | 25.27 | 25.27 | 25.27 | 25.27 | 25.27 | 25.27 | 25.27 | 25.27 | 25.27 |
| EBITAT | -7,085.1 | -6,911.3 | -7,215.9 | -7,548.8 | 4,187.9 | -6,803.4 | -7,360.9 | -7,964.1 | -8,616.7 | -9,322.8 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 3,512.9 | 6,075.7 | 7,911.1 | 7,336.2 | 4,257.9 | 7,829.4 | 8,613.5 | 9,319.3 | 10,082.9 | 10,909.2 |
| WACC, % | 8.15 | 8.16 | 8.17 | 8.17 | 8.17 | 8.16 | 8.16 | 8.16 | 8.16 | 8.16 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 36,700.1 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 11,127 | |||||||||
| Terminal Value | 180,525 | |||||||||
| Present Terminal Value | 121,934 | |||||||||
| Enterprise Value | 158,634 | |||||||||
| Net Debt | 12,078 | |||||||||
| Equity Value | 146,556 | |||||||||
| Diluted Shares Outstanding, MM | 499 | |||||||||
| Equity Value Per Share | 293.70 |
What You Will Get
- Editable Forecast Inputs: Easily modify assumptions (growth %, margins, WACC) to explore various scenarios.
- Real-World Data: Marsh & McLennan Companies, Inc. (MMC) financial data pre-filled to kickstart your analysis.
- Automatic DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value automatically.
- Customizable and Professional: A refined Excel model that adjusts to your valuation requirements.
- Built for Analysts and Investors: Perfect for evaluating projections, validating strategies, and enhancing efficiency.
Key Features
- Comprehensive Risk Assessment Tools: Tailored solutions for evaluating and managing risks across various sectors.
- Market Intelligence Reports: Access to in-depth analysis and insights on market trends and competitive landscapes.
- Customizable Client Dashboards: Personalize your view with metrics and KPIs relevant to your business needs.
- Integrated Compliance Solutions: Tools to ensure adherence to regulatory requirements and industry standards.
- Data-Driven Decision Support: Leverage analytics and modeling to inform strategic business decisions.
How It Works
- Download the Template: Gain immediate access to the Excel-based MMC DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and other key factors.
- Instant Calculations: The model automatically recalculates Marsh & McLennan's intrinsic value.
- Test Scenarios: Experiment with various assumptions to assess potential changes in valuation.
- Analyze and Decide: Utilize the outcomes to inform your investment or financial analysis.
Why Choose Marsh & McLennan Companies, Inc. (MMC)?
- Comprehensive Services: Offers a wide range of risk, strategy, and human capital solutions in one platform.
- Tailored Solutions: Customize services to meet the unique needs of your organization.
- In-Depth Analysis: Provides detailed insights into market trends and risk management strategies.
- Extensive Resources: Access to a wealth of data and expertise for informed decision-making.
- Industry Expertise: Trusted by professionals across various sectors, including finance, healthcare, and technology.
Who Should Use This Product?
- Corporate Executives: Gain insights into risk management and strategic planning for your organization.
- Insurance Professionals: Enhance underwriting processes with comprehensive data analysis and market insights.
- Consultants: Provide clients with expert advice on organizational effectiveness and operational improvement.
- Investors: Evaluate investment opportunities in the professional services sector with informed analysis.
- Students of Business: Explore case studies and methodologies in risk management and consulting practices.
What the Template Contains
- Preloaded MMC Data: Historical and projected financial data, including revenue, EBIT, and capital expenditures.
- DCF and WACC Models: Professional-grade sheets for calculating intrinsic value and Weighted Average Cost of Capital.
- Editable Inputs: Yellow-highlighted cells for adjusting revenue growth, tax rates, and discount rates.
- Financial Statements: Comprehensive annual and quarterly financials for deeper analysis.
- Key Ratios: Profitability, leverage, and efficiency ratios to evaluate performance.
- Dashboard and Charts: Visual summaries of valuation outcomes and assumptions.