Delek US Holdings, Inc. (DK) DCF Valuation

Delek US Holdings, Inc. (DK) 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

Delek US Holdings, Inc. (DK) Bundle

DCF model
Get Full Bundle:
$25 $15
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7

TOTAL:

Gain mastery over your Delek US Holdings, Inc. (DK) valuation analysis with our cutting-edge DCF Calculator! This Excel template comes preloaded with real (DK) data, enabling you to adjust forecasts and assumptions for an accurate calculation of Delek US Holdings, Inc.'s intrinsic value.


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 9,298.2 7,301.8 10,648.2 20,245.8 16,917.4 21,064.4 26,227.9 32,657.2 40,662.5 50,630.2
Revenue Growth, % 0 -21.47 45.83 90.13 -16.44 24.51 24.51 24.51 24.51 24.51
EBITDA 772.5 -336.1 324.6 899.3 664.0 637.0 793.2 987.6 1,229.7 1,531.1
EBITDA, % 8.31 -4.6 3.05 4.44 3.92 3.02 3.02 3.02 3.02 3.02
Depreciation 238.7 338.1 325.2 349.6 351.6 592.2 737.4 918.1 1,143.2 1,423.4
Depreciation, % 2.57 4.63 3.05 1.73 2.08 2.81 2.81 2.81 2.81 2.81
EBIT 533.8 -674.2 -.6 549.7 312.4 44.8 55.8 69.5 86.5 107.7
EBIT, % 5.74 -9.23 -0.00563476 2.72 1.85 0.21273 0.21273 0.21273 0.21273 0.21273
Total Cash 955.3 787.5 856.5 841.3 822.2 1,605.9 1,999.5 2,489.7 3,100.0 3,859.9
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 792.6 527.9 776.6 1,234.4 799.2
Account Receivables, % 8.52 7.23 7.29 6.1 4.72
Inventories 946.7 727.7 1,176.1 1,518.5 981.9 1,874.6 2,334.1 2,906.3 3,618.7 4,505.8
Inventories, % 10.18 9.97 11.05 7.5 5.8 8.9 8.9 8.9 8.9 8.9
Accounts Payable 1,599.7 1,144.0 1,695.3 1,745.6 1,814.3 2,870.6 3,574.3 4,450.5 5,541.4 6,899.8
Accounts Payable, % 17.2 15.67 15.92 8.62 10.72 13.63 13.63 13.63 13.63 13.63
Capital Expenditure -432.9 -272.2 -223.2 -311.4 -419.6 -610.8 -760.5 -946.9 -1,179.1 -1,468.1
Capital Expenditure, % -4.66 -3.73 -2.1 -1.54 -2.48 -2.9 -2.9 -2.9 -2.9 -2.9
Tax Rate, % 61.78 61.78 61.78 61.78 61.78 61.78 61.78 61.78 61.78 61.78
EBITAT 411.7 -503.9 -.4 398.8 119.4 30.1 37.5 46.7 58.1 72.3
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF 77.9 -410.0 -44.2 -312.9 1,091.9 -452.5 -91.3 -113.7 -141.5 -176.2
WACC, % 9.16 8.97 8.84 8.79 5.99 8.35 8.35 8.35 8.35 8.35
PV UFCF
SUM PV UFCF -805.5
Long Term Growth Rate, % 2.00
Free cash flow (T + 1) -180
Terminal Value -2,831
Present Terminal Value -1,896
Enterprise Value -2,702
Net Debt 1,944
Equity Value -4,645
Diluted Shares Outstanding, MM 66
Equity Value Per Share -70.41

What You Will Get

  • Real DK Financial Data: Pre-filled with Delek US Holdings, Inc.'s historical and projected data for precise analysis.
  • Fully Editable Template: Modify key inputs like revenue growth, WACC, and EBITDA % with ease.
  • Automatic Calculations: See Delek US Holdings, Inc.'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 DCF Calculator: Offers detailed unlevered and levered DCF valuation models tailored for Delek US Holdings, Inc. (DK).
  • WACC Calculator: Features a pre-built Weighted Average Cost of Capital sheet with adjustable inputs specific to the energy sector.
  • Customizable Forecast Assumptions: Allows users to modify growth rates, capital expenditures, and discount rates based on market conditions.
  • Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios relevant to Delek US Holdings, Inc. (DK).
  • Interactive Dashboard and Charts: Visual representations highlight key valuation metrics for simplified analysis.

How It Works

  • 1. Download the Template: Obtain and open the Excel file featuring Delek US Holdings, Inc. (DK)'s preloaded data.
  • 2. Adjust Key Inputs: Modify essential parameters such as growth rates, WACC, and capital expenditures.
  • 3. See Immediate Results: The DCF model automatically computes intrinsic value and NPV in real-time.
  • 4. Explore Different Scenarios: Analyze various forecasts to evaluate alternative valuation results.
  • 5. Present with Assurance: Deliver expert valuation insights to reinforce your decision-making process.

Why Choose This Calculator for Delek US Holdings, Inc. (DK)?

  • Comprehensive Tool: Offers DCF, WACC, and financial ratio analyses all in one convenient package.
  • Customizable Inputs: Modify the yellow-highlighted cells to explore different financial scenarios.
  • Detailed Insights: Automatically computes Delek’s intrinsic value and Net Present Value.
  • Preloaded Data: Includes historical and forecasted data for reliable starting points.
  • Professional Quality: Perfect for financial analysts, investors, and business consultants focused on (DK).

Who Should Use This Product?

  • Investors: Accurately assess Delek US Holdings, Inc.'s (DK) fair value prior to making investment choices.
  • CFOs: Utilize a professional-grade DCF model for financial reporting and analysis specific to Delek US Holdings, Inc. (DK).
  • Consultants: Efficiently customize the template for valuation reports tailored to Delek US Holdings, Inc. (DK) clients.
  • Entrepreneurs: Acquire knowledge of financial modeling practices employed by leading companies like Delek US Holdings, Inc. (DK).
  • Educators: Implement it as a teaching resource to illustrate valuation methodologies relevant to Delek US Holdings, Inc. (DK).

What the Template Contains

  • Pre-Filled Data: Includes Delek US Holdings, Inc.'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 US Holdings, Inc.'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.

No products were found matching.