Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS
Duke Energy Corporation (Holding Company) logo

Duke Energy Corporation (Holding Company)

Sector: Utilities   

Industry: Utilities - Regulated Electric

96.71
 
USD
  
0.62
  
(0.65%)
Optionable: Yes  Market Cap: 72,202 M  90-day average vol: 3,136,360

Previous close: 96.09  Open: 96.14  Bid: 96.51  Ask: 97.0
52 week range    
83.06   
   100.39
Peers   
XEL / 
SO / 
AEP / 
D / 
FE / 
PPL / 
PCG / 
AEE / 
Last updated: Friday 29th March 2024
60
MarketXLS Rank
75
Value
61
Technical
44
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

🎉 Exciting news! 🎉

You are invited to join our Discord Channel.

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

Join our Discord

Metrics

Peers

StockDividendMarket Cap (B)PEPrice ($)

AEE

0.025223 B23.287.36

AEP

0.034744 B1989.81

D

0.033365 B25.580.17

FE

0.037624 B20.741.44

NEE

0.0203152 B43.275.68

PCG

24 B91.412.15

PPL

0.056722 B-17.429.29

SO

0.038472 B24.867.65

XEL

0.026637 B23.568.75
Financials

DUK Income Statement

Annual
Dec-13Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22
AccruedPreferredStockDividends-3 M41 M107 M106 M106 M
AcquiredInProcessRnD-2 M
AcquisitionExpense-499 M
Basic EPS from continuing operations3.643.463.83.714.373.7310.133.439.627.91
Basic EPS total3.772.664.053.114.363.7610.123.449.886.34
Basic weighted shares outstanding706 M707 M694 M691 M700 M708 M729 M737 M769 M770 M
BasicDiscontinuousOperations0.13-0.80.25-0.6-0.010.03-0.010.010.26-1.57
Cost of sales3,417 M3,976 M4,024 M
Depreciation-325 M
Depreciation unreconciled-13 M-6 M-5 M-6 M3,527 M4,074 M4,548 M4,705 M4,762 M5,086 M
DepreciationAndAmortization3,527 M4,074 M4,548 M4,705 M4,762 M5,086 M
Diluted EPS total3.762.664.053.114.363.7610.123.449.886.34
Diluted normalized net income/share3.633.463.83.714.373.733.439.627.91
Diluted weighted shares outstanding706 M707 M694 M691 M700 M285 M729 M738 M769 M770 M
DilutedDiscontinuousOperations0.13-0.80.25-0.6-0.010.030.010.26-1.57
Dividends paid per share3.093.363.493.643.753.823.93.98
Earnings from equity interest222 M147 M69 M-15 M119 M83 M162 M-2,005 M62 M113 M
EarningsFromEquityInterestNetOfTax222 M147 M69 M-15 M119 M83 M162 M-2,005 M62 M113 M
ExciseTaxes-602 M-498 M-396 M-362 M-376 M-405 M-421 M-415 M-420 M-449 M
FuelAndPurchasePower-499 M
GainOnSaleOfPPE-16 M16 M30 M27 M28 M-89 M-4 M10 M12 M26 M
GainOnSaleOfSecurity-4 M3 M-6 M2 M
GainsLossOnDisposalOfDiscontinuedOperations86 M-576 M177 M-408 M-6 M19 M-7 M7 M-144 M-1,323 M
GeneralAndAdministrativeExpense75 M53 M160 M
Gross operating profit22,756 M23,925 M22,371 M22,743 M23,565 M24,521 M25,079 M23,868 M24,621 M28,768 M
ImpairmentOfCapitalAssets399 M81 M106 M18 M282 M402 M-8 M984 M353 M434 M
Income before tax14,111 M15,419 M14,318 M13,653 M1,866 M1,374 M1,714 M1,044 M1,387 M1,726 M
Income restructuring and M&A-297 M-246 M-380 M-523 M435 M427 M508 M542 M504 M501 M
Income taxes1,205 M1,669 M1,256 M1,156 M1,196 M448 M519 M-1,395 M-1,558 M-1,876 M
Interest income761 M
InterestExpenseNonOperating1,543 M1,622 M1,527 M1,916 M1,986 M2,094 M2,204 M2,162 M2,207 M2,439 M
MinorityInterests16 M65 M9 M11 M-5 M22 M-177 M295 M329 M95 M
MiscOtherSpecialCharges262 M351 M290 M324 M508 M399 M430 M453 M636 M392 M
Net income from total operations12,981 M13,168 M13,224 M12,071 M1,214 M1,071 M1,403 M956 M1,336 M2,550 M
NetIncomeCommonStockholders12,981 M13,168 M13,224 M12,071 M1,214 M2,666 M3,707 M1,270 M3,802 M2,444 M
NetIncomeContinuousOperations12,981 M13,168 M13,224 M12,071 M1,214 M1,071 M1,403 M956 M1,336 M2,550 M
NetIncomeDiscontinuousOperations86 M-576 M177 M-408 M-6 M19 M-7 M7 M-144 M-1,323 M
NetIncomeExtraordinary-11 M-6 M-15 M-18 M
NetNonOperatingInterestIncomeExpense-1,543 M-1,622 M-1,527 M-1,916 M-1,986 M-2,094 M-2,204 M-2,162 M-2,207 M-2,439 M
Operating income15,585 M16,608 M15,562 M15,251 M12,229 M12,704 M13,158 M12,038 M12,801 M16,482 M
Operating income before depreciation (EBITDA)26,745 M29,690 M28,744 M29,426 M18,516 M20,976 M23,194 M23,518 M24,233 M17,804 M
OperatingExpense7,171 M7,317 M6,809 M7,492 M11,336 M11,817 M11,921 M11,830 M11,820 M12,286 M
Other income net-468 M-514 M-389 M-336 M-655 M-393 M-588 M1,542 M-710 M-531 M
OtherCostofRevenue10,316 M11,285 M10,455 M9,970 M6,408 M6,826 M16,717 M17,828 M25,981 M
OtherGandA75 M53 M160 M
OtherOperatingExpenses5,897 M6,104 M5,680 M6,350 M6,576 M6,463 M6,066 M5,788 M5,703 M5,734 M
OtherTaxes1,274 M1,213 M1,129 M1,142 M1,233 M1,280 M1,307 M1,337 M1,355 M1,466 M
OtherunderPreferredStockDividend-3 M41 M107 M106 M106 M
PreferredStockDividends-3 M41 M107 M106 M106 M
RealizedCapitalGain3 M
RestructringAndMnAIncome-297 M-246 M-380 M-523 M435 M427 M508 M542 M504 M501 M
Revenue per share-13 M-6 M-5 M-6 M7 M
Special income/charges399 M81 M106 M18 M282 M402 M-8 M984 M353 M434 M
Total Income available for interest expense (EBIT)15,654 M17,041 M15,845 M15,569 M3,852 M3,468 M3,918 M3,206 M3,594 M4,165 M
Total common shares outstanding706 M708 M688 M700 M700 M727 M733 M769 M769 M770 M
Total net income12,981 M13,168 M13,224 M12,071 M1,214 M1,071 M1,403 M956 M1,336 M2,550 M
Total ordinary shares771 M771 M771 M771 M771 M771 M771 M771 M771 M771 M
Total revenues20,840 M22,123 M21,915 M22,084 M22,911 M23,757 M24,348 M23,480 M24,486 M28,675 M
TotalExpenses7,171 M7,317 M6,809 M7,492 M14,753 M15,793 M11,921 M11,830 M11,820 M12,286 M
TotalRevenue22,756 M23,925 M22,371 M22,743 M23,565 M24,521 M25,079 M23,868 M24,621 M28,768 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.

We respect your privacy and will never share your email.
MarketXLS is a complete Excel stock solution

Kevin Hsu

StockKevin.com

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.

Dave

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