DCF Tool

ED

Consolidated Edison, Inc. – Other Electric Power Generation
Analysis Results
Intrinsic Value $572.52
Latest Price $99.87
Relative Value 83% undervalued
Thoughts on this result? Let us know.
Ad
Cash Flow (Billions)
Analysis Parameters
%
%
%
New Ticker
Ad
Analysis Details
Growth Rate Projection

An exponential growth model was fit to the past cash flow data, giving more weight to more recent years. This model determined a growth rate estimate of 48.3%.

Weighted Average Cost of Capital (WACC)

The calculated WACC is 3.7%. This value is used as the default discount rate.

Value of Future Flows

Assuming a growth rate of 48.3%, the cash flows for the next 5 years are projected.

The present value of each year's flow is adjusted to present value using the discount rate.

Year Future flow (billion) Present value (billion)
2022 1.58 1.53
2023 2.35 2.18
2024 3.48 3.13
2025 5.17 4.47
2026 7.66 6.4
Terminal Value

Assuming the company was sold after the projection period at an exit multiple of 30, the terminal value of the company would be 230 billion. This corresponds to a present value of 185 billion.

Intrinsic Value Per Share

The total present value of the projected cash flows is 17.7 billion. Adding in the terminal value gives a total present value of 203 billion.

There are presently 354.0 million outstanding shares, so the intrinsic value per share is 572.52.

Financial Statements

The following data was to determine the past cash flows.

Current Assets 5,551,000,000
Current Cash 992,000,000
Current Liabilities 5,427,000,000
Current Debt 1,928,000,000
Non-Cash Working Capital (NCWC) 1,060,000,000
Change in NCWC 548,000,000
EBIT 2,826,000,000
Tax Provision 190,000,000
Depreciation and Amortization 2,032,000,000
Capital Expenditure -3,983,000,000
Unlevered Free Cash Flow 1,034,757,049
Current Assets 5,301,000,000
Current Cash 1,272,000,000
Current Liabilities 7,354,000,000
Current Debt 3,837,000,000
Non-Cash Working Capital (NCWC) 512,000,000
Change in NCWC 370,000,000
EBIT 2,654,000,000
Tax Provision 90,000,000
Depreciation and Amortization 1,920,000,000
Capital Expenditure -3,912,000,000
Unlevered Free Cash Flow 838,434,359
Current Assets 4,272,000,000
Current Cash 981,000,000
Current Liabilities 6,287,000,000
Current Debt 3,138,000,000
Non-Cash Working Capital (NCWC) 142,000,000
Change in NCWC 164,000,000
EBIT 2,676,000,000
Tax Provision 296,000,000
Depreciation and Amortization 1,684,000,000
Capital Expenditure -3,691,000,000
Unlevered Free Cash Flow 376,723,502
Current Assets 3,864,000,000
Current Cash 895,000,000
Current Liabilities 6,207,000,000
Current Debt 3,216,000,000
Non-Cash Working Capital (NCWC) -22,000,000
Change in NCWC 265,000,000
EBIT 2,533,000,000
Tax Provision 401,000,000
Depreciation and Amortization 1,438,000,000
Capital Expenditure -3,745,000,000
Unlevered Free Cash Flow -78,676,388
Current Assets 3,537,000,000
Current Cash 797,000,000
Current Liabilities 4,902,000,000
Current Debt 1,875,000,000
Non-Cash Working Capital (NCWC) -287,000,000
Change in NCWC -167,000,000
EBIT 2,609,000,000
Tax Provision 472,000,000
Depreciation and Amortization 1,341,000,000
Capital Expenditure -3,488,000,000
Unlevered Free Cash Flow -321,648,973
Current Assets 3,406,000,000
Current Cash 776,000,000
Current Liabilities 3,843,000,000
Current Debt 1,093,000,000
Non-Cash Working Capital (NCWC) -120,000,000
Change in NCWC -560,000,000
EBIT 2,471,000,000
Tax Provision 698,000,000
Depreciation and Amortization 1,216,000,000
Capital Expenditure -5,158,000,000
Unlevered Free Cash Flow -2,918,677,817
Current Assets 3,836,000,000
Current Cash 944,000,000
Current Liabilities 4,720,000,000
Current Debt 2,268,000,000
Non-Cash Working Capital (NCWC) 440,000,000
Change in NCWC -294,000,000
EBIT 2,427,000,000
Tax Provision 605,000,000
Depreciation and Amortization 1,130,000,000
Capital Expenditure -3,353,000,000
Unlevered Free Cash Flow -906,649,054
Current Assets 3,854,000,000
Current Cash 699,000,000
Current Liabilities 3,781,000,000
Current Debt 1,360,000,000
Non-Cash Working Capital (NCWC) 734,000,000
Change in NCWC 311,000,000
EBIT 2,164,000,000
Tax Provision 568,000,000
Depreciation and Amortization 1,071,000,000
Capital Expenditure -2,702,000,000
Unlevered Free Cash Flow 103,546,987
Current Assets 3,891,000,000
Current Cash 674,000,000
Current Liabilities 4,730,000,000
Current Debt 1,936,000,000
Non-Cash Working Capital (NCWC) 423,000,000
Change in NCWC 66,000,000
EBIT 2,244,000,000
Tax Provision 476,000,000
Depreciation and Amortization 1,024,000,000
Capital Expenditure -2,713,000,000
Unlevered Free Cash Flow -73,501,950
Current Assets 3,451,000,000
Current Cash 394,000,000
Current Liabilities 3,945,000,000
Current Debt 1,245,000,000
Non-Cash Working Capital (NCWC) 357,000,000
Change in NCWC -176,000,000
EBIT 2,339,000,000
Tax Provision 600,000,000
Depreciation and Amortization 955,000,000
Capital Expenditure -2,406,000,000
Unlevered Free Cash Flow -94,088,454

This analysis is provided for informational purposes only and does not constitute financial or investing advice. For more information on the advantages and limitations of DCF analysis see background. This information is provided on an "as is" basis. No warranty, expressed or implied, is made regarding accuracy, adequacy, completeness, legality, reliability or usefulness of any information. By using this site you agree that under no circumstances shall Valuation Tools LLC be held liable for any loss or damage caused by information obtained from this website including any articles, data, videos, its social media accounts, or any other materials.