Cleveland-Cliffs Inc. (CLF) 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
Cleveland-Cliffs Inc. (CLF) Bundle
Optimize your time and improve precision with our (CLF) DCF Calculator! Utilizing real Cleveland-Cliffs Inc. data and customizable assumptions, this tool empowers you to forecast, analyze, and evaluate (CLF) just like a seasoned investor.
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 | 1,989.9 | 5,354.0 | 20,444.0 | 22,989.0 | 21,996.0 | 33,441.0 | 50,841.2 | 77,295.0 | 117,513.3 | 178,658.2 |
| Revenue Growth, % | 0 | 169.06 | 281.85 | 12.45 | -4.32 | 52.03 | 52.03 | 52.03 | 52.03 | 52.03 |
| EBITDA | 498.4 | 310.0 | 5,044.0 | 3,106.0 | 1,859.0 | 5,181.4 | 7,877.4 | 11,976.3 | 18,207.8 | 27,681.7 |
| EBITDA, % | 25.05 | 5.79 | 24.67 | 13.51 | 8.45 | 15.49 | 15.49 | 15.49 | 15.49 | 15.49 |
| Depreciation | 85.1 | 308.0 | 904.0 | 1,034.0 | 973.0 | 1,563.2 | 2,376.6 | 3,613.1 | 5,493.2 | 8,351.4 |
| Depreciation, % | 4.28 | 5.75 | 4.42 | 4.5 | 4.42 | 4.67 | 4.67 | 4.67 | 4.67 | 4.67 |
| EBIT | 413.3 | 2.0 | 4,140.0 | 2,072.0 | 886.0 | 3,618.2 | 5,500.9 | 8,363.1 | 12,714.6 | 19,330.4 |
| EBIT, % | 20.77 | 0.03735525 | 20.25 | 9.01 | 4.03 | 10.82 | 10.82 | 10.82 | 10.82 | 10.82 |
| Total Cash | 352.6 | 112.0 | 48.0 | 26.0 | 198.0 | 1,408.5 | 2,141.4 | 3,255.6 | 4,949.5 | 7,524.9 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 152.6 | 1,193.0 | 2,154.0 | 1,960.0 | 1,840.0 | 3,837.6 | 5,834.3 | 8,870.1 | 13,485.4 | 20,502.2 |
| Account Receivables, % | 7.67 | 22.28 | 10.54 | 8.53 | 8.37 | 11.48 | 11.48 | 11.48 | 11.48 | 11.48 |
| Inventories | 317.4 | 3,828.0 | 5,188.0 | 5,130.0 | 4,460.0 | 10,394.6 | 15,803.1 | 24,025.8 | 36,527.0 | 55,532.9 |
| Inventories, % | 15.95 | 71.5 | 25.38 | 22.32 | 20.28 | 31.08 | 31.08 | 31.08 | 31.08 | 31.08 |
| Accounts Payable | 155.0 | 1,575.0 | 2,073.0 | 2,186.0 | 2,099.0 | 4,440.8 | 6,751.5 | 10,264.5 | 15,605.3 | 23,725.1 |
| Accounts Payable, % | 7.79 | 29.42 | 10.14 | 9.51 | 9.54 | 13.28 | 13.28 | 13.28 | 13.28 | 13.28 |
| Capital Expenditure | -656.0 | -525.0 | -705.0 | -943.0 | -646.0 | -3,562.1 | -5,415.6 | -8,233.4 | -12,517.4 | -19,030.5 |
| Capital Expenditure, % | -32.97 | -9.81 | -3.45 | -4.1 | -2.94 | -10.65 | -10.65 | -10.65 | -10.65 | -10.65 |
| Tax Rate, % | 33.17 | 33.17 | 33.17 | 33.17 | 33.17 | 33.17 | 33.17 | 33.17 | 33.17 | 33.17 |
| EBITAT | 387.7 | .8 | 3,252.8 | 1,540.2 | 592.2 | 2,576.5 | 3,917.1 | 5,955.2 | 9,053.8 | 13,764.7 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -498.2 | -3,347.2 | 1,628.8 | 1,996.2 | 1,622.2 | -5,012.8 | -4,216.6 | -6,410.6 | -9,746.1 | -14,817.3 |
| WACC, % | 11.7 | 9.81 | 11.14 | 10.98 | 10.7 | 10.86 | 10.86 | 10.86 | 10.86 | 10.86 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -27,955.2 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | -15,114 | |||||||||
| Terminal Value | -170,490 | |||||||||
| Present Terminal Value | -101,796 | |||||||||
| Enterprise Value | -129,751 | |||||||||
| Net Debt | 2,939 | |||||||||
| Equity Value | -132,690 | |||||||||
| Diluted Shares Outstanding, MM | 511 | |||||||||
| Equity Value Per Share | -259.67 |
What You Will Get
- Editable Excel Template: A fully customizable Excel-based DCF Calculator featuring pre-filled real CLF 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: Instantly observe the effect of your inputs on Cleveland-Cliffs Inc.’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 Cleveland-Cliffs Financials: Access reliable pre-loaded historical data and future forecasts.
- Customizable Forecast Parameters: Modify yellow-highlighted fields such as WACC, growth rates, and profit margins.
- Real-Time Calculations: Automatic updates for DCF, Net Present Value (NPV), and cash flow assessments.
- User-Friendly Dashboard: Intuitive charts and summaries to easily visualize your valuation outcomes.
- Designed for All Users: A straightforward, intuitive layout tailored for investors, CFOs, and consultants.
How It Works
- Step 1: Download the prebuilt Excel template with Cleveland-Cliffs Inc. (CLF) data included.
- Step 2: Explore the pre-filled sheets and familiarize yourself with the key metrics.
- Step 3: Update forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
- Step 4: Instantly view recalculated results, including Cleveland-Cliffs Inc. (CLF)'s intrinsic value.
- Step 5: Make informed investment decisions or generate reports using the outputs.
Why Choose This Calculator for Cleveland-Cliffs Inc. (CLF)?
- Accurate Data: Authentic Cleveland-Cliffs financials provide dependable valuation outcomes.
- Customizable: Tailor essential parameters such as growth rates, WACC, and tax rates to align with your forecasts.
- Time-Saving: Pre-configured calculations save you from starting from the ground up.
- Professional-Grade Tool: Crafted for investors, analysts, and consultants in the industry.
- User-Friendly: Easy-to-navigate design and clear instructions make it accessible for all users.
Who Should Use This Product?
- Investors: Accurately assess Cleveland-Cliffs Inc.'s (CLF) fair value before making investment choices.
- CFOs: Utilize a professional-grade DCF model for financial reporting and analysis related to Cleveland-Cliffs Inc. (CLF).
- Consultants: Quickly tailor the template for valuation reports specific to Cleveland-Cliffs Inc. (CLF) for clients.
- Entrepreneurs: Gain insights into financial modeling practices employed by leading steel producers like Cleveland-Cliffs Inc. (CLF).
- Educators: Employ it as a teaching resource to illustrate valuation methodologies with a focus on Cleveland-Cliffs Inc. (CLF).
What the Template Contains
- Comprehensive DCF Model: Editable template featuring detailed valuation calculations for Cleveland-Cliffs Inc. (CLF).
- Real-World Data: Cleveland-Cliffs Inc.'s historical and projected financials preloaded for thorough analysis.
- Customizable Parameters: Modify WACC, growth rates, and tax assumptions to explore various scenarios.
- Financial Statements: Complete annual and quarterly breakdowns for enhanced insights into Cleveland-Cliffs Inc. (CLF).
- Key Ratios: Integrated analysis for profitability, efficiency, and leverage specific to Cleveland-Cliffs Inc. (CLF).
- Dashboard with Visual Outputs: Charts and tables designed for clear, actionable results relevant to Cleveland-Cliffs Inc. (CLF).