ArcelorMittal S.A. (MT) DCF Valuation
- ✓ Entièrement Modifiable: Adapté À Vos Besoins Dans Excel Ou Sheets
- ✓ Conception Professionnelle: Modèles Fiables Et Conformes Aux Normes Du Secteur
- ✓ Pré-Construits Pour Une Utilisation Rapide Et Efficace
- ✓ Aucune Expertise N'Est Requise; Facile À Suivre
ArcelorMittal S.A. (MT) Bundle
Discover the true potential of ArcelorMittal S.A. (MT) with our advanced DCF Calculator! Adjust key assumptions, explore various scenarios, and examine how different factors affect ArcelorMittal S.A. (MT) valuation – all within one convenient Excel template.
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 | 70,615.0 | 53,270.0 | 76,571.0 | 79,844.0 | 68,275.0 | 69,805.0 | 71,369.2 | 72,968.5 | 74,603.6 | 76,275.4 |
| Revenue Growth, % | 0 | -24.56 | 43.74 | 4.27 | -14.49 | 2.24 | 2.24 | 2.24 | 2.24 | 2.24 |
| EBITDA | 1,483.0 | 5,258.0 | 19,148.0 | 12,919.0 | 4,650.0 | 8,372.2 | 8,559.8 | 8,751.6 | 8,947.7 | 9,148.2 |
| EBITDA, % | 2.1 | 9.87 | 25.01 | 16.18 | 6.81 | 11.99 | 11.99 | 11.99 | 11.99 | 11.99 |
| Depreciation | 3,067.0 | 2,960.0 | 2,523.0 | 2,580.0 | 2,675.0 | 2,840.2 | 2,903.9 | 2,969.0 | 3,035.5 | 3,103.5 |
| Depreciation, % | 4.34 | 5.56 | 3.29 | 3.23 | 3.92 | 4.07 | 4.07 | 4.07 | 4.07 | 4.07 |
| EBIT | -1,584.0 | 2,298.0 | 16,625.0 | 10,339.0 | 1,975.0 | 5,531.9 | 5,655.9 | 5,782.7 | 5,912.2 | 6,044.7 |
| EBIT, % | -2.24 | 4.31 | 21.71 | 12.95 | 2.89 | 7.92 | 7.92 | 7.92 | 7.92 | 7.92 |
| Total Cash | 4,995.0 | 5,963.0 | 4,371.0 | 9,414.0 | 7,686.0 | 6,565.0 | 6,712.1 | 6,862.5 | 7,016.3 | 7,173.5 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 3,569.0 | 3,072.0 | 5,143.0 | 3,839.0 | 5,196.0 | 4,182.2 | 4,275.9 | 4,371.7 | 4,469.7 | 4,569.8 |
| Account Receivables, % | 5.05 | 5.77 | 6.72 | 4.81 | 7.61 | 5.99 | 5.99 | 5.99 | 5.99 | 5.99 |
| Inventories | 17,296.0 | 12,328.0 | 19,858.0 | 20,087.0 | 18,759.0 | 17,619.2 | 18,014.1 | 18,417.7 | 18,830.5 | 19,252.4 |
| Inventories, % | 24.49 | 23.14 | 25.93 | 25.16 | 27.48 | 25.24 | 25.24 | 25.24 | 25.24 | 25.24 |
| Accounts Payable | 12,614.0 | 11,525.0 | 15,093.0 | 13,532.0 | 13,605.0 | 13,414.3 | 13,714.9 | 14,022.2 | 14,336.4 | 14,657.7 |
| Accounts Payable, % | 17.86 | 21.64 | 19.71 | 16.95 | 19.93 | 19.22 | 19.22 | 19.22 | 19.22 | 19.22 |
| Capital Expenditure | -3,572.0 | -2,439.0 | -3,008.0 | -3,468.0 | -4,613.0 | -3,443.5 | -3,520.7 | -3,599.6 | -3,680.2 | -3,762.7 |
| Capital Expenditure, % | -5.06 | -4.58 | -3.93 | -4.34 | -6.76 | -4.93 | -4.93 | -4.93 | -4.93 | -4.93 |
| Tax Rate, % | 27.06 | 27.06 | 27.06 | 27.06 | 27.06 | 27.06 | 27.06 | 27.06 | 27.06 | 27.06 |
| EBITAT | -1,960.3 | -1,220.8 | 18,893.9 | 8,544.9 | 1,440.5 | 3,934.1 | 4,022.3 | 4,112.4 | 4,204.6 | 4,298.8 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -10,716.3 | 3,676.2 | 12,375.9 | 7,170.9 | -453.5 | 5,293.7 | 3,217.6 | 3,289.7 | 3,363.4 | 3,438.7 |
| WACC, % | 10.56 | 8.19 | 10.56 | 10.15 | 9.92 | 9.87 | 9.87 | 9.87 | 9.87 | 9.87 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 14,418.5 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 3,508 | |||||||||
| Terminal Value | 44,544 | |||||||||
| Present Terminal Value | 27,817 | |||||||||
| Enterprise Value | 42,236 | |||||||||
| Net Debt | 2,995 | |||||||||
| Equity Value | 39,241 | |||||||||
| Diluted Shares Outstanding, MM | 845 | |||||||||
| Equity Value Per Share | 46.44 |
What You Will Get
- Editable Forecast Inputs: Effortlessly adjust key assumptions (growth %, margins, WACC) to explore various scenarios.
- Real-World Data: ArcelorMittal’s financial data pre-loaded to facilitate your analysis.
- Automatic DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value automatically.
- Customizable and Professional: A refined Excel model tailored to meet your valuation requirements.
- Built for Analysts and Investors: Perfect for evaluating projections, confirming strategies, and optimizing efficiency.
Key Features
- Comprehensive MT Data: Pre-populated with ArcelorMittal's historical performance metrics and future projections.
- Customizable Financial Inputs: Modify parameters such as revenue growth, profit margins, discount rates, taxation, and capital investments.
- Interactive Valuation Model: Automatically recalculates Net Present Value (NPV) and intrinsic value based on your adjustments.
- Scenario Analysis: Develop various forecasting scenarios to evaluate different valuation possibilities.
- Intuitive User Interface: Designed to be accessible and easy to navigate for both experts and newcomers.
How It Works
- Step 1: Download the Excel file for ArcelorMittal S.A. (MT).
- Step 2: Review ArcelorMittal’s pre-filled financial data and projections.
- Step 3: Adjust essential inputs such as production volume, cost of goods sold, and tax rates (highlighted cells).
- Step 4: Observe the DCF model refresh in real-time as you modify assumptions.
- Step 5: Evaluate the results and leverage the outputs for your investment strategies.
Why Choose This Calculator for ArcelorMittal S.A. (MT)?
- Comprehensive Tool: Offers DCF, WACC, and financial ratio analyses tailored for ArcelorMittal (MT).
- Customizable Inputs: Modify the highlighted cells to explore different financial scenarios for ArcelorMittal (MT).
- Detailed Insights: Automatically computes ArcelorMittal’s intrinsic value and Net Present Value.
- Preloaded Data: Includes historical and projected data to provide reliable starting points for analysis.
- Professional Quality: Perfect for financial analysts, investors, and business consultants focused on ArcelorMittal (MT).
Who Should Use This Product?
- Investors: Assess ArcelorMittal’s (MT) intrinsic value effectively before making investment choices.
- CFOs: Utilize a sophisticated DCF model for comprehensive financial analysis and reporting.
- Consultants: Easily customize the template for client valuation reports specific to ArcelorMittal (MT).
- Entrepreneurs: Acquire knowledge on financial modeling practices adopted by leading steel companies.
- Educators: Implement it as a resource to illustrate valuation techniques in the classroom.
What the Template Contains
- Pre-Filled Data: Contains ArcelorMittal’s historical financials and projections.
- Discounted Cash Flow Model: Customizable DCF valuation model with automatic calculations.
- Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC using tailored inputs.
- Key Financial Ratios: Assess ArcelorMittal’s profitability, efficiency, and leverage metrics.
- Customizable Inputs: Easily modify revenue growth, profit margins, and tax rates.
- Clear Dashboard: Visual representations and tables summarizing essential valuation outcomes.