|
Valoración de DCF PBF Energy Inc. (PBF)
US | Energy | Oil & Gas Refining & Marketing | 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
PBF Energy Inc. (PBF) Bundle
¡Descubra el verdadero potencial de PBF Energy Inc. (PBF) con nuestra calculadora DCF avanzada! Ajuste los supuestos clave, explore varios escenarios y examine cómo los diferentes cambios afectan la valoración de PBF Energy Inc. (PBF), todo dentro de una sola plantilla de Excel.
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 | 24,508.2 | 15,115.9 | 27,253.4 | 46,830.3 | 38,324.8 | 47,488.6 | 58,843.6 | 72,913.6 | 90,347.9 | 111,950.9 |
Revenue Growth, % | 0 | -38.32 | 80.3 | 71.83 | -18.16 | 23.91 | 23.91 | 23.91 | 23.91 | 23.91 |
EBITDA | 1,075.2 | -510.0 | 1,111.9 | 4,314.7 | 3,521.1 | 2,231.4 | 2,764.9 | 3,426.1 | 4,245.3 | 5,260.4 |
EBITDA, % | 4.39 | -3.37 | 4.08 | 9.21 | 9.19 | 4.7 | 4.7 | 4.7 | 4.7 | 4.7 |
Depreciation | 436.1 | 563.0 | 466.8 | 511.1 | 591.6 | 935.7 | 1,159.4 | 1,436.7 | 1,780.2 | 2,205.8 |
Depreciation, % | 1.78 | 3.72 | 1.71 | 1.09 | 1.54 | 1.97 | 1.97 | 1.97 | 1.97 | 1.97 |
EBIT | 639.1 | -1,073.0 | 645.1 | 3,803.6 | 2,929.5 | 1,295.7 | 1,605.5 | 1,989.4 | 2,465.1 | 3,054.5 |
EBIT, % | 2.61 | -7.1 | 2.37 | 8.12 | 7.64 | 2.73 | 2.73 | 2.73 | 2.73 | 2.73 |
Total Cash | 814.9 | 1,609.5 | 1,341.5 | 2,203.6 | 1,783.5 | 2,683.5 | 3,325.2 | 4,120.2 | 5,105.4 | 6,326.2 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 835.0 | 512.9 | 1,277.6 | 1,456.3 | 1,362.5 | 1,724.1 | 2,136.4 | 2,647.2 | 3,280.1 | 4,064.5 |
Account Receivables, % | 3.41 | 3.39 | 4.69 | 3.11 | 3.56 | 3.63 | 3.63 | 3.63 | 3.63 | 3.63 |
Inventories | 2,122.2 | 1,686.2 | 2,505.1 | 2,763.6 | 3,183.1 | 4,104.3 | 5,085.6 | 6,301.6 | 7,808.4 | 9,675.5 |
Inventories, % | 8.66 | 11.16 | 9.19 | 5.9 | 8.31 | 8.64 | 8.64 | 8.64 | 8.64 | 8.64 |
Accounts Payable | 601.4 | 407.0 | 911.7 | 854.6 | 959.0 | 1,217.5 | 1,508.6 | 1,869.3 | 2,316.3 | 2,870.2 |
Accounts Payable, % | 2.45 | 2.69 | 3.35 | 1.82 | 2.5 | 2.56 | 2.56 | 2.56 | 2.56 | 2.56 |
Capital Expenditure | -404.9 | -196.2 | -249.1 | -633.3 | -659.6 | -658.9 | -816.5 | -1,011.7 | -1,253.6 | -1,553.3 |
Capital Expenditure, % | -1.65 | -1.3 | -0.91401 | -1.35 | -1.72 | -1.39 | -1.39 | -1.39 | -1.39 | -1.39 |
Tax Rate, % | 25.83 | 25.83 | 25.83 | 25.83 | 25.83 | 25.83 | 25.83 | 25.83 | 25.83 | 25.83 |
EBITAT | 425.7 | -1,074.7 | 621.3 | 3,075.7 | 2,172.9 | 1,083.1 | 1,342.1 | 1,663.0 | 2,060.6 | 2,553.3 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -1,898.9 | -144.2 | -239.9 | 2,459.2 | 1,883.6 | 335.6 | 582.5 | 721.8 | 894.4 | 1,108.3 |
WACC, % | 8.45 | 9.02 | 8.96 | 8.69 | 8.58 | 8.74 | 8.74 | 8.74 | 8.74 | 8.74 |
PV UFCF | ||||||||||
SUM PV UFCF | 2,731.3 | |||||||||
Long Term Growth Rate, % | 0.50 | |||||||||
Free cash flow (T + 1) | 1,114 | |||||||||
Terminal Value | 13,516 | |||||||||
Present Terminal Value | 8,890 | |||||||||
Enterprise Value | 11,621 | |||||||||
Net Debt | 261 | |||||||||
Equity Value | 11,361 | |||||||||
Diluted Shares Outstanding, MM | 131 | |||||||||
Equity Value Per Share | 87.05 |
What You Will Get
- Editable Excel Template: A fully customizable Excel-based DCF Calculator featuring pre-filled real PBF financials.
- Real-World Data: Historical data and forward-looking estimates (as highlighted in the yellow cells).
- Forecast Flexibility: Adjust forecast assumptions such as revenue growth, EBITDA %, and WACC.
- Automatic Calculations: Instantly observe the impact of your inputs on PBF Energy'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
- Comprehensive PBF Financials: Gain access to precise pre-loaded historical data and future forecasts for PBF Energy Inc. (PBF).
- Adjustable Forecast Parameters: Modify highlighted cells for metrics such as WACC, growth rates, and profit margins.
- Automated Calculations: Real-time updates for DCF, Net Present Value (NPV), and cash flow assessments.
- Interactive Dashboard: User-friendly charts and summaries to effectively present your valuation outcomes.
- Designed for All Skill Levels: An intuitive layout tailored for investors, CFOs, and consultants alike.
How It Works
- Step 1: Download the prebuilt Excel template featuring PBF Energy Inc. (PBF) data.
- Step 2: Navigate through the pre-filled sheets to familiarize yourself with essential metrics.
- Step 3: Modify forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
- Step 4: Instantly see recalculated results, including PBF Energy Inc.'s (PBF) intrinsic value.
- Step 5: Make informed investment choices or create reports based on the outputs.
Why Choose This Calculator for PBF Energy Inc. (PBF)?
- Accuracy: Utilizes real PBF Energy financial data to ensure precision.
- Flexibility: Built for users to easily test and adjust inputs as needed.
- Time-Saving: Avoid the complexities of creating a DCF model from the ground up.
- Professional-Grade: Crafted with the expertise and usability expected at the CFO level.
- User-Friendly: Intuitive design makes it accessible for users without extensive financial modeling skills.
Who Should Use This Product?
- Individual Investors: Make informed decisions about buying or selling PBF Energy Inc. (PBF) stock.
- Financial Analysts: Streamline valuation processes with ready-to-use financial models specific to PBF Energy Inc. (PBF).
- Consultants: Deliver professional valuation insights regarding PBF Energy Inc. (PBF) to clients quickly and accurately.
- Business Owners: Understand how companies like PBF Energy Inc. (PBF) are valued to guide your own strategy.
- Finance Students: Learn valuation techniques using real-world data and scenarios related to PBF Energy Inc. (PBF).
What the Template Contains
- Pre-Filled Data: Includes PBF Energy 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 PBF Energy 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.