|
Cheniere Energy Partners, L.P. (CQP) DCF Valuation
US | Energy | Oil & Gas Midstream | AMEX
|
- ✓ 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
Cheniere Energy Partners, L.P. (CQP) Bundle
Designed for accuracy, our (CQP) DCF Calculator enables you to evaluate Cheniere Energy Partners, L.P. valuation using real-world financial insights, offering complete flexibility to modify all essential parameters for enhanced projections.
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 | 6,838.0 | 6,167.0 | 9,434.0 | 17,206.0 | 9,664.0 | 11,456.5 | 13,581.4 | 16,100.4 | 19,086.7 | 22,626.9 |
| Revenue Growth, % | 0 | -9.81 | 52.98 | 82.38 | -43.83 | 18.55 | 18.55 | 18.55 | 18.55 | 18.55 |
| EBITDA | 2,587.0 | 2,643.0 | 3,129.0 | 4,002.0 | 5,749.0 | 4,504.8 | 5,340.3 | 6,330.9 | 7,505.1 | 8,897.1 |
| EBITDA, % | 37.83 | 42.86 | 33.17 | 23.26 | 59.49 | 39.32 | 39.32 | 39.32 | 39.32 | 39.32 |
| Depreciation | 527.0 | 551.0 | 557.0 | 634.0 | 672.0 | 760.3 | 901.4 | 1,068.6 | 1,266.8 | 1,501.7 |
| Depreciation, % | 7.71 | 8.93 | 5.9 | 3.68 | 6.95 | 6.64 | 6.64 | 6.64 | 6.64 | 6.64 |
| EBIT | 2,060.0 | 2,092.0 | 2,572.0 | 3,368.0 | 5,077.0 | 3,744.5 | 4,439.0 | 5,262.3 | 6,238.3 | 7,395.4 |
| EBIT, % | 30.13 | 33.92 | 27.26 | 19.57 | 52.54 | 32.68 | 32.68 | 32.68 | 32.68 | 32.68 |
| Total Cash | 1,781.0 | 1,210.0 | 876.0 | 904.0 | 575.0 | 1,515.8 | 1,797.0 | 2,130.3 | 2,525.4 | 2,993.8 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 402.0 | 502.0 | 813.0 | 1,178.0 | 651.0 | 829.9 | 983.8 | 1,166.3 | 1,382.6 | 1,639.1 |
| Account Receivables, % | 5.88 | 8.14 | 8.62 | 6.85 | 6.74 | 7.24 | 7.24 | 7.24 | 7.24 | 7.24 |
| Inventories | 116.0 | 107.0 | 176.0 | 160.0 | 142.0 | 176.3 | 209.1 | 247.8 | 293.8 | 348.3 |
| Inventories, % | 1.7 | 1.74 | 1.87 | 0.92991 | 1.47 | 1.54 | 1.54 | 1.54 | 1.54 | 1.54 |
| Accounts Payable | 40.0 | 12.0 | 21.0 | 32.0 | 69.0 | 43.6 | 51.7 | 61.3 | 72.6 | 86.1 |
| Accounts Payable, % | 0.58497 | 0.19458 | 0.2226 | 0.18598 | 0.71399 | 0.38042 | 0.38042 | 0.38042 | 0.38042 | 0.38042 |
| Capital Expenditure | -1,331.0 | -972.0 | -648.0 | -451.0 | -220.0 | -1,076.7 | -1,276.4 | -1,513.2 | -1,793.9 | -2,126.6 |
| Capital Expenditure, % | -19.46 | -15.76 | -6.87 | -2.62 | -2.28 | -9.4 | -9.4 | -9.4 | -9.4 | -9.4 |
| Tax Rate, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| EBITAT | 1,374.5 | 1,441.2 | 1,252.9 | 2,134.3 | 5,077.0 | 2,603.9 | 3,086.8 | 3,659.4 | 4,338.1 | 5,142.8 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 92.5 | 901.2 | 790.9 | 1,979.3 | 6,111.0 | 2,048.8 | 2,533.2 | 3,003.1 | 3,560.1 | 4,220.4 |
| WACC, % | 5.99 | 6.04 | 5.64 | 5.93 | 6.65 | 6.05 | 6.05 | 6.05 | 6.05 | 6.05 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 12,663.6 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 4,305 | |||||||||
| Terminal Value | 106,318 | |||||||||
| Present Terminal Value | 79,264 | |||||||||
| Enterprise Value | 91,928 | |||||||||
| Net Debt | 15,416 | |||||||||
| Equity Value | 76,512 | |||||||||
| Diluted Shares Outstanding, MM | 484 | |||||||||
| Equity Value Per Share | 158.08 |
What You Will Get
- Editable Forecast Inputs: Easily modify assumptions (growth %, margins, WACC) to create various scenarios.
- Real-World Data: Cheniere Energy Partners, L.P.’s (CQP) financial data pre-filled to kickstart your analysis.
- Automatic DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value for you.
- Customizable and Professional: A refined Excel model that adjusts to your valuation requirements.
- Built for Analysts and Investors: Perfect for testing projections, validating strategies, and enhancing efficiency.
Key Features
- Real-Life CQP Data: Pre-filled with Cheniere Energy Partners' historical financials and forward-looking projections.
- Fully Customizable Inputs: Adjust revenue growth, margins, WACC, tax rates, and capital expenditures.
- Dynamic Valuation Model: Automatic updates to Net Present Value (NPV) and intrinsic value based on your inputs.
- Scenario Testing: Create multiple forecast scenarios to analyze different valuation outcomes.
- User-Friendly Design: Simple, structured, and designed for professionals and beginners alike.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review Cheniere Energy Partners, L.P.'s (CQP) pre-filled financial data and forecasts.
- Step 3: Modify key inputs such as revenue growth, WACC, and tax rates (highlighted cells).
- Step 4: Observe the DCF model update in real-time as you adjust assumptions.
- Step 5: Evaluate the outputs and leverage the results for your investment strategies.
Why Choose Cheniere Energy Partners, L.P. (CQP)?
- Industry Leader: A prominent player in the LNG sector with a strong market presence.
- Robust Financials: Consistent revenue growth and solid financial performance enhance investor confidence.
- Strategic Partnerships: Collaborations with key industry players ensure sustainable operations and expansion.
- Environmental Commitment: Focused on reducing carbon footprint and promoting cleaner energy solutions.
- Expert Management Team: Led by seasoned professionals with extensive experience in the energy sector.
Who Should Use Cheniere Energy Partners, L.P. (CQP)?
- Energy Investors: Make informed investment choices with insights into the LNG market.
- Market Analysts: Utilize comprehensive data to evaluate Cheniere's performance and growth potential.
- Consultants: Easily modify reports and presentations to meet client needs in the energy sector.
- Energy Sector Enthusiasts: Enhance your knowledge of liquefied natural gas operations and their impact on the market.
- Academics and Students: Leverage real-world case studies for a deeper understanding of energy finance.
What the Template Contains
- Preloaded CQP Data: Historical and projected financial data, including revenue, EBITDA, 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.