Medpace Holdings, Inc. (MEDP) DCF Valuation
- ✓ Totalmente Editável: Adapte-Se Às Suas Necessidades No Excel Ou Planilhas
- ✓ Design Profissional: Modelos Confiáveis E Padrão Da Indústria
- ✓ Pré-Construídos Para Uso Rápido E Eficiente
- ✓ Não É Necessária Experiência; Fácil De Seguir
Medpace Holdings, Inc. (MEDP) Bundle
Reveal the true potential of Medpace Holdings, Inc. (MEDP) with our expert-level DCF Calculator! Adjust critical assumptions, explore various scenarios, and evaluate how different changes affect Medpace Holdings, Inc. (MEDP) valuation—all within a comprehensive Excel template.
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 | 861.0 | 925.9 | 1,142.4 | 1,460.0 | 1,885.8 | 2,300.2 | 2,805.6 | 3,422.1 | 4,174.1 | 5,091.3 |
Revenue Growth, % | 0 | 7.54 | 23.38 | 27.8 | 29.17 | 21.97 | 21.97 | 21.97 | 21.97 | 21.97 |
EBITDA | 150.5 | 186.6 | 219.7 | 301.0 | 363.2 | 445.0 | 542.8 | 662.1 | 807.6 | 985.0 |
EBITDA, % | 17.47 | 20.15 | 19.23 | 20.62 | 19.26 | 19.35 | 19.35 | 19.35 | 19.35 | 19.35 |
Depreciation | 23.2 | 33.5 | 37.4 | 40.4 | 26.3 | 63.2 | 77.1 | 94.0 | 114.7 | 139.9 |
Depreciation, % | 2.69 | 3.61 | 3.27 | 2.76 | 1.4 | 2.75 | 2.75 | 2.75 | 2.75 | 2.75 |
EBIT | 127.3 | 153.1 | 182.3 | 260.7 | 336.8 | 381.8 | 465.7 | 568.0 | 692.8 | 845.1 |
EBIT, % | 14.78 | 16.54 | 15.96 | 17.85 | 17.86 | 16.6 | 16.6 | 16.6 | 16.6 | 16.6 |
Total Cash | 131.9 | 277.8 | 461.3 | 28.3 | 245.4 | 463.0 | 564.8 | 688.9 | 840.3 | 1,024.9 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 155.7 | 161.0 | 186.4 | 253.4 | 298.4 | 390.9 | 476.8 | 581.5 | 709.3 | 865.1 |
Account Receivables, % | 18.08 | 17.38 | 16.32 | 17.36 | 15.82 | 16.99 | 16.99 | 16.99 | 16.99 | 16.99 |
Inventories | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Inventories, % | 0.000000116 | 0 | 0 | 0 | 0 | 0.0000000232 | 0.0000000232 | 0.0000000232 | 0.0000000232 | 0.0000000232 |
Accounts Payable | 22.4 | 26.6 | 25.7 | 33.1 | 31.9 | 53.7 | 65.5 | 79.9 | 97.4 | 118.9 |
Accounts Payable, % | 2.6 | 2.87 | 2.25 | 2.27 | 1.69 | 2.33 | 2.33 | 2.33 | 2.33 | 2.33 |
Capital Expenditure | -17.9 | -31.3 | -28.3 | -36.9 | -36.6 | -57.1 | -69.6 | -84.9 | -103.6 | -126.4 |
Capital Expenditure, % | -2.08 | -3.38 | -2.47 | -2.53 | -1.94 | -2.48 | -2.48 | -2.48 | -2.48 | -2.48 |
Tax Rate, % | 15.75 | 15.75 | 15.75 | 15.75 | 15.75 | 15.75 | 15.75 | 15.75 | 15.75 | 15.75 |
EBITAT | 102.1 | 131.7 | 163.8 | 226.0 | 283.8 | 326.1 | 397.7 | 485.1 | 591.7 | 721.8 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -25.9 | 132.6 | 146.6 | 169.9 | 227.3 | 261.6 | 331.1 | 403.9 | 492.6 | 600.9 |
WACC, % | 10.81 | 10.81 | 10.81 | 10.81 | 10.81 | 10.81 | 10.81 | 10.81 | 10.81 | 10.81 |
PV UFCF | ||||||||||
SUM PV UFCF | 1,489.0 | |||||||||
Long Term Growth Rate, % | 3.50 | |||||||||
Free cash flow (T + 1) | 622 | |||||||||
Terminal Value | 8,507 | |||||||||
Present Terminal Value | 5,092 | |||||||||
Enterprise Value | 6,581 | |||||||||
Net Debt | -103 | |||||||||
Equity Value | 6,684 | |||||||||
Diluted Shares Outstanding, MM | 32 | |||||||||
Equity Value Per Share | 209.92 |
What You Will Get
- Editable Excel Template: A fully customizable Excel-based DCF Calculator featuring pre-filled real MEDP financials.
- Real-World Data: Historical data and forward-looking estimates (as highlighted in the yellow cells).
- Forecast Flexibility: Adjust forecast assumptions such as revenue growth, EBITDA %, and WACC.
- Automatic Calculations: Instantly observe the effect of your inputs on Medpace’s valuation.
- Professional Tool: Designed for investors, CFOs, consultants, and financial analysts.
- User-Friendly Design: Organized for clarity and ease of use, complete with step-by-step instructions.
Key Features
- Customizable Forecast Inputs: Adjust essential metrics such as revenue growth, EBITDA %, and capital expenditures.
- Instant DCF Valuation: Automatically computes intrinsic value, NPV, and additional outputs with ease.
- High-Precision Accuracy: Leverages Medpace's actual financial data for credible valuation results.
- Streamlined Scenario Analysis: Effortlessly explore various assumptions and assess outcomes.
- Efficiency Booster: Remove the hassle of constructing intricate valuation models from the ground up.
How It Works
- 1. Access the Template: Download and open the Excel file containing Medpace Holdings, Inc. (MEDP) preloaded data.
- 2. Modify Assumptions: Adjust key inputs such as growth rates, WACC, and capital expenditures.
- 3. Analyze Results Immediately: The DCF model automatically computes intrinsic value and NPV.
- 4. Explore Scenarios: Evaluate various forecasts to investigate different valuation results.
- 5. Present with Assurance: Showcase professional valuation insights to back your decisions.
Why Choose This Calculator for Medpace Holdings, Inc. (MEDP)?
- Accurate Data: Utilize real Medpace financials for dependable valuation outcomes.
- Customizable: Tailor essential parameters such as growth rates, WACC, and tax rates to align with your forecasts.
- Time-Saving: Ready-to-use calculations save you from starting from the ground up.
- Professional-Grade Tool: Crafted for investors, analysts, and consultants in the healthcare sector.
- User-Friendly: Easy-to-navigate design and clear instructions make it accessible for all users.
Who Should Use This Product?
- Clinical Research Professionals: Enhance your understanding of trial methodologies and apply them using real-world data.
- Academics: Integrate advanced clinical models into your teaching or research initiatives.
- Investors: Evaluate your investment strategies and analyze valuation metrics for Medpace Holdings, Inc. (MEDP).
- Analysts: Optimize your analysis process with a pre-configured, adaptable financial model.
- Healthcare Entrepreneurs: Discover how major clinical research organizations like Medpace are evaluated.
What the Template Contains
- Pre-Filled DCF Model: Medpace Holdings, Inc.'s (MEDP) financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
- Financial Ratios: Evaluate Medpace's profitability, leverage, and efficiency.
- Editable Inputs: Change assumptions such as growth, margins, and CAPEX to fit your scenarios.
- Financial Statements: Annual and quarterly reports to support detailed analysis.
- Interactive Dashboard: Easily visualize key valuation metrics and results.