Steel Dynamics, Inc. (STLD) DCF Valuation
- ✓ Fully Editable: Tailor To Your Needs In Excel Or Sheets
- ✓ Professional Design: Trusted, Industry-Standard Templates
- ✓ Pre-Built For Quick And Efficient Use
- ✓ No Expertise Is Needed; Easy To Follow
Steel Dynamics, Inc. (STLD) Bundle
Engineered for accuracy, our Steel Dynamics, Inc. (STLD) DCF Calculator empowers you to evaluate Steel Dynamics' valuation using up-to-date financial data and complete flexibility to modify all key parameters for enhanced 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 | 10,485.3 | 9,601.5 | 18,408.9 | 22,260.8 | 18,795.3 | 22,960.3 | 28,048.3 | 34,263.8 | 41,856.7 | 51,132.1 |
Revenue Growth, % | 0.00 | -8.43 | 91.73 | 20.92 | -15.57 | 22.16 | 22.16 | 22.16 | 22.16 | 22.16 |
EBITDA | 1,323.5 | 1,192.3 | 4,613.9 | 5,496.8 | 3,589.0 | 4,312.0 | 5,267.5 | 6,434.7 | 7,860.7 | 9,602.6 |
EBITDA, % | 12.62 | 12.42 | 25.06 | 24.69 | 19.10 | 18.78 | 18.78 | 18.78 | 18.78 | 18.78 |
Depreciation | 321.1 | 325.8 | 347.7 | 384.2 | 437.8 | 569.4 | 695.6 | 849.7 | 1,038.0 | 1,268.1 |
Depreciation, % | 3.06 | 3.39 | 1.89 | 1.73 | 2.33 | 2.48 | 2.48 | 2.48 | 2.48 | 2.48 |
EBIT | 1,002.4 | 866.6 | 4,266.3 | 5,112.6 | 3,151.2 | 3,742.5 | 4,571.9 | 5,585.0 | 6,822.6 | 8,334.5 |
EBIT, % | 9.56 | 9.03 | 23.18 | 22.97 | 16.77 | 16.30 | 16.30 | 16.30 | 16.30 | 16.30 |
Total Cash | 1,643.6 | 1,368.6 | 1,243.9 | 2,256.6 | 2,122.1 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 844.3 | 971.9 | 1,916.4 | 2,056.1 | 1,608.3 | 2,130.7 | 2,602.9 | 3,179.7 | 3,884.3 | 4,745.1 |
Account Receivables, % | 8.05 | 10.12 | 10.41 | 9.24 | 8.56 | 9.28 | 9.28 | 9.28 | 9.28 | 9.28 |
Inventories | 1,689.0 | 1,843.5 | 3,531.1 | 3,130.0 | 2,894.6 | 3,855.0 | 4,709.3 | 5,752.9 | 7,027.7 | 8,585.1 |
Inventories, % | 16.11 | 19.20 | 19.18 | 14.06 | 15.40 | 16.79 | 16.79 | 16.79 | 16.79 | 16.79 |
Accounts Payable | 513.3 | 769.5 | 1,280.6 | 1,017.2 | 1,088.3 | 1,389.1 | 1,696.9 | 2,073.0 | 2,532.3 | 3,093.5 |
Accounts Payable, % | 4.90 | 8.01 | 6.96 | 4.57 | 5.79 | 6.05 | 6.05 | 6.05 | 6.05 | 6.05 |
Capital Expenditure | -451.9 | -1,198.1 | -1,006.2 | -908.9 | -1,657.9 | -1,614.1 | -1,971.8 | -2,408.7 | -2,942.5 | -3,594.6 |
Capital Expenditure, % | -4.31 | -12.48 | -5.47 | -4.08 | -8.82 | -7.03 | -7.03 | -7.03 | -7.03 | -7.03 |
Tax Rate, % | 23.32 | 21.92 | 23.64 | 23.07 | 23.86 | 23.16 | 23.16 | 23.16 | 23.16 | 23.16 |
EBITAT | 768.6 | 676.6 | 3,257.8 | 3,933.1 | 2,399.3 | 2,875.8 | 3,513.0 | 4,291.5 | 5,242.5 | 6,404.3 |
Depreciation | 321.1 | 325.8 | 347.7 | 384.2 | 437.8 | 569.4 | 695.6 | 849.7 | 1,038.0 | 1,268.1 |
Changes in Account Receivables | -522.4 | -472.2 | -576.8 | -704.6 | -860.8 | |||||
Changes in Inventories | -960.4 | -854.3 | -1,043.6 | -1,274.8 | -1,557.4 | |||||
Changes in Accounts Payable | 300.8 | 307.8 | 376.1 | 459.3 | 561.2 | |||||
Capital Expenditure | -451.9 | -1,198.1 | -1,006.2 | -908.9 | -1,657.9 | -1,614.1 | -1,971.8 | -2,408.7 | -2,942.5 | -3,594.6 |
UFCF | -1,382.3 | -221.7 | 478.2 | 3,406.6 | 1,933.4 | 649.0 | 1,218.2 | 1,488.2 | 1,817.9 | 2,220.8 |
WACC, % | 9.67 | 9.68 | 9.67 | 9.67 | 9.67 | 9.67 | 9.67 | 9.67 | 9.67 | 9.67 |
PV UFCF | 591.8 | 1,012.8 | 1,128.2 | 1,256.7 | 1,399.8 | |||||
SUM PV UFCF | 5,389.3 | |||||||||
Long Term Growth Rate, % | 0.50 | |||||||||
Free cash flow (T + 1) | 2,231.9 | |||||||||
Terminal Value | 24,339.2 | |||||||||
Present Terminal Value | 15,341.5 | |||||||||
Enterprise Value | 20,730.8 | |||||||||
Net Debt | 1,798.0 | |||||||||
Equity Value | 18,932.8 | |||||||||
Diluted Shares Outstanding, MM | 167.0 | |||||||||
Equity Value Per Share | 113.37 |
What You Will Get
- Real STLD Financials: Access to both historical and projected data for precise valuation.
- Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures to fit your analysis.
- Dynamic Calculations: Intrinsic value and NPV are computed in real-time.
- Scenario Analysis: Explore various scenarios to assess Steel Dynamics' future performance.
- User-Friendly Design: Designed for industry professionals while remaining approachable for newcomers.
Key Features
- Comprehensive STLD Data: Pre-loaded with Steel Dynamics’ historical performance metrics and future projections.
- Customizable Assumptions: Tailor inputs for revenue growth, profit margins, weighted average cost of capital (WACC), tax rates, and capital expenditures.
- Interactive Valuation Framework: Real-time adjustments to Net Present Value (NPV) and intrinsic value based on user-defined parameters.
- Scenario Analysis: Develop various forecast scenarios to evaluate different valuation possibilities.
- Intuitive Interface: Clean, organized design suitable for both industry experts and newcomers.
How It Works
- 1. Download the Template: Obtain and open the Excel file featuring Steel Dynamics, Inc. (STLD)'s preloaded data.
- 2. Adjust Key Inputs: Modify essential variables such as growth rates, WACC, and capital expenditures.
- 3. Analyze Results Immediately: The DCF model automatically computes intrinsic value and NPV in real-time.
- 4. Explore Different Scenarios: Evaluate various forecasts to assess multiple valuation results.
- 5. Present with Assurance: Deliver professional valuation insights to bolster your decision-making process.
Why Choose This Calculator?
- User-Friendly Interface: Suitable for both novices and seasoned professionals.
- Customizable Inputs: Effortlessly adjust parameters to tailor your analysis.
- Real-Time Feedback: Observe immediate updates to Steel Dynamics, Inc.’s (STLD) valuation as you make changes.
- Preloaded Data: Comes equipped with Steel Dynamics, Inc.’s (STLD) actual financial information for swift evaluation.
- Relied Upon by Experts: Utilized by investors and analysts for making well-informed choices.
Who Should Use This Product?
- Investors: Evaluate Steel Dynamics, Inc. (STLD) valuation prior to making investment decisions.
- CFOs and Financial Analysts: Enhance valuation methodologies and assess financial forecasts.
- Startup Founders: Discover how leading public companies like Steel Dynamics, Inc. (STLD) are appraised.
- Consultants: Provide clients with detailed and professional valuation analyses.
- Students and Educators: Utilize current data to practice and instruct on valuation strategies.
What the Template Contains
- Historical Data: Includes Steel Dynamics, Inc. (STLD)’s past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate Steel Dynamics, Inc. (STLD)’s intrinsic value.
- WACC Sheet: Pre-built calculations for Weighted Average Cost of Capital.
- Editable Inputs: Modify key drivers like growth rates, EBITDA %, and CAPEX assumptions.
- Quarterly and Annual Statements: A complete breakdown of Steel Dynamics, Inc. (STLD)’s financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.