Sotera Health Company (SHC) DCF Valuation
- ✓ 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
Sotera Health Company (SHC) Bundle
Explore the financial prospects of Sotera Health Company (SHC) with our user-friendly DCF Calculator! Enter your assumptions regarding growth, margins, and expenses to calculate the intrinsic value of Sotera Health Company (SHC) and refine your investment approach.
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 | 778.3 | 818.2 | 931.5 | 1,003.7 | 1,049.3 | 1,131.3 | 1,219.7 | 1,315.1 | 1,417.8 | 1,528.7 |
Revenue Growth, % | 0 | 5.12 | 13.85 | 7.75 | 4.54 | 7.82 | 7.82 | 7.82 | 7.82 | 7.82 |
EBITDA | 305.2 | 320.0 | 404.2 | -3.0 | 420.2 | 365.3 | 393.9 | 424.7 | 457.9 | 493.7 |
EBITDA, % | 39.22 | 39.11 | 43.4 | -0.2982 | 40.05 | 32.29 | 32.29 | 32.29 | 32.29 | 32.29 |
Depreciation | 148.8 | 145.5 | 153.2 | 147.7 | 160.3 | 188.6 | 203.3 | 219.2 | 236.3 | 254.8 |
Depreciation, % | 19.11 | 17.78 | 16.44 | 14.72 | 15.28 | 16.67 | 16.67 | 16.67 | 16.67 | 16.67 |
EBIT | 156.5 | 174.5 | 251.1 | -150.7 | 259.9 | 176.8 | 190.6 | 205.5 | 221.6 | 238.9 |
EBIT, % | 20.1 | 21.32 | 26.96 | -15.02 | 24.77 | 15.63 | 15.63 | 15.63 | 15.63 | 15.63 |
Total Cash | 62.9 | 102.5 | 106.9 | 396.3 | 301.7 | 227.0 | 244.7 | 263.8 | 284.4 | 306.7 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 111.6 | 131.0 | 134.0 | 155.7 | 175.5 | 174.2 | 187.8 | 202.5 | 218.3 | 235.4 |
Account Receivables, % | 14.34 | 16.01 | 14.39 | 15.51 | 16.73 | 15.4 | 15.4 | 15.4 | 15.4 | 15.4 |
Inventories | 37.4 | 34.1 | 54.3 | 37.1 | 52.0 | 53.1 | 57.2 | 61.7 | 66.5 | 71.7 |
Inventories, % | 4.8 | 4.17 | 5.83 | 3.7 | 4.95 | 4.69 | 4.69 | 4.69 | 4.69 | 4.69 |
Accounts Payable | 42.0 | 52.4 | 72.9 | 74.1 | 71.0 | 76.4 | 82.4 | 88.8 | 95.8 | 103.3 |
Accounts Payable, % | 5.4 | 6.4 | 7.82 | 7.39 | 6.77 | 6.76 | 6.76 | 6.76 | 6.76 | 6.76 |
Capital Expenditure | -57.3 | -53.5 | -102.2 | -182.4 | -215.0 | -143.7 | -155.0 | -167.1 | -180.1 | -194.2 |
Capital Expenditure, % | -7.36 | -6.54 | -10.97 | -18.17 | -20.49 | -12.7 | -12.7 | -12.7 | -12.7 | -12.7 |
Tax Rate, % | 51.54 | 51.54 | 51.54 | 51.54 | 51.54 | 51.54 | 51.54 | 51.54 | 51.54 | 51.54 |
EBITAT | 3,489.2 | 168.3 | 167.0 | -144.8 | 125.9 | 144.1 | 155.3 | 167.5 | 180.6 | 194.7 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 3,473.7 | 254.6 | 215.3 | -182.7 | 33.5 | 194.6 | 191.9 | 206.9 | 223.1 | 240.5 |
WACC, % | 11.2 | 11.11 | 10.42 | 11.1 | 10 | 10.77 | 10.77 | 10.77 | 10.77 | 10.77 |
PV UFCF | ||||||||||
SUM PV UFCF | 776.8 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 245 | |||||||||
Terminal Value | 2,799 | |||||||||
Present Terminal Value | 1,679 | |||||||||
Enterprise Value | 2,455 | |||||||||
Net Debt | 2,031 | |||||||||
Equity Value | 425 | |||||||||
Diluted Shares Outstanding, MM | 283 | |||||||||
Equity Value Per Share | 1.50 |
What You Will Receive
- Comprehensive Financial Model: Sotera Health Company’s (SHC) actual data facilitates accurate DCF valuation.
- Complete Forecasting Control: Modify revenue growth, profit margins, WACC, and other essential metrics.
- Real-Time Calculations: Automatic updates provide immediate feedback as you adjust inputs.
- Professional-Grade Template: A polished Excel file crafted for high-quality valuation presentations.
- Flexible and Reusable: Designed for adaptability, allowing for repeated use in detailed financial projections.
Key Features
- Pre-Loaded Data: Sotera Health Company's (SHC) historical financial statements and pre-filled forecasts.
- Fully Adjustable Inputs: Modify WACC, tax rates, revenue growth, and EBITDA margins as needed.
- Instant Results: View Sotera Health Company's (SHC) intrinsic value recalculating in real time.
- Clear Visual Outputs: Dashboard charts present valuation results and essential metrics.
- Built for Accuracy: A professional tool tailored for analysts, investors, and finance experts.
How It Works
- Download: Obtain the pre-configured Excel file featuring Sotera Health Company's (SHC) financial data.
- Customize: Modify projections, including revenue growth, EBITDA %, and WACC.
- Update Automatically: The intrinsic value and NPV calculations refresh in real-time.
- Test Scenarios: Generate various forecasts and instantly compare the results.
- Make Decisions: Utilize the valuation insights to inform your investment strategy.
Why Choose This Calculator for Sotera Health Company (SHC)?
- Accurate Data: Utilizes real Sotera Health financials for trustworthy valuation outcomes.
- Customizable: Tailor key inputs such as growth rates, WACC, and tax rates to fit your forecasts.
- Time-Saving: Pre-configured calculations save you the hassle of starting from the ground up.
- Professional-Grade Tool: Crafted for investors, analysts, and consultants in the healthcare sector.
- User-Friendly: Features an intuitive design and clear instructions, making it accessible for everyone.
Who Should Use Sotera Health Company (SHC)?
- Healthcare Investors: Make informed decisions with a reliable valuation tool tailored for the health sector.
- Financial Analysts: Streamline your workflow with a customizable DCF model designed specifically for Sotera Health.
- Consultants: Effortlessly modify the template for client proposals or strategic reports related to SHC.
- Healthcare Enthusiasts: Enhance your knowledge of healthcare valuation methods through practical examples.
- Educators and Students: Utilize it as a hands-on resource in healthcare finance courses.
What the Template Contains
- Pre-Filled DCF Model: Sotera Health Company's (SHC) financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
- Financial Ratios: Evaluate Sotera Health Company's (SHC) profitability, leverage, and efficiency.
- Editable Inputs: Change assumptions such as growth, margins, and CAPEX to fit your scenarios.
- Financial Statements: Annual and quarterly reports to support detailed analysis.
- Interactive Dashboard: Easily visualize key valuation metrics and results.