investorscraft@gmail.com

Intrinsic value of Consolidated Edison Inc (ED)

Previous Close$97.19
Intrinsic Value
Upside potential
Previous Close
$97.19
* Our model cannot be used “out of the box” for the valuation of this stock. You can still do your own valuation by changing the valuation input parameters.

VALUATION INPUT DATA (original, your and others' valuations)

ParameterOrig.Your
Date of valuation (DoV)  
Intrinsic value (IV) at DoV, $/sh  
IV at current val. algorithm, $/sh56.42 

The original valuation is based on fiscal year data as of 2021-12-31 and quarterly data as of 2022-03-31.

Registered users can save their valuation input data

  1. Annual
  2. Quarterly YoY
  3. Quarterly QoQ

Annual revenue growth rates, % (past and forecasted)

NOTE: The bar chart shows historic and forecasted yearly revenue growth rates. Its purpose is to help you in determining what initial revenue rate you want to base your stock valuation on. Please make sure that you are confident in the value you select - for most stocks it is by far the most important parameter in valuation.

Company description

Consolidated Edison, Inc., through its subsidiaries, engages in regulated electric, gas, and steam delivery businesses in the United States. The company offers electric services to approximately 3.5 million customers in New York City and Westchester County; gas to approximately 1.1 million customers in Manhattan, the Bronx, parts of Queens, and Westchester County; and steam to approximately 1,589 customers in parts of Manhattan. It also supplies electricity to approximately 0.3 million customers in southeastern New York and northern New Jersey; and gas to approximately 0.1 million customers in southeastern New York. The company operates 543 circuit miles of transmission lines; 15 transmission substations; 64 distribution substations; 89,395 in-service line transformers; 3,745 pole miles of overhead distribution lines; and 2,200 miles of underground distribution lines, as well as 4,318 miles of mains and 376,306 service lines for natural gas distribution. In addition, it owns, operates, and develops renewable and energy infrastructure projects; and provides energy-related products and services to wholesale and retail customers, as well as invests in electric and gas transmission projects. The company primarily sells electricity to industrial, commercial, residential, and government customers. Consolidated Edison, Inc. was founded in 1884 and is based in New York, New York.

show cash flow forecast

FINANCIAL STATEMENTS FORECAST and PRESENT VALUE CALCULATION

Fiscal year2021(a)2022202320242025202620272028202920302031203220332034203520362037203820392040204120422043204420452046

INCOME STATEMENT

Revenue growth rate, %11.7NaN
Revenue, $13673NaN
Variable operating expenses, $mNaN
Fixed operating expenses, $mNaN
Total operating expenses, $m10847NaN
Operating income, $m2826NaN
EBITDA, $m4858NaN
Interest expense (income), $mNaN
Earnings before tax, $m1536NaN
Tax expense, $m190NaN
Net income, $m1346NaN

BALANCE SHEET

Cash and short-term investments, $m1146NaN
Total assets, $m63116NaN
Adjusted assets (=assets-cash), $m61970NaN
Average production assets, $m50218NaN
Working capital, $m124NaN
Total debt, $m25364NaN
Total liabilities, $m43079NaN
Total equity, $m20037NaN
Debt-to-equity ratio1.266NaN
Adjusted equity ratio0.338NaN

CASH FLOW

Net income, $m1346NaN
Depreciation, amort., depletion, $m2032NaN
Funds from operations, $mNaN
Change in working capital, $mNaN
Cash from operations, $m2733NaN
Maintenance CAPEX, $mNaN
New CAPEX, $mNaN
Total CAPEX, $m-3647NaN
Free cash flow, $m6380NaN
Issuance/(repurchase) of shares, $mNaN
Retained Cash Flow, $mNaN
Pot'l extraordinary dividend, $m124
Cash available for distribution, $mNaN
Discount rate, %NaN
PV of cash for distribution, $mNaN
Current shareholders' claim on cash, %NaN
HomeMenuAccount