Grufity logoGrufity logo

ED

98.00USD-0.04(-0.04%)Delayedas of 01 Dec 2022, 03:48 pm

Consolidated Edison Inc

Market Summary

USD98.00-0.04Delayedas of 01 Dec 2022, 03:48 pm
-0.04%

ED Stock Price

RSI Chart

Valuation

Market Cap

31.4B

Price/Earnings

19.37

Price/Sales

2.16

Price/Cashflow

9.51

MarketCap/EBT

17.86

Price/Sales

Profitability

EBT Margin

12.11%

Return on Equity

7.94%

Return on Assets

2.49%

Fundamentals

Revenue

Revenue (TTM)

14.5B

Revenue Y/Y

14.94%

Revenue Q/Q

-15.89%

Earnings

Earnings (TTM)

1.6B

Earnings Y/Y

54.55%

Earnings Q/Q

-57.64%

Price Action

52 Week Range

75.50101.31
(Low)(High)

Last 7 days

1.4%

Last 30 days

12.5%

Last 90 days

-0.5%

Trailing 12 Months

30.7%

Financial Health

Current Ratio

0.88

Debt/Equity

1.13

Debt/Cashflow

0.14

Investor Care

Dividend Yield

3.55%

Dividend/Share (TTM)

3.14

Shares Dilution (1Y)

0.34%

Diluted EPS (TTM)

4.56

Peers (Alternatives to Consolidated Edison)

View All Peers In Detail
NameMkt Capsorted ascendingRevenuePrice %, 1MReturns, 1YP/EP/SRev 1-YrInc 1-Yr
LARGE-CAP
31.4B
14.5B
12.45% 30.73%
19.37
2.16
12.07% 44.55%
28.9B
9.0B
10.28% 18.45%
21.12
3.22
12.98% 5.90%
28.6B
9.7B
7.99% -0.76%
-28.94
3.06
7.16% 203.93%
21.3B
7.5B
9.57% 11.62%
20.98
3.06
20.71% 9.27%
16.8B
8.4B
7.92% 6.78%
12.88
2.01
16.57% 49.66%
10.5B
5.6B
8.76% 17.85%
14.54
1.94
18.13% 44.12%
MID-CAP
7.4B
10.1B
9.40% -3.74%
5.45
0.77
35.71% -26.86%
4.3B
2.2B
10.60% 15.53%
15.96
1.91
21.85% 14.34%
3.1B
1.4B
10.56% 9.14%
18.42
2.21
4.59% -11.35%
3.0B
1.7B
1.77% 11.75%
20.24
1.88
18.02% -17.46%
2.1B
589.1M
6.23% 13.38%
36.36
3.6
3.41% 4.67%
SMALL-CAP
1.6B
157.6M
4.81% -8.13%
37.33
10.06
9.67% 12.98%
855.2M
541.5M
4.81% 36.27%
20.91
1.62
20.23% 17.61%
245.2M
272.4M
2.86% 100.98%
3.14
0.81
-31.71% 36324.09%

Financials for Consolidated Edison

Income Statement (Last 12 Months)
(In Millions)
Description(%) Q/Q2022Q22022Q12021Q42021Q32021Q2
Revenue3.2%14,50314,05913,67613,22112,941
Operating Expenses4.2%11,77011,29510,85010,58610,296
  R&D Expenses-25
Earnings Before Taxes10.3%1,7561,5921,3831,1571,182
Net Income5.9%1,6191,5291,3461,1651,120
Balance Sheet
(In Millions)
Description(%) Q/Q2022Q22022Q12021Q42021Q32021Q2
Assets2.1%65,07263,73763,11662,93862,919
  Current Assets10.1%6,0165,4625,5515,0965,110
    Cash Equivalents943.5%1,127108992661,067
  Net PPE1.3%49,66049,01848,59647,94747,339
  Goodwill0%439439439446446
  Current Liabilities26.0%6,8235,4155,4275,2555,557
.    Short Term Borrowings------
  Long Term Debt-23,044----
    LT Debt, Non Current-1.0%22,36122,58322,60421,84121,666
Shareholder's Equity0.0%20,38720,37820,03720,03719,743
Accumulated Depreciation5.5%696660626590555
Shares Outstanding0.1%354354354353345
Minority Interest-4.5%234245299340310
Float-25,300----
* denotes actual numbers (not divided by Millions)
Cashflow (Last 12 Months)
(In Millions)
Description(%) Q/Q2022Q22022Q12021Q42021Q32021Q2
Cashflow From Operations13.0%3,2972,9172,7332,5422,411
  Share Based Compensation-35
Cashflow From Investing-7.8%-3,602.00-3,340.00-3,484.00-3,677.00-4,292.00
Cashflow From Financing-20.7%3674634611,0361,714
  Dividend Payments1.3%1,0671,0531,0301,012995

Risks

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.

Returns

Cumulative Returns on ED

9.9%


10-Year Cumulative Returns

10.9%


7-Year Cumulative Returns

5.9%


5-Year Cumulative Returns

8.1%


3-Year Cumulative Returns

What are the long-term rolling returns for ED?

FIve years rolling returns for Consolidated Edison.

Which funds bought or sold ED recently?

View All Details
Datesorted ascendingFund NameType% Chg$ Change$ Held% Portfolio
2022-11-29
Bridgefront Capital, LLC
SOLD OFF
-100
-361,000
-
-%
2022-11-23
Toroso Investments, LLC
ADDED
45.72
123,000
516,000
0.02%
2022-11-23
Eagle Bay Advisors LLC
UNCHANGED
-
-473
2,000
-%
2022-11-23
FSB PREMIER WEALTH MANAGEMENT, INC.
UNCHANGED
-
-37,000
335,000
0.20%
2022-11-22
B. Riley Wealth Advisors, Inc.
ADDED
14.22
62,000
2,140,000
0.06%
2022-11-22
TEACHERS RETIREMENT SYSTEM OF THE STATE OF KENTUCKY
NEW
-
2,834,000
2,834,000
0.03%
2022-11-22
IHT Wealth Management, LLC
ADDED
162.26
388,000
672,000
0.05%
2022-11-22
CVA Family Office, LLC
UNCHANGED
-
-3,000
28,000
0.01%
2022-11-21
Parallax Volatility Advisers, L.P.
ADDED
2.45
-28,000
333,000
-%
2022-11-21
Sunbelt Securities, Inc.
ADDED
0.43
-36,000
343,000
0.07%

1–10 of 46

Latest Funds Activity

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

Consolidated Edison News

24/7 Wall St.

Thursday’s Top Analyst Upgrades and Downgrades: Carvana, CrowdStrike, Foot Locker, Rivian, Shopify, UnitedHealth and More.7 hours ago

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

43.58

-55.53%

60.90

-37.86%

73.05

-25.46%

89.19

-8.99%

120.18

22.63%

Current Inflation

40.05

-59.13%

54.73

-44.15%

64.70

-33.98%

78.45

-19.95%

104.00

6.12%

Very High Inflation

35.69

-63.58%

47.33

-51.70%

54.91

-43.97%

65.94

-32.71%

85.52

-12.73%

Historical Consolidated Edison Fair Value Estimates


Recent SEC filings of Consolidated Edison

View All Filings
Date Filed Form Type Document
Nov 17, 2022
4
Insider Trading
Nov 14, 2022
8-K
Current Report
Nov 08, 2022
8-K
Current Report
Nov 07, 2022
4
Insider Trading
Nov 07, 2022
4
Insider Trading
Nov 07, 2022
4
Insider Trading
Nov 07, 2022
4
Insider Trading
Nov 07, 2022
4
Insider Trading
Nov 07, 2022
4
Insider Trading
Nov 07, 2022
4
Insider Trading

Latest Insider Trading transactions for ED

Filter Transactions
Datesorted ascendingNameBuy/Sell$ ValueAvg. Price# SharesTitle
2022-11-15
MULROW WILLIAM J
ACQUIRED
13,756.8
89.33
154
Director
2022-11-01
Cawley Timothy
BOUGHT
7,041.6
88.02
80
Chairman, President & CEO
2022-10-31
Sanchez Robert
BOUGHT
2,311.06
87.96
26.274
President & CEO, O&R
2022-10-31
Cawley Timothy
BOUGHT
2,315.55
87.96
26.325
Chairman, President, CEO
2022-10-31
Shannon Nancy
BOUGHT
444.462
87.96
5.053
SVP Utility Shared Services
2022-10-31
Ketschke Matthew
BOUGHT
111.093
87.96
1.263
President CECONY
2022-10-31
Donnley Deneen L
BOUGHT
2,313.35
87.96
26.3
SVP and General Counsel
2022-10-31
Nachmias Stuart
BOUGHT
666.649
87.96
7.579
President & CEO CET
2022-10-31
Miller Joseph
BOUGHT
222.187
87.96
2.526
VP & Controller
2022-10-31
HOGLUND ROBERT N
BOUGHT
2,314.84
87.96
26.317
SVP & CFO

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-09-30
CONSOLIDATED INCOME STATEMENT (UNAUDITED) - USD ($)
shares in Millions, $ in Millions
3 Months Ended9 Months Ended
Sep. 30, 2022
Sep. 30, 2021
Sep. 30, 2022
Sep. 30, 2021
OPERATING REVENUES    
TOTAL OPERATING REVENUES$ 4,165$ 3,613$ 11,639$ 10,261
OPERATING EXPENSES    
Depreciation and amortization5255121,5931,511
Taxes, other than income taxes7777272,2482,103
TOTAL OPERATING EXPENSES3,2762,7639,5658,132
OPERATING INCOME8898502,0742,129
OTHER INCOME (DEDUCTIONS)    
Investment income (loss)5515(180)
Other income101529619
Allowance for equity funds used during construction451515
Other deductions(21)(37)(57)(113)
TOTAL OTHER INCOME (DEDUCTIONS)89(22)269(259)
INCOME BEFORE INTEREST AND INCOME TAX EXPENSE9788282,3431,870
INTEREST EXPENSE (INCOME)    
Interest on long-term debt246235728693
Other interest expense (income)(32)(2)(119)(15)
Allowance for borrowed funds used during construction(15)(1)(23)(9)
NET INTEREST EXPENSE199232586669
INCOME BEFORE INCOME TAX EXPENSE7795961,7571,201
INCOME TAX EXPENSE160127330194
NET INCOME6194691,4271,007
Income (loss) attributable to non-controlling interest6(69)(43)(115)
NET INCOME$ 613$ 538$ 1,470$ 1,122
Net income per common share - basic (dollars per share)$ 1.73$ 1.52$ 4.15$ 3.23
Net income per common share - diluted (dollars per share)$ 1.72$ 1.52$ 4.13$ 3.23
AVERAGE NUMBER OF SHARES OUTSTANDING-BASIC (shares)354.6353.4354.4346.8
AVERAGE NUMBER OF SHARES OUTSTANDING—DILUTED (shares)355.9354.1355.7347.5
Electric    
OPERATING REVENUES    
TOTAL OPERATING REVENUES$ 3,328$ 2,952$ 7,994$ 7,180
Gas    
OPERATING REVENUES    
TOTAL OPERATING REVENUES4533412,3451,907
OPERATING EXPENSES    
Operating costs18583833461
Steam    
OPERATING REVENUES    
TOTAL OPERATING REVENUES5855444393
Non-utility    
OPERATING REVENUES    
TOTAL OPERATING REVENUES326265856781
Purchased power    
OPERATING EXPENSES    
Operating costs7315481,8511,448
Fuel    
OPERATING EXPENSES    
Operating costs5944255166
Other operations and maintenance    
OPERATING EXPENSES    
Operating costs$ 999$ 849$ 2,785$ 2,443

ED Balance Sheet

2022-09-30
CONSOLIDATED BALANCE SHEET (UNAUDITED) - USD ($)
$ in Millions
Sep. 30, 2022
Dec. 31, 2021
CURRENT ASSETS  
Cash and temporary cash investments$ 78$ 992
Accounts receivable – customers, net allowance for uncollectible accounts2,0951,943
Other receivables, net allowance for uncollectible accounts330298
Taxes receivable913
Accrued unbilled revenue619662
Fuel oil, gas in storage, materials and supplies, at average cost533437
Prepayments913295
Regulatory assets282206
Restricted cash163154
Revenue decoupling mechanism receivable167190
Fair value of derivative assets256128
Other current assets288233
TOTAL CURRENT ASSETS5,7335,551
INVESTMENTS805853
UTILITY PLANT, AT ORIGINAL COST  
General4,1674,170
TOTAL56,47654,239
Less: Accumulated depreciation12,83112,177
Net43,64542,062
Construction work in progress2,2342,152
NET UTILITY PLANT45,87944,214
NON-UTILITY PLANT  
Non-utility property, net accumulated depreciation of $731 and $626 in 2022 and 2021, respectively4,1284,194
Construction work in progress385188
NET PLANT50,39248,596
OTHER NONCURRENT ASSETS  
Goodwill439439
Intangible assets, net accumulated amortization of $368 and $297 in 2022 and 2021, respectively1,2221,293
Regulatory assets3,7053,639
Pension and retiree benefits2,1881,654
Operating lease right-of-use asset844809
Fair value of derivative assets25077
Other Assets, Miscellaneous, Noncurrent185205
TOTAL OTHER NONCURRENT ASSETS8,8338,116
TOTAL ASSETS65,76363,116
CURRENT LIABILITIES  
Long-term debt due within one year323440
Term loan5500
Notes payable1,9411,488
Accounts payable1,5871,497
Customer deposits345300
Accrued taxes94104
Accrued interest277151
Accrued wages117113
Fair value of derivative liabilities70152
Regulatory liabilities568185
System benefit charge423423
Operating lease liabilities131113
Other current liabilities464461
TOTAL CURRENT LIABILITIES6,8905,427
NONCURRENT LIABILITIES  
Provision for injuries and damages176183
Pensions and retiree benefits688737
Superfund and other environmental costs923940
Asset retirement obligations591577
Fair value of derivative liabilities3184
Deferred income taxes and unamortized investment tax credits7,3876,873
Operating lease liabilities772717
Regulatory liabilities4,7174,381
Deferred Credits and Other Liabilities, Noncurrent262257
TOTAL NONCURRENT LIABILITIES15,54714,749
LONG-TERM DEBT22,35022,604
COMMITMENTS, CONTINGENCIES, AND GUARANTEES (Note B, Note G, and Note H)
EQUITY  
Common shareholders’ equity20,74820,037
Noncontrolling interest228299
TOTAL EQUITY (See Statement of Equity)20,97620,336
TOTAL LIABILITIES AND EQUITY65,76363,116
Electric  
UTILITY PLANT, AT ORIGINAL COST  
Utility plant, at original cost36,34634,938
Gas  
UTILITY PLANT, AT ORIGINAL COST  
Utility plant, at original cost13,06812,303
Steam  
UTILITY PLANT, AT ORIGINAL COST  
Utility plant, at original cost$ 2,895$ 2,828