|
Constellation Energy Corporation (CEG) DCF Valoración
US | Utilities | Renewable Utilities | NASDAQ
|
- ✓ 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
Constellation Energy Corporation (CEG) Bundle
¡Simplifique la valoración de Constellation Energy Corporation (CEG) con esta calculadora DCF personalizable! Con las finanzas precisas de Constellation Energy Corporation (CEG) y entradas de pronóstico ajustables, puede explorar escenarios y revelar el valor razonable de Constellation Energy Corporation (CEG) en solo minutos.
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 | 18,924.0 | 17,603.0 | 19,649.0 | 24,440.0 | 24,918.0 | 26,848.0 | 28,927.4 | 31,167.9 | 33,582.0 | 36,183.0 |
| Revenue Growth, % | 0 | -6.98 | 11.62 | 24.38 | 1.96 | 7.75 | 7.75 | 7.75 | 7.75 | 7.75 |
| EBITDA | 5,409.0 | 4,829.0 | 4,989.0 | 2,136.0 | 4,252.0 | 5,756.7 | 6,202.6 | 6,683.0 | 7,200.6 | 7,758.4 |
| EBITDA, % | 28.58 | 27.43 | 25.39 | 8.74 | 17.06 | 21.44 | 21.44 | 21.44 | 21.44 | 21.44 |
| Depreciation | 3,063.0 | 3,636.0 | 4,540.0 | 2,427.0 | 2,514.0 | 4,293.9 | 4,626.4 | 4,984.8 | 5,370.9 | 5,786.9 |
| Depreciation, % | 16.19 | 20.66 | 23.11 | 9.93 | 10.09 | 15.99 | 15.99 | 15.99 | 15.99 | 15.99 |
| EBIT | 2,346.0 | 1,193.0 | 449.0 | -291.0 | 1,738.0 | 1,462.9 | 1,576.2 | 1,698.2 | 1,829.8 | 1,971.5 |
| EBIT, % | 12.4 | 6.78 | 2.29 | -1.19 | 6.97 | 5.45 | 5.45 | 5.45 | 5.45 | 5.45 |
| Total Cash | 303.0 | 226.0 | 504.0 | 422.0 | 368.0 | 464.7 | 500.6 | 539.4 | 581.2 | 626.2 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 3,749.0 | 1,803.0 | 2,421.0 | 3,316.0 | 2,851.0 | 3,618.3 | 3,898.5 | 4,200.4 | 4,525.8 | 4,876.3 |
| Account Receivables, % | 19.81 | 10.24 | 12.32 | 13.57 | 11.44 | 13.48 | 13.48 | 13.48 | 13.48 | 13.48 |
| Inventories | 1,262.0 | 1,211.0 | 1,288.0 | 1,505.0 | 1,500.0 | 1,733.4 | 1,867.6 | 2,012.3 | 2,168.1 | 2,336.0 |
| Inventories, % | 6.67 | 6.88 | 6.56 | 6.16 | 6.02 | 6.46 | 6.46 | 6.46 | 6.46 | 6.46 |
| Accounts Payable | 1,692.0 | 1,253.0 | 1,757.0 | 2,828.0 | 1,480.0 | 2,282.7 | 2,459.5 | 2,650.0 | 2,855.3 | 3,076.4 |
| Accounts Payable, % | 8.94 | 7.12 | 8.94 | 11.57 | 5.94 | 8.5 | 8.5 | 8.5 | 8.5 | 8.5 |
| Capital Expenditure | -1,845.0 | -1,747.0 | -1,329.0 | -1,689.0 | -2,422.0 | -2,312.6 | -2,491.7 | -2,684.7 | -2,892.6 | -3,116.7 |
| Capital Expenditure, % | -9.75 | -9.92 | -6.76 | -6.91 | -9.72 | -8.61 | -8.61 | -8.61 | -8.61 | -8.61 |
| Tax Rate, % | 33.67 | 33.67 | 33.67 | 33.67 | 33.67 | 33.67 | 33.67 | 33.67 | 33.67 | 33.67 |
| EBITAT | 1,376.8 | 840.5 | -215.6 | -82.7 | 1,152.7 | 655.0 | 705.7 | 760.4 | 819.3 | 882.8 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -724.2 | 4,287.5 | 2,804.4 | 614.3 | 366.7 | 2,438.4 | 2,602.8 | 2,804.4 | 3,021.6 | 3,255.6 |
| WACC, % | 7.51 | 7.57 | 7.2 | 7.35 | 7.55 | 7.44 | 7.44 | 7.44 | 7.44 | 7.44 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 11,328.1 | |||||||||
| Long Term Growth Rate, % | 3.00 | |||||||||
| Free cash flow (T + 1) | 3,353 | |||||||||
| Terminal Value | 75,571 | |||||||||
| Present Terminal Value | 52,793 | |||||||||
| Enterprise Value | 64,122 | |||||||||
| Net Debt | 8,893 | |||||||||
| Equity Value | 55,229 | |||||||||
| Diluted Shares Outstanding, MM | 324 | |||||||||
| Equity Value Per Share | 170.46 |
What You Will Get
- Real Constellation Energy Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for Constellation Energy Corporation (CEG).
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates to fit your analysis.
- Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on Constellation Energy's fair value.
- Versatile Excel Template: Tailored for quick edits, scenario testing, and detailed projections specifically for Constellation Energy Corporation (CEG).
- Time-Saving and Accurate: Skip building models from scratch while ensuring precision and flexibility in your evaluations.
Key Features
- Real-Life CEG Data: Pre-filled with Constellation Energy's historical financials and future projections.
- Fully Customizable Inputs: Modify revenue growth, profit 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: Develop multiple forecast scenarios to explore various valuation outcomes.
- User-Friendly Design: Intuitive, organized, and suitable for both professionals and novices.
How It Works
- Download the Template: Gain immediate access to the Excel-based CEG DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and other variables.
- Instant Calculations: The model automatically recalculates Constellation Energy's intrinsic value.
- Test Scenarios: Experiment with different assumptions to assess potential valuation shifts.
- Analyze and Decide: Utilize the results to inform your investment or financial evaluations.
Why Choose This Calculator for Constellation Energy Corporation (CEG)?
- Accuracy: Real Constellation Energy financials ensure data precision.
- Flexibility: Built for users to easily test and adjust inputs.
- Time-Saving: Avoid the complexity of creating a DCF model from the ground up.
- Professional-Grade: Crafted with CFO-level accuracy and user experience in focus.
- User-Friendly: Intuitive design makes it accessible for all users, regardless of financial modeling expertise.
Who Should Use This Product?
- Professional Investors: Develop comprehensive and accurate valuation models for portfolio management of Constellation Energy Corporation (CEG).
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within the organization.
- Consultants and Advisors: Deliver precise valuation insights for clients interested in Constellation Energy Corporation (CEG).
- Students and Educators: Utilize real-time data to enhance learning and practice in financial modeling.
- Energy Sector Enthusiasts: Gain insights into how energy companies like Constellation Energy Corporation (CEG) are assessed in the market.
What the Template Contains
- Preloaded CEG 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.