Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS
DTE Energy Company logo

DTE Energy Company

Sector: Utilities   

Industry: Utilities - Regulated Electric

112.14
 
USD
  
0.84
  
(0.75%)
Optionable: Yes  Market Cap: 22,117 M  90-day average vol: 1,183,798

Previous close: 111.3  Open: 111.32  Bid: 110.18  Ask: 113.35
52 week range    
90.14   
   116.73
Peers   
XEL / 
CMS / 
MGEE / 
NU / 
WEC / 
LNT / 
NI / 
Last updated: Friday 29th March 2024
51
MarketXLS Rank
60
Value
53
Technical
42
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

CMS

0.028318 B21.464.92

LNT

0.028915 B23.859.1

MGEE

0.02063 B25.775.2

NI

0.032711 B25.828.79

NU

WEC

0.030730 B23.494.72

XEL

0.026637 B23.568.75
Financials

DTE Income Statement

Annual
Dec-13Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22
Amortization of intangibles-16 M
Basic EPS from continuing operations3.765.114.054.846.326.186.327.094.115.53
Basic EPS total3.765.114.054.846.326.186.327.094.685.53
Basic weighted shares outstanding175 M177 M179 M179 M179 M181 M185 M193 M193 M195 M
BasicDiscontinuousOperations1.630.57
Cost of sales-7,033 M-9,226 M-7,776 M-7,791 M-9,434 M-11,062 M-9,270 M-8,144 M
Depreciation-1,276 M1,377 M1,468 M
Depreciation unreconciled-1,094 M-1,145 M-852 M-976 M-1,030 M-1,124 M-1,263 M-1,292 M1,652 M1,781 M
DepreciationAndAmortization-1,094 M-1,145 M-852 M-976 M-1,030 M-1,124 M-1,263 M-1,292 M
Diluted EPS total3.765.14.054.836.326.176.317.084.675.52
Diluted normalized net income/share3.765.14.054.836.326.176.317.084.15.52
Diluted weighted shares outstanding175 M177 M179 M179 M179 M181 M185 M193 M194 M196 M
DilutedDiscontinuousOperations1.630.57
Dividends paid per share2.592.692.843.063.363.593.854.123.883.61
Earnings from equity interest126 M149 M68 M102 M132 M111 M26 M38 M-14 M
EarningsFromEquityInterestNetOfTax126 M149 M68 M102 M132 M111 M26 M38 M-14 M
FuelAndPurchasePower-4,055 M-5,879 M-5,562 M-5,530 M-7,164 M-8,611 M-6,851 M-5,839 M
GainOnSaleOfPPE-41 M-27 M-15 M-37 M
GainOnSaleOfSecurity14 M1000000.090 M103 M104 M167 M167 M
GainsLossOnDisposalOfDiscontinuedOperations117 M
Gross operating profit2,628 M3,075 M2,561 M2,839 M3,173 M3,150 M3,399 M3,279 M14,964 M19,228 M
ImpairmentOfCapitalAssets33 M-5 M
Income before tax922 M1,275 M950 M1,105 M1,287 M1,216 M1,324 M1,082 M656 M1,112 M
Income restructuring and M&A184 M
Income taxes254 M364 M230 M271 M175 M98 M152 M37 M-130 M29 M
Interest income9 M10 M13 M20 M12 M12 M17 M29 M22 M46 M
InterestExpenseNonOperating436 M429 M450 M472 M536 M559 M641 M601 M630 M675 M
InterestExpenseOperating39 M42 M
MinorityInterests-7 M-6 M7 M34 M22 M2 M-3 M-3 M4 M
MiscOtherSpecialCharges146 M104 M-270 M112 M100 M169 M241 M99 M-231 M-7 M
Net income from total operations661 M905 M727 M868 M1,134 M1,120 M1,169 M1,368 M907 M1,083 M
NetIncomeCommonStockholders661 M905 M727 M866 M1,132 M1,118 M1,167 M1,366 M12,008 M1,083 M
NetIncomeContinuousOperations661 M905 M727 M868 M1,134 M1,120 M1,169 M1,368 M907 M1,083 M
NetIncomeDiscontinuousOperations326 M117 M
NetNonOperatingInterestIncomeExpense-427 M-419 M-437 M-452 M-524 M-547 M-624 M-572 M-608 M-629 M
NetOperatingInterestIncomeExpense-39 M-42 M
Normalized income599 M850 M1,491 M718 M878 M988 M1,085 M886 M1,057 M
Operating income1,203 M1,578 M1,345 M1,514 M1,775 M1,649 M1,722 M1,617 M1,495 M16,266 M
Operating income before depreciation (EBITDA)2,485 M4,921 M3,552 M4,084 M4,395 M4,614 M5,159 M4,054 M2,702 M3,297 M
OperatingExpense1,425 M-1,497 M-1,216 M-1,325 M-1,398 M-1,501 M-1,677 M-1,662 M2,335 M2,962 M
Other income net-146 M-116 M-42 M-43 M-36 M-114 M-226 M-37 M231 M7 M
Other special charges21 M21 M24 M-6 M
OtherCostofRevenue4,055 M5,879 M1,574 M1,532 M2,484 M
OtherOperatingExpenses-9 M21 M-23 M-28 M24 M25 M1,904 M2,505 M
OtherTaxes340 M352 M364 M370 M391 M405 M414 M395 M431 M457 M
OtherWriteOff852 M
RestructringAndMnAIncome184 M
Revenue per share16 M16 M16 M
Special income/charges-9 M-12 M106 M7 M41 M27 M-9 M43 M33 M-5 M
Total Income available for interest expense (EBIT)1,391 M2,849 M1,434 M1,608 M1,859 M1,818 M2,004 M1,719 M1,325 M1,829 M
Total common shares outstanding177 M177 M318 M318 M318 M321 M331 M332 M332 M344 M
Total net income661 M905 M727 M868 M1,134 M1,120 M1,169 M1,368 M907 M1,083 M
Total ordinary shares206 M206 M206 M206 M206 M206 M206 M206 M206 M206 M
Total revenues9,661 M12,301 M10,337 M10,630 M12,607 M14,212 M12,669 M11,423 M14,964 M19,228 M
TotalExpenses4,403 M2,556 M2,578 M3,648 M2,572 M2,711 M4,610 M2,114 M2,335 M2,962 M
TotalRevenue9,661 M12,301 M10,337 M10,630 M12,607 M14,212 M12,669 M11,423 M14,964 M19,228 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