STERIS plc (STE) DCF Valuation

STERIS plc (STE) DCF Valuation
  • ✓ Fully Editable: Tailor To Your Needs In Excel Or Sheets
  • ✓ Professional Design: Trusted, Industry-Standard Templates
  • ✓ Pre-Built For Quick And Efficient Use
  • ✓ No Expertise Is Needed; Easy To Follow

STERIS plc (STE) Bundle

DCF model
Get Full Bundle:
$25 $15
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7

TOTAL:

Enhance your investment choices with the STERIS plc (STE) DCF Calculator! Explore authentic STERIS financial data, adjust growth projections and expenses, and observe how these modifications affect the intrinsic value of STERIS plc (STE) in real-time.


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
Account Receivables, % 19.35 19.61 17.43 17.45 19.62
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

  1. Step 1: Download the Excel file for STERIS plc (STE).
  2. Step 2: Review STERIS plc's pre-filled financial data and forecasts.
  3. Step 3: Modify key inputs such as revenue growth, WACC, and tax rates (highlighted cells).
  4. Step 4: Observe the DCF model update in real-time as you adjust assumptions.
  5. 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.

Es wurden keine passenden Produkte gefunden.