|
Valoración de DCF de Neogen Corporation (NEOG)
US | Healthcare | Medical - Diagnostics & Research | NASDAQ
|
- ✓ 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
Neogen Corporation (NEOG) Bundle
¡Mejore sus opciones de inversión con la calculadora DCF de Neogen Corporation (NEOG)! Explore los datos financieros auténticos para Neogen, ajuste las predicciones y gastos de crecimiento, y observe instantáneamente cómo estas modificaciones afectan el valor intrínseco de Neogen Corporation (NEOG).
Discounted Cash Flow (DCF) - (USD MM)
| Year | AY1 2020 |
AY2 2021 |
AY3 2022 |
AY4 2023 |
AY5 2024 |
FY1 2025 |
FY2 2026 |
FY3 2027 |
FY4 2028 |
FY5 2029 |
|---|---|---|---|---|---|---|---|---|---|---|
| Revenue | 418.2 | 468.5 | 527.2 | 822.4 | 924.2 | 1,139.0 | 1,403.6 | 1,729.8 | 2,131.7 | 2,627.1 |
| Revenue Growth, % | 0 | 12.03 | 12.53 | 56.01 | 12.37 | 23.24 | 23.24 | 23.24 | 23.24 | 23.24 |
| EBITDA | 85.9 | 98.3 | 107.9 | 122.3 | 182.6 | 220.1 | 271.2 | 334.3 | 411.9 | 507.7 |
| EBITDA, % | 20.55 | 20.98 | 20.47 | 14.87 | 19.76 | 19.32 | 19.32 | 19.32 | 19.32 | 19.32 |
| Depreciation | 18.4 | 21.0 | 23.7 | 88.4 | 121.2 | 84.8 | 104.6 | 128.9 | 158.8 | 195.7 |
| Depreciation, % | 4.4 | 4.49 | 4.49 | 10.75 | 13.12 | 7.45 | 7.45 | 7.45 | 7.45 | 7.45 |
| EBIT | 67.5 | 77.3 | 84.2 | 33.9 | 61.4 | 135.3 | 166.7 | 205.4 | 253.1 | 312.0 |
| EBIT, % | 16.15 | 16.49 | 15.97 | 4.12 | 6.64 | 11.87 | 11.87 | 11.87 | 11.87 | 11.87 |
| Total Cash | 343.7 | 381.1 | 381.1 | 245.6 | 170.9 | 647.3 | 797.7 | 983.1 | 1,211.6 | 1,493.1 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 84.7 | 91.8 | 99.7 | 153.3 | 173.0 | 218.9 | 269.8 | 332.5 | 409.8 | 505.0 |
| Account Receivables, % | 20.25 | 19.6 | 18.91 | 18.63 | 18.72 | 19.22 | 19.22 | 19.22 | 19.22 | 19.22 |
| Inventories | 95.1 | 100.7 | 122.3 | 133.8 | 189.3 | 237.3 | 292.5 | 360.4 | 444.2 | 547.4 |
| Inventories, % | 22.73 | 21.5 | 23.2 | 16.27 | 20.48 | 20.84 | 20.84 | 20.84 | 20.84 | 20.84 |
| Accounts Payable | 25.7 | 23.9 | 34.6 | 76.7 | 83.1 | 82.3 | 101.4 | 124.9 | 154.0 | 189.7 |
| Accounts Payable, % | 6.13 | 5.1 | 6.57 | 9.32 | 8.99 | 7.22 | 7.22 | 7.22 | 7.22 | 7.22 |
| Capital Expenditure | -24.1 | -26.7 | -24.4 | -65.8 | -111.4 | -82.3 | -101.5 | -125.0 | -154.1 | -189.9 |
| Capital Expenditure, % | -5.75 | -5.7 | -4.63 | -8 | -12.06 | -7.23 | -7.23 | -7.23 | -7.23 | -7.23 |
| Tax Rate, % | 34.14 | 34.14 | 34.14 | 34.14 | 34.14 | 34.14 | 34.14 | 34.14 | 34.14 | 34.14 |
| EBITAT | 55.5 | 62.5 | 67.6 | 35.2 | 40.4 | 110.7 | 136.4 | 168.1 | 207.2 | 255.3 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -104.2 | 42.3 | 48.1 | 34.8 | -18.6 | 18.4 | 52.6 | 64.9 | 79.9 | 98.5 |
| WACC, % | 9.33 | 9.3 | 9.28 | 9.69 | 8.99 | 9.32 | 9.32 | 9.32 | 9.32 | 9.32 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 229.6 | |||||||||
| Long Term Growth Rate, % | 4.00 | |||||||||
| Free cash flow (T + 1) | 102 | |||||||||
| Terminal Value | 1,927 | |||||||||
| Present Terminal Value | 1,234 | |||||||||
| Enterprise Value | 1,464 | |||||||||
| Net Debt | 736 | |||||||||
| Equity Value | 728 | |||||||||
| Diluted Shares Outstanding, MM | 216 | |||||||||
| Equity Value Per Share | 3.36 |
What You Will Get
- Real Neogen Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for Neogen Corporation (NEOG).
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates specific to Neogen Corporation (NEOG).
- Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on Neogen Corporation’s fair value.
- Versatile Excel Template: Tailored for quick edits, scenario testing, and detailed projections for Neogen Corporation (NEOG).
- Time-Saving and Accurate: Skip building models from scratch while maintaining precision and flexibility for Neogen Corporation (NEOG).
Key Features
- Comprehensive DCF Calculator: Features detailed unlevered and levered DCF valuation models tailored for Neogen Corporation (NEOG).
- WACC Calculator: Comes with a pre-built Weighted Average Cost of Capital sheet that allows for customizable inputs.
- Customizable Forecast Assumptions: Adjust growth rates, capital expenditures, and discount rates to fit your analysis.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios specific to Neogen Corporation (NEOG).
- Interactive Dashboard and Charts: Visual representations summarize essential valuation metrics for straightforward analysis.
How It Works
- Download the Template: Gain immediate access to the Excel-based NEOG DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and other parameters.
- Instant Calculations: The model automatically recalculates Neogen Corporation’s intrinsic value.
- Test Scenarios: Experiment with various assumptions to assess potential changes in valuation.
- Analyze and Decide: Utilize the findings to inform your investment or financial analysis.
Why Choose This Calculator for Neogen Corporation (NEOG)?
- User-Friendly Interface: Perfect for both novices and seasoned users.
- Customizable Inputs: Tailor assumptions easily to suit your financial analysis.
- Real-Time Feedback: Observe immediate updates to Neogen's valuation as you change the inputs.
- Pre-Loaded Data: Comes with Neogen’s latest financial information for swift evaluations.
- Relied Upon by Experts: A go-to tool for investors and analysts seeking reliable insights.
Who Should Use This Product?
- Investors: Evaluate Neogen Corporation’s (NEOG) valuation prior to making investment decisions.
- CFOs and Financial Analysts: Optimize valuation methodologies and validate forecasts for Neogen Corporation (NEOG).
- Startup Founders: Gain insights into how established companies like Neogen Corporation (NEOG) are valued in the market.
- Consultants: Produce comprehensive valuation reports for clients focused on Neogen Corporation (NEOG).
- Students and Educators: Utilize real-time data from Neogen Corporation (NEOG) to practice and instruct on valuation methods.
What the Template Contains
- Historical Data: Includes Neogen Corporation’s past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate Neogen Corporation’s intrinsic value.
- WACC Sheet: Pre-built calculations for Weighted Average Cost of Capital.
- Editable Inputs: Modify key drivers like growth rates, EBITDA %, and CAPEX assumptions.
- Quarterly and Annual Statements: A complete breakdown of Neogen Corporation’s financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.