Stevanato Group S.p.A. (STVN) 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
Stevanato Group S.p.A. (STVN) Bundle
Explore the financial future of Stevanato Group S.p.A. (STVN) with our user-friendly DCF Calculator! Enter your projections for growth, margins, and expenses to calculate the intrinsic value of Stevanato Group S.p.A. (STVN) and enhance your investment strategy.
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 | 559.2 | 689.9 | 879.5 | 1,025.2 | 1,131.1 | 1,351.0 | 1,613.6 | 1,927.3 | 2,302.0 | 2,749.5 |
Revenue Growth, % | 0 | 23.39 | 27.47 | 16.57 | 10.33 | 19.44 | 19.44 | 19.44 | 19.44 | 19.44 |
EBITDA | 111.0 | 163.0 | 236.5 | 267.2 | 283.8 | 328.4 | 392.2 | 468.4 | 559.5 | 668.3 |
EBITDA, % | 19.86 | 23.62 | 26.89 | 26.06 | 25.09 | 24.3 | 24.3 | 24.3 | 24.3 | 24.3 |
Depreciation | 48.0 | 52.3 | 60.1 | 66.3 | 81.8 | 99.2 | 118.4 | 141.5 | 169.0 | 201.8 |
Depreciation, % | 8.59 | 7.58 | 6.83 | 6.47 | 7.23 | 7.34 | 7.34 | 7.34 | 7.34 | 7.34 |
EBIT | 63.0 | 110.6 | 176.4 | 200.9 | 202.0 | 229.2 | 273.7 | 327.0 | 390.5 | 466.4 |
EBIT, % | 11.27 | 16.04 | 20.06 | 19.6 | 17.86 | 16.96 | 16.96 | 16.96 | 16.96 | 16.96 |
Total Cash | 131.6 | 163.7 | 456.7 | 267.5 | 75.2 | 356.5 | 425.8 | 508.6 | 607.4 | 725.5 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 198.7 | 204.1 | 237.0 | 329.5 | 494.3 | 453.7 | 541.9 | 647.2 | 773.1 | 923.4 |
Account Receivables, % | 35.54 | 29.58 | 26.95 | 32.14 | 43.7 | 33.58 | 33.58 | 33.58 | 33.58 | 33.58 |
Inventories | 137.4 | 145.2 | 155.2 | 222.3 | 266.1 | 293.1 | 350.1 | 418.2 | 499.5 | 596.6 |
Inventories, % | 24.58 | 21.05 | 17.64 | 21.68 | 23.52 | 21.7 | 21.7 | 21.7 | 21.7 | 21.7 |
Accounts Payable | 99.1 | 123.7 | 171.7 | 249.3 | 289.5 | 283.9 | 339.1 | 405.1 | 483.8 | 577.9 |
Accounts Payable, % | 17.72 | 17.94 | 19.53 | 24.31 | 25.6 | 21.02 | 21.02 | 21.02 | 21.02 | 21.02 |
Capital Expenditure | -77.0 | -100.1 | -118.0 | -253.4 | -460.6 | -289.4 | -345.7 | -412.9 | -493.2 | -589.1 |
Capital Expenditure, % | -13.77 | -14.5 | -13.41 | -24.72 | -40.72 | -21.42 | -21.42 | -21.42 | -21.42 | -21.42 |
Tax Rate, % | 23.17 | 23.17 | 23.17 | 23.17 | 23.17 | 23.17 | 23.17 | 23.17 | 23.17 | 23.17 |
EBITAT | 45.1 | 90.2 | 143.0 | 153.0 | 155.2 | 177.5 | 212.0 | 253.2 | 302.4 | 361.2 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -221.0 | 54.0 | 90.3 | -116.2 | -391.9 | -4.7 | -105.2 | -125.7 | -150.1 | -179.3 |
WACC, % | 6.94 | 6.97 | 6.96 | 6.95 | 6.95 | 6.95 | 6.95 | 6.95 | 6.95 | 6.95 |
PV UFCF | ||||||||||
SUM PV UFCF | -442.0 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | -183 | |||||||||
Terminal Value | -3,692 | |||||||||
Present Terminal Value | -2,638 | |||||||||
Enterprise Value | -3,080 | |||||||||
Net Debt | 341 | |||||||||
Equity Value | -3,421 | |||||||||
Diluted Shares Outstanding, MM | 265 | |||||||||
Equity Value Per Share | -12.91 |
What You Will Get
- Real STVN Financial Data: Pre-filled with Stevanato Group’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 Stevanato Group’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
- Comprehensive Historical Data: Stevanato Group’s past financial statements and pre-populated projections.
- Customizable Parameters: Modify WACC, tax rates, revenue growth, and EBITDA margins as needed.
- Real-Time Calculations: View Stevanato Group’s intrinsic value update instantly.
- Intuitive Visual Representations: Dashboard graphs showcase valuation outcomes and essential metrics.
- Engineered for Precision: A reliable tool designed for analysts, investors, and finance professionals.
How It Works
- Step 1: Download the Excel file for Stevanato Group S.p.A. (STVN).
- Step 2: Review the pre-filled financial data and forecasts for Stevanato Group.
- 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 your assumptions.
- Step 5: Analyze the results and utilize the outputs for your investment decisions.
Why Choose This Calculator for Stevanato Group S.p.A. (STVN)?
- Accurate Data: Real Stevanato Group financials provide trustworthy valuation outcomes.
- Customizable: Modify essential parameters such as growth rates, WACC, and tax rates to fit your forecasts.
- Time-Saving: Pre-built calculations save you from building models from the ground up.
- Professional-Grade Tool: Tailored for investors, analysts, and consultants in the industry.
- User-Friendly: Clear layout and step-by-step guidance ensure accessibility for all users.
Who Should Use Stevanato Group S.p.A. (STVN)?
- Investors: Make informed investment choices with insights from a leading player in the pharmaceutical packaging sector.
- Financial Analysts: Streamline your analysis with comprehensive data on market trends and company performance.
- Consultants: Efficiently tailor presentations or reports using detailed information on Stevanato Group’s offerings.
- Industry Enthusiasts: Enhance your knowledge of the pharmaceutical supply chain and packaging innovations.
- Educators and Students: Utilize it as a case study in business and finance courses focusing on the healthcare industry.
What the Template Contains
- Pre-Filled Data: Includes Stevanato Group S.p.A.'s historical financials and forecasts.
- Discounted Cash Flow Model: Editable DCF valuation model with automatic calculations.
- Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC based on custom inputs.
- Key Financial Ratios: Analyze Stevanato Group S.p.A.'s profitability, efficiency, and leverage.
- Customizable Inputs: Edit revenue growth, margins, and tax rates with ease.
- Clear Dashboard: Charts and tables summarizing key valuation results.