OrthoPediatrics Corp. (KIDS) 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
OrthoPediatrics Corp. (KIDS) Bundle
Enhance your investment choices with the (KIDS) DCF Calculator! Utilize actual OrthoPediatrics Corp. financial data, adjust growth projections and expenses, and instantly observe how these modifications affect the intrinsic value of (KIDS).
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 | 72.6 | 71.1 | 98.0 | 122.3 | 148.7 | 179.3 | 216.2 | 260.7 | 314.3 | 378.9 |
| Revenue Growth, % | 0 | -2.03 | 37.95 | 24.72 | 21.62 | 20.56 | 20.56 | 20.56 | 20.56 | 20.56 |
| EBITDA | -4.5 | -22.3 | -7.2 | -7.9 | -8.4 | -20.5 | -24.7 | -29.8 | -35.9 | -43.3 |
| EBITDA, % | -6.22 | -31.44 | -7.34 | -6.48 | -5.63 | -11.42 | -11.42 | -11.42 | -11.42 | -11.42 |
| Depreciation | 4.6 | 7.9 | 10.7 | 13.1 | 17.4 | 18.2 | 22.0 | 26.5 | 31.9 | 38.5 |
| Depreciation, % | 6.39 | 11.12 | 10.89 | 10.71 | 11.69 | 10.16 | 10.16 | 10.16 | 10.16 | 10.16 |
| EBIT | -9.1 | -30.3 | -17.9 | -21.0 | -25.8 | -38.7 | -46.7 | -56.3 | -67.8 | -81.8 |
| EBIT, % | -12.61 | -42.57 | -18.23 | -17.19 | -17.32 | -21.58 | -21.58 | -21.58 | -21.58 | -21.58 |
| Total Cash | 70.8 | 83.9 | 53.5 | 118.3 | 80.3 | 144.5 | 174.2 | 210.0 | 253.2 | 305.3 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 16.6 | 17.5 | 17.9 | 24.8 | 34.6 | 39.2 | 47.3 | 57.0 | 68.7 | 82.9 |
| Account Receivables, % | 22.83 | 24.69 | 18.3 | 20.28 | 23.27 | 21.88 | 21.88 | 21.88 | 21.88 | 21.88 |
| Inventories | 38.0 | 53.0 | 57.6 | 78.2 | 105.9 | 115.0 | 138.7 | 167.2 | 201.6 | 243.1 |
| Inventories, % | 52.38 | 74.55 | 58.71 | 63.94 | 71.17 | 64.15 | 64.15 | 64.15 | 64.15 | 64.15 |
| Accounts Payable | 6.5 | 10.0 | 9.3 | 11.2 | 12.6 | 18.0 | 21.7 | 26.2 | 31.5 | 38.0 |
| Accounts Payable, % | 8.91 | 14.12 | 9.51 | 9.12 | 8.5 | 10.03 | 10.03 | 10.03 | 10.03 | 10.03 |
| Capital Expenditure | -12.1 | -11.3 | -16.0 | -10.0 | -19.0 | -25.1 | -30.2 | -36.4 | -43.9 | -52.9 |
| Capital Expenditure, % | -16.66 | -15.9 | -16.33 | -8.2 | -12.76 | -13.97 | -13.97 | -13.97 | -13.97 | -13.97 |
| Tax Rate, % | 1.59 | 1.59 | 1.59 | 1.59 | 1.59 | 1.59 | 1.59 | 1.59 | 1.59 | 1.59 |
| EBITAT | -12.4 | -29.6 | -16.7 | 7.2 | -25.4 | -30.2 | -36.4 | -43.9 | -52.9 | -63.8 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -68.0 | -45.4 | -27.7 | -15.4 | -62.9 | -45.5 | -72.6 | -87.6 | -105.6 | -127.3 |
| WACC, % | 9.83 | 9.83 | 9.83 | 9.75 | 9.83 | 9.82 | 9.82 | 9.82 | 9.82 | 9.82 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -320.1 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | -130 | |||||||||
| Terminal Value | -1,661 | |||||||||
| Present Terminal Value | -1,040 | |||||||||
| Enterprise Value | -1,360 | |||||||||
| Net Debt | -21 | |||||||||
| Equity Value | -1,339 | |||||||||
| Diluted Shares Outstanding, MM | 23 | |||||||||
| Equity Value Per Share | -59.06 |
What You Will Get
- Real OrthoPediatrics Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for OrthoPediatrics Corp. (KIDS).
- Full Customization: Adjust all critical parameters (yellow cells) such as WACC, growth %, and tax rates specifically for OrthoPediatrics Corp. (KIDS).
- Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on OrthoPediatrics Corp.'s (KIDS) fair value.
- Versatile Excel Template: Designed for quick edits, scenario testing, and detailed projections related to OrthoPediatrics Corp. (KIDS).
- Time-Saving and Accurate: Eliminate the need to build models from scratch while ensuring precision and flexibility for OrthoPediatrics Corp. (KIDS).
Key Features
- 🔍 Real-Life KIDS Financials: Pre-filled historical and projected data for OrthoPediatrics Corp.
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate OrthoPediatrics’ intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize OrthoPediatrics’ valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- Download the Template: Gain immediate access to the Excel-based OrthoPediatrics Corp. (KIDS) DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and other parameters.
- Instant Calculations: The model automatically recalculates OrthoPediatrics' intrinsic value.
- Test Scenarios: Explore various assumptions to assess potential changes in valuation.
- Analyze and Decide: Leverage the results to inform your investment or financial strategies.
Why Choose This Calculator?
- Designed for Healthcare Professionals: A specialized tool utilized by pediatric orthopedic surgeons and healthcare analysts.
- Comprehensive Data: OrthoPediatrics Corp.'s [KIDS] historical and projected financials preloaded for precise analysis.
- Scenario Analysis: Effortlessly simulate various forecasts and assumptions to inform decisions.
- Clear Insights: Automatically computes intrinsic value, NPV, and essential metrics for evaluation.
- User-Friendly: Step-by-step guidance simplifies the process for all users.
Who Should Use This Product?
- Medical Students: Understand pediatric orthopedic practices and apply them in clinical settings.
- Researchers: Utilize advanced models for studying pediatric orthopedic innovations.
- Healthcare Professionals: Evaluate your treatment strategies and outcomes using data from OrthoPediatrics Corp. (KIDS).
- Investors: Analyze market trends and performance metrics related to pediatric orthopedic products.
- Hospital Administrators: Learn how to assess and implement pediatric orthopedic solutions effectively.
What the Template Contains
- Pre-Filled Data: Includes OrthoPediatrics Corp.'s historical financials and forecasts.
- Discounted Cash Flow Model: Editable DCF valuation model with automatic calculations.
- Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC based on custom inputs.
- Key Financial Ratios: Analyze OrthoPediatrics Corp.'s profitability, efficiency, and leverage.
- Customizable Inputs: Edit revenue growth, margins, and tax rates with ease.
- Clear Dashboard: Charts and tables summarizing key valuation results.