Final Project WS

Duke Energy Corporation (DUK)

* all results are stated in US

Dollars

Target Country (United States)

Peer Grouping

NAIC

Country

Company Name

ROA %

(Net)

latest

ROE %

(Net)

latest

Gross

Margin

%

latest

Net Profit

Margin %

latest

Quick

Ratio

latest

Current

Ratio

latest

Duke Energy 1% 2% 72.72% 5.32% 0.34 0.53

CenterPoint Energy -1.77% -9.87% 76.48% -12.79% NM 0.61

Public Sevice Enterprise Group 3.90% 12.20% 99.70% 19.80% 0.41 0.66

PG&E -1.33% -6.14% 78.89% -7.14% 0.17 0.71

Southern Company 2.60% 9.80% 32.10% 15.40% 0.22 0.71

PPL Corporation 3.05% 10.98% 83.36% 19.31% 1.37 0.0046

American Electric Power 2.72% 10.57% 70.71% 14.75% 0.31 0.44

Xcel Energy 2.73% 10.11% 63.23% 12.78% 0.65 0.77

Average 2% 5% 72% 8.43% 50% 55%

LT Debt to

Equity latest

Total Debt to

Equity latest

Interest

Coverage

latest

Total

Asset

Turnover

latest

Inventory

Turnover

latest

0.53 1.28 1.39 0.5 2.06

0.58 1.61 -0.73 0.22 3.49

0.68 0.0213 0.0484 0.05 0.018

0.64 0.0192 0.25 0.19 0.0621

0.74 0.028 0.0292 0.16 0.043

0.62 0.0185 0.0297 0.16 0.0351

0.58 0.0162 2.92 0.18 0.0334

0.57 0.0142 0.0284 0.21 0.0792

62% 38% 50% 21% 73%