Duke Energy
Financial ratios & Valuation

Historical Multiples (2014 – 2023)

2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 TTM Median
Valuation Ratios
Price/Earnings ratio
31.3617.5924.9219.2422.9117.7449.0020.6431.0926.3319.3417.74
Price/Sales ratio
2.462.112.352.492.492.652.883.272.752.572.772.49
Price/Book Value ratio
1.441.241.301.411.391.421.401.631.601.521.701.39
Price/Cash Flow ratio
8.967.427.888.878.508.097.619.7313.377.5726.758.50
Price/Free Cash Flow ratio
49.13-550.49-48.62-41.52-27.73-22.82-64.20-56.60-14.57-27.44-86.45-22.82
Price/Earnings Growth ratio
-1.060.33-1.070.47-1.690.51-0.740.11-0.953.98-9.710.51
Dividend Yield
3.78%4.54%4.34%4.16%4.04%4.01%4.16%3.86%4.00%4.33%3.82%4.01%
Profitability Indicator Ratios
Gross Profit Margin
40.13%41.48%42.94%45.80%42.94%46.09%48.58%48.56%45.10%47.33%48.80%42.94%
Operating Profit Margin
21.97%22.87%23.48%24.53%19.10%22.76%19.56%22.33%20.89%24.32%25.38%19.10%
Pretax Profit Margin
17.27%17.63%16.41%18.10%12.53%16.33%3.93%16.20%14.17%16.40%16.92%12.53%
Net Profit Margin
7.87%12.00%9.46%12.98%10.87%14.94%5.89%15.87%8.86%9.77%14.31%10.87%
Effective Tax Rate
40.37%32.05%30.95%28.03%14.57%12.66%-18.36%6.71%7.35%9.18%11.79%12.66%
Return on Assets
1.56%2.32%1.62%2.21%1.83%2.35%0.84%2.30%1.43%1.60%2.35%1.83%
Return On Equity
4.60%7.08%5.24%7.32%6.08%8.00%2.87%7.92%5.17%5.78%8.75%6.08%
Return on Capital Employed
4.80%4.88%4.40%4.60%3.59%3.96%3.12%3.57%3.77%4.42%4.61%3.59%
Liquidity Ratios
Current Ratio
N/AN/AN/AN/AN/A0.620.53N/AN/AN/A0.690.62
Quick Ratio
0.720.390.390.410.440.400.330.420.510.490.440.44
Cash ratio
0.180.070.030.020.020.020.010.020.020.010.020.02
Days of Sales Outstanding
42.1635.2142.4342.9646.6544.5349.2552.2156.0151.8826.1144.53
Days of Inventory outstanding
88.14101.3099.0792.8980.4587.2696.2292.2082.83102.36102.3880.45
Operating Cycle
130.31136.51141.51135.86127.10131.79145.47144.42138.85154.25128.49127.10
Days of Payables Outstanding
57.8762.4884.2286.9790.9694.1495.52101.77109.87100.8393.2990.96
Cash Conversion Cycle
72.4474.0257.2848.8836.1337.6549.9542.6428.9753.4135.1937.65
Debt Ratios
Debt Ratio
0.350.350.370.390.390.380.380.390.410.440.450.39
Debt Equity Ratio
1.031.061.221.301.301.301.301.341.501.601.711.30
Long-term Debt to Capitalization
0.470.480.520.540.530.540.530.540.570.590.600.53
Total Debt to Capitalization
0.500.510.550.560.560.560.560.570.600.610.630.56
Interest Coverage Ratio
N/AN/AN/AN/AN/A2.582.55N/AN/AN/A2.312.58
Cash Flow to Debt Ratio
0.150.150.130.120.120.130.140.120.070.120.030.13
Company Equity Multiplier
2.943.043.233.303.313.393.383.443.613.603.733.31
Cash Flow Ratios
Operating Cash Flow / Sales Ratio
0.270.280.290.280.290.320.370.330.200.330.100.32
Free Cash Flow / Operating Cash Flow Ratio
0.18-0.01-0.16-0.21-0.30-0.35-0.11-0.17-0.91-0.27-0.30-0.35
Cash Flow Coverage Ratio
0.150.150.130.120.120.130.140.120.070.120.030.13
Short Term Coverage Ratio
1.231.171.411.221.051.301.241.260.771.390.411.30
Dividend Payout Ratio
118.64%80.04%108.36%80.09%92.68%71.18%204.21%79.68%124.66%114.18%92.18%92.18%