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

Optionable: Yes  Market Cap: 32,077 M  90-day average vol: 1,901,930

Previous close: 92.84  Open: 92.05  Bid: 92.0  Ask: 93.99
52 week range    
FE / 
D / 
CMS / 
PEG / 
EXC / 
NI / 
WEC / 
UTL / 
Last updated: Thursday 25th April 2024
MarketXLS Rank

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

🎉 Exciting news! 🎉

You are invited to join our Discord Channel.

Interact, learn, and grow with experts in the markets!

Join our Discord



StockDividendMarket Cap (B)PEPrice ($)


0.028318 B21.464.92


0.033365 B25.580.17


0.035157 B33.943.64


0.037624 B20.741.44


0.032711 B25.828.79



0.030534 B-50.466.79


0.03061 B20.151.03


0.030730 B23.494.72

ED Income Statement

Basic EPS from continuing operations3.623.734.074.154.974.434.093.293.864.68
Basic EPS total3.623.734.074.154.974.434.093.293.864.68
Basic weighted shares outstanding293 M293 M293 M300 M307 M312 M329 M335 M348 M355 M
Cost of sales216 M263 M207 M156 M229 M3,905 M
Depreciation1,024 M1,071 M1,130 M1,216 M1,341 M1,438 M1,684 M1,920 M2,032 M2,056 M
Depreciation unreconciled1,024 M1,071 M1,130 M1,216 M1,341 M1,438 M1,684 M1,920 M2,032 M2,056 M
DevelopmentExpense18 M22 M23 M24 M24 M24 M24 M24 M25 M27 M
Diluted EPS total3.613.714.054.124.944.424.083.283.854.66
Diluted normalized net income/share3.613.714.054.124.944.424.083.283.854.66
Diluted weighted shares outstanding294 M294 M294 M302 M309 M313 M330 M336 M349 M356 M
Dividends paid per share2.462.522.62.682.762.862.963.063.13.16
ExciseTaxes-354 M-365 M-354 M-336 M-302 M-330 M-323 M-335 M-358 M-400 M
FuelAndPurchasePower320 M285 M248 M172 M216 M
GainOnSaleOfPPE104 M1000000.0
GainOnSaleOfSecurity24 M99 M35 M47 M111 M119 M96 M-214 M-420 M20 M
GeneralAndAdministrativeExpense78 M169 M5 M
Gross operating profit12,354 M12,919 M12,554 M12,075 M11,817 M12,074 M12,367 M12,090 M13,447 M15,670 M
Income before tax1,540 M1,660 M1,798 M1,943 M1,997 M1,783 M1,736 M1,400 M1,590 M1,645 M
Income restructuring and M&A-1,612 M-1,279 M18 M
Income taxes476 M568 M605 M698 M472 M401 M296 M90 M190 M498 M
InterestExpenseNonOperating721 M592 M656 M702 M737 M829 M1,004 M797 M944 M1,086 M
MinorityInterests12,245 M12,585 M13,061 M14,306 M15,425 M16,839 M-97 M-43 M153 M60 M
MiscOtherSpecialCharges-15 M-14 M-16 M7 M-170 M-193 M-59 M-204 M-139 M287 M
Net income from total operations1,062 M1,092 M1,193 M1,245 M1,525 M1,382 M1,343 M1,185 M1,346 M1,660 M
NetIncomeCommonStockholders1,062 M5,604 M4,906 M4,327 M7,281 M7,472 M7,138 M6,420 M1,346 M1,660 M
NetIncomeContinuousOperations1,062 M1,092 M1,193 M1,245 M1,525 M1,382 M1,343 M1,185 M1,346 M1,660 M
NetNonOperatingInterestIncomeExpense-721 M-592 M-656 M-702 M-737 M-829 M-1,004 M-797 M-944 M-1,086 M
NonRecurringOperationExpense-7 M-1000000.0
Normalized income1,001 M1,072 M1,169 M1,158 M-315 M-1 M1,371 M1,106 M
Operating income2,244 M2,209 M2,427 M2,575 M2,774 M2,664 M2,676 M2,654 M2,826 M10,628 M
Operating income before depreciation (EBITDA)5,207 M5,630 M5,464 M5,409 M6,057 M6,219 M6,820 M4,077 M6,271 M6,565 M
OperatingExpense8,370 M8,647 M8,081 M7,903 M7,919 M8,326 M8,473 M8,337 M9,256 M11,133 M
Other income net-9 M-85 M-19 M-158 M58 M-57 M-37 M418 M559 M-307 M
OtherCostofRevenue3,734 M4,228 M3,468 M2,916 M2,409 M
OtherGandA78 M169 M5 M
OtherOperatingExpenses3,133 M3,292 M3,339 M3,259 M-11 M-12 M-14 M-17 M-21 M-19 M
OtherTaxes1,895 M1,877 M1,937 M2,031 M2,155 M2,266 M2,406 M2,575 M2,810 M3,005 M
Research & development expense18 M22 M23 M24 M24 M24 M24 M24 M25 M27 M
RestructringAndMnAIncome-1,612 M-1,279 M18 M
Revenue per share2 M9 M14 M99 M102 M95 M71 M
Special income/charges-7 M-1000000.0-1,612 M-1,279 M18 M
Total Income available for interest expense (EBIT)2,261 M2,252 M2,454 M2,645 M2,734 M2,612 M2,740 M2,197 M2,534 M2,731 M
Total common shares outstanding293 M293 M294 M305 M310 M321 M334 M342 M354 M355 M
Total net income1,062 M1,092 M1,193 M1,245 M1,525 M1,382 M1,343 M1,185 M1,346 M1,660 M
Total ordinary shares346 M346 M346 M346 M346 M346 M346 M346 M346 M346 M
Total revenues12,354 M12,919 M12,554 M12,075 M12,033 M12,337 M12,574 M12,246 M13,676 M15,670 M
TotalExpenses8,370 M8,647 M8,081 M7,903 M8,135 M8,589 M8,680 M8,493 M9,485 M15,038 M
TotalRevenue12,354 M12,919 M12,554 M12,075 M12,033 M12,337 M12,574 M12,246 M13,676 M13,268 M
Call: 1-877-778-8358
Ankur Mohan MarketXLS
Welcome! I'm Ankur, the founder and CEO of MarketXLS. With more than ten years of experience, I have assisted over 2,500 customers in developing personalized investment research strategies and monitoring systems using Excel.

I invite you to book a demo with me or my team to save time, enhance your investment research, and streamline your workflows.
Implement “your own” investment strategies in Excel with thousands of MarketXLS functions and templates.

MarketXLS is a complete Excel stock solution

Kevin Hsu


I have used lots of stock and option information services. This is the only one which gives me what I need inside Excel

Lloyd Lenase

Option Day Trader

MarketXLS is a data junkie’s dream. It gives me the flexibility to mine for hidden treasures.


Swing trader since 2011

I like to access historical closing prices on a particular date. That makes tracking performance easy.

Patrick Cusatis, Ph.D., CFA

Associate Professor of Finance - Penn State University