|
Valoración de DCF de Superior Industries International, Inc. (SUP)
US | Consumer Cyclical | Auto - Parts | 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
Superior Industries International, Inc. (SUP) Bundle
¡Mejore sus estrategias de inversión con la calculadora (SUP) DCF! Analice datos financieros genuinos de las industrias superiores, ajuste las proyecciones y gastos de crecimiento, y observe instantáneamente cómo estas modificaciones afectan el valor intrínseco de (SUP).
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 | 1,372.5 | 1,100.8 | 1,384.8 | 1,639.9 | 1,385.3 | 1,416.1 | 1,447.6 | 1,479.8 | 1,512.7 | 1,546.4 |
| Revenue Growth, % | 0 | -19.8 | 25.8 | 18.42 | -15.53 | 2.22 | 2.22 | 2.22 | 2.22 | 2.22 |
| EBITDA | 48.2 | -85.1 | 157.3 | 189.2 | 43.1 | 61.7 | 63.1 | 64.5 | 65.9 | 67.4 |
| EBITDA, % | 3.51 | -7.73 | 11.36 | 11.54 | 3.11 | 4.36 | 4.36 | 4.36 | 4.36 | 4.36 |
| Depreciation | 93.2 | 98.2 | 99.6 | 91.2 | 93.0 | 99.6 | 101.8 | 104.1 | 106.4 | 108.8 |
| Depreciation, % | 6.79 | 8.92 | 7.19 | 5.56 | 6.71 | 7.04 | 7.04 | 7.04 | 7.04 | 7.04 |
| EBIT | -45.0 | -183.3 | 57.7 | 98.0 | -49.9 | -37.9 | -38.8 | -39.6 | -40.5 | -41.4 |
| EBIT, % | -3.28 | -16.65 | 4.16 | 5.98 | -3.6 | -2.68 | -2.68 | -2.68 | -2.68 | -2.68 |
| Total Cash | 77.9 | 152.4 | 113.5 | 213.0 | 201.6 | 156.5 | 160.0 | 163.6 | 167.2 | 170.9 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 81.4 | 54.0 | 88.4 | 75.0 | 58.0 | 73.6 | 75.2 | 76.9 | 78.6 | 80.3 |
| Account Receivables, % | 5.93 | 4.9 | 6.38 | 4.57 | 4.18 | 5.19 | 5.19 | 5.19 | 5.19 | 5.19 |
| Inventories | 168.5 | 155.0 | 172.1 | 178.7 | 144.6 | 170.3 | 174.0 | 177.9 | 181.9 | 185.9 |
| Inventories, % | 12.27 | 14.08 | 12.43 | 10.9 | 10.44 | 12.02 | 12.02 | 12.02 | 12.02 | 12.02 |
| Accounts Payable | 123.1 | 151.8 | 153.2 | 158.0 | 124.9 | 148.6 | 151.9 | 155.3 | 158.8 | 162.3 |
| Accounts Payable, % | 8.97 | 13.79 | 11.06 | 9.64 | 9.02 | 10.5 | 10.5 | 10.5 | 10.5 | 10.5 |
| Capital Expenditure | -64.3 | -45.0 | -64.1 | -57.2 | -41.2 | -56.3 | -57.5 | -58.8 | -60.1 | -61.4 |
| Capital Expenditure, % | -4.68 | -4.09 | -4.63 | -3.49 | -2.97 | -3.97 | -3.97 | -3.97 | -3.97 | -3.97 |
| Tax Rate, % | 20.5 | 20.5 | 20.5 | 20.5 | 20.5 | 20.5 | 20.5 | 20.5 | 20.5 | 20.5 |
| EBITAT | -46.7 | -195.2 | 19.3 | 71.1 | -39.6 | -29.2 | -29.9 | -30.5 | -31.2 | -31.9 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -144.5 | -72.3 | 4.7 | 116.7 | 30.2 | -3.4 | 12.3 | 12.6 | 12.9 | 13.2 |
| WACC, % | 10.82 | 10.82 | 4.76 | 8.31 | 8.95 | 8.73 | 8.73 | 8.73 | 8.73 | 8.73 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 35.1 | |||||||||
| Long Term Growth Rate, % | 0.50 | |||||||||
| Free cash flow (T + 1) | 13 | |||||||||
| Terminal Value | 161 | |||||||||
| Present Terminal Value | 106 | |||||||||
| Enterprise Value | 141 | |||||||||
| Net Debt | 424 | |||||||||
| Equity Value | -283 | |||||||||
| Diluted Shares Outstanding, MM | 28 | |||||||||
| Equity Value Per Share | -10.16 |
What You Will Receive
- Comprehensive SUP Financial Data: Pre-loaded with Superior Industries' historical and projected figures for accurate analysis.
- Completely Customizable Template: Easily adjust key metrics such as revenue growth, WACC, and EBITDA %.
- Instant Calculations: Watch the intrinsic value of Superior Industries update in real-time as you make changes.
- Expert Valuation Tool: Tailored for investors, analysts, and consultants aiming for precise DCF outcomes.
- Intuitive Design: Straightforward layout and clear guidelines suitable for all skill levels.
Key Features
- Accurate Superior Industries Financials: Gain access to reliable pre-loaded historical data and future forecasts.
- Adjustable Forecast Parameters: Modify highlighted cells for metrics like WACC, growth rates, and profit margins.
- Real-Time Calculations: Instant updates to DCF, Net Present Value (NPV), and cash flow assessments.
- User-Friendly Dashboard: Clear charts and summaries to help visualize your valuation outcomes.
- Suitable for All Skill Levels: An intuitive layout designed for investors, CFOs, and consultants alike.
How It Works
- Step 1: Download the Excel file for Superior Industries International, Inc. (SUP).
- Step 2: Review the pre-filled financial data and forecasts for Superior Industries.
- 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 the assumptions.
- Step 5: Analyze the outputs and leverage the results for your investment decisions.
Why Choose This Calculator for Superior Industries International, Inc. (SUP)?
- Accurate Data: Up-to-date financial information for Superior Industries ensures trustworthy valuation outcomes.
- Customizable: Tailor key inputs such as growth rates, WACC, and tax rates to align with your forecasts.
- Time-Saving: Built-in calculations save you the hassle of starting from the ground up.
- Professional-Grade Tool: Crafted for investors, analysts, and industry consultants.
- User-Friendly: Easy-to-navigate design and clear instructions make it accessible for everyone.
Who Should Use This Product?
- Individual Investors: Make informed decisions about buying or selling Superior Industries International, Inc. (SUP) stock.
- Financial Analysts: Streamline valuation processes with ready-to-use financial models tailored for Superior Industries International, Inc. (SUP).
- Consultants: Deliver professional valuation insights regarding Superior Industries International, Inc. (SUP) to clients quickly and accurately.
- Business Owners: Understand how companies like Superior Industries International, Inc. (SUP) are valued to guide your own business strategy.
- Finance Students: Learn valuation techniques using real-world data and scenarios related to Superior Industries International, Inc. (SUP).
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Superior Industries International, Inc. (SUP) historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
- WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), including parameters like Beta, risk-free rate, and share price.
- DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models showing intrinsic value with detailed calculations.
- Financial Statements: Pre-loaded financial statements (annual and quarterly) to support analysis.
- Key Ratios: Includes profitability, leverage, and efficiency ratios for Superior Industries International, Inc. (SUP).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.