|
Valoración de DCF de Nucor Corporation (NUE)
US | 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
Nucor Corporation (NUE) Bundle
Ya sea que sea un inversor o un analista, esta calculadora DCF de Nucor Corporation (NUE) es su herramienta esencial para una valoración precisa. Cargados con datos reales de Nucor Corporation, puede ajustar los pronósticos y observar los efectos en tiempo real.
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 | 22,588.9 | 20,139.7 | 36,483.9 | 41,512.5 | 34,713.5 | 40,590.2 | 47,461.8 | 55,496.8 | 64,891.9 | 75,877.6 |
| Revenue Growth, % | 0 | -10.84 | 81.15 | 13.78 | -16.38 | 16.93 | 16.93 | 16.93 | 16.93 | 16.93 |
| EBITDA | 2,674.8 | 1,787.6 | 10,228.5 | 11,525.4 | 7,687.0 | 8,009.3 | 9,365.3 | 10,950.7 | 12,804.6 | 14,972.3 |
| EBITDA, % | 11.84 | 8.88 | 28.04 | 27.76 | 22.14 | 19.73 | 19.73 | 19.73 | 19.73 | 19.73 |
| Depreciation | 734.7 | 785.5 | 864.6 | 1,061.6 | 1,168.3 | 1,253.8 | 1,466.1 | 1,714.3 | 2,004.5 | 2,343.9 |
| Depreciation, % | 3.25 | 3.9 | 2.37 | 2.56 | 3.37 | 3.09 | 3.09 | 3.09 | 3.09 | 3.09 |
| EBIT | 1,940.2 | 1,002.2 | 9,364.0 | 10,463.8 | 6,518.7 | 6,755.5 | 7,899.2 | 9,236.4 | 10,800.1 | 12,628.5 |
| EBIT, % | 8.59 | 4.98 | 25.67 | 25.21 | 18.78 | 16.64 | 16.64 | 16.64 | 16.64 | 16.64 |
| Total Cash | 1,834.6 | 3,047.7 | 2,617.9 | 4,857.8 | 7,130.8 | 5,087.9 | 5,949.2 | 6,956.4 | 8,134.1 | 9,511.1 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 2,160.1 | 2,298.9 | 3,854.0 | 3,591.0 | 2,953.3 | 3,953.4 | 4,622.7 | 5,405.3 | 6,320.3 | 7,390.3 |
| Account Receivables, % | 9.56 | 11.41 | 10.56 | 8.65 | 8.51 | 9.74 | 9.74 | 9.74 | 9.74 | 9.74 |
| Inventories | 3,842.1 | 3,569.1 | 6,011.2 | 5,453.5 | 5,577.8 | 6,527.9 | 7,633.0 | 8,925.2 | 10,436.2 | 12,202.9 |
| Inventories, % | 17.01 | 17.72 | 16.48 | 13.14 | 16.07 | 16.08 | 16.08 | 16.08 | 16.08 | 16.08 |
| Accounts Payable | 1,201.7 | 1,432.2 | 1,830.2 | 1,649.5 | 2,020.3 | 2,211.4 | 2,585.8 | 3,023.6 | 3,535.4 | 4,134.0 |
| Accounts Payable, % | 5.32 | 7.11 | 5.02 | 3.97 | 5.82 | 5.45 | 5.45 | 5.45 | 5.45 | 5.45 |
| Capital Expenditure | -1,477.3 | -1,543.2 | -1,622.0 | -1,947.9 | -2,214.2 | -2,412.6 | -2,821.0 | -3,298.6 | -3,857.0 | -4,510.0 |
| Capital Expenditure, % | -6.54 | -7.66 | -4.45 | -4.69 | -6.38 | -5.94 | -5.94 | -5.94 | -5.94 | -5.94 |
| Tax Rate, % | 27.87 | 27.87 | 27.87 | 27.87 | 27.87 | 27.87 | 27.87 | 27.87 | 27.87 | 27.87 |
| EBITAT | 1,383.3 | 865.3 | 6,948.5 | 7,769.9 | 4,702.2 | 5,110.4 | 5,975.6 | 6,987.2 | 8,170.1 | 9,553.2 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -4,159.8 | 472.3 | 2,591.9 | 7,523.5 | 4,540.6 | 2,192.6 | 3,220.6 | 3,765.9 | 4,403.4 | 5,148.9 |
| WACC, % | 10.19 | 10.31 | 10.21 | 10.21 | 10.19 | 10.22 | 10.22 | 10.22 | 10.22 | 10.22 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 13,600.3 | |||||||||
| Long Term Growth Rate, % | 0.50 | |||||||||
| Free cash flow (T + 1) | 5,175 | |||||||||
| Terminal Value | 53,217 | |||||||||
| Present Terminal Value | 32,710 | |||||||||
| Enterprise Value | 46,310 | |||||||||
| Net Debt | 566 | |||||||||
| Equity Value | 45,744 | |||||||||
| Diluted Shares Outstanding, MM | 250 | |||||||||
| Equity Value Per Share | 182.67 |
What You Will Get
- Real NUE Financials: Access to historical and projected data for precise valuation.
- Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures as needed.
- Dynamic Calculations: Intrinsic value and NPV are computed automatically.
- Scenario Analysis: Evaluate various scenarios to assess Nucor’s future performance.
- User-Friendly Design: Designed for professionals while remaining approachable for newcomers.
Key Features
- Pre-Loaded Data: Nucor Corporation's historical financial statements and pre-filled forecasts.
- Fully Adjustable Inputs: Modify WACC, tax rates, revenue growth, and EBITDA margins as needed.
- Instant Results: View Nucor's intrinsic value recalculating in real time.
- Clear Visual Outputs: Dashboard charts illustrate valuation results and essential metrics.
- Built for Accuracy: A professional tool designed for analysts, investors, and finance specialists.
How It Works
- Step 1: Download the Excel file for Nucor Corporation (NUE).
- Step 2: Examine Nucor’s pre-filled financial data and projections.
- Step 3: Adjust key inputs such as revenue growth, WACC, and tax rates (highlighted cells).
- Step 4: Observe the DCF model update in real-time as you modify the assumptions.
- Step 5: Evaluate the outputs and leverage the results for investment strategies.
Why Choose This Calculator for Nucor Corporation (NUE)?
- Designed for Industry Experts: A sophisticated tool favored by analysts, CFOs, and industry consultants.
- Accurate Financial Data: Nucor’s historical and projected financials integrated for reliable analysis.
- Flexible Scenario Analysis: Effortlessly model various forecasts and assumptions.
- Comprehensive Outputs: Instantly computes intrinsic value, NPV, and essential financial metrics.
- User-Friendly Interface: Step-by-step guidance simplifies the calculation process.
Who Should Use Nucor Corporation (NUE)?
- Investors: Gain insights into the steel industry and make informed investment choices with a reliable resource.
- Financial Analysts: Streamline your analysis with comprehensive data and reports tailored for Nucor Corporation (NUE).
- Consultants: Easily modify industry reports to suit client needs and presentations focused on Nucor Corporation (NUE).
- Industry Enthusiasts: Enhance your knowledge of the steel market through detailed case studies and performance metrics.
- Educators and Students: Utilize real-world examples from Nucor Corporation (NUE) to enrich finance and business curricula.
What the Template Contains
- Preloaded NUE 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.