Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS
Consolidated Edison Inc. logo

Consolidated Edison Inc.

Sector: Utilities   

Industry: Utilities - Regulated Electric

95.11
 
USD
  
0.72
  
(0.76%)
Optionable: Yes  Market Cap: 33,513 M  90-day average vol: 1,858,139

Previous close: 94.39  Open: 94.79  Bid: 95.7  Ask: 95.7
52 week range    
78.10   
   102.21
Peers   
FE / 
D / 
CMS / 
PEG / 
EXC / 
NI / 
WEC / 
UTL / 
Last updated: Thursday 30th March 2023
65
MarketXLS Rank
80
Value
61
Technical
55
Quality

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today
Search for a stock
Are you?
twitterstocktwits
Metrics

Peers

StockDividendMarket Cap (B)PEPrice ($)

CMS

0.028318 B21.464.92

D

0.033365 B25.580.17

EXC

0.035157 B33.943.64

FE

0.037624 B20.741.44

NI

0.032711 B25.828.79

NU

PEG

0.030534 B-50.466.79

UTL

0.03061 B20.151.03

WEC

0.030730 B23.494.72
Financials

ED Income Statement

Annual
Dec-13Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22
Total revenues12,354 M12,919 M12,554 M12,075 M12,033 M12,337 M12,574 M12,246 M13,676 M15,670 M
Cost of sales6,167 M6,736 M5,930 M4,936 M4,423 M4,662 M4,124 M3,177 M3,976 M5,929 M
Gross operating profit5,163 M5,112 M5,494 M5,923 M6,269 M6,237 M6,766 M7,149 M7,668 M7,685 M
Selling Gen & administrative expenseN/AN/AN/AN/AN/AN/AN/AN/AN/AN/A
Research & development expense0000000000
Operating income2,244 M2,164 M2,427 M2,676 M2,773 M2,533 M2,676 M2,654 M2,826 M2,624 M
floaterest income0000000000
floaterest expense0000000000
Other income net13 M87 M24 M-37 M-47 M69 M51 M-401 M-538 M326 M
Pre-tax Income (EBT)1,538 M1,660 M1,798 M1,943 M1,997 M1,783 M1,736 M1,234 M1,383 M2,098 M
Income taxes476 M568 M605 M698 M472 M401 M296 M90 M190 M498 M
Net income from total operations1,062 M1,092 M1,193 M1,245 M1,525 M1,382 M1,440 M1,144 M1,193 M1,600 M
Minority floaterest0000000000
Total net income1,062 M1,092 M1,193 M1,245 M1,525 M1,382 M1,343 M1,101 M1,346 M1,660 M
Preferred dividendsN/AN/AN/AN/AN/AN/AN/AN/AN/AN/A
Net income available for common1,062 M1,092 M1,193 M1,245 M1,525 M1,382 M1,440 M1,144 M1,193 M1,600 M
Depreciation1,024 M1,071 M1,130 M1,216 M1,341 M1,438 M1,684 M1,920 M2,032 M2,056 M
Amortization0000000000
Operating income before depreciation (EBITDA)3,281 M3,322 M3,581 M3,855 M4,067 M4,040 M4,411 M4,173 M4,334 M5,105 M
Total Income available for floaterest expense (EBIT)0000000000
Basic EPS total3.623.734.074.154.974.434.093.293.864.68
Diluted EPS total3.613.714.054.124.944.424.083.283.854.66
Call: 1-877-778-8358
Ankur Mohan MarketXLS
I am so happy you are here. My name is Ankur and I am the founder/CEO of MarketXLS. Over the past four years, I have helped more than 2500 customers to implement their own investment research strategies and monitoring systems in Excel.
Implement “your own” investment strategies in Excel with thousands of MarketXLS functions and starter sheets.
Get started today