|
Delek Logistics Partners, LP (DKL) DCF Valoración
US | Energy | Oil & Gas Midstream | 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
Delek Logistics Partners, LP (DKL) Bundle
¡Ahorre tiempo y mejore la precisión con nuestra calculadora DCF (DKL)! Utilizando los socios de logística de Real Delek, los datos de LP y los supuestos personalizables, esta herramienta le permite pronosticar, analizar y valor (DKL) como un inversor experimentado.
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 | 584.0 | 563.4 | 700.9 | 1,036.4 | 1,020.4 | 1,191.8 | 1,392.1 | 1,626.0 | 1,899.1 | 2,218.2 |
| Revenue Growth, % | 0 | -3.52 | 24.4 | 47.87 | -1.54 | 16.8 | 16.8 | 16.8 | 16.8 | 16.8 |
| EBITDA | 169.9 | 236.1 | 256.1 | 301.9 | 371.0 | 412.5 | 481.8 | 562.7 | 657.2 | 767.7 |
| EBITDA, % | 29.1 | 41.9 | 36.54 | 29.13 | 36.36 | 34.61 | 34.61 | 34.61 | 34.61 | 34.61 |
| Depreciation | 34.5 | 49.4 | 60.1 | 87.0 | 99.6 | 98.7 | 115.3 | 134.7 | 157.3 | 183.7 |
| Depreciation, % | 5.91 | 8.78 | 8.57 | 8.4 | 9.76 | 8.28 | 8.28 | 8.28 | 8.28 | 8.28 |
| EBIT | 135.4 | 186.6 | 196.0 | 214.9 | 271.4 | 313.7 | 366.5 | 428.0 | 499.9 | 583.9 |
| EBIT, % | 23.19 | 33.13 | 27.97 | 20.74 | 26.6 | 26.32 | 26.32 | 26.32 | 26.32 | 26.32 |
| Total Cash | 5.5 | 4.2 | 4.3 | 8.0 | 3.8 | 8.2 | 9.6 | 11.2 | 13.1 | 15.3 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 13.2 | 21.6 | 15.4 | 53.3 | 69.6 | 48.3 | 56.4 | 65.9 | 76.9 | 89.9 |
| Account Receivables, % | 2.26 | 3.84 | 2.19 | 5.14 | 6.82 | 4.05 | 4.05 | 4.05 | 4.05 | 4.05 |
| Inventories | 12.6 | 3.1 | 2.4 | 1.5 | 2.3 | 8.2 | 9.5 | 11.1 | 13.0 | 15.2 |
| Inventories, % | 2.16 | 0.55501 | 0.34327 | 0.14309 | 0.22187 | 0.68474 | 0.68474 | 0.68474 | 0.68474 | 0.68474 |
| Accounts Payable | 21.4 | 6.7 | 72.6 | 63.5 | 26.3 | 57.0 | 66.5 | 77.7 | 90.8 | 106.0 |
| Accounts Payable, % | 3.66 | 1.18 | 10.36 | 6.12 | 2.58 | 4.78 | 4.78 | 4.78 | 4.78 | 4.78 |
| Capital Expenditure | -9.1 | -13.3 | -24.0 | -146.7 | -96.1 | -73.7 | -86.1 | -100.5 | -117.4 | -137.1 |
| Capital Expenditure, % | -1.55 | -2.36 | -3.43 | -14.15 | -9.42 | -6.18 | -6.18 | -6.18 | -6.18 | -6.18 |
| Tax Rate, % | 0.94554 | 0.94554 | 0.94554 | 0.94554 | 0.94554 | 0.94554 | 0.94554 | 0.94554 | 0.94554 | 0.94554 |
| EBITAT | 134.1 | 186.4 | 195.9 | 214.4 | 268.8 | 312.2 | 364.7 | 426.0 | 497.5 | 581.1 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 155.1 | 208.9 | 304.8 | 108.6 | 218.1 | 383.3 | 394.0 | 460.2 | 537.6 | 627.9 |
| WACC, % | 11.36 | 11.4 | 11.4 | 11.39 | 11.36 | 11.38 | 11.38 | 11.38 | 11.38 | 11.38 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 1,710.4 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 640 | |||||||||
| Terminal Value | 6,826 | |||||||||
| Present Terminal Value | 3,982 | |||||||||
| Enterprise Value | 5,692 | |||||||||
| Net Debt | 1,715 | |||||||||
| Equity Value | 3,977 | |||||||||
| Diluted Shares Outstanding, MM | 44 | |||||||||
| Equity Value Per Share | 91.20 |
What You Will Get
- Editable Excel Template: A fully customizable Excel-based DCF Calculator featuring pre-filled real DKL 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 Delek Logistics Partners' 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
- Comprehensive DKL Data: Pre-filled with Delek Logistics Partners' historical performance metrics and future projections.
- Customizable Input Parameters: Modify revenue growth rates, profit margins, discount rates, tax implications, and capital investments.
- Interactive Valuation Framework: Automatically refreshes 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 for ease of use, catering to both industry veterans and newcomers.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered Delek Logistics data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for Delek Logistics' intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose This Calculator for Delek Logistics Partners, LP (DKL)?
- Accurate Data: Real Delek Logistics financials ensure reliable valuation outcomes.
- Customizable: Modify essential parameters like growth rates, WACC, and tax rates to align with your forecasts.
- Time-Saving: Pre-built calculations save you the hassle of starting from the ground up.
- Professional-Grade Tool: Tailored for investors, analysts, and consultants in the logistics sector.
- User-Friendly: Intuitive design and step-by-step guidance make it accessible for all users.
Who Should Use This Product?
- Finance Students: Explore logistics and energy sector valuation techniques with real-world data.
- Academics: Integrate industry-specific models into your teaching or research related to logistics.
- Investors: Evaluate your investment strategies and analyze valuation metrics for Delek Logistics Partners, LP (DKL).
- Analysts: Enhance your analysis process with a customizable DCF model tailored for logistics companies.
- Small Business Owners: Understand how large logistics firms like Delek are valued and analyzed in the market.
What the Template Contains
- Pre-Filled Data: Includes Delek Logistics Partners, LP’s historical financials and forecasts.
- Discounted Cash Flow Model: Editable DCF valuation model with automatic calculations.
- Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC based on custom inputs.
- Key Financial Ratios: Analyze Delek Logistics Partners, LP’s profitability, efficiency, and leverage.
- Customizable Inputs: Edit revenue growth, margins, and tax rates with ease.
- Clear Dashboard: Charts and tables summarizing key valuation results.