|
Valoración de DCF de Exelon Corporation (EXC)
US | Utilities | Regulated Electric | 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
Exelon Corporation (EXC) Bundle
¡Simplifique la valoración de Exelon Corporation (EXC) con esta calculadora DCF personalizable! Con el Real Exelon Corporation (EXC) Financials y las entradas de pronóstico ajustables, puede probar escenarios y descubrir el valor razonable de Exelon Corporation (EXC) en 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 | 34,438.0 | 33,039.0 | 17,938.0 | 19,078.0 | 21,727.0 | 22,899.1 | 24,134.3 | 25,436.3 | 26,808.4 | 28,254.6 |
Revenue Growth, % | 0 | -4.06 | -45.71 | 6.36 | 13.89 | 5.39 | 5.39 | 5.39 | 5.39 | 5.39 |
EBITDA | 11,152.0 | 9,540.0 | 10,516.0 | 7,383.0 | 7,937.0 | 8,935.7 | 9,417.8 | 9,925.8 | 10,461.3 | 11,025.6 |
EBITDA, % | 32.38 | 28.87 | 58.62 | 38.7 | 36.53 | 39.02 | 39.02 | 39.02 | 39.02 | 39.02 |
Depreciation | 5,551.0 | 5,572.0 | 7,573.0 | 3,533.0 | 3,506.0 | 5,031.2 | 5,302.6 | 5,588.7 | 5,890.2 | 6,207.9 |
Depreciation, % | 16.12 | 16.86 | 42.22 | 18.52 | 16.14 | 21.97 | 21.97 | 21.97 | 21.97 | 21.97 |
EBIT | 5,601.0 | 3,968.0 | 2,943.0 | 3,850.0 | 4,431.0 | 3,904.5 | 4,115.1 | 4,337.1 | 4,571.1 | 4,817.7 |
EBIT, % | 16.26 | 12.01 | 16.41 | 20.18 | 20.39 | 17.05 | 17.05 | 17.05 | 17.05 | 17.05 |
Total Cash | 587.0 | 663.0 | 672.0 | 407.0 | 445.0 | 533.0 | 561.8 | 592.1 | 624.0 | 657.7 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 4,592.0 | 3,375.0 | 2,865.0 | 3,561.0 | 3,361.0 | 3,373.3 | 3,555.3 | 3,747.1 | 3,949.2 | 4,162.2 |
Account Receivables, % | 13.33 | 10.22 | 15.97 | 18.67 | 15.47 | 14.73 | 14.73 | 14.73 | 14.73 | 14.73 |
Inventories | 1,768.0 | 1,722.0 | 581.0 | 755.0 | 801.0 | 972.2 | 1,024.7 | 1,080.0 | 1,138.2 | 1,199.6 |
Inventories, % | 5.13 | 5.21 | 3.24 | 3.96 | 3.69 | 4.25 | 4.25 | 4.25 | 4.25 | 4.25 |
Accounts Payable | 3,560.0 | 3,562.0 | 2,379.0 | 3,382.0 | 2,846.0 | 2,986.4 | 3,147.5 | 3,317.3 | 3,496.2 | 3,684.8 |
Accounts Payable, % | 10.34 | 10.78 | 13.26 | 17.73 | 13.1 | 13.04 | 13.04 | 13.04 | 13.04 | 13.04 |
Capital Expenditure | -7,248.0 | -8,048.0 | -7,981.0 | -7,147.0 | -7,408.0 | -7,394.4 | -7,793.2 | -8,213.7 | -8,656.7 | -9,123.7 |
Capital Expenditure, % | -21.05 | -24.36 | -44.49 | -37.46 | -34.1 | -32.29 | -32.29 | -32.29 | -32.29 | -32.29 |
Tax Rate, % | 13.84 | 13.84 | 13.84 | 13.84 | 13.84 | 13.84 | 13.84 | 13.84 | 13.84 | 13.84 |
EBITAT | 4,126.6 | 3,338.7 | 3,035.5 | 3,476.7 | 3,817.7 | 3,391.3 | 3,574.2 | 3,767.0 | 3,970.3 | 4,184.4 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -370.4 | 2,127.7 | 3,095.5 | -4.3 | -466.3 | 985.0 | 1,010.3 | 1,064.8 | 1,122.2 | 1,182.8 |
WACC, % | 5.14 | 5.39 | 5.77 | 5.54 | 5.44 | 5.45 | 5.45 | 5.45 | 5.45 | 5.45 |
PV UFCF | ||||||||||
SUM PV UFCF | 4,564.9 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 1,206 | |||||||||
Terminal Value | 34,922 | |||||||||
Present Terminal Value | 26,778 | |||||||||
Enterprise Value | 31,343 | |||||||||
Net Debt | 43,563 | |||||||||
Equity Value | -12,220 | |||||||||
Diluted Shares Outstanding, MM | 997 | |||||||||
Equity Value Per Share | -12.26 |
What You Will Get
- Editable Forecast Inputs: Effortlessly modify assumptions (growth %, margins, WACC) to explore various scenarios.
- Real-World Data: Exelon Corporation’s (EXC) financial data pre-loaded to kickstart your analysis.
- Automatic DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value automatically for you.
- Customizable and Professional: A refined Excel model that adjusts to your valuation requirements.
- Built for Analysts and Investors: Perfect for assessing projections, validating strategies, and enhancing efficiency.
Key Features
- Comprehensive Exelon Financials: Gain access to precise pre-loaded historical data and future forecasts.
- Personalized Forecast Assumptions: Modify the yellow-highlighted cells for parameters like WACC, growth rates, and profit margins.
- Automated Calculations: Enjoy real-time updates to DCF, Net Present Value (NPV), and cash flow analysis.
- Interactive Dashboard: Utilize user-friendly charts and summaries to visualize your valuation findings.
- Designed for All Users: A straightforward, intuitive layout tailored for investors, CFOs, and consultants alike.
How It Works
- Step 1: Download the prebuilt Excel template featuring Exelon Corporation’s (EXC) data.
- Step 2: Navigate through the pre-filled sheets to grasp the essential metrics.
- Step 3: Adjust forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
- Step 4: Instantly observe the recalculated results, including Exelon Corporation’s intrinsic value.
- Step 5: Make informed investment decisions or create reports utilizing the outputs.
Why Choose This Calculator for Exelon Corporation (EXC)?
- Accuracy: Leverages real Exelon financial data to ensure precise calculations.
- Flexibility: Allows users to freely test and adjust inputs as needed.
- Time-Saving: Eliminates the need to create a DCF model from the ground up.
- Professional-Grade: Crafted with the precision and usability expected by CFOs.
- User-Friendly: Intuitive design makes it accessible for users without extensive financial modeling skills.
Who Should Use This Product?
- Investors: Gain a clear understanding of Exelon Corporation’s (EXC) fair value to inform investment choices.
- CFOs: Utilize a robust DCF model for accurate financial reporting and analysis for Exelon Corporation (EXC).
- Consultants: Easily customize the template for valuation reports tailored to Exelon Corporation (EXC) clients.
- Entrepreneurs: Discover financial modeling techniques applied by leading companies like Exelon Corporation (EXC).
- Educators: Implement this tool in the classroom to illustrate valuation methods using Exelon Corporation (EXC) as a case study.
What the Template Contains
- Pre-Filled Data: Includes Exelon Corporation’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 Exelon Corporation’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.