Consolidated Edison, Inc. (ED) DCF Valuation
- ✓ 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
Consolidated Edison, Inc. (ED) Bundle
Evaluate the financial outlook of Consolidated Edison, Inc. (ED) with expert precision! This (ED) DCF Calculator provides pre-filled financial data along with the flexibility to modify revenue growth, WACC, profit margins, and other essential assumptions to match your 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 | 12,574.0 | 12,246.0 | 13,676.0 | 15,670.0 | 14,663.0 | 15,294.3 | 15,952.9 | 16,639.7 | 17,356.2 | 18,103.5 |
Revenue Growth, % | 0 | -2.61 | 11.68 | 14.58 | -6.43 | 4.31 | 4.31 | 4.31 | 4.31 | 4.31 |
EBITDA | 4,279.0 | 4,371.0 | 4,720.0 | 5,034.0 | 6,062.0 | 5,435.7 | 5,669.8 | 5,913.9 | 6,168.5 | 6,434.1 |
EBITDA, % | 34.03 | 35.69 | 34.51 | 32.13 | 41.34 | 35.54 | 35.54 | 35.54 | 35.54 | 35.54 |
Depreciation | 1,684.0 | 1,920.0 | 2,032.0 | 2,056.0 | 2,031.0 | 2,168.8 | 2,262.2 | 2,359.6 | 2,461.2 | 2,567.1 |
Depreciation, % | 13.39 | 15.68 | 14.86 | 13.12 | 13.85 | 14.18 | 14.18 | 14.18 | 14.18 | 14.18 |
EBIT | 2,595.0 | 2,451.0 | 2,688.0 | 2,978.0 | 4,031.0 | 3,267.0 | 3,407.6 | 3,554.3 | 3,707.4 | 3,867.0 |
EBIT, % | 20.64 | 20.01 | 19.65 | 19 | 27.49 | 21.36 | 21.36 | 21.36 | 21.36 | 21.36 |
Total Cash | 981.0 | 1,272.0 | 992.0 | 1,282.0 | 1,189.0 | 1,276.5 | 1,331.5 | 1,388.8 | 1,448.6 | 1,511.0 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 2,115.0 | 2,741.0 | 3,106.0 | 3,232.0 | 3,788.0 | 3,315.0 | 3,457.7 | 3,606.6 | 3,761.9 | 3,923.9 |
Account Receivables, % | 16.82 | 22.38 | 22.71 | 20.63 | 25.83 | 21.67 | 21.67 | 21.67 | 21.67 | 21.67 |
Inventories | 352.0 | 356.0 | 437.0 | 492.0 | 469.0 | 466.2 | 486.2 | 507.2 | 529.0 | 551.8 |
Inventories, % | 2.8 | 2.91 | 3.2 | 3.14 | 3.2 | 3.05 | 3.05 | 3.05 | 3.05 | 3.05 |
Accounts Payable | 1,164.0 | 1,475.0 | 1,497.0 | 1,955.0 | 1,775.0 | 1,738.3 | 1,813.2 | 1,891.3 | 1,972.7 | 2,057.6 |
Accounts Payable, % | 9.26 | 12.04 | 10.95 | 12.48 | 12.11 | 11.37 | 11.37 | 11.37 | 11.37 | 11.37 |
Capital Expenditure | -3,486.0 | -3,909.0 | -3,953.0 | -4,168.0 | -4,494.0 | -4,459.7 | -4,651.7 | -4,852.0 | -5,060.9 | -5,278.8 |
Capital Expenditure, % | -27.72 | -31.92 | -28.9 | -26.6 | -30.65 | -29.16 | -29.16 | -29.16 | -29.16 | -29.16 |
Tax Rate, % | 16.12 | 16.12 | 16.12 | 16.12 | 16.12 | 16.12 | 16.12 | 16.12 | 16.12 | 16.12 |
EBITAT | 2,007.5 | 2,186.8 | 2,616.1 | 2,356.3 | 3,381.3 | 2,789.4 | 2,909.5 | 3,034.8 | 3,165.5 | 3,301.8 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -1,097.5 | -121.2 | 271.1 | 521.3 | 205.3 | 937.6 | 432.0 | 450.6 | 470.0 | 490.2 |
WACC, % | 4.93 | 5.16 | 5.32 | 4.96 | 5.06 | 5.09 | 5.09 | 5.09 | 5.09 | 5.09 |
PV UFCF | ||||||||||
SUM PV UFCF | 2,439.6 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 500 | |||||||||
Terminal Value | 16,198 | |||||||||
Present Terminal Value | 12,639 | |||||||||
Enterprise Value | 15,079 | |||||||||
Net Debt | 23,821 | |||||||||
Equity Value | -8,742 | |||||||||
Diluted Shares Outstanding, MM | 349 | |||||||||
Equity Value Per Share | -25.03 |
What You Will Get
- Real ED Financial Data: Pre-filled with Consolidated Edison’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 Consolidated Edison’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 ED Financials: Pre-filled historical and projected data for Consolidated Edison, Inc. (ED).
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate Consolidated Edison’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize Consolidated Edison’s valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- 1. Access the Template: Download and open the Excel file featuring Consolidated Edison, Inc. (ED)’s preloaded data.
- 2. Modify Assumptions: Adjust critical inputs such as growth rates, WACC, and capital expenditures.
- 3. Observe Results Instantly: The DCF model automatically calculates intrinsic value and NPV in real-time.
- 4. Experiment with Scenarios: Analyze various forecasts to evaluate different valuation outcomes.
- 5. Utilize with Assurance: Present expert valuation insights to bolster your decision-making process.
Why Choose This Calculator for Consolidated Edison, Inc. (ED)?
- Designed for Experts: A sophisticated tool utilized by financial analysts, CFOs, and industry consultants.
- Accurate Data: Consolidated Edison’s historical and projected financials are preloaded for precision.
- Flexible Scenario Analysis: Effortlessly simulate various forecasts and assumptions.
- Comprehensive Outputs: Automatically computes intrinsic value, NPV, and essential financial metrics.
- User-Friendly: Step-by-step guidance simplifies the calculation process.
Who Should Use This Product?
- Investors: Accurately estimate Consolidated Edison’s fair value before making investment decisions.
- CFOs: Leverage a professional-grade DCF model for financial reporting and analysis.
- Consultants: Quickly adapt the template for valuation reports for clients.
- Entrepreneurs: Gain insights into financial modeling used by leading utility companies.
- Educators: Use it as a teaching tool to demonstrate valuation methodologies.
What the Template Contains
- Pre-Filled DCF Model: Consolidated Edison’s financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
- Financial Ratios: Evaluate Consolidated Edison’s profitability, leverage, and efficiency.
- Editable Inputs: Change assumptions such as growth, margins, and CAPEX to fit your scenarios.
- Financial Statements: Annual and quarterly reports to support detailed analysis.
- Interactive Dashboard: Easily visualize key valuation metrics and results.