GrafTech International Ltd. (EAF) 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
GrafTech International Ltd. (EAF) Bundle
Looking to calculate the intrinsic value of GrafTech International Ltd.? Our EAF DCF Calculator integrates real-world data with extensive customization options, enabling you to adjust forecasts and enhance your investment strategies.
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,790.8 | 1,224.4 | 1,345.8 | 1,281.3 | 620.5 | 499.4 | 401.9 | 323.5 | 260.3 | 209.5 |
Revenue Growth, % | 0 | -31.63 | 9.92 | -4.8 | -51.57 | -19.52 | -19.52 | -19.52 | -19.52 | -19.52 |
EBITDA | 1,033.0 | 666.7 | 589.0 | 546.8 | -145.2 | 175.0 | 140.8 | 113.3 | 91.2 | 73.4 |
EBITDA, % | 57.69 | 54.45 | 43.77 | 42.68 | -23.4 | 35.04 | 35.04 | 35.04 | 35.04 | 35.04 |
Depreciation | 61.8 | 63.0 | 65.7 | 55.5 | 56.9 | 26.9 | 21.7 | 17.5 | 14.0 | 11.3 |
Depreciation, % | 3.45 | 5.14 | 4.88 | 4.33 | 9.17 | 5.4 | 5.4 | 5.4 | 5.4 | 5.4 |
EBIT | 971.2 | 603.7 | 523.3 | 491.3 | -202.1 | 148.0 | 119.1 | 95.9 | 77.2 | 62.1 |
EBIT, % | 54.23 | 49.31 | 38.89 | 38.35 | -32.57 | 29.64 | 29.64 | 29.64 | 29.64 | 29.64 |
Total Cash | 80.9 | 145.4 | 57.5 | 134.6 | 176.9 | 59.6 | 48.0 | 38.6 | 31.1 | 25.0 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 247.1 | 194.8 | 249.6 | 145.6 | 101.4 | 75.9 | 61.1 | 49.1 | 39.5 | 31.8 |
Account Receivables, % | 13.8 | 15.91 | 18.55 | 11.36 | 16.34 | 15.19 | 15.19 | 15.19 | 15.19 | 15.19 |
Inventories | 313.6 | 266.0 | 289.4 | 447.7 | 345.4 | 151.2 | 121.7 | 97.9 | 78.8 | 63.4 |
Inventories, % | 17.51 | 21.72 | 21.51 | 34.95 | 55.66 | 30.27 | 30.27 | 30.27 | 30.27 | 30.27 |
Accounts Payable | 78.7 | 71.0 | 117.1 | 103.2 | 83.3 | 40.3 | 32.4 | 26.1 | 21.0 | 16.9 |
Accounts Payable, % | 4.39 | 5.8 | 8.7 | 8.05 | 13.42 | 8.07 | 8.07 | 8.07 | 8.07 | 8.07 |
Capital Expenditure | -64.1 | -36.1 | -58.3 | -72.2 | -54.0 | -25.2 | -20.3 | -16.3 | -13.1 | -10.6 |
Capital Expenditure, % | -3.58 | -2.95 | -4.33 | -5.63 | -8.71 | -5.04 | -5.04 | -5.04 | -5.04 | -5.04 |
Tax Rate, % | 6.76 | 6.76 | 6.76 | 6.76 | 6.76 | 6.76 | 6.76 | 6.76 | 6.76 | 6.76 |
EBITAT | 858.0 | 514.2 | 445.3 | 416.0 | -188.4 | 129.2 | 104.0 | 83.7 | 67.4 | 54.2 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 373.7 | 633.3 | 420.6 | 331.1 | -58.9 | 307.8 | 141.9 | 114.2 | 91.9 | 74.0 |
WACC, % | 7.47 | 7.31 | 7.3 | 7.28 | 7.73 | 7.42 | 7.42 | 7.42 | 7.42 | 7.42 |
PV UFCF | ||||||||||
SUM PV UFCF | 622.3 | |||||||||
Long Term Growth Rate, % | 0.50 | |||||||||
Free cash flow (T + 1) | 74 | |||||||||
Terminal Value | 1,074 | |||||||||
Present Terminal Value | 751 | |||||||||
Enterprise Value | 1,373 | |||||||||
Net Debt | 754 | |||||||||
Equity Value | 619 | |||||||||
Diluted Shares Outstanding, MM | 257 | |||||||||
Equity Value Per Share | 2.41 |
What You Will Receive
- Comprehensive Financial Model: GrafTech’s actual data facilitates accurate DCF valuation.
- Complete Forecast Flexibility: Modify revenue growth, profit margins, WACC, and other essential factors.
- Real-Time Calculations: Automatic updates provide immediate feedback as you adjust inputs.
- Professional-Grade Template: A polished Excel file crafted for high-quality valuation presentations.
- Adaptable and Reusable: Designed for versatility, allowing repeated application for in-depth forecasts.
Key Features
- Customizable Financial Inputs: Adjust essential parameters such as production capacity, cost of goods sold, and operational expenses.
- Instant DCF Valuation: Automatically computes intrinsic value, NPV, and additional financial metrics.
- Industry-Leading Precision: Leverages GrafTech's actual financial data for accurate valuation results.
- Effortless Scenario Testing: Evaluate various assumptions and analyze results with ease.
- Efficiency Booster: Streamline the valuation process without the hassle of creating intricate models from the ground up.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review GrafTech International Ltd.'s pre-filled financial data and forecasts.
- Step 3: Modify key inputs such as revenue growth, WACC, and tax rates (highlighted cells).
- Step 4: Observe the DCF model update in real-time as you adjust your assumptions.
- Step 5: Analyze the outputs and utilize the results for your investment choices.
Why Choose This Calculator for GrafTech International Ltd. (EAF)?
- Precise Financials: Utilize accurate GrafTech financial data for trustworthy valuation outcomes.
- Flexible Options: Tailor crucial parameters such as growth rates, WACC, and tax rates to fit your forecasts.
- Efficiency Boost: Ready-to-use calculations save you from starting from the ground up.
- Expert-Level Resource: Crafted for investors, analysts, and consultants in the field.
- Easy to Navigate: User-friendly design and clear, step-by-step guidance facilitate use for everyone.
Who Should Use This Product?
- Investors: Evaluate GrafTech International Ltd.'s (EAF) market position before making investment decisions.
- CFOs and Financial Analysts: Enhance valuation methodologies and validate financial forecasts.
- Startup Founders: Understand the valuation strategies employed by established firms like GrafTech International Ltd. (EAF).
- Consultants: Provide comprehensive valuation assessments for your clients based on GrafTech International Ltd. (EAF).
- Students and Educators: Utilize current data to learn and teach valuation practices in real-world scenarios.
What the Template Contains
- Preloaded EAF 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.