|
Valoración de DCF Nacional (SID) de Companhia Siderúrgica (SID)
BR | Basic Materials | Steel | 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
Companhia Siderúrgica Nacional (SID) Bundle
¡Descubra el verdadero potencial de Companhia Siderúrgica Nacional (SID) con nuestra calculadora DCF avanzada! Ajuste los supuestos clave, explore varios escenarios y examine cómo los diferentes factores influyen en la valoración de la compañía Siderúrgica (SID), todo dentro de una sola plantilla de Excel.
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 | 4,101.9 | 4,848.2 | 7,726.4 | 7,153.9 | 7,327.4 | 8,656.9 | 10,227.6 | 12,083.2 | 14,275.6 | 16,865.7 |
| Revenue Growth, % | 0 | 18.19 | 59.37 | -7.41 | 2.43 | 18.14 | 18.14 | 18.14 | 18.14 | 18.14 |
| EBITDA | 925.9 | 1,562.8 | 3,721.8 | 1,624.2 | 1,384.3 | 2,503.1 | 2,957.3 | 3,493.8 | 4,127.7 | 4,876.7 |
| EBITDA, % | 22.57 | 32.24 | 48.17 | 22.7 | 18.89 | 28.91 | 28.91 | 28.91 | 28.91 | 28.91 |
| Depreciation | 258.3 | 403.2 | 358.2 | 464.5 | 544.9 | 574.5 | 678.7 | 801.9 | 947.4 | 1,119.3 |
| Depreciation, % | 6.3 | 8.32 | 4.64 | 6.49 | 7.44 | 6.64 | 6.64 | 6.64 | 6.64 | 6.64 |
| EBIT | 667.5 | 1,159.6 | 3,363.6 | 1,159.8 | 839.4 | 1,928.6 | 2,278.5 | 2,692.0 | 3,180.4 | 3,757.4 |
| EBIT, % | 16.27 | 23.92 | 43.53 | 16.21 | 11.46 | 22.28 | 22.28 | 22.28 | 22.28 | 22.28 |
| Total Cash | 600.9 | 2,214.6 | 3,112.9 | 2,168.6 | 2,836.0 | 2,937.0 | 3,469.9 | 4,099.5 | 4,843.3 | 5,722.0 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 330.3 | 462.4 | 418.9 | 521.4 | 527.3 | 649.2 | 767.0 | 906.1 | 1,070.5 | 1,264.8 |
| Account Receivables, % | 8.05 | 9.54 | 5.42 | 7.29 | 7.2 | 7.5 | 7.5 | 7.5 | 7.5 | 7.5 |
| Inventories | 846.1 | 776.9 | 1,764.8 | 1,820.5 | 1,541.3 | 1,834.8 | 2,167.7 | 2,561.1 | 3,025.7 | 3,574.7 |
| Inventories, % | 20.63 | 16.02 | 22.84 | 25.45 | 21.03 | 21.2 | 21.2 | 21.2 | 21.2 | 21.2 |
| Accounts Payable | 666.7 | 877.8 | 1,755.7 | 1,984.5 | 1,251.7 | 1,764.3 | 2,084.4 | 2,462.6 | 2,909.5 | 3,437.4 |
| Accounts Payable, % | 16.25 | 18.11 | 22.72 | 27.74 | 17.08 | 20.38 | 20.38 | 20.38 | 20.38 | 20.38 |
| Capital Expenditure | -357.3 | -271.5 | -462.0 | -867.0 | -710.9 | -729.1 | -861.4 | -1,017.7 | -1,202.3 | -1,420.5 |
| Capital Expenditure, % | -8.71 | -5.6 | -5.98 | -12.12 | -9.7 | -8.42 | -8.42 | -8.42 | -8.42 | -8.42 |
| Tax Rate, % | 130.73 | 130.73 | 130.73 | 130.73 | 130.73 | 130.73 | 130.73 | 130.73 | 130.73 | 130.73 |
| EBITAT | 846.5 | 894.6 | 2,217.4 | 609.2 | -258.0 | 1,140.2 | 1,347.1 | 1,591.5 | 1,880.3 | 2,221.4 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 237.8 | 1,174.6 | 2,047.0 | 277.4 | -883.3 | 1,082.8 | 1,033.8 | 1,221.4 | 1,443.0 | 1,704.8 |
| WACC, % | 10.06 | 8.4 | 7.58 | 6.61 | 2.8 | 7.09 | 7.09 | 7.09 | 7.09 | 7.09 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 5,214.5 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 1,739 | |||||||||
| Terminal Value | 34,158 | |||||||||
| Present Terminal Value | 24,251 | |||||||||
| Enterprise Value | 29,466 | |||||||||
| Net Debt | 4,765 | |||||||||
| Equity Value | 24,701 | |||||||||
| Diluted Shares Outstanding, MM | 1,326 | |||||||||
| Equity Value Per Share | 18.63 |
What You Will Get
- Editable Excel Template: A fully customizable Excel-based DCF Calculator featuring pre-filled real Companhia Siderúrgica Nacional (SID) financials.
- Real-World Data: Historical data and forward-looking estimates (highlighted in the yellow cells).
- Forecast Flexibility: Adjust forecast assumptions such as revenue growth, EBITDA %, and WACC.
- Automatic Calculations: Instantly observe the effects of your inputs on Companhia Siderúrgica Nacional’s valuation.
- Professional Tool: Designed for investors, CFOs, consultants, and financial analysts.
- User-Friendly Design: Organized for clarity and ease of use, complete with step-by-step instructions.
Key Features
- Accurate CSN Financials: Gain access to reliable pre-loaded historical data and future forecasts for Companhia Siderúrgica Nacional (SID).
- Adjustable Forecast Assumptions: Modify the highlighted cells such as WACC, growth rates, and profit margins.
- Real-time Calculations: Automatic updates for DCF, Net Present Value (NPV), and cash flow analysis.
- Interactive Dashboard: User-friendly charts and summaries to help you visualize your valuation outcomes.
- Designed for All Users: A straightforward, intuitive layout tailored for investors, CFOs, and consultants alike.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered Companhia Siderúrgica Nacional (SID) data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for Companhia Siderúrgica Nacional’s (SID) intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose This Calculator for Companhia Siderúrgica Nacional (SID)?
- Accurate Data: Utilize real Companhia Siderúrgica Nacional financials for dependable valuation outcomes.
- Customizable: Tailor key inputs such as growth rates, WACC, and tax rates to align with your forecasts.
- Time-Saving: Pre-constructed calculations save you from starting from the ground up.
- Professional-Grade Tool: Crafted for investors, analysts, and consultants in the steel industry.
- User-Friendly: Easy-to-navigate design and clear instructions facilitate use for everyone.
Who Should Use Companhia Siderúrgica Nacional (SID)?
- Investors: Gain insights and make informed decisions with a leading steel producer.
- Financial Analysts: Streamline your analysis with comprehensive data on market trends and performance.
- Consultants: Easily tailor reports and presentations for clients in the industrial sector.
- Industry Enthusiasts: Enhance your knowledge of the steel industry and market dynamics through real-life case studies.
- Educators and Students: Utilize it as a valuable resource for learning about the steel market and corporate finance.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Companhia Siderúrgica Nacional (SID) historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
- WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), featuring parameters such as Beta, risk-free rate, and share price.
- DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models illustrating intrinsic value with comprehensive calculations.
- Financial Statements: Pre-loaded financial statements (annual and quarterly) to facilitate analysis.
- Key Ratios: Includes profitability, leverage, and efficiency ratios for Companhia Siderúrgica Nacional (SID).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions for easy result analysis.