Pediatrix Medical Group, Inc. (MD) 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
Pediatrix Medical Group, Inc. (MD) Bundle
Whether you’re an investor or an analyst, this (MD) DCF Calculator is your go-to resource for accurate valuation. Preloaded with real data from Pediatrix Medical Group, Inc., you can adjust forecasts and immediately observe the results.
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 | 3,513.5 | 1,734.0 | 1,911.2 | 1,972.0 | 1,994.6 | 1,814.6 | 1,650.9 | 1,501.9 | 1,366.4 | 1,243.0 |
Revenue Growth, % | 0 | -50.65 | 10.22 | 3.18 | 1.15 | -9.02 | -9.02 | -9.02 | -9.02 | -9.02 |
EBITDA | 258.6 | 200.4 | 249.9 | 235.6 | 29.9 | 164.9 | 150.0 | 136.5 | 124.2 | 113.0 |
EBITDA, % | 7.36 | 11.56 | 13.07 | 11.95 | 1.5 | 9.09 | 9.09 | 9.09 | 9.09 | 9.09 |
Depreciation | 25.9 | 28.4 | 32.1 | 35.6 | 36.2 | 27.9 | 25.4 | 23.1 | 21.0 | 19.1 |
Depreciation, % | 0.73803 | 1.64 | 1.68 | 1.81 | 1.81 | 1.54 | 1.54 | 1.54 | 1.54 | 1.54 |
EBIT | 232.6 | 171.9 | 217.7 | 200.0 | -6.3 | 137.0 | 124.7 | 113.4 | 103.2 | 93.9 |
EBIT, % | 6.62 | 9.92 | 11.39 | 10.14 | -0.31504 | 7.55 | 7.55 | 7.55 | 7.55 | 7.55 |
Total Cash | 112.8 | 1,228.7 | 387.4 | 9.8 | 177.7 | 376.5 | 342.6 | 311.6 | 283.5 | 257.9 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 434.3 | 241.9 | 301.8 | 296.8 | 279.9 | 258.3 | 235.0 | 213.8 | 194.5 | 177.0 |
Account Receivables, % | 12.36 | 13.95 | 15.79 | 15.05 | 14.03 | 14.24 | 14.24 | 14.24 | 14.24 | 14.24 |
Inventories | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Inventories, % | 0.0000000285 | 0.0000000577 | 0.0000000523 | 0.0000000507 | 0 | 0.0000000378 | 0.0000000378 | 0.0000000378 | 0.0000000378 | 0.0000000378 |
Accounts Payable | 35.4 | 59.8 | 36.6 | 31.9 | 34.6 | 35.3 | 32.1 | 29.2 | 26.6 | 24.2 |
Accounts Payable, % | 1.01 | 3.45 | 1.92 | 1.62 | 1.73 | 1.94 | 1.94 | 1.94 | 1.94 | 1.94 |
Capital Expenditure | -31.9 | -28.8 | -32.2 | -29.7 | -33.3 | -27.0 | -24.5 | -22.3 | -20.3 | -18.5 |
Capital Expenditure, % | -0.90737 | -1.66 | -1.69 | -1.51 | -1.67 | -1.49 | -1.49 | -1.49 | -1.49 | -1.49 |
Tax Rate, % | -24.92 | -24.92 | -24.92 | -24.92 | -24.92 | -24.92 | -24.92 | -24.92 | -24.92 | -24.92 |
EBITAT | 215.4 | -230.4 | 210.9 | 163.0 | -7.8 | 101.7 | 92.5 | 84.1 | 76.6 | 69.6 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -189.4 | -14.1 | 127.8 | 169.2 | 14.6 | 124.8 | 113.4 | 103.2 | 93.9 | 85.4 |
WACC, % | 9.37 | 7.22 | 9.47 | 9.12 | 9.54 | 8.94 | 8.94 | 8.94 | 8.94 | 8.94 |
PV UFCF | ||||||||||
SUM PV UFCF | 412.3 | |||||||||
Long Term Growth Rate, % | 3.50 | |||||||||
Free cash flow (T + 1) | 88 | |||||||||
Terminal Value | 1,624 | |||||||||
Present Terminal Value | 1,058 | |||||||||
Enterprise Value | 1,470 | |||||||||
Net Debt | 628 | |||||||||
Equity Value | 842 | |||||||||
Diluted Shares Outstanding, MM | 82 | |||||||||
Equity Value Per Share | 10.24 |
What You Will Get
- Comprehensive MD Financials: Access historical and projected data for precise valuation.
- Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures as needed.
- Real-Time Calculations: Intrinsic value and NPV are computed automatically.
- Scenario Analysis: Evaluate various scenarios to assess Pediatrix Medical Group’s future performance.
- User-Friendly Design: Designed for professionals but easy for newcomers to navigate.
Key Features
- Comprehensive MD Data: Pre-filled with Pediatrix Medical Group's historical performance metrics and future growth projections.
- Fully Customizable Inputs: Modify revenue growth rates, profit margins, discount rates, tax implications, and capital investments.
- Dynamic Valuation Model: Real-time updates to Net Present Value (NPV) and intrinsic value based on your customized inputs.
- Scenario Testing: Generate various forecasting scenarios to explore different valuation results.
- User-Friendly Design: Intuitive layout, structured for both industry professionals and newcomers.
How It Works
- Step 1: Download the prebuilt Excel template containing Pediatrix Medical Group, Inc.'s (MD) data.
- Step 2: Review the pre-filled sheets to familiarize yourself with the essential metrics.
- Step 3: Adjust forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
- Step 4: Instantly see recalculated results, including Pediatrix Medical Group, Inc.'s (MD) intrinsic value.
- Step 5: Utilize the outputs to make informed investment decisions or generate comprehensive reports.
Why Choose This Calculator?
- User-Friendly Interface: Crafted for both novices and seasoned professionals.
- Customizable Inputs: Easily adjust parameters to suit your analysis needs.
- Real-Time Feedback: Witness immediate updates to Pediatrix Medical Group’s valuation as you modify inputs.
- Preloaded Data: Comes with Pediatrix Medical Group’s actual financial figures for swift assessments.
- Relied Upon by Experts: Favored by investors and analysts for making well-informed decisions.
Who Should Use This Product?
- Investors: Evaluate Pediatrix Medical Group’s (MD) fair value to inform investment strategies.
- CFOs: Utilize a comprehensive DCF model for accurate financial reporting and analysis.
- Consultants: Easily customize the template for client valuation reports in the healthcare sector.
- Entrepreneurs: Discover financial modeling techniques employed by leading healthcare organizations.
- Educators: Employ it as a resource for teaching valuation techniques in finance courses.
What the Template Contains
- Preloaded MD 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.