DTE Energy Company (DTE)

Number of days of payables

		Dec 31, 2023	Sep 30, 2023	Jun 30, 2023	Mar 31, 2023	Dec 31, 2022	Sep 30, 2022	Jun 30, 2022	Mar 31, 2022	Dec 31, 2021	Sep 30, 2021	Jun 30, 2021	Mar 31, 2021	Dec 31, 2020	Sep 30, 2020	Jun 30, 2020	Mar 31, 2020	Dec 31, 2019	Sep 30, 2019	Jun 30, 2019	Mar 31, 2019
Payables turnover		0.77	0.87	0.93	0.90	0.62	0.58	0.55	0.76	0.72	0.79	0.90	1.05	1.01	0.90	0.86	0.87	0.80	0.85	0.83	0.89
Number of days of payables	days	476.28	418.46	391.04	407.43	593.17	633.37	659.34	483.25	509.49	460.04	406.98	348.23	362.10	404.44	425.63	420.18	458.27	428.95	440.94	410.62

December 31, 2023 calculation

Number of days of payables = 365 ÷ Payables turnover
= 365 ÷ 0.77
= 476.28

The number of days of payables for DTE Energy Co. has shown some fluctuations over the past eight quarters. In Q4 2023, the number of days of payables stood at 79.38 days, indicating that the company takes approximately 79 days to settle its payables on average. This represents an improvement from the previous quarter where the data is not provided.

In comparison to Q1 2023, where the number of days of payables was significantly higher at 195.95 days, the company appears to have managed to more efficiently settle its payables by Q4 2023.

Looking back further, there was a notable decrease in the number of days of payables in Q3 2022 at 57.06 days, followed by some increase in subsequent quarters. Overall, the trend in the number of days of payables indicates some variability in the company's efficiency in managing its accounts payable over the past two years. Further analysis and comparison with industry averages may provide more insights into the company's payables management performance.