|
Infusystem Holdings, Inc. (infu) valoración de DCF
US | Healthcare | Medical - Instruments & Supplies | AMEX
|
- ✓ 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
InfuSystem Holdings, Inc. (INFU) Bundle
¡Simplifique la valoración de Infusystem Holdings, Inc. (infu) con esta calculadora DCF personalizable! Con Real Infusystem Holdings, Inc. (Infu) financieras y entradas de pronóstico ajustables, puede probar escenarios y descubrir Infusystem Holdings, Inc. (infu) valor razonable 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 | 81.1 | 97.4 | 102.4 | 109.9 | 125.8 | 140.6 | 157.1 | 175.5 | 196.1 | 219.2 |
Revenue Growth, % | 0 | 20.06 | 5.13 | 7.36 | 14.44 | 11.75 | 11.75 | 11.75 | 11.75 | 11.75 |
EBITDA | 15.8 | 22.8 | 17.2 | 15.1 | 16.5 | 24.3 | 27.2 | 30.4 | 33.9 | 37.9 |
EBITDA, % | 19.44 | 23.44 | 16.75 | 13.73 | 13.11 | 17.29 | 17.29 | 17.29 | 17.29 | 17.29 |
Depreciation | 12.3 | 14.0 | 14.6 | 13.4 | 12.5 | 18.6 | 20.7 | 23.2 | 25.9 | 28.9 |
Depreciation, % | 15.22 | 14.4 | 14.28 | 12.15 | 9.94 | 13.2 | 13.2 | 13.2 | 13.2 | 13.2 |
EBIT | 3.4 | 8.8 | 2.5 | 1.7 | 4.0 | 5.8 | 6.4 | 7.2 | 8.0 | 9.0 |
EBIT, % | 4.23 | 9.03 | 2.47 | 1.57 | 3.17 | 4.09 | 4.09 | 4.09 | 4.09 | 4.09 |
Total Cash | 2.6 | 9.6 | .2 | .2 | .2 | 3.8 | 4.3 | 4.8 | 5.4 | 6.0 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 12.1 | 14.7 | 15.4 | 16.9 | 19.8 | 21.4 | 23.9 | 26.7 | 29.9 | 33.4 |
Account Receivables, % | 14.91 | 15.11 | 15.05 | 15.35 | 15.76 | 15.24 | 15.24 | 15.24 | 15.24 | 15.24 |
Inventories | 2.9 | 3.0 | 3.9 | 4.8 | 6.4 | 5.6 | 6.3 | 7.0 | 7.8 | 8.8 |
Inventories, % | 3.57 | 3.08 | 3.85 | 4.39 | 5.09 | 4 | 4 | 4 | 4 | 4 |
Accounts Payable | 8.0 | 6.8 | 7.9 | 8.3 | 8.0 | 10.8 | 12.1 | 13.5 | 15.1 | 16.8 |
Accounts Payable, % | 9.82 | 6.96 | 7.68 | 7.59 | 6.37 | 7.68 | 7.68 | 7.68 | 7.68 | 7.68 |
Capital Expenditure | -22.6 | -16.9 | -16.7 | -15.1 | -1.0 | -21.4 | -23.9 | -26.7 | -29.8 | -33.3 |
Capital Expenditure, % | -27.86 | -17.37 | -16.27 | -13.72 | -0.81409 | -15.2 | -15.2 | -15.2 | -15.2 | -15.2 |
Tax Rate, % | 52.89 | 52.89 | 52.89 | 52.89 | 52.89 | 52.89 | 52.89 | 52.89 | 52.89 | 52.89 |
EBITAT | 3.1 | 20.2 | 2.9 | .2 | 1.9 | 4.0 | 4.5 | 5.0 | 5.6 | 6.3 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -14.2 | 13.4 | .3 | -3.3 | 8.5 | 3.2 | -.5 | -.6 | -.7 | -.8 |
WACC, % | 10.28 | 10.39 | 10.39 | 9.51 | 9.85 | 10.08 | 10.08 | 10.08 | 10.08 | 10.08 |
PV UFCF | ||||||||||
SUM PV UFCF | 1.1 | |||||||||
Long Term Growth Rate, % | 4.00 | |||||||||
Free cash flow (T + 1) | -1 | |||||||||
Terminal Value | -13 | |||||||||
Present Terminal Value | -8 | |||||||||
Enterprise Value | -7 | |||||||||
Net Debt | 36 | |||||||||
Equity Value | -43 | |||||||||
Diluted Shares Outstanding, MM | 22 | |||||||||
Equity Value Per Share | -2.00 |
What You Will Get
- Real INFU Financial Data: Pre-filled with InfuSystem's historical and projected data for precise analysis.
- Fully Editable Template: Modify key inputs like revenue growth, WACC, and EBITDA % with ease.
- Automatic Calculations: See InfuSystem's intrinsic value update instantly based on your changes.
- Professional Valuation Tool: Designed for investors, analysts, and consultants seeking accurate DCF results.
- User-Friendly Design: Simple structure and clear instructions for all experience levels.
Key Features
- Customizable Financial Inputs: Adjust essential variables such as revenue projections, EBITDA margins, and capital investments.
- Instant DCF Valuation: Automatically computes intrinsic value, NPV, and other financial metrics in real-time.
- High-Precision Accuracy: Leverages InfuSystem's actual financial data for dependable valuation results.
- Easy Scenario Testing: Effortlessly evaluate various assumptions and analyze different outcomes.
- Efficiency Booster: Avoid the hassle of constructing intricate valuation models from the ground up.
How It Works
- 1. Access the Template: Download and open the Excel file containing InfuSystem Holdings, Inc. (INFU) preloaded data.
- 2. Modify Assumptions: Adjust critical inputs such as growth rates, WACC, and capital expenditures.
- 3. Analyze Results Instantly: The DCF model automatically calculates intrinsic value and NPV.
- 4. Explore Scenarios: Evaluate various forecasts to understand different valuation possibilities.
- 5. Present with Confidence: Deliver professional valuation insights to enhance your decision-making process.
Why Choose This Calculator?
- Designed for Industry Experts: A sophisticated tool utilized by analysts, CFOs, and consultants.
- Accurate Data: InfuSystem's historical and projected financials preloaded for precision.
- Scenario Analysis: Effortlessly simulate various forecasts and assumptions.
- Comprehensive Outputs: Automatically computes intrinsic value, NPV, and essential metrics.
- User-Friendly: Step-by-step guidance leads you through the calculations.
Who Should Use InfuSystem Holdings, Inc. (INFU)?
- Healthcare Investors: Make informed investment choices with reliable data on InfuSystem's performance.
- Market Analysts: Streamline your analysis process with comprehensive reports on INFU's market position.
- Consultants: Easily modify presentations or reports to include insights on InfuSystem's services.
- Healthcare Enthusiasts: Enhance your knowledge of the healthcare sector with real-life case studies involving INFU.
- Educators and Students: Utilize it as a practical resource for coursework in healthcare finance and management.
What the Template Contains
- Preloaded INFU 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.