|
Valoración de DCF de Cheniere Energy, Inc. (LNG)
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
Cheniere Energy, Inc. (LNG) Bundle
¡Ahorre tiempo y mejore la precisión con nuestra calculadora DCF (LNG)! Utilizando datos reales de Cheniere Energy, Inc. y suposiciones personalizables, esta herramienta le permite pronosticar, analizar y evaluar (GNL) 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 | 9,730.0 | 9,358.0 | 15,864.0 | 33,428.0 | 20,394.0 | 23,528.9 | 27,145.6 | 31,318.2 | 36,132.3 | 41,686.4 |
Revenue Growth, % | 0 | -3.82 | 69.52 | 110.72 | -38.99 | 15.37 | 15.37 | 15.37 | 15.37 | 15.37 |
EBITDA | 3,153.0 | 3,566.0 | 171.0 | 5,621.0 | 16,709.0 | 8,015.6 | 9,247.7 | 10,669.2 | 12,309.2 | 14,201.3 |
EBITDA, % | 32.4 | 38.11 | 1.08 | 16.82 | 81.93 | 34.07 | 34.07 | 34.07 | 34.07 | 34.07 |
Depreciation | 1,144.0 | 1,223.0 | 1,404.0 | 1,726.0 | 1,196.0 | 2,103.7 | 2,427.1 | 2,800.1 | 3,230.6 | 3,727.1 |
Depreciation, % | 11.76 | 13.07 | 8.85 | 5.16 | 5.86 | 8.94 | 8.94 | 8.94 | 8.94 | 8.94 |
EBIT | 2,009.0 | 2,343.0 | -1,233.0 | 3,895.0 | 15,513.0 | 5,911.9 | 6,820.6 | 7,869.1 | 9,078.7 | 10,474.2 |
EBIT, % | 20.65 | 25.04 | -7.77 | 11.65 | 76.07 | 25.13 | 25.13 | 25.13 | 25.13 | 25.13 |
Total Cash | 2,474.0 | 1,628.0 | 1,404.0 | 1,353.0 | 4,066.0 | 3,560.3 | 4,107.6 | 4,739.0 | 5,467.4 | 6,307.8 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 491.0 | 647.0 | 1,506.0 | 1,944.0 | 1,106.0 | 1,538.4 | 1,774.9 | 2,047.7 | 2,362.5 | 2,725.6 |
Account Receivables, % | 5.05 | 6.91 | 9.49 | 5.82 | 5.42 | 6.54 | 6.54 | 6.54 | 6.54 | 6.54 |
Inventories | 312.0 | 292.0 | 706.0 | 826.0 | 445.0 | 726.1 | 837.7 | 966.5 | 1,115.1 | 1,286.5 |
Inventories, % | 3.21 | 3.12 | 4.45 | 2.47 | 2.18 | 3.09 | 3.09 | 3.09 | 3.09 | 3.09 |
Accounts Payable | 66.0 | 35.0 | 155.0 | 124.0 | 181.0 | 154.7 | 178.5 | 205.9 | 237.6 | 274.1 |
Accounts Payable, % | 0.67831 | 0.37401 | 0.97705 | 0.37095 | 0.88752 | 0.65757 | 0.65757 | 0.65757 | 0.65757 | 0.65757 |
Capital Expenditure | -3,056.0 | -1,839.0 | -966.0 | -1,830.0 | -2,121.0 | -3,436.3 | -3,964.5 | -4,573.9 | -5,277.0 | -6,088.2 |
Capital Expenditure, % | -31.41 | -19.65 | -6.09 | -5.47 | -10.4 | -14.6 | -14.6 | -14.6 | -14.6 | -14.6 |
Tax Rate, % | 32.22 | 32.22 | 32.22 | 32.22 | 32.22 | 32.22 | 32.22 | 32.22 | 32.22 | 32.22 |
EBITAT | 1,820.7 | -366.1 | -1,268.2 | 1,797.7 | 10,514.7 | 3,601.1 | 4,154.6 | 4,793.3 | 5,530.1 | 6,380.1 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -828.3 | -1,149.1 | -1,983.2 | 1,104.7 | 10,865.7 | 1,528.7 | 2,292.9 | 2,645.3 | 3,051.9 | 3,521.1 |
WACC, % | 7.22 | 5.83 | 7.36 | 6.54 | 6.87 | 6.76 | 6.76 | 6.76 | 6.76 | 6.76 |
PV UFCF | ||||||||||
SUM PV UFCF | 10,504.2 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 3,591 | |||||||||
Terminal Value | 75,379 | |||||||||
Present Terminal Value | 54,339 | |||||||||
Enterprise Value | 64,843 | |||||||||
Net Debt | 22,724 | |||||||||
Equity Value | 42,119 | |||||||||
Diluted Shares Outstanding, MM | 243 | |||||||||
Equity Value Per Share | 173.62 |
What You Will Get
- Real LNG Financial Data: Pre-filled with Cheniere Energy’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 Cheniere Energy’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
- 🔍 Real-Life LNG Financials: Pre-filled historical and projected data for Cheniere Energy, Inc. (LNG).
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate Cheniere’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize Cheniere’s valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review Cheniere Energy’s pre-filled financial data and forecasts.
- Step 3: Modify critical inputs like revenue growth, WACC, and tax rates (highlighted cells).
- Step 4: Watch the DCF model update instantly as you tweak assumptions.
- Step 5: Analyze the outputs and use the results for investment decisions.
Why Choose This Calculator for Cheniere Energy, Inc. (LNG)?
- Accurate Data: Real Cheniere Energy financials ensure reliable valuation results.
- Customizable: Adjust key parameters like growth rates, WACC, and tax rates to align with your projections.
- Time-Saving: Pre-built calculations save you from starting from scratch.
- Professional-Grade Tool: Tailored for investors, analysts, and consultants in the energy sector.
- User-Friendly: Intuitive design and step-by-step guidance make it accessible for all users.
Who Should Use This Product?
- Professional Investors: Develop comprehensive and accurate valuation models for assessing Cheniere Energy's portfolio.
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within the organization.
- Consultants and Advisors: Deliver precise valuation insights for clients interested in Cheniere Energy (LNG).
- Students and Educators: Utilize real-world data to enhance learning and practice in financial modeling.
- Energy Sector Enthusiasts: Gain insights into how companies like Cheniere Energy (LNG) are valued in the energy market.
What the Template Contains
- Preloaded LNG 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.