Grufity logoGrufity logo

Consolidated Edison Inc Stock Research

ED

94.80USD-0.27(-0.28%)Delayedas of 27 Mar 2023, 10:32 am

Market Summary

USD94.80-0.27
Delayedas of 27 Mar 2023, 10:32 am
-0.28%

ED Stock Price

ED RSI Chart

ED Valuation

Market Cap

33.7B

Price/Earnings (Trailing)

20.33

Price/Sales (Trailing)

2.15

EV/EBITDA

11.17

Price/Free Cashflow

8.58

ED Price/Sales (Trailing)

ED Profitability

EBT Margin

13.39%

Return on Equity

8.02%

Return on Assets

2.4%

Free Cashflow Yield

11.66%

ED Fundamentals

ED Revenue

Revenue (TTM)

15.7B

Revenue Y/Y

18.04%

Revenue Q/Q

-3.22%

ED Earnings

Earnings (TTM)

1.7B

Earnings Y/Y

-15.18%

Earnings Q/Q

-69%

Price Action

52 Week Range

77.41101.31
(Low)(High)

Last 7 days

-1.3%

Last 30 days

2.9%

Last 90 days

-0.8%

Trailing 12 Months

6.7%

ED Financial Health

Current Ratio

1.14

Debt/Equity

1.13

Debt/Cashflow

0.17

ED Investor Care

Dividend Yield

3.32%

Dividend/Share (TTM)

3.16

Shares Dilution (1Y)

0.28%

Diluted EPS (TTM)

4.66

Peers (Alternatives to Consolidated Edison)

View All Peers In Detail
NameMkt Capsorted ascendingRevenuePrice %, 1MReturns, 1YP/EP/SRev 1-YrInc 1-Yr
LARGE-CAP
33.7B
15.7B
2.88% 6.65%
20.33
2.15
14.58% 23.33%
29.4B
9.6B
2.28% -0.57%
20.86
3.06
15.41% 8.56%
29.2B
9.8B
-3.32% -12.28%
28.34
2.98
0.80% 259.10%
22.0B
8.0B
-1.71% -5.55%
20.41
2.77
24.44% 8.44%
17.6B
8.6B
-0.62% -9.27%
21.03
2.05
17.29% -38.14%
11.0B
5.9B
-3.11% -10.18%
13.71
1.88
19.41% 37.48%
MID-CAP
7.0B
10.2B
-12.71% -5.51%
32.24
0.68
24.47% -79.76%
4.0B
2.6B
-2.96% -13.81%
15.31
1.55
30.92% 9.14%
3.3B
1.5B
-4.57% -3.15%
18.01
2.23
7.69% -2.05%
3.1B
1.7B
-1.53% -2.64%
19.86
1.77
20.61% 5.32%
2.3B
620.7M
-1.71% 13.78%
31.21
3.71
8.19% 22.07%
SMALL-CAP
1.4B
162.4M
-8.93% -23.52%
32.22
8.42
13.48% 16.11%
883.5M
563.2M
-0.86% 15.06%
21.34
1.57
18.99% 14.68%
278.1M
315.5M
-1.85% 76.98%
2.8
0.76
-13.25% 200.56%

Financials for Consolidated Edison

Income Statement (Last 12 Months)
(In Millions)
* denotes actual numbers (not divided by Millions)
Description(%) Q/Q2022Q42022Q32022Q22022Q12021Q4
Revenue4.1%15,67015,05514,50314,05913,676
Operating Expenses6.2%13,04612,28311,77011,29510,850
  R&D Expenses-25.00----
EBITDA2.7%5,0064,8754,7124,567-
EBITDA Margin-1.3%0.32*0.32*0.34*0.32*-
Earnings Before Taxes8.2%2,0981,9391,7561,5921,383
EBT Margin4.0%0.13*0.13*0.13*0.11*-
Interest Expenses3.6%852822855911905
Net Income0.9%1,6601,6451,5701,4341,346
Net Income Margin-3.0%0.11*0.11*0.12*0.11*-
Free Cahsflow8.1%3,9353,6393,2972,917-
Balance Sheet
(In Millions)
* denotes actual numbers (not divided by Millions)
Description(%) Q/Q2022Q42022Q32022Q22022Q12021Q4
Assets5.0%69,06565,76365,07263,73763,116
  Current Assets126.3%12,9725,7336,0165,4625,551
    Cash Equivalents1543.6%1,28278.001,127108992
  Net PPE-7.2%46,76650,39249,66049,01848,596
  Goodwill-7.1%408439439439439
  Current Liabilities64.5%11,3366,8906,8235,4155,427
.    Short Term BorrowingsInfinity%400----
  Long Term Debt1.7%23,44123,044---
    LT Debt, Current127.7%1,002440---
    LT Debt, Non Current0.4%22,43922,35022,36122,58322,604
Shareholder's Equity-0.3%20,68720,74820,62120,62320,037
Accumulated Depreciation-96.9%23.00731696660626
Shares Outstanding0.1%355355354354354
Minority Interest-11.4%202228234245299
Cashflow (Last 12 Months)
(In Millions)
Description(%) Q/Q2022Q42022Q32022Q22022Q12021Q4
Cashflow From Operations8.1%3,9353,6393,2972,9172,733
  Share Based Compensation-35.00----
Cashflow From Investing-3.9%-4,565-4,393-3,602-3,340-3,484
Cashflow From Financing30.0%1,014780367463461
  Dividend Payments1.4%1,0891,0741,0671,0531,030

Risks for ED

What is the probability of a big loss on ED?

21.5%


Probability that Consolidated Edison stock will be more than 20% underwater in next one year

0%


Probability that Consolidated Edison stock will be more than 30% underwater in next one year.

0%


Probability that Consolidated Edison stock will be more than 40% underwater in next one year.
*Calculated based on probability distribution of losses observed in actual data in the last 5 years.

How does ED drawdown profile look like?

Y-axis is the maximum loss one would have experienced if Consolidated Edison was unfortunately bought at previous high price.

Drawdowns

Returns for ED

Cumulative Returns on ED

8.7%


10-Year Cumulative Returns

7.0%


7-Year Cumulative Returns

8.5%


5-Year Cumulative Returns

14.4%


3-Year Cumulative Returns

What are the long-term rolling returns for ED?

FIve years rolling returns for Consolidated Edison.

Annualized Returns

Which funds bought or sold ED recently?

View All Details
Datesorted ascendingFund NameType% Chg$ Change$ Held% Portfolio
2023-03-15
B. Riley Wealth Advisors, Inc.
added
5.18
360,808
2,500,810
0.07%
2023-03-10
VICTORY CAPITAL MANAGEMENT INC
added
3.99
11,258,300
83,592,300
0.09%
2023-03-10
BAILLIE GIFFORD & CO
reduced
-35.15
-10,205,900
26,342,100
0.03%
2023-03-10
MATHER GROUP, LLC.
reduced
-7.96
9,374
415,374
0.01%
2023-03-06
Rockefeller Capital Management L.P.
reduced
-18.09
-617,000
6,250,000
0.03%
2023-03-06
BIRMINGHAM CAPITAL MANAGEMENT CO INC/AL
unchanged
-
67,506
670,506
0.26%
2023-03-06
Aldebaran Financial Inc.
unchanged
-
23,019
278,019
0.30%
2023-03-03
TIAA, FSB
added
2.74
221,537
1,785,540
0.01%
2023-03-02
LORING WOLCOTT & COOLIDGE FIDUCIARY ADVISORS LLP/MA
new
-
200,151
200,151
-%
2023-03-01
Regal Investment Advisors LLC
reduced
-0.96
541,396
5,923,400
0.57%

1–10 of 44

Latest Funds Activity

Are funds buying ED calls or puts?
Calls
Puts
Are funds bullish or bearish(Calls - Puts)?
Net Call Options
No. of funds that own ED
No. of Funds

Consolidated Edison News

Stock Traders Daily

Trading Consolidated Edison $ED With Integrated Risk Controls.

Stock Traders Daily,
11 hours ago

Barchart

Marketscreener.com

Marketscreener.com

Schedule 13G FIlings of Consolidated Edison

Date FiledName of FilerPercent of ClassNo. of SharesForm Type
Feb 09, 2023
vanguard group inc
12.22%
43,349,680
SC 13G/A
Feb 03, 2023
state street corp
7.89%
28,009,544
SC 13G/A
Jan 30, 2023
blackrock inc.
12.9%
45,851,229
SC 13G/A
Feb 10, 2022
state street corp
7.78%
27,514,717
SC 13G/A
Feb 09, 2022
vanguard group inc
9.99%
35,340,540
SC 13G/A
Jan 27, 2022
blackrock inc.
12.8%
45,413,132
SC 13G/A
Jan 26, 2022
blackrock inc.
12.8%
45,413,132
SC 13G/A
Feb 10, 2021
vanguard group inc
8.74%
29,884,610
SC 13G/A
Feb 08, 2021
state street corp
6.54%
22,381,107
SC 13G
Jan 27, 2021
blackrock inc.
10.9%
37,296,050
SC 13G/A

ED Fair Value

Consolidated Edison fair value in different scenarios

The table shows the Fair Value estimates for Consolidated Edison for various scenarios. Disclaimer: These are just estimations from a model. None of the models are good at predicting the future. Please dont buy or sell stocks based on these outputs.
Fair ValueVery PessimisticPessimisticBase CaseOptimisticVery Optimistic
Very Low Inflation

49.79

-47.48%

59.94

-36.77%

79.05

-16.61%

111.32

17.43%

140.94

48.67%
Current Inflation

45.80

-51.69%

54.45

-42.56%

70.54

-25.59%

97.32

2.66%

122.01

28.70%
Very High Inflation

40.86

-56.90%

47.77

-49.61%

60.44

-36.24%

81.14

-14.41%

100.34

5.84%

Historical Consolidated Edison Fair Value Estimates


Very Pessimistic Case
Pessimistic Case
Fair Value
Optimistic Case
Very Optimistic Case
Closing Stock Price

Recent SEC filings of Consolidated Edison

View All Filings
Date Filed Form Type Document
Mar 16, 2023
4
Insider Trading
Mar 07, 2023
8-K
Current Report
Mar 06, 2023
4
Insider Trading
Mar 06, 2023
4
Insider Trading
Mar 06, 2023
4
Insider Trading
Mar 06, 2023
4
Insider Trading
Mar 06, 2023
4
Insider Trading
Mar 06, 2023
4
Insider Trading
Mar 06, 2023
4
Insider Trading
Mar 06, 2023
4
Insider Trading

Latest Insider Trading transactions for ED

Filter Transactions
Datesorted ascendingNameBuy/Sell$ ValueAvg. Price# SharesTitle
2023-03-15
Miller Joseph
bought
89.9006
93.94
0.957
vp & controller
2023-02-28
Donnley Deneen L
bought
2,313
89.35
25.891
svp and general counsel
2023-02-28
Nadkarni Gurudatta D
bought
2,078
89.35
23.267
vp, strategic planning
2023-02-28
Ketschke Matthew
bought
111
89.35
1.244
president cecony
2023-02-28
HOGLUND ROBERT N
bought
2,314
89.35
25.907
svp & cfo
2023-02-28
Nachmias Stuart
bought
666
89.35
7.4612
president & ceo cet
2023-02-28
Shannon Nancy
bought
888
89.35
9.948
svp utility shared services
2023-02-28
Miller Joseph
bought
222
89.35
2.487
vp & controller
2023-02-28
Sanchez Robert
bought
2,311
89.35
25.866
president & ceo, o&r
2023-02-28
Cawley Timothy
bought
2,315
89.35
25.916
chairman, president, ceo

1–10 of 50

Timothy P. Cawley
13900
Consolidated Edison, Inc., through its subsidiaries, engages in the regulated electric, gas, and steam delivery businesses in the United States. It 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,555 customers in parts of Manhattan. The company 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. In addition, it operates 533 circuit miles of transmission lines; 15 transmission substations; 64 distribution substations; 87,564 in-service line transformers; 3,924 pole miles of overhead distribution lines; and 2,291 miles of underground distribution lines, as well as 4,350 miles of mains and 377,971 service lines for natural gas distribution. Further, the company 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. It primarily sells electricity to industrial, commercial, residential, and government customers. The company was founded in 1823 and is based in New York, New York.

ED Income Statement

2022-12-31
Consolidated Income Statement - USD ($)
shares in Millions, $ in Millions
12 Months Ended
Dec. 31, 2022
Dec. 31, 2021
Dec. 31, 2020
OPERATING REVENUES   
TOTAL OPERATING REVENUES$ 15,670$ 13,676$ 12,246
OPERATING EXPENSES   
Depreciation and amortization2,0562,0321,920
Taxes, other than income taxes3,0052,8102,575
TOTAL OPERATING EXPENSES13,04610,8509,592
OPERATING INCOME2,6242,8262,654
OTHER INCOME (DEDUCTIONS)   
Investment income (loss)20(420)(214)
Other income4022223
Allowance for equity funds used during construction192117
Other deductions(115)(161)(227)
TOTAL OTHER INCOME (DEDUCTIONS)326(538)(401)
INCOME BEFORE INTEREST AND INCOME TAX EXPENSE2,9502,2882,253
INTEREST EXPENSE   
Interest on long-term debt987930915
Other interest(99)(14)118
Allowance for borrowed funds used during construction(36)(11)(14)
NET INTEREST EXPENSE8529051,019
INCOME BEFORE INCOME TAX EXPENSE2,0981,3831,234
INCOME TAX EXPENSE49819090
NET INCOME1,6001,1931,144
(Loss) Income attributable to non-controlling interest(60)(153)43
NET INCOME$ 1,660$ 1,346$ 1,101
Net income per common share — basic (in dollars per share)$ 4.68$ 3.86$ 3.29
Net income per common share — diluted (in dollars per share)$ 4.66$ 3.85$ 3.28
AVERAGE NUMBER OF SHARES OUTSTANDING — BASIC (in shares)354.5348.4334.8
AVERAGE NUMBER OF SHARES OUTSTANDING — DILUTED (in shares)355.8349.4335.7
Electric   
OPERATING REVENUES   
TOTAL OPERATING REVENUES$ 10,522$ 9,485$ 8,730
Gas   
OPERATING REVENUES   
TOTAL OPERATING REVENUES3,2372,6382,269
OPERATING EXPENSES   
Operating costs1,245690527
Steam   
OPERATING REVENUES   
TOTAL OPERATING REVENUES593532508
Non-utility   
OPERATING REVENUES   
TOTAL OPERATING REVENUES1,3181,021739
Purchased power   
OPERATING EXPENSES   
Operating costs2,4791,8351,600
Fuel   
OPERATING EXPENSES   
Operating costs356229156
Other operations and maintenance   
OPERATING EXPENSES   
Operating costs$ 3,905$ 3,254$ 2,814

ED Balance Sheet

2022-12-31
Consolidated Balance Sheet - USD ($)
$ in Millions
Dec. 31, 2022
Dec. 31, 2021
CURRENT ASSETS  
Cash and temporary cash investments$ 1,282$ 992
Accounts receivable - customers, less allowance for uncollectible accounts2,1921,943
Other receivables, less allowance for uncollectible accounts164298
Taxes receivable1013
Accrued unbilled revenue702662
Fuel oil, gas in storage, materials and supplies, at average cost492437
Prepayments264295
Regulatory assets305206
Restricted cash0154
Revenue decoupling mechanism receivable164190
Fair value of derivative assets59128
Assets held for sale7,1620
Other current assets176233
TOTAL CURRENT ASSETS12,9725,551
INVESTMENTS841853
UTILITY PLANT, AT ORIGINAL COST  
General4,2054,170
TOTAL57,33754,239
Less: Accumulated depreciation13,06912,177
Net44,26842,062
Construction work in progress2,4842,152
NET UTILITY PLANT46,75244,214
NON-UTILITY PLANT  
Non-utility property, less accumulated depreciation134,194
Construction work in progress1188
NET PLANT46,76648,596
OTHER NONCURRENT ASSETS  
Goodwill408439
Intangible assets, net of accumulated amortization of $297 and $228 in 2021 and 2020, respectively01,293
Operating lease right-of-use-asset568809
Regulatory assets3,9743,639
Pension and Retiree Benefits3,2691,654
Fair value of derivative assets8577
Other deferred charges and noncurrent assets182205
TOTAL OTHER NONCURRENT ASSETS8,4868,116
TOTAL ASSETS69,06563,116
CURRENT LIABILITIES  
Long-term debt due within one year649440
Term Loan4000
Notes payable2,6401,488
Accounts payable1,9551,497
Customer deposits358300
Accrued taxes102104
Accrued interest153151
Accrued wages116113
Fair value of derivative liabilities42152
Regulatory liabilities374185
System benefit charge390423
Operating lease liabilities103113
Liabilities held for sale3,6100
Other current liabilities444461
TOTAL CURRENT LIABILITIES11,3365,427
NONCURRENT LIABILITIES  
Provision for injuries and damages181183
Pensions and retiree benefits577737
Superfund and other environmental costs997940
Asset retirement obligations500577
Fair value of derivative liabilities1384
Deferred income taxes and unamortized investment tax credits7,6416,873
Operating lease liabilities476717
Regulatory liabilities6,0274,381
Other deferred credits and noncurrent liabilities281257
TOTAL NONCURRENT LIABILITIES16,69314,749
TOTAL LONG-TERM DEBT EXCLUDING HELD FOR SALE20,14722,604
COMMITMENTS, CONTINGENCIES, AND GUARANTEES (Note B, Note G, and Note H)
EQUITY  
Common shareholders’ equity20,68720,037
Noncontrolling interest202299
TOTAL EQUITY (See Statement of Equity)20,88920,336
TOTAL LIABILITIES AND EQUITY69,06563,116
Electric  
UTILITY PLANT, AT ORIGINAL COST  
Utility plant, at original cost36,81934,938
Gas  
UTILITY PLANT, AT ORIGINAL COST  
Utility plant, at original cost13,37812,303
Steam  
UTILITY PLANT, AT ORIGINAL COST  
Utility plant, at original cost$ 2,935$ 2,828