|
Valoración de DCF de Edison International (EIX)
US | Utilities | Regulated Electric | 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
Edison International (EIX) Bundle
¡Explore la perspectiva financiera de Edison International (EIX) con nuestra calculadora DCF fácil de usar! Ingrese sus proyecciones para el crecimiento, los márgenes y los gastos para calcular el valor intrínseco de Edison International (EIX) y refinar su enfoque de inversión.
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 | 12,347.0 | 13,578.0 | 14,905.0 | 17,220.0 | 16,338.0 | 17,569.6 | 18,894.0 | 20,318.3 | 21,850.0 | 23,497.1 |
Revenue Growth, % | 0 | 9.97 | 9.77 | 15.53 | -5.12 | 7.54 | 7.54 | 7.54 | 7.54 | 7.54 |
EBITDA | 3,771.0 | 3,497.0 | 4,002.0 | 4,464.0 | 5,848.0 | 5,090.4 | 5,474.1 | 5,886.8 | 6,330.5 | 6,807.8 |
EBITDA, % | 30.54 | 25.75 | 26.85 | 25.92 | 35.79 | 28.97 | 28.97 | 28.97 | 28.97 | 28.97 |
Depreciation | 1,803.0 | 2,029.0 | 2,288.0 | 2,633.0 | 2,721.0 | 2,700.1 | 2,903.7 | 3,122.6 | 3,358.0 | 3,611.1 |
Depreciation, % | 14.6 | 14.94 | 15.35 | 15.29 | 16.65 | 15.37 | 15.37 | 15.37 | 15.37 | 15.37 |
EBIT | 1,968.0 | 1,468.0 | 1,714.0 | 1,831.0 | 3,127.0 | 2,390.3 | 2,570.4 | 2,764.2 | 2,972.6 | 3,196.7 |
EBIT, % | 15.94 | 10.81 | 11.5 | 10.63 | 19.14 | 13.6 | 13.6 | 13.6 | 13.6 | 13.6 |
Total Cash | 68.0 | 87.0 | 390.0 | 914.0 | 345.0 | 394.5 | 424.3 | 456.2 | 490.6 | 527.6 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 1,394.0 | 1,651.0 | 2,192.0 | 2,336.0 | 2,758.0 | 2,410.6 | 2,592.4 | 2,787.8 | 2,997.9 | 3,223.9 |
Account Receivables, % | 11.29 | 12.16 | 14.71 | 13.57 | 16.88 | 13.72 | 13.72 | 13.72 | 13.72 | 13.72 |
Inventories | 364.0 | 405.0 | 420.0 | 474.0 | 527.0 | 517.5 | 556.5 | 598.5 | 643.6 | 692.1 |
Inventories, % | 2.95 | 2.98 | 2.82 | 2.75 | 3.23 | 2.95 | 2.95 | 2.95 | 2.95 | 2.95 |
Accounts Payable | 1,752.0 | 1,980.0 | 2,002.0 | 2,359.0 | 1,983.0 | 2,390.9 | 2,571.1 | 2,764.9 | 2,973.4 | 3,197.5 |
Accounts Payable, % | 14.19 | 14.58 | 13.43 | 13.7 | 12.14 | 13.61 | 13.61 | 13.61 | 13.61 | 13.61 |
Capital Expenditure | -4,877.0 | -5,484.0 | -5,505.0 | -5,778.0 | -5,448.0 | -6,455.8 | -6,942.5 | -7,465.8 | -8,028.6 | -8,633.8 |
Capital Expenditure, % | -39.5 | -40.39 | -36.93 | -33.55 | -33.35 | -36.74 | -36.74 | -36.74 | -36.74 | -36.74 |
Tax Rate, % | 20.99 | 20.99 | 20.99 | 20.99 | 20.99 | 20.99 | 20.99 | 20.99 | 20.99 | 20.99 |
EBITAT | 2,453.5 | 2,259.1 | 2,009.4 | 2,279.1 | 2,470.6 | 2,289.9 | 2,462.5 | 2,648.2 | 2,847.8 | 3,062.5 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -626.5 | -1,265.9 | -1,741.6 | -706.9 | -1,107.4 | -701.0 | -1,616.8 | -1,738.6 | -1,869.7 | -2,010.7 |
WACC, % | 6.56 | 6.56 | 6.56 | 6.56 | 6.05 | 6.46 | 6.46 | 6.46 | 6.46 | 6.46 |
PV UFCF | ||||||||||
SUM PV UFCF | -6,451.4 | |||||||||
Long Term Growth Rate, % | 3.50 | |||||||||
Free cash flow (T + 1) | -2,081 | |||||||||
Terminal Value | -70,252 | |||||||||
Present Terminal Value | -51,366 | |||||||||
Enterprise Value | -57,818 | |||||||||
Net Debt | 34,966 | |||||||||
Equity Value | -92,784 | |||||||||
Diluted Shares Outstanding, MM | 385 | |||||||||
Equity Value Per Share | -241.00 |
What You Will Receive
- Genuine Edison Data: Preloaded financials – encompassing revenue to EBIT – based on real and projected metrics.
- Complete Customization: Modify all essential parameters (yellow cells) such as WACC, growth %, and tax rates.
- Immediate Valuation Adjustments: Automatic recalculations to assess the effect of changes on Edison’s fair value.
- Flexible Excel Template: Designed for quick modifications, scenario analysis, and comprehensive projections.
- Efficient and Precise: Avoid constructing models from the ground up while ensuring accuracy and adaptability.
Key Features
- Comprehensive EIX Data: Pre-populated with Edison International’s historical performance and future outlook.
- Customizable Assumptions: Modify growth rates, profit margins, discount rates, tax implications, and capital investments.
- Interactive Valuation Framework: Automatic recalculations of Net Present Value (NPV) and intrinsic value based on user inputs.
- Scenario Analysis: Develop various forecasting scenarios to evaluate different valuation possibilities.
- Intuitive User Interface: Clear, organized, and tailored for both seasoned professionals and newcomers.
How It Works
- 1. Access the Template: Download and open the Excel file featuring Edison International’s (EIX) preloaded data.
- 2. Modify Assumptions: Adjust essential inputs such as growth rates, WACC, and capital expenditures.
- 3. View Results Instantly: The DCF model automatically calculates intrinsic value and NPV in real-time.
- 4. Explore Scenarios: Evaluate various forecasts to understand different valuation results.
- 5. Present with Assurance: Deliver expert valuation insights to bolster your decision-making process.
Why Choose This Calculator for Edison International (EIX)?
- All-in-One Solution: Combines DCF, WACC, and financial ratio assessments tailored for Edison International (EIX).
- Flexible Inputs: Modify the yellow-highlighted fields to explore different financial scenarios.
- In-Depth Analysis: Automatically computes Edison International’s intrinsic value and Net Present Value.
- Preloaded Metrics: Historical and projected data provide reliable starting figures.
- High-Quality Tool: Perfect for financial analysts, investors, and business advisors focused on Edison International (EIX).
Who Should Use This Product?
- Finance Students: Discover valuation methods and apply them using actual data for Edison International (EIX).
- Academics: Integrate industry-standard models into your lectures or research involving Edison International (EIX).
- Investors: Validate your investment hypotheses and evaluate valuation results for Edison International (EIX).
- Analysts: Enhance your analysis process with a ready-to-use, customizable DCF model tailored for Edison International (EIX).
- Small Business Owners: Understand the valuation techniques used for analyzing large corporations like Edison International (EIX).
What the Template Contains
- Pre-Filled Data: Includes Edison International’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 Edison International’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.