|
SunCoke Energy, Inc. (SXC) DCF Valoración
US | Energy | Coal | 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
SunCoke Energy, Inc. (SXC) Bundle
Ingementada para su precisión, nuestra calculadora DCF de SunCoke Energy, Inc. (SXC) le permite evaluar la valoración de la energía de la caja del sol con datos financieros del mundo real y una flexibilidad completa para modificar todos los parámetros esenciales para mejorar las proyecciones.
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,600.3 | 1,333.0 | 1,456.0 | 1,972.5 | 2,063.2 | 2,069.4 | 2,075.6 | 2,081.9 | 2,088.2 | 2,094.4 |
| Revenue Growth, % | 0 | -16.7 | 9.23 | 35.47 | 4.6 | 0.30097 | 0.30097 | 0.30097 | 0.30097 | 0.30097 |
| EBITDA | 2.0 | 210.2 | 243.5 | 296.2 | 267.9 | 250.9 | 251.6 | 252.4 | 253.2 | 253.9 |
| EBITDA, % | 0.12498 | 15.77 | 16.72 | 15.02 | 12.98 | 12.12 | 12.12 | 12.12 | 12.12 | 12.12 |
| Depreciation | 144.8 | 134.8 | 134.8 | 143.4 | 142.8 | 176.4 | 176.9 | 177.4 | 178.0 | 178.5 |
| Depreciation, % | 9.05 | 10.11 | 9.26 | 7.27 | 6.92 | 8.52 | 8.52 | 8.52 | 8.52 | 8.52 |
| EBIT | -142.8 | 75.4 | 108.7 | 152.8 | 125.1 | 74.5 | 74.8 | 75.0 | 75.2 | 75.4 |
| EBIT, % | -8.92 | 5.66 | 7.47 | 7.75 | 6.06 | 3.6 | 3.6 | 3.6 | 3.6 | 3.6 |
| Total Cash | 97.1 | 48.4 | 63.8 | 90.0 | 140.1 | 105.3 | 105.6 | 105.9 | 106.2 | 106.5 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 61.7 | 51.8 | 77.6 | 104.8 | 89.7 | 94.1 | 94.4 | 94.7 | 94.9 | 95.2 |
| Account Receivables, % | 3.86 | 3.89 | 5.33 | 5.31 | 4.35 | 4.55 | 4.55 | 4.55 | 4.55 | 4.55 |
| Inventories | 147.0 | 126.6 | 127.0 | 175.2 | 182.6 | 186.8 | 187.4 | 187.9 | 188.5 | 189.1 |
| Inventories, % | 9.19 | 9.5 | 8.72 | 8.88 | 8.85 | 9.03 | 9.03 | 9.03 | 9.03 | 9.03 |
| Accounts Payable | 142.4 | 104.1 | 126.0 | 159.3 | 172.1 | 172.9 | 173.4 | 174.0 | 174.5 | 175.0 |
| Accounts Payable, % | 8.9 | 7.81 | 8.65 | 8.08 | 8.34 | 8.36 | 8.36 | 8.36 | 8.36 | 8.36 |
| Capital Expenditure | -110.1 | -73.9 | -98.6 | -75.5 | -109.2 | -117.2 | -117.5 | -117.9 | -118.3 | -118.6 |
| Capital Expenditure, % | -6.88 | -5.54 | -6.77 | -3.83 | -5.29 | -5.66 | -5.66 | -5.66 | -5.66 | -5.66 |
| Tax Rate, % | 41.21 | 41.21 | 41.21 | 41.21 | 41.21 | 41.21 | 41.21 | 41.21 | 41.21 | 41.21 |
| EBITAT | -104.3 | 34.7 | 70.3 | 126.4 | 73.6 | 48.5 | 48.6 | 48.8 | 48.9 | 49.1 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -135.9 | 87.6 | 102.2 | 152.2 | 127.7 | 99.9 | 107.7 | 108.0 | 108.3 | 108.6 |
| WACC, % | 7.38 | 6.85 | 7.21 | 7.57 | 7.1 | 7.22 | 7.22 | 7.22 | 7.22 | 7.22 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 433.0 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 111 | |||||||||
| Terminal Value | 2,122 | |||||||||
| Present Terminal Value | 1,497 | |||||||||
| Enterprise Value | 1,930 | |||||||||
| Net Debt | 350 | |||||||||
| Equity Value | 1,580 | |||||||||
| Diluted Shares Outstanding, MM | 85 | |||||||||
| Equity Value Per Share | 18.61 |
What You Will Get
- Real SunCoke Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for SunCoke Energy, Inc. (SXC).
- Full Customization: Adjust all critical parameters (yellow cells) such as WACC, growth %, and tax rates tailored for SunCoke Energy, Inc. (SXC).
- Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on SunCoke Energy, Inc. (SXC)’s fair value.
- Versatile Excel Template: Designed for quick edits, scenario testing, and detailed projections specific to SunCoke Energy, Inc. (SXC).
- Time-Saving and Accurate: Avoid building models from scratch while ensuring precision and flexibility for SunCoke Energy, Inc. (SXC).
Key Features
- Comprehensive DCF Calculator: Features both unlevered and levered DCF valuation models tailored for SunCoke Energy, Inc. (SXC).
- WACC Calculator: Pre-formulated Weighted Average Cost of Capital sheet with adjustable parameters.
- Customizable Forecast Assumptions: Adjust growth rates, capital expenditures, and discount rates as needed.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios specific to SunCoke Energy, Inc. (SXC).
- Interactive Dashboard and Charts: Visual representations that summarize essential valuation metrics for straightforward analysis.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered SunCoke Energy data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for SunCoke Energy’s intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose This Calculator for SunCoke Energy, Inc. (SXC)?
- User-Friendly Interface: Perfectly crafted for both novices and seasoned professionals.
- Customizable Inputs: Easily adjust parameters to suit your financial analysis needs.
- Real-Time Valuation: Instantly observe how changes affect SunCoke's valuation as you tweak the inputs.
- Preloaded Data: Comes with SunCoke's actual financial figures for immediate evaluation.
- Industry Approved: A go-to tool for investors and analysts seeking reliable insights.
Who Should Use This Product?
- Institutional Investors: Develop comprehensive and precise valuation models for analyzing SunCoke Energy, Inc. (SXC) investments.
- Corporate Finance Departments: Evaluate valuation scenarios to inform strategic decisions within the organization.
- Financial Consultants and Advisors: Deliver accurate valuation insights related to SunCoke Energy, Inc. (SXC) to clients.
- Academic Students and Instructors: Utilize real-world data to enhance learning and practice in financial modeling.
- Energy Sector Enthusiasts: Gain insights into how energy companies like SunCoke Energy, Inc. (SXC) are valued in the market.
What the Template Contains
- Preloaded SXC 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.