SunCoke Energy, Inc. (SXC) DCF Valuation
- ✓ Totalmente Editável: Adapte-Se Às Suas Necessidades No Excel Ou Planilhas
- ✓ Design Profissional: Modelos Confiáveis E Padrão Da Indústria
- ✓ Pré-Construídos Para Uso Rápido E Eficiente
- ✓ Não É Necessária Experiência; Fácil De Seguir
SunCoke Energy, Inc. (SXC) Bundle
Engineered for accuracy, our SunCoke Energy, Inc. (SXC) DCF Calculator enables you to evaluate the valuation of SunCoke Energy with real-world financial data and complete flexibility to modify all essential parameters for improved projections.
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.