Moelis & Company (MC) DCF Valuation
- ✓ Completamente Editable: Adáptelo A Sus Necesidades En Excel O Sheets
- ✓ Diseño Profesional: Plantillas Confiables Y Estándares De La Industria
- ✓ Predeterminadas Para Un Uso Rápido Y Eficiente
- ✓ No Se Necesita Experiencia; Fáciles De Seguir
Moelis & Company (MC) Bundle
Enhance your investment strategies with the Moelis & Company (MC) DCF Calculator! Utilize authentic Moelis & Company financial data, adjust growth projections and expenses, and instantly observe how these modifications affect the intrinsic value of Moelis & Company (MC).
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 | 746.5 | 943.3 | 1,540.6 | 985.3 | 854.7 | 941.0 | 1,036.1 | 1,140.7 | 1,255.8 | 1,382.6 |
| Revenue Growth, % | 0 | 26.35 | 63.33 | -36.05 | -13.25 | 10.1 | 10.1 | 10.1 | 10.1 | 10.1 |
| EBITDA | 119.5 | 270.4 | 503.2 | 224.1 | -32.0 | 181.3 | 199.6 | 219.8 | 241.9 | 266.4 |
| EBITDA, % | 16.01 | 28.67 | 32.66 | 22.74 | -3.75 | 19.27 | 19.27 | 19.27 | 19.27 | 19.27 |
| Depreciation | 631.8 | 677.6 | 1,047.5 | 754.2 | 8.3 | 568.3 | 625.7 | 688.9 | 758.4 | 835.0 |
| Depreciation, % | 84.63 | 71.83 | 67.99 | 76.54 | 0.97304 | 60.39 | 60.39 | 60.39 | 60.39 | 60.39 |
| EBIT | -512.3 | -407.2 | -544.3 | -530.1 | -40.4 | -387.0 | -426.1 | -469.1 | -516.5 | -568.6 |
| EBIT, % | -68.62 | -43.16 | -35.33 | -53.8 | -4.72 | -41.13 | -41.13 | -41.13 | -41.13 | -41.13 |
| Total Cash | 167.8 | 202.5 | 520.2 | 206.8 | 186.4 | 226.8 | 249.7 | 274.9 | 302.7 | 333.2 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 55.8 | 101.2 | 69.6 | 56.3 | 63.6 | 67.5 | 74.4 | 81.9 | 90.1 | 99.2 |
| Account Receivables, % | 7.47 | 10.73 | 4.52 | 5.72 | 7.44 | 7.18 | 7.18 | 7.18 | 7.18 | 7.18 |
| Inventories | 225.1 | 305.3 | 591.4 | .0 | .0 | 189.9 | 209.1 | 230.2 | 253.4 | 279.0 |
| Inventories, % | 30.16 | 32.37 | 38.39 | 0 | 0 | 20.18 | 20.18 | 20.18 | 20.18 | 20.18 |
| Accounts Payable | 16.1 | 25.0 | 69.9 | 11.9 | 32.6 | 27.1 | 29.8 | 32.8 | 36.1 | 39.7 |
| Accounts Payable, % | 2.16 | 2.65 | 4.54 | 1.21 | 3.82 | 2.87 | 2.87 | 2.87 | 2.87 | 2.87 |
| Capital Expenditure | -6.5 | -40.7 | -16.4 | -6.0 | -16.7 | -16.6 | -18.2 | -20.1 | -22.1 | -24.3 |
| Capital Expenditure, % | -0.86627 | -4.31 | -1.07 | -0.60459 | -1.95 | -1.76 | -1.76 | -1.76 | -1.76 | -1.76 |
| Tax Rate, % | 15.26 | 15.26 | 15.26 | 15.26 | 15.26 | 15.26 | 15.26 | 15.26 | 15.26 | 15.26 |
| EBITAT | -365.0 | -269.6 | -370.7 | -368.4 | -34.2 | -278.5 | -306.6 | -337.6 | -371.7 | -409.2 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -4.5 | 250.7 | 450.8 | 926.4 | -29.2 | 73.9 | 277.6 | 305.6 | 336.5 | 370.4 |
| WACC, % | 10.48 | 10.47 | 10.47 | 10.47 | 10.5 | 10.48 | 10.48 | 10.48 | 10.48 | 10.48 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 971.9 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 378 | |||||||||
| Terminal Value | 4,458 | |||||||||
| Present Terminal Value | 2,709 | |||||||||
| Enterprise Value | 3,681 | |||||||||
| Net Debt | 29 | |||||||||
| Equity Value | 3,651 | |||||||||
| Diluted Shares Outstanding, MM | 69 | |||||||||
| Equity Value Per Share | 53.30 |
What You Will Get
- Authentic Moelis Data: Preloaded financials – from revenue to EBIT – based on real and projected figures.
- Comprehensive Customization: Modify all essential parameters (yellow cells) such as WACC, growth %, and tax rates.
- Instant Valuation Adjustments: Automatic recalculations to evaluate the effects of changes on Moelis & Company's (MC) fair value.
- Flexible Excel Template: Designed for easy edits, scenario analysis, and thorough projections.
- Efficient and Precise: Avoid starting from scratch while ensuring accuracy and adaptability.
Key Features
- Comprehensive MC Data: Pre-filled with Moelis & Company's historical performance metrics and future forecasts.
- Fully Adjustable Parameters: Modify advisory fees, revenue growth rates, and operational expenses.
- Interactive Valuation Model: Real-time updates to Net Present Value (NPV) and intrinsic value based on your adjustments.
- Scenario Analysis: Develop various forecasting scenarios to explore different valuation results.
- User-Centric Interface: Intuitive, organized, and suitable for both professionals and newcomers.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review Moelis & Company's (MC) pre-filled financial data and projections.
- Step 3: Adjust key inputs such as revenue growth, WACC, and tax rates (highlighted cells).
- Step 4: Observe the DCF model update in real-time as you modify the assumptions.
- Step 5: Evaluate the outputs and leverage the findings for investment strategies.
Why Choose the Moelis & Company (MC) Calculator?
- Designed for Experts: A sophisticated tool tailored for investment bankers, analysts, and financial advisors.
- Comprehensive Data: Moelis & Company’s historical and projected financials integrated for precision.
- Flexible Scenario Analysis: Effortlessly model various financial scenarios and assumptions.
- Insightful Outputs: Automatically computes intrinsic value, NPV, and essential financial metrics.
- User-Friendly: Detailed step-by-step guidance simplifies the calculation process.
Who Should Use This Product?
- Individual Investors: Make informed decisions about buying or selling Moelis & Company (MC) stock.
- Financial Analysts: Enhance valuation processes with comprehensive financial models specific to Moelis & Company (MC).
- Consultants: Provide clients with expert valuation insights on Moelis & Company (MC) efficiently and accurately.
- Business Owners: Gain insights into the valuation of companies like Moelis & Company (MC) to inform your own business strategies.
- Finance Students: Explore valuation techniques using real-world data from Moelis & Company (MC) and relevant case studies.
What the Template Contains
- Preloaded MC 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.