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

110.12
 
USD
  
0.00
  
(0.00%)
Optionable: Yes  Market Cap: 21,306 M  90-day average vol: 1,257,809

Previous close: 110.12  Open: 109.74  Bid: 108.44  Ask: 110.43
52 week range    
90.14   
   116.73
Peers   
XEL / 
CMS / 
MGEE / 
NU / 
WEC / 
LNT / 
NI / 
Last updated: Wednesday 24th April 2024
57
MarketXLS Rank
70
Value
61
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

Financials

DTE Cash Flow

Annual
Dec-13Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22
(Increase) Decrease in inventories123 M-274 M-43 M89 M58 M-2 M25 M33 M-153 M-98 M
(Increase) Decrease in other current assets-24 M-30 M
(Increase) Decrease in other current liabilities48 M-18 M177 M95 M
(Increase) Decrease in other working capital1,376 M-2,367 M378 M133 M179 M669 M-97 M353 M896 M-378 M
(Increase) Decrease in payables14 M139 M-250 M263 M125 M254 M-402 M20 M308 M109 M
(Increase) Decrease in receivables-154 M273 M341 M-354 M-412 M22 M89 M69 M-146 M-352 M
Acquisitions-42 M-959 M-1,386 M-299 M-637 M-2,619 M-163 M-8 M-13 M
CapitalExpenditureReported1,876 M3,610 M4,836 M5,051 M5,398 M6,691 M7,439 M6,539 M3,772 M3,378 M
Cash at beginning of period65 M52 M48 M37 M113 M89 M76 M93 M516 M35 M
Cash at end of period52 M1,069 M854 M1,027 M1,365 M1,258 M1,379 M3,180 M516 M43 M
Cash flow2,154 M4,449 M5,047 M6,333 M6,557 M7,296 M7,365 M8,262 M5,351 M4,528 M
CashFlowFromContinuingInvestingActivities-1,906 M-3,641 M-5,462 M-6,334 M-5,646 M-7,325 M-10,186 M-6,752 M-3,863 M-3,431 M
ChangeInAccountPayable14 M139 M-250 M263 M125 M254 M-402 M20 M308 M109 M
ChangeInPayablesAndAccruedExpense14 M139 M-250 M263 M125 M254 M-402 M20 M308 M109 M
ChangeInWorkingCapital1,383 M-2,247 M603 M131 M-50 M943 M-385 M475 M905 M-719 M
ChangesInAccountReceivables-154 M81 M325 M-354 M-412 M22 M89 M69 M-146 M-352 M
CommonStockDividendPaid-445 M-840 M-1,291 M-1,371 M-1,456 M-1,542 M-1,680 M-1,299 M-791 M-685 M
CommonStockPayments-52 M-33 M-51 M-66 M-55 M
Current deferred income taxes164 M653 M877 M949 M886 M492 M523 M496 M-32 M44 M
Deferred income taxes164 M653 M877 M949 M886 M492 M523 M496 M-32 M44 M
Depreciation1,094 M2,072 M2,118 M2,476 M2,536 M2,796 M3,155 M2,335 M1,377 M1,468 M
Depreciation unreconciled1,094 M2,072 M2,118 M2,476 M2,536 M2,796 M3,155 M2,335 M1,377 M1,468 M
DepreciationAndAmortization1,094 M2,072 M2,118 M2,476 M2,536 M2,796 M3,155 M2,335 M1,377 M1,468 M
EarningsLossesFromEquityInvestments7 M-6 M-4 M-28 M-58 M49 M142 M79 M4 M
FinancingCashFlow-261 M209 M1,221 M991 M341 M1,198 M4,124 M1,577 M315 M1,462 M
Free cash flow2,154 M4,449 M5,047 M6,333 M6,557 M7,296 M7,365 M8,262 M3,067 M1,977 M
GainLossOnSaleOfPPE-8 M-4 M
IncomeTaxPaidSupplementalData121 M-31 M-92 M11 M-28 M-26 M110 M-346 M-3 M-3 M
InterestPaidSupplementalData418 M655 M916 M952 M999 M1,138 M1,185 M994 M671 M638 M
Issuance of capital stock39 M9 M1,023 M2 M1,300 M
Issuance of debt-109 M267 M101 M122 M-12 M219 M-790 M720 M404 M
IssuanceOfCapitalStock39 M9 M1,023 M2 M1,300 M
IssuanceOfDebt164 M871 M1,491 M2,572 M1,405 M2,353 M4,455 M3,071 M1,655 M988 M
Net cash from financing activities-261 M209 M1,221 M991 M341 M1,198 M4,124 M1,577 M315 M1,462 M
Net cash from investing activities-1,906 M-3,641 M-5,462 M-6,334 M-5,646 M-7,325 M-10,186 M-6,752 M-3,863 M-3,431 M
Net cash from operating activities2,154 M4,449 M5,047 M6,333 M6,557 M7,296 M7,365 M8,262 M3,067 M1,977 M
Net change in cash & cash equivalents-13 M1,017 M806 M990 M1,252 M1,169 M1,303 M3,087 M-481 M8 M
Net income from continuing operations706 M3,214 M1,950 M3,011 M3,475 M3,337 M4,120 M4,845 M3,163 M3,792 M
NetBusinessPurchaseAndSale-42 M-959 M-1,386 M-299 M-637 M-2,619 M-163 M-8 M-13 M
NetCommonStockIssuance39 M-52 M9 M-33 M-51 M1,023 M2 M-66 M1,245 M
NetInvestmentPropertiesPurchaseAndSale-66 M-34 M317 M103 M51 M3 M-128 M-63 M-86 M-64 M
NetInvestmentPurchaseAndSale-66 M-34 M317 M103 M51 M3 M-128 M-63 M-86 M-64 M
NetIssuancePaymentsOfDebt164 M871 M1,491 M2,572 M1,405 M2,353 M4,455 M3,071 M1,655 M988 M
NetLongTermDebtIssuance273 M604 M1,390 M2,572 M1,283 M2,365 M4,236 M3,861 M935 M584 M
Operating (gains) losses-1,178 M799 M-440 M-177 M-231 M-206 M20 M159 M-35 M-28 M
Other financing charges net-19 M154 M593 M338 M93 M595 M224 M153 M-85 M-86 M
Other investing changes net-50 M-14 M356 M121 M9 M-42 M-12 M22 M-13 M-35 M
Other non-cash items-15 M-42 M-61 M-57 M-59 M-66 M-68 M-48 M-27 M-29 M
Payment of cash dividends445 M840 M1,291 M1,371 M1,456 M1,542 M1,680 M1,299 M791 M685 M
PensionAndEmployeeBenefitExpense-1,170 M792 M-434 M-173 M-203 M-148 M-29 M11 M-507 M-32 M
ProceedsFromStockOptionExercised76 M428 M-515 M350 M-208 M102 M-350 M-37 M
Purchase of Float term investments-98 M-85 M-74 M-30 M
Purchase of short term investments1,234 M2,678 M1,946 M3,399 M2,268 M2,470 M5,057 M5,375 M4,457 M2,171 M
PurchaseOfInvestment-1,134 M-2,312 M-2,694 M-4,389 M-3,678 M-3,564 M-2,480 M-4,785 M-1,120 M-908 M
PurchaseOfLongTermInvestments-1,134 M-2,312 M-2,694 M-4,389 M-3,678 M-3,564 M-2,382 M-4,700 M-1,046 M-878 M
PurchaseOfPPE-1,876 M-3,610 M-4,836 M-5,051 M-5,398 M-6,691 M-7,439 M-6,539 M-3,772 M-3,378 M
Repayment of debt-961 M-2,074 M-556 M-827 M-985 M-105 M-821 M-1,514 M-3,522 M-1,587 M
RepaymentOfDebt-1,070 M-1,807 M-455 M-827 M-985 M-117 M-821 M-2,304 M-3,522 M-1,587 M
Repurchase of capital stock-52 M-33 M-51 M-66 M-55 M
Sale of Float term investments1,118 M2,292 M2,655 M4,371 M3,720 M3,609 M2,364 M4,700 M1,047 M879 M
SaleOfInvestment1,118 M2,292 M2,655 M4,371 M3,720 M3,609 M2,364 M4,700 M1,047 M879 M
SaleOfPPE36 M45 M16 M12 M13 M3 M24 M
ShortTermDebtIssuance122 M219 M720 M404 M
ShortTermDebtPayments-109 M267 M101 M122 M-12 M-790 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

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