|
Valoración de DCF de Commercial Metals Company (CMC)
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
Commercial Metals Company (CMC) Bundle
¡Simplifique la valoración de Commercial Metals Company (CMC) con esta calculadora DCF personalizable! Con las finanzas de Real Commercial Metals Company (CMC) y los aportes de pronóstico ajustables, puede probar escenarios y descubrir el valor razonable de la Compañía de Metales Comerciales (CMC) en minutos.
Discounted Cash Flow (DCF) - (USD MM)
| Year | AY1 2020 |
AY2 2021 |
AY3 2022 |
AY4 2023 |
AY5 2024 |
FY1 2025 |
FY2 2026 |
FY3 2027 |
FY4 2028 |
FY5 2029 |
|---|---|---|---|---|---|---|---|---|---|---|
| Revenue | 5,476.5 | 6,729.8 | 8,913.5 | 8,799.5 | 7,926.0 | 8,800.4 | 9,771.2 | 10,849.2 | 12,046.0 | 13,374.9 |
| Revenue Growth, % | 0 | 22.88 | 32.45 | -1.28 | -9.93 | 11.03 | 11.03 | 11.03 | 11.03 | 11.03 |
| EBITDA | 598.4 | 753.5 | 1,486.4 | 1,387.2 | 963.9 | 1,174.4 | 1,304.0 | 1,447.8 | 1,607.6 | 1,784.9 |
| EBITDA, % | 10.93 | 11.2 | 16.68 | 15.76 | 12.16 | 13.35 | 13.35 | 13.35 | 13.35 | 13.35 |
| Depreciation | 165.8 | 167.6 | 175.0 | 218.8 | 280.4 | 237.7 | 263.9 | 293.0 | 325.4 | 361.3 |
| Depreciation, % | 3.03 | 2.49 | 1.96 | 2.49 | 3.54 | 2.7 | 2.7 | 2.7 | 2.7 | 2.7 |
| EBIT | 432.6 | 585.9 | 1,311.4 | 1,168.4 | 683.6 | 936.7 | 1,040.1 | 1,154.8 | 1,282.2 | 1,423.6 |
| EBIT, % | 7.9 | 8.71 | 14.71 | 13.28 | 8.62 | 10.64 | 10.64 | 10.64 | 10.64 | 10.64 |
| Total Cash | 542.1 | 497.7 | 672.6 | 592.3 | 857.9 | 746.2 | 828.5 | 919.9 | 1,021.4 | 1,134.1 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 880.7 | 1,105.6 | 1,358.9 | 1,240.2 | 1,158.9 | 1,346.0 | 1,494.4 | 1,659.3 | 1,842.4 | 2,045.6 |
| Account Receivables, % | 16.08 | 16.43 | 15.25 | 14.09 | 14.62 | 15.29 | 15.29 | 15.29 | 15.29 | 15.29 |
| Inventories | 625.4 | 935.4 | 1,169.7 | 1,035.6 | 971.8 | 1,099.5 | 1,220.8 | 1,355.5 | 1,505.0 | 1,671.1 |
| Inventories, % | 11.42 | 13.9 | 13.12 | 11.77 | 12.26 | 12.49 | 12.49 | 12.49 | 12.49 | 12.49 |
| Accounts Payable | 266.1 | 450.7 | 428.1 | 364.4 | 350.6 | 438.7 | 487.0 | 540.8 | 600.4 | 666.7 |
| Accounts Payable, % | 4.86 | 6.7 | 4.8 | 4.14 | 4.42 | 4.98 | 4.98 | 4.98 | 4.98 | 4.98 |
| Capital Expenditure | -187.6 | -184.2 | -450.0 | -606.7 | -324.3 | -390.7 | -433.8 | -481.6 | -534.8 | -593.8 |
| Capital Expenditure, % | -3.43 | -2.74 | -5.05 | -6.89 | -4.09 | -4.44 | -4.44 | -4.44 | -4.44 | -4.44 |
| Tax Rate, % | 23.63 | 23.63 | 23.63 | 23.63 | 23.63 | 23.63 | 23.63 | 23.63 | 23.63 | 23.63 |
| EBITAT | 326.1 | 453.0 | 1,053.6 | 895.3 | 522.1 | 723.2 | 803.0 | 891.6 | 990.0 | 1,099.2 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -935.8 | 86.2 | 268.3 | 696.6 | 609.4 | 343.6 | 411.8 | 457.2 | 507.6 | 563.6 |
| WACC, % | 8.72 | 8.73 | 8.76 | 8.73 | 8.73 | 8.73 | 8.73 | 8.73 | 8.73 | 8.73 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 1,753.9 | |||||||||
| Long Term Growth Rate, % | 0.50 | |||||||||
| Free cash flow (T + 1) | 566 | |||||||||
| Terminal Value | 6,880 | |||||||||
| Present Terminal Value | 4,526 | |||||||||
| Enterprise Value | 6,280 | |||||||||
| Net Debt | 332 | |||||||||
| Equity Value | 5,949 | |||||||||
| Diluted Shares Outstanding, MM | 117 | |||||||||
| Equity Value Per Share | 50.78 |
What You Will Get
- Editable Excel Template: A fully customizable Excel-based DCF Calculator featuring pre-filled real CMC financials.
- Real-World Data: Historical data and forward-looking estimates (as indicated in the yellow cells).
- Forecast Flexibility: Adjust forecast assumptions such as revenue growth, EBITDA %, and WACC.
- Automatic Calculations: Quickly observe how your inputs influence Commercial Metals Company’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
- 🔍 Real-Life CMC Financials: Pre-filled historical and projected data for Commercial Metals Company (CMC).
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate CMC’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize CMC’s valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered Commercial Metals Company (CMC) data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for Commercial Metals Company’s intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose This Calculator for Commercial Metals Company (CMC)?
- Designed for Industry Leaders: A specialized tool utilized by financial analysts, CFOs, and industry consultants.
- Accurate Financial Data: CMC’s historical and projected financial information preloaded for precision.
- Flexible Scenario Analysis: Effortlessly simulate various forecasts and assumptions.
- Comprehensive Outputs: Automatically computes intrinsic value, NPV, and essential financial metrics.
- User-Friendly Interface: Step-by-step guidance to navigate through the calculations seamlessly.
Who Should Use Commercial Metals Company (CMC)?
- Investors: Gain insights into the metals industry and make informed investment choices.
- Financial Analysts: Utilize comprehensive data to streamline your analysis of metal market trends.
- Consultants: Tailor insights from CMC for impactful client strategies and recommendations.
- Industry Enthusiasts: Enhance your knowledge of the metals sector through real-time market updates.
- Educators and Students: Leverage CMC's resources for practical applications in materials and finance education.
What the Template Contains
- Comprehensive DCF Model: Editable template with detailed valuation calculations tailored for Commercial Metals Company (CMC).
- Real-World Data: CMC’s historical and projected financials preloaded for in-depth analysis.
- Customizable Parameters: Adjust WACC, growth rates, and tax assumptions to explore various scenarios.
- Financial Statements: Complete annual and quarterly breakdowns for enhanced insights into CMC's performance.
- Key Ratios: Integrated analysis for profitability, efficiency, and leverage specific to CMC.
- Dashboard with Visual Outputs: Charts and tables designed for clear, actionable results related to CMC.