Orion Engineered Carbons S.A. (OEC) 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
Orion Engineered Carbons S.A. (OEC) Bundle
Explore the financial outlook of Orion Engineered Carbons S.A. (OEC) with our easy-to-use DCF Calculator! Enter your projections for growth, margins, and expenses to calculate the intrinsic value of Orion Engineered Carbons S.A. (OEC) and shape your investment approach.
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,476.4 | 1,136.4 | 1,546.8 | 2,030.9 | 1,893.9 | 2,072.1 | 2,267.1 | 2,480.4 | 2,713.8 | 2,969.2 |
| Revenue Growth, % | 0 | -23.03 | 36.12 | 31.3 | -6.75 | 9.41 | 9.41 | 9.41 | 9.41 | 9.41 |
| EBITDA | 240.3 | 149.9 | 244.9 | 302.8 | 327.2 | 321.1 | 351.3 | 384.4 | 420.6 | 460.1 |
| EBITDA, % | 16.27 | 13.19 | 15.83 | 14.91 | 17.28 | 15.5 | 15.5 | 15.5 | 15.5 | 15.5 |
| Depreciation | 96.7 | 96.5 | 104.1 | 105.7 | 113.0 | 136.5 | 149.4 | 163.4 | 178.8 | 195.6 |
| Depreciation, % | 6.55 | 8.49 | 6.73 | 5.2 | 5.97 | 6.59 | 6.59 | 6.59 | 6.59 | 6.59 |
| EBIT | 143.6 | 53.4 | 140.8 | 197.1 | 214.2 | 184.6 | 201.9 | 220.9 | 241.7 | 264.5 |
| EBIT, % | 9.72 | 4.7 | 9.1 | 9.71 | 11.31 | 8.91 | 8.91 | 8.91 | 8.91 | 8.91 |
| Total Cash | 75.1 | 68.5 | 65.7 | 60.8 | 37.5 | 84.3 | 92.2 | 100.9 | 110.4 | 120.8 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 266.7 | 234.8 | 288.9 | 367.8 | 241.0 | 365.7 | 400.1 | 437.7 | 478.9 | 524.0 |
| Account Receivables, % | 18.06 | 20.66 | 18.68 | 18.11 | 12.73 | 17.65 | 17.65 | 17.65 | 17.65 | 17.65 |
| Inventories | 164.8 | 141.5 | 229.8 | 277.9 | 287.1 | 278.9 | 305.2 | 333.9 | 365.3 | 399.7 |
| Inventories, % | 11.16 | 12.45 | 14.86 | 13.68 | 15.16 | 13.46 | 13.46 | 13.46 | 13.46 | 13.46 |
| Accounts Payable | 156.3 | 131.2 | 195.1 | 184.1 | 183.7 | 221.8 | 242.6 | 265.5 | 290.4 | 317.8 |
| Accounts Payable, % | 10.59 | 11.55 | 12.61 | 9.06 | 9.7 | 10.7 | 10.7 | 10.7 | 10.7 | 10.7 |
| Capital Expenditure | -155.8 | -144.9 | -214.7 | -232.8 | -172.8 | -239.4 | -262.0 | -286.6 | -313.6 | -343.1 |
| Capital Expenditure, % | -10.56 | -12.75 | -13.88 | -11.46 | -9.12 | -11.56 | -11.56 | -11.56 | -11.56 | -11.56 |
| Tax Rate, % | 36.62 | 36.62 | 36.62 | 36.62 | 36.62 | 36.62 | 36.62 | 36.62 | 36.62 | 36.62 |
| EBITAT | 104.3 | 37.7 | 102.1 | 133.2 | 135.8 | 128.0 | 140.0 | 153.2 | 167.6 | 183.4 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -230.0 | 19.4 | -87.0 | -131.9 | 193.2 | -53.4 | -12.4 | -13.5 | -14.8 | -16.2 |
| WACC, % | 7.76 | 7.7 | 7.76 | 7.62 | 7.51 | 7.67 | 7.67 | 7.67 | 7.67 | 7.67 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -93.2 | |||||||||
| Long Term Growth Rate, % | 3.00 | |||||||||
| Free cash flow (T + 1) | -17 | |||||||||
| Terminal Value | -357 | |||||||||
| Present Terminal Value | -247 | |||||||||
| Enterprise Value | -340 | |||||||||
| Net Debt | 890 | |||||||||
| Equity Value | -1,230 | |||||||||
| Diluted Shares Outstanding, MM | 60 | |||||||||
| Equity Value Per Share | -20.50 |
What You Will Get
- Real OEC Financial Data: Pre-filled with Orion Engineered Carbons’ historical and projected data for precise analysis.
- Fully Editable Template: Modify key inputs like revenue growth, WACC, and EBITDA % with ease.
- Automatic Calculations: See OEC’s intrinsic value update instantly based on your changes.
- Professional Valuation Tool: Designed for investors, analysts, and consultants seeking accurate DCF results.
- User-Friendly Design: Simple structure and clear instructions for all experience levels.
Key Features
- Comprehensive Data: Orion Engineered Carbons S.A. (OEC) provides detailed historical financial statements and insightful forecasts.
- Customizable Parameters: Modify WACC, tax rates, revenue growth, and EBITDA margins to fit your analysis.
- Real-Time Insights: Observe the recalculated intrinsic value of Orion Engineered Carbons S.A. (OEC) instantly.
- Visual Analytics: Intuitive dashboard charts illustrate valuation outcomes and essential metrics.
- Designed for Precision: A robust tool tailored for analysts, investors, and finance professionals.
How It Works
- Step 1: Download the Excel file for Orion Engineered Carbons S.A. (OEC).
- Step 2: Review the pre-filled financial data and forecasts for OEC.
- 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 your assumptions.
- Step 5: Evaluate the outputs and utilize the results for your investment strategies.
Why Choose This Calculator for Orion Engineered Carbons (OEC)?
- All-in-One Solution: Combines DCF, WACC, and financial ratio evaluations tailored for OEC.
- Flexible Inputs: Modify the highlighted fields to explore different financial scenarios.
- In-Depth Analysis: Automatically computes the intrinsic value and Net Present Value for OEC.
- Pre-Loaded Information: Historical and projected data provide reliable foundations for analysis.
- Expert-Level Tool: Perfect for financial analysts, investors, and business advisors focusing on OEC.
Who Should Use Orion Engineered Carbons S.A. (OEC)?
- Investors: Make informed investment choices with insights from a leading carbon black manufacturer.
- Financial Analysts: Utilize comprehensive financial data to enhance your market analysis.
- Consultants: Tailor reports and presentations with detailed information on OEC's industry positioning.
- Industry Professionals: Gain a deeper understanding of carbon black applications and market trends.
- Educators and Students: Explore real-world case studies and applications in materials science and engineering courses.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Orion Engineered Carbons S.A. (OEC) historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
- WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), including parameters like Beta, risk-free rate, and share price.
- DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models showing intrinsic value with detailed calculations.
- Financial Statements: Pre-loaded financial statements (annual and quarterly) to support analysis.
- Key Ratios: Includes profitability, leverage, and efficiency ratios for Orion Engineered Carbons S.A. (OEC).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.