Duke Energy reported a gross margin of 75.39% and a net margin of 8.76% for the quarter ended Sep 2012. These financial ratios cover 15 quarters of results from Mar 2009 through Sep 2012, standardized by Business Quant from the company’s SEC filings.
| Ratios | Mar2009 | Jun2009 | Sep2009 | Dec2009 | Mar2010 | Jun2010 | Sep2010 | Dec2010 | Mar2011 | Jun2011 | Sep2011 | Dec2011 | Mar2012 | Jun2012 | Sep2012 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Profitability | |||||||||||||||
| Gross Margin | 75.51% | 70.89% | 76.30% | 72.51% | 74.99% | 71.28% | 77.67% | 68.04% | 75.98% | 72.86% | 78.15% | 68.38% | 79.45% | 75.90% | 75.39% |
| EBT Margin | 15.85% | 15.83% | 10.34% | 15.88% | 18.67% | -3.10% | 24.51% | 19.56% | 20.37% | 17.91% | 17.08% | 12.14% | 11.02% | 18.54% | 12.53% |
| EBIT Margin | 20.56% | 15.83% | 10.34% | 29.32% | 21.17% | -0.43% | 26.18% | 19.77% | 22.22% | 19.21% | 19.35% | 15.35% | 13.64% | 21.97% | 16.04% |
| EBITDA Margin | 20.56% | 15.83% | 10.34% | 29.32% | 21.17% | -0.43% | 26.18% | 19.77% | 22.22% | 19.21% | 19.35% | 15.35% | 13.64% | 21.97% | 16.04% |
| Operating Margin | 20.56% | 15.83% | 10.34% | 29.32% | 21.17% | -0.43% | 26.18% | 19.77% | 22.22% | 19.21% | 19.35% | 15.35% | 13.64% | 21.97% | 16.04% |
| Net Margin | 10.54% | 9.68% | 3.12% | 11.19% | 12.35% | -6.78% | 16.95% | 12.31% | 13.92% | 12.28% | 11.88% | 8.52% | 8.04% | 12.41% | 8.76% |
| FCF Margin | -15.37% | 44.11% | 42.70% | -98.36% | -1.61% | -4.35% | 9.66% | -13.70% | -1.23% | -4.98% | 6.51% | -21.62% | -3.20% | -3.75% | 5.71% |
| Efficiency | |||||||||||||||
| Inventory AverageInventory Avg. | 1.39B | 1.47B | 1.43B | 1.32B | 1.27B | 1.27B | 1.33B | 1.38B | 1.42B | 1.50B | 1.67B | 1.76B | 2.40B | ||
| Assets AverageAssets Avg. | 55.24B | 56.41B | 57.34B | 57.02B | 57.13B | 58.47B | 59.04B | 59.39B | 60.28B | 61.65B | 62.16B | 62.41B | 87.52B | ||
| Invested CapitalInvested Cap. | 37.09B | 38.17B | 38.52B | 38.88B | 38.24B | 39.64B | 40.10B | 40.41B | 40.75B | 41.53B | 42.76B | 42.21B | 42.72B | 79.28B | |
| Asset Utilization RatioAsset Util. | 0.23 | 0.23 | 0.23 | 0.23 | 0.24 | 0.24 | 0.24 | 0.25 | 0.24 | 0.24 | 0.23 | 0.23 | 0.20 | ||
| Leverage & Solvency | |||||||||||||||
| Interest Coverage RatioInterest Cover | 3.70 | 2.48 | 1.85 | 4.77 | 3.62 | -0.07 | 5.11 | 3.15 | 3.72 | 3.34 | 3.60 | 2.31 | 2.21 | 3.39 | 2.69 |
| Debt Ratio | 0.29 | 0.29 | 0.29 | 0.29 | 0.30 | 0.30 | 0.30 | 0.30 | 0.30 | 0.31 | 0.32 | 0.31 | 0.32 | 0.34 | |
| Times Interest Earned | 3.70 | 2.48 | 1.85 | 4.77 | 3.62 | -0.07 | 5.11 | 3.15 | 3.72 | 3.34 | 3.60 | 2.31 | 2.21 | 3.39 | 2.69 |
| Dividends & Payouts | |||||||||||||||
| Dividend Coverage RatioDiv. Cover | 1.18 | 0.94 | 0.34 | 1.11 | 1.41 | -0.70 | 2.08 | 1.30 | 1.54 | 1.33 | 1.40 | 0.86 | 0.87 | 1.33 | 1.09 |
| FCF Payout RatioFCF Cover | -0.58 | 0.23 | 0.22 | -0.10 | -5.45 | -2.23 | 0.85 | -0.69 | -7.36 | -1.85 | 1.31 | -0.46 | -2.89 | -2.50 | 1.41 |
| Payout Ratio | 0.85 | 1.06 | 2.94 | 0.90 | 0.71 | -1.43 | 0.48 | 0.77 | 0.65 | 0.75 | 0.72 | 1.17 | 1.15 | 0.75 | 0.92 |
| Return Ratios | |||||||||||||||
| Return on Sales [ROS]ROS | 20.56% | 15.83% | 10.34% | 29.32% | 21.17% | -0.43% | 26.18% | 19.77% | 22.22% | 19.21% | 19.35% | 15.35% | 13.64% | 21.97% | 16.04% |
| Return on Capital Employed [ROCE]ROCE | 2.66% | 4.60% | 4.65% | 3.78% | 5.04% | 4.51% | 4.58% | 5.83% | 5.33% | 4.95% | 4.25% | 4.56% | 3.64% | ||
| Return on Invested Capital [ROIC]ROIC | 2.15% | 3.68% | 3.81% | 2.47% | 4.19% | 3.69% | 3.79% | 5.36% | 4.84% | 4.58% | 4.09% | 4.23% | 3.32% | ||
| Return on Assets [ROA]ROA | 1.81% | 1.92% | 2.06% | 1.20% | 2.17% | 2.26% | 2.36% | 3.45% | 3.07% | 2.78% | 2.41% | 2.41% | 1.87% |