|
Avanos Medical, Inc. (AVNS) DCF Valoración
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
Avanos Medical, Inc. (AVNS) Bundle
¡Mejore sus opciones de inversión con la calculadora DCF de Avanos Medical, Inc. (AVNS)! Explore datos financieros auténticos, ajuste las proyecciones y gastos de crecimiento, y observe instantáneamente los efectos de estos cambios en el valor intrínseco de Avanos Medical, Inc. (AVNS).
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 | 697.6 | 714.8 | 744.6 | 820.0 | 673.3 | 671.4 | 669.5 | 667.6 | 665.7 | 663.8 |
| Revenue Growth, % | 0 | 2.47 | 4.17 | 10.13 | -17.89 | -0.28235 | -0.28235 | -0.28235 | -0.28235 | -0.28235 |
| EBITDA | -12.1 | -2.0 | 8.9 | 77.8 | 50.6 | 21.7 | 21.7 | 21.6 | 21.5 | 21.5 |
| EBITDA, % | -1.73 | -0.2798 | 1.2 | 9.49 | 7.52 | 3.24 | 3.24 | 3.24 | 3.24 | 3.24 |
| Depreciation | 36.9 | 42.9 | 38.3 | 41.1 | 46.1 | 38.0 | 37.9 | 37.8 | 37.7 | 37.6 |
| Depreciation, % | 5.29 | 6 | 5.14 | 5.01 | 6.85 | 5.66 | 5.66 | 5.66 | 5.66 | 5.66 |
| EBIT | -49.0 | -44.9 | -29.4 | 36.7 | 4.5 | -16.3 | -16.2 | -16.2 | -16.1 | -16.1 |
| EBIT, % | -7.02 | -6.28 | -3.95 | 4.48 | 0.66835 | -2.42 | -2.42 | -2.42 | -2.42 | -2.42 |
| Total Cash | 205.3 | 111.5 | 118.5 | 127.7 | 87.7 | 120.2 | 119.9 | 119.6 | 119.2 | 118.9 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 163.8 | 167.9 | 118.2 | 167.9 | 142.8 | 140.4 | 140.0 | 139.6 | 139.2 | 138.8 |
| Account Receivables, % | 23.48 | 23.49 | 15.87 | 20.48 | 21.21 | 20.91 | 20.91 | 20.91 | 20.91 | 20.91 |
| Inventories | 145.9 | 168.9 | 150.3 | 190.3 | 163.2 | 150.6 | 150.2 | 149.8 | 149.4 | 148.9 |
| Inventories, % | 20.91 | 23.63 | 20.19 | 23.21 | 24.24 | 22.44 | 22.44 | 22.44 | 22.44 | 22.44 |
| Accounts Payable | 83.0 | 67.6 | 56.4 | 67.9 | 56.3 | 61.2 | 61.0 | 60.8 | 60.7 | 60.5 |
| Accounts Payable, % | 11.9 | 9.46 | 7.57 | 8.28 | 8.36 | 9.11 | 9.11 | 9.11 | 9.11 | 9.11 |
| Capital Expenditure | -50.6 | -20.2 | -21.0 | -19.3 | -17.8 | -24.0 | -24.0 | -23.9 | -23.8 | -23.8 |
| Capital Expenditure, % | -7.25 | -2.83 | -2.82 | -2.35 | -2.64 | -3.58 | -3.58 | -3.58 | -3.58 | -3.58 |
| Tax Rate, % | -682.28 | -682.28 | -682.28 | -682.28 | -682.28 | -682.28 | -682.28 | -682.28 | -682.28 | -682.28 |
| EBITAT | -35.1 | -20.2 | -31.9 | 28.4 | 35.2 | -12.8 | -12.8 | -12.7 | -12.7 | -12.7 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -275.5 | -40.0 | 42.5 | -28.0 | 104.1 | 21.0 | 1.8 | 1.8 | 1.8 | 1.8 |
| WACC, % | 8.01 | 7.59 | 8.45 | 8.1 | 8.45 | 8.12 | 8.12 | 8.12 | 8.12 | 8.12 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 24.9 | |||||||||
| Long Term Growth Rate, % | 3.00 | |||||||||
| Free cash flow (T + 1) | 2 | |||||||||
| Terminal Value | 36 | |||||||||
| Present Terminal Value | 24 | |||||||||
| Enterprise Value | 49 | |||||||||
| Net Debt | 121 | |||||||||
| Equity Value | -72 | |||||||||
| Diluted Shares Outstanding, MM | 47 | |||||||||
| Equity Value Per Share | -1.55 |
What You Will Get
- Editable Excel Template: A fully customizable Excel-based DCF Calculator featuring pre-filled real AVNS financials.
- Real-World Data: Historical data and forward-looking estimates (highlighted in the yellow cells).
- Forecast Flexibility: Adjust forecast assumptions such as revenue growth, EBITDA %, and WACC.
- Automatic Calculations: Instantly observe how your inputs affect Avanos Medical’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
- Comprehensive DCF Calculator: Features detailed unlevered and levered DCF valuation models tailored for Avanos Medical, Inc. (AVNS).
- WACC Calculator: Customizable Weighted Average Cost of Capital sheet designed for Avanos Medical, Inc. (AVNS) with pre-set inputs.
- Adjustable Forecast Assumptions: Easily alter growth rates, capital expenditures, and discount rates specific to Avanos Medical, Inc. (AVNS).
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios relevant to Avanos Medical, Inc. (AVNS).
- Interactive Dashboard and Charts: Visual representations summarize essential valuation metrics for quick and effective analysis of Avanos Medical, Inc. (AVNS).
How It Works
- Download: Obtain the comprehensive Excel file containing Avanos Medical, Inc.'s (AVNS) financial data.
- Customize: Modify projections, including sales growth, EBITDA %, and WACC.
- Update Automatically: The intrinsic value and NPV calculations refresh in real-time.
- Test Scenarios: Develop various forecasts and instantly analyze the results.
- Make Decisions: Leverage the valuation findings to inform your investment choices.
Why Choose This Calculator for Avanos Medical, Inc. (AVNS)?
- Accurate Data: Up-to-date Avanos Medical financials guarantee trustworthy valuation outcomes.
- Customizable: Modify essential parameters such as growth rates, WACC, and tax rates to align with your forecasts.
- Time-Saving: Integrated calculations streamline your process, removing the need to begin from scratch.
- Professional-Grade Tool: Tailored for investors, analysts, and consultants in the healthcare sector.
- User-Friendly: Simple design and clear, step-by-step guidance make it accessible for all users.
Who Should Use This Product?
- Individual Investors: Make informed decisions about buying or selling Avanos Medical, Inc. (AVNS) stock.
- Financial Analysts: Streamline valuation processes with ready-to-use financial models for Avanos Medical, Inc. (AVNS).
- Consultants: Deliver professional valuation insights on Avanos Medical, Inc. (AVNS) to clients quickly and accurately.
- Business Owners: Understand how medical companies like Avanos Medical, Inc. (AVNS) are valued to guide your own strategy.
- Finance Students: Learn valuation techniques using real-world data and scenarios related to Avanos Medical, Inc. (AVNS).
What the Template Contains
- Historical Data: Includes Avanos Medical, Inc.'s (AVNS) past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate Avanos Medical, Inc.'s (AVNS) intrinsic value.
- WACC Sheet: Pre-built calculations for Weighted Average Cost of Capital for Avanos Medical, Inc. (AVNS).
- Editable Inputs: Modify key drivers like growth rates, EBITDA %, and CAPEX assumptions specific to Avanos Medical, Inc. (AVNS).
- Quarterly and Annual Statements: A complete breakdown of Avanos Medical, Inc.'s (AVNS) financials.
- Interactive Dashboard: Visualize valuation results and projections for Avanos Medical, Inc. (AVNS) dynamically.