|
Globus Medical, Inc. (GMed) Valoración de DCF
US | Healthcare | Medical - Devices | NYSE
|
- ✓ 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
Globus Medical, Inc. (GMED) Bundle
¡Simplifique la valoración de Globus Medical, Inc. (GMED) con esta calculadora DCF personalizable! Con Real Globus Medical, Inc. (GMED) finanzas y entradas de pronóstico ajustables, puede probar escenarios y descubrir el valor razonable de Globus Medical, Inc. (GMED) en minutos.
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 | 785.4 | 789.0 | 958.1 | 1,022.8 | 1,568.5 | 1,890.0 | 2,277.4 | 2,744.3 | 3,306.8 | 3,984.7 |
Revenue Growth, % | 0 | 0.46781 | 21.43 | 6.76 | 53.34 | 20.5 | 20.5 | 20.5 | 20.5 | 20.5 |
EBITDA | 242.7 | 178.3 | 250.3 | 304.5 | 310.1 | 488.3 | 588.3 | 708.9 | 854.3 | 1,029.4 |
EBITDA, % | 30.9 | 22.6 | 26.12 | 29.77 | 19.77 | 25.83 | 25.83 | 25.83 | 25.83 | 25.83 |
Depreciation | 52.7 | 62.9 | 69.9 | 68.3 | 144.7 | 143.2 | 172.5 | 207.9 | 250.5 | 301.8 |
Depreciation, % | 6.71 | 7.97 | 7.29 | 6.67 | 9.23 | 7.58 | 7.58 | 7.58 | 7.58 | 7.58 |
EBIT | 189.9 | 115.5 | 180.4 | 236.3 | 165.4 | 345.1 | 415.8 | 501.1 | 603.8 | 727.5 |
EBIT, % | 24.19 | 14.63 | 18.83 | 23.1 | 10.54 | 18.26 | 18.26 | 18.26 | 18.26 | 18.26 |
Total Cash | 311.5 | 426.7 | 443.4 | 446.1 | 517.8 | 818.9 | 986.8 | 1,189.1 | 1,432.8 | 1,726.6 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 162.4 | 148.1 | 165.7 | 217.3 | 504.9 | 416.5 | 501.8 | 604.7 | 728.7 | 878.0 |
Account Receivables, % | 20.68 | 18.77 | 17.29 | 21.25 | 32.19 | 22.03 | 22.03 | 22.03 | 22.03 | 22.03 |
Inventories | 196.3 | 229.2 | 237.0 | 299.0 | 848.1 | 612.7 | 738.2 | 889.6 | 1,071.9 | 1,291.7 |
Inventories, % | 25 | 29.04 | 24.74 | 29.23 | 54.07 | 32.42 | 32.42 | 32.42 | 32.42 | 32.42 |
Accounts Payable | 24.6 | 18.2 | 22.0 | 36.1 | 56.7 | 56.2 | 67.8 | 81.6 | 98.4 | 118.5 |
Accounts Payable, % | 3.13 | 2.31 | 2.29 | 3.53 | 3.61 | 2.98 | 2.98 | 2.98 | 2.98 | 2.98 |
Capital Expenditure | -70.8 | -63.7 | -56.9 | -74.0 | -78.3 | -133.2 | -160.5 | -193.4 | -233.1 | -280.9 |
Capital Expenditure, % | -9.01 | -8.07 | -5.94 | -7.24 | -4.99 | -7.05 | -7.05 | -7.05 | -7.05 | -7.05 |
Tax Rate, % | 25.71 | 25.71 | 25.71 | 25.71 | 25.71 | 25.71 | 25.71 | 25.71 | 25.71 | 25.71 |
EBITAT | 155.2 | 93.8 | 149.2 | 184.9 | 122.9 | 274.8 | 331.2 | 399.0 | 480.8 | 579.4 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -196.9 | 68.1 | 140.5 | 79.6 | -626.8 | 608.2 | 143.7 | 173.2 | 208.7 | 251.4 |
WACC, % | 9.64 | 9.64 | 9.64 | 9.63 | 9.62 | 9.64 | 9.64 | 9.64 | 9.64 | 9.64 |
PV UFCF | ||||||||||
SUM PV UFCF | 1,108.9 | |||||||||
Long Term Growth Rate, % | 4.00 | |||||||||
Free cash flow (T + 1) | 261 | |||||||||
Terminal Value | 4,639 | |||||||||
Present Terminal Value | 2,929 | |||||||||
Enterprise Value | 4,038 | |||||||||
Net Debt | 53 | |||||||||
Equity Value | 3,984 | |||||||||
Diluted Shares Outstanding, MM | 115 | |||||||||
Equity Value Per Share | 34.76 |
What You Will Get
- Real GMED Financials: Access to historical and projected data for precise valuation.
- Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures as needed.
- Dynamic Calculations: Intrinsic value and NPV are computed in real-time.
- Scenario Analysis: Explore various scenarios to assess Globus Medical's future performance.
- User-Friendly Design: Tailored for professionals while remaining approachable for newcomers.
Key Features
- Customizable Forecast Inputs: Adjust vital metrics such as revenue growth, EBITDA %, and capital expenditures.
- Instant DCF Valuation: Quickly computes intrinsic value, NPV, and additional outputs.
- High-Precision Accuracy: Leverages Globus Medical's actual financial data for credible valuation results.
- Effortless Scenario Analysis: Evaluate various assumptions and compare results with ease.
- Efficiency Booster: Remove the necessity of constructing intricate valuation models from the ground up.
How It Works
- Step 1: Download the Excel file for Globus Medical, Inc. (GMED).
- Step 2: Review the pre-filled financial data and forecasts for Globus Medical.
- 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 your assumptions.
- Step 5: Evaluate the outputs and leverage the results for your investment strategies.
Why Choose This Calculator for Globus Medical, Inc. (GMED)?
- Accurate Data: Up-to-date Globus Medical financials provide trustworthy valuation outcomes.
- Customizable: Tailor essential inputs like growth rates, WACC, and tax rates to fit your forecasts.
- Time-Saving: Ready-made calculations save you from having to build from the ground up.
- Professional-Grade Tool: Crafted for investors, analysts, and consultants in the medical device sector.
- User-Friendly: Simple design and clear instructions ensure accessibility for all users.
Who Should Use This Product?
- Professional Investors: Develop comprehensive and accurate valuation models for investment analysis in Globus Medical, Inc. (GMED).
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within the organization.
- Consultants and Advisors: Deliver precise valuation insights to clients regarding Globus Medical, Inc. (GMED).
- Students and Educators: Utilize real-world data to enhance learning and practice in financial modeling.
- Healthcare Industry Analysts: Gain insights into how medical device companies like Globus Medical, Inc. (GMED) are valued in the market.
What the Template Contains
- Pre-Filled Data: Contains Globus Medical’s historical financials and projections.
- Discounted Cash Flow Model: An editable DCF valuation model with automated calculations.
- Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC based on user-defined inputs.
- Key Financial Ratios: Evaluate Globus Medical’s profitability, efficiency, and leverage metrics.
- Customizable Inputs: Easily adjust revenue growth, profit margins, and tax rates.
- Clear Dashboard: Visual representations and tables summarizing essential valuation outcomes.