DTE Energy Company JR SUB DB 2017 E
Financial ratios & Valuation

Historical Multiples (2014 – 2023)

2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 TTM Median
Valuation Ratios
Price/Earnings ratio
4.916.185.184.063.604.193.845.513.823.612.924.19
Price/Sales ratio
0.360.430.410.360.280.380.450.330.210.392.000.28
Price/Book Value ratio
0.530.510.490.480.390.410.420.570.390.450.380.41
Price/Cash Flow ratio
2.402.312.142.161.491.831.411.612.071.561.311.83
Price/Free Cash Flow ratio
-21.78-52.7989.75-37.40-167.80-14.47-38.6-7.25-2.98-7.0510.83-167.80
Price/Earnings Growth ratio
0.13-0.300.260.13-1.621.990.31-0.160.210.16-1.55-1.62
Dividend Yield
10.57%11.16%11.83%12.86%15.39%14.14%14.47%15.86%16.56%14.91%6.07%14.14%
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.65%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.93%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.11%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.61%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.78%4.85%4.35%
Liquidity Ratios
Current Ratio
N/AN/AN/AN/AN/AN/AN/AN/AN/AN/A0.82N/A
Quick Ratio
0.850.700.810.810.550.581.030.380.620.420.620.55
Cash ratio
0.010.020.040.030.010.020.170.000.000.000.150.01
Days of Sales Outstanding
44.6245.1251.7351.0245.9847.5348.8341.0838.6951.1747.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.0196.87101.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.4137.8651.8630.35
Debt Ratios
Debt Ratio
0.320.330.360.380.390.410.420.450.440.460.360.41
Debt Equity Ratio
1.081.101.301.351.391.491.562.081.841.881.551.39
Long-term Debt to Capitalization
0.500.490.550.560.540.570.600.620.610.610.540.57
Total Debt to Capitalization
0.510.520.560.570.580.590.610.670.640.650.600.58
Interest Coverage Ratio
N/AN/AN/AN/AN/AN/AN/AN/AN/AN/A2.29N/A
Cash Flow to Debt Ratio
0.200.190.170.160.180.150.190.160.100.150.180.18
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.160.100.150.180.18
Short Term Coverage Ratio
2.741.994.082.911.271.717.110.840.870.930.771.71
Dividend Payout Ratio
51.99%69.10%61.31%52.29%55.45%59.29%55.63%87.40%63.42%53.94%52.06%59.29%