|
Valoración de DCF de Steris Plc (Ste)
IE | 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
STERIS plc (STE) Bundle
¡Mejore sus opciones de inversión con la calculadora DCF STERIS PLC (STE)! Explore datos financieros de Steris auténticos, ajuste las proyecciones y gastos de crecimiento, y observe cómo estas modificaciones afectan el valor intrínseco de Steris PLC (STE) en tiempo real.
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 | 3,030.9 | 3,107.5 | 4,585.1 | 4,957.8 | 5,138.7 | 5,933.3 | 6,850.8 | 7,910.2 | 9,133.4 | 10,545.7 |
Revenue Growth, % | 0 | 2.53 | 47.55 | 8.13 | 3.65 | 15.46 | 15.46 | 15.46 | 15.46 | 15.46 |
EBITDA | 743.2 | 800.3 | 957.2 | 1,344.0 | 1,412.4 | 1,492.2 | 1,722.9 | 1,989.3 | 2,297.0 | 2,652.1 |
EBITDA, % | 24.52 | 25.75 | 20.88 | 27.11 | 27.49 | 25.15 | 25.15 | 25.15 | 25.15 | 25.15 |
Depreciation | 197.2 | 219.2 | 553.1 | 552.9 | 565.2 | 567.0 | 654.6 | 755.9 | 872.7 | 1,007.7 |
Depreciation, % | 6.51 | 7.06 | 12.06 | 11.15 | 11 | 9.56 | 9.56 | 9.56 | 9.56 | 9.56 |
EBIT | 545.9 | 581.1 | 404.1 | 791.1 | 847.2 | 925.2 | 1,068.3 | 1,233.5 | 1,424.2 | 1,644.5 |
EBIT, % | 18.01 | 18.7 | 8.81 | 15.96 | 16.49 | 15.59 | 15.59 | 15.59 | 15.59 | 15.59 |
Total Cash | 319.6 | 220.5 | 348.3 | 208.4 | 207.0 | 397.2 | 458.6 | 529.5 | 611.4 | 705.9 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 586.5 | 609.4 | 799.0 | 865.0 | 1,008.3 | 1,109.0 | 1,280.5 | 1,478.5 | 1,707.1 | 1,971.1 |
Account Receivables, % | 19.35 | 19.61 | 17.43 | 17.45 | 19.62 | 18.69 | 18.69 | 18.69 | 18.69 | 18.69 |
Inventories | 248.3 | 315.1 | 575.0 | 695.5 | 674.5 | 688.6 | 795.0 | 918.0 | 1,059.9 | 1,223.8 |
Inventories, % | 8.19 | 10.14 | 12.54 | 14.03 | 13.13 | 11.61 | 11.61 | 11.61 | 11.61 | 11.61 |
Accounts Payable | 149.3 | 157.0 | 225.7 | 264.2 | 251.7 | 298.2 | 344.3 | 397.5 | 459.0 | 530.0 |
Accounts Payable, % | 4.93 | 5.05 | 4.92 | 5.33 | 4.9 | 5.03 | 5.03 | 5.03 | 5.03 | 5.03 |
Capital Expenditure | -214.5 | -239.3 | -287.6 | -362.0 | -360.3 | -419.6 | -484.5 | -559.4 | -645.9 | -745.8 |
Capital Expenditure, % | -7.08 | -7.7 | -6.27 | -7.3 | -7.01 | -7.07 | -7.07 | -7.07 | -7.07 | -7.07 |
Tax Rate, % | 46.18 | 46.18 | 46.18 | 46.18 | 46.18 | 46.18 | 46.18 | 46.18 | 46.18 | 46.18 |
EBITAT | 446.3 | 446.2 | 313.4 | 538.1 | 455.9 | 662.3 | 764.7 | 883.0 | 1,019.5 | 1,177.2 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -256.4 | 344.1 | 198.1 | 581.0 | 526.0 | 741.4 | 703.0 | 811.7 | 937.2 | 1,082.1 |
WACC, % | 7.79 | 7.76 | 7.76 | 7.7 | 7.61 | 7.72 | 7.72 | 7.72 | 7.72 | 7.72 |
PV UFCF | ||||||||||
SUM PV UFCF | 3,385.3 | |||||||||
Long Term Growth Rate, % | 4.00 | |||||||||
Free cash flow (T + 1) | 1,125 | |||||||||
Terminal Value | 30,223 | |||||||||
Present Terminal Value | 20,834 | |||||||||
Enterprise Value | 24,219 | |||||||||
Net Debt | 3,176 | |||||||||
Equity Value | 21,043 | |||||||||
Diluted Shares Outstanding, MM | 99 | |||||||||
Equity Value Per Share | 211.79 |
What You Will Receive
- Pre-Filled Financial Model: STERIS plc's actual data allows for accurate DCF valuation.
- Comprehensive Forecast Control: Modify revenue growth rates, profit margins, WACC, and other critical factors.
- Real-Time Calculations: Automatic updates provide immediate feedback as you adjust parameters.
- Professional-Grade Template: A polished Excel file crafted for high-quality valuation presentations.
- Customizable and Reusable: Designed for adaptability, facilitating repeated use for in-depth forecasts.
Key Features
- Comprehensive STERIS Financials: Gain access to precise pre-loaded historical data and future forecasts.
- Adjustable Forecast Parameters: Modify highlighted cells for WACC, growth rates, and profit margins.
- Real-Time Calculations: Automatic updates for DCF, Net Present Value (NPV), and cash flow assessments.
- User-Friendly Dashboard: Clear charts and summaries to help visualize your valuation findings.
- Suitable for All Skill Levels: An intuitive design tailored for investors, CFOs, and consultants alike.
How It Works
- Step 1: Download the Excel file for STERIS plc (STE).
- Step 2: Review STERIS plc's pre-filled financial data and forecasts.
- Step 3: Modify key inputs such as revenue growth, WACC, and tax rates (highlighted cells).
- Step 4: Observe the DCF model update in real-time as you adjust assumptions.
- Step 5: Analyze the outputs and leverage the results for investment decisions.
Why Choose This Calculator for STERIS plc (STE)?
- Comprehensive Tool: Incorporates DCF, WACC, and financial ratio analyses all in one convenient package.
- Customizable Inputs: Modify the highlighted cells to explore different financial scenarios.
- Detailed Insights: Automatically computes STERIS plc’s intrinsic value and Net Present Value.
- Preloaded Data: Access historical and projected data for accurate analysis.
- Professional Quality: Perfect for financial analysts, investors, and business consultants focused on STERIS plc (STE).
Who Should Use This Product?
- Individual Investors: Make informed decisions about buying or selling STERIS plc (STE) stock.
- Financial Analysts: Streamline valuation processes with ready-to-use financial models for STERIS plc (STE).
- Consultants: Deliver professional valuation insights on STERIS plc (STE) to clients quickly and accurately.
- Business Owners: Understand how large companies like STERIS plc (STE) are valued to guide your own strategy.
- Finance Students: Learn valuation techniques using real-world data and scenarios related to STERIS plc (STE).
What the Template Contains
- Preloaded STE 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.