DTE Energy Company 2020 Series
Financial ratios & Valuation

Historical Multiples (2014 – 2023)

2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 TTM Median
Valuation Ratios
Price/Earnings ratio
5.016.325.294.044.144.053.835.593.442.902.484.05
Price/Sales ratio
0.360.440.420.360.320.370.450.330.190.311.970.32
Price/Book Value ratio
0.540.520.500.480.450.400.420.580.350.360.320.40
Price/Cash Flow ratio
2.452.362.182.151.721.781.401.641.861.261.111.78
Price/Free Cash Flow ratio
-22.24-53.9191.64-37.25-193.06-14.01-38.51-7.37-2.68-5.6810.66-193.06
Price/Earnings Growth ratio
0.14-0.300.270.13-1.871.920.31-0.160.190.13-1.32-1.87
Dividend Yield
10.35%10.93%11.58%12.91%13.38%14.61%14.50%15.61%18.41%18.53%4.47%14.61%
Profitability Indicator Ratios
Gross Profit Margin
24.99%16.97%17.98%16.02%14.83%16.50%17.95%14.23%11.99%33.95%23.45%14.83%
Operating Profit Margin
12.82%13.44%14.53%12.91%11.98%13.22%14.53%11.36%9.61%17.59%17.01%11.98%
Pretax Profit Margin
10.36%9.20%10.29%10.23%8.56%10.50%9.38%4.35%5.78%12.28%12.45%8.56%
Net Profit Margin
7.34%7.02%8.06%9.00%7.87%9.25%11.85%6.00%5.61%10.96%12.43%7.87%
Effective Tax Rate
28.54%24.21%24.52%13.59%8.05%11.48%3.41%-19.81%2.60%10.79%-0.06%11.48%
Return on Assets
3.24%2.52%2.70%3.35%3.08%2.76%3.00%2.27%2.53%3.12%3.06%3.06%
Return On Equity
10.85%8.26%9.61%11.90%10.92%9.99%10.99%10.39%10.38%12.64%13.59%10.92%
Return on Capital Employed
6.23%5.31%5.27%5.24%5.34%4.35%3.91%5.12%4.92%5.77%4.73%4.35%
Liquidity Ratios
Current Ratio
N/AN/AN/AN/AN/AN/AN/AN/AN/AN/A0.99N/A
Quick Ratio
0.850.700.810.810.550.581.030.380.620.420.740.55
Cash ratio
0.010.020.040.030.010.020.170.000.000.000.180.01
Days of Sales Outstanding
44.6245.1251.7351.0245.9847.5348.8341.0838.6946.7347.9445.98
Days of Inventory outstanding
31.8034.2031.9926.9224.4826.3127.3224.2420.3245.7054.0124.48
Operating Cycle
76.4379.3283.7377.9470.4673.8476.1665.3359.0192.43101.9570.46
Days of Payables Outstanding
38.4934.4544.7240.4740.1137.3038.5939.9534.6059.0150.0940.11
Cash Conversion Cycle
37.9444.8639.0137.4730.3536.5437.5625.3724.4133.4251.8630.35
Debt Ratios
Debt Ratio
0.320.330.360.380.390.410.420.450.440.460.400.39
Debt Equity Ratio
1.081.101.301.351.391.491.562.081.841.881.731.39
Long-term Debt to Capitalization
0.500.490.550.560.540.570.600.620.610.610.570.54
Total Debt to Capitalization
0.510.520.560.570.580.590.610.670.640.650.630.58
Interest Coverage Ratio
N/AN/AN/AN/AN/AN/AN/AN/AN/AN/A2.44N/A
Cash Flow to Debt Ratio
0.200.190.170.160.180.150.190.170.100.150.160.15
Company Equity Multiplier
3.353.263.553.543.543.623.664.564.104.054.293.54
Cash Flow Ratios
Operating Cash Flow / Sales Ratio
0.140.180.190.160.180.210.320.200.100.250.270.18
Free Cash Flow / Operating Cash Flow Ratio
-0.11-0.040.02-0.05-0.00-0.12-0.03-0.22-0.69-0.220.67-0.00
Cash Flow Coverage Ratio
0.200.190.170.160.180.150.190.170.100.150.160.15
Short Term Coverage Ratio
2.772.004.122.931.271.767.440.850.870.940.811.76
Dividend Payout Ratio
51.99%69.10%61.31%52.29%55.45%59.29%55.63%87.40%63.42%53.82%52.06%59.29%