ED Competition Analysis

Consolidated Edison, Inc. Peer Comparison

Metric	Value	Ranking
Market Cap	$36.2 Billion	7/10	NEE $175.6B	SO $100.3B	DUK $90.1B	AEP $54.2B	D $49.0B	EXC $41.0B	ED $36.2B	ETR $28.4B	FE $25.4B	PNW $10.2B
Gross Margin	64%	1/10	ED 64%	D 53%	NEE 37%	SO 36%	FE 34%	DUK 30%	ETR 30%	PNW 29%	AEP 27%	EXC 24%
Profit Margin	6%	8/10	NEE 27%	SO 19%	D 16%	PNW 16%	DUK 13%	EXC 8%	AEP 7%	ED 6%	FE 3%	ETR 2%
EBITDA margin	26%	9/10	NEE 52%	SO 50%	DUK 44%	D 42%	PNW 42%	ETR 40%	AEP 37%	EXC 34%	ED 26%	FE 13%
Quarterly Revenue	$3.2 Billion	8/10	DUK $7.2B	SO $6.5B	NEE $6.1B	EXC $5.4B	AEP $4.6B	D $3.5B	FE $3.3B	ED $3.2B	ETR $3.0B	PNW $1.3B
Quarterly Earnings	$202.0 Million	8/10	NEE $1.6B	SO $1.2B	DUK $900.0M	D $572.0M	EXC $448.0M	AEP $340.3M	PNW $203.8M	ED $202.0M	FE $98.0M	ETR $51.7M
Quarterly Free Cash Flow	$180.0 Million	3/10	NEE $1.8B	SO $419.0M	ED $180.0M	DUK -$43.0M	AEP -$130.7M	ETR -$165.9M	EXC -$237.0M	PNW -$344.2M	D -$2.1B	FE -$0
Trailing 4 Quarters Revenue	$13.9 Billion	7/10	DUK $30.0B	SO $26.1B	EXC $22.8B	AEP $19.6B	NEE $16.1B	D $14.1B	ED $13.9B	FE $13.2B	ETR $12.1B	PNW $4.9B
Trailing 4 Quarters Earnings	$1.5 Billion	8/10	DUK $7.2B	SO $6.5B	NEE $6.1B	EXC $5.4B	AEP $4.6B	D $3.5B	FE $3.3B	ED $3.2B	ETR $3.0B	PNW $1.3B
Quarterly Earnings Growth	-86%	9/10	DUK 509%	PNW 91%	SO 44%	EXC 31%	D -5%	AEP -35%	NEE -42%	FE -61%	ED -86%	ETR -87%
Annual Earnings Growth	-26%	8/10	PNW 452%	DUK 102%	AEP 53%	SO 35%	ETR 34%	EXC 3%	FE -18%	ED -26%	D -54%	NEE -61%
Quarterly Revenue Growth	-27%	10/10	PNW 17%	SO 12%	EXC 11%	DUK 9%	FE 9%	AEP 6%	ETR 4%	D -8%	NEE -17%	ED -27%
Annual Revenue Growth	-16%	8/10	PNW 24%	AEP 6%	DUK 6%	EXC 6%	SO 4%	FE 4%	ETR 2%	ED -16%	D -28%	NEE -41%
Cash On Hand	$1.5 Billion	2/10	NEE $2.1B	ED $1.5B	EXC $1.5B	ETR $1.4B	SO $1.2B	DUK $390.0M	AEP $247.9M	D $184.0M	FE $60.0M	PNW $4.0M
Short Term Debt	$2.8 Billion	6/10	NEE $14.1B	DUK $6.0B	D $5.0B	SO $4.3B	AEP $3.9B	ED $2.8B	EXC $2.8B	ETR $2.4B	FE $2.3B	PNW $1.6B
Long Term Debt	$23.3 Billion	8/10	DUK $76.4B	NEE $68.5B	SO $59.9B	EXC $43.0B	AEP $40.0B	D $36.4B	ETR $26.3B	ED $23.3B	FE $20.8B	PNW $8.1B
PE	24.40	4/10	NEE 49.31	D 29.78	FE 27.40	ED 24.40	SO 21.75	AEP 20.70	DUK 20.36	EXC 16.91	PNW 16.84	ETR 15.94
PS	2.60	6/10	NEE 10.88	SO 3.84	D 3.47	DUK 3.00	AEP 2.77	ED 2.60	ETR 2.35	PNW 2.09	FE 1.92	EXC 1.80
PB	1.68	8/10	NEE 2.95	SO 2.78	AEP 2.07	ETR 1.90	FE 1.85	D 1.81	DUK 1.77	ED 1.68	PNW 1.62	EXC 1.57
PC	24.01	9/10	PNW 2546.98	FE 422.82	D 266.09	DUK 231.03	AEP 218.54	SO 83.68	NEE 83.53	EXC 27.99	ED 24.01	ETR 20.94
Liabilities to Equity	2.15	10/10	SO 3.26	ETR 3.24	PNW 3.12	EXC 3.02	FE 2.99	AEP 2.81	D 2.71	DUK 2.63	NEE 2.55	ED 2.15
ROA	0.02	4/10	AEP 3%	SO 3%	ETR 3%	ED 2%	D 2%	DUK 2%	NEE 2%	EXC 2%	PNW 2%	FE 2%
ROE	0.07	7/10	SO 14%	ETR 12%	AEP 10%	PNW 10%	DUK 9%	EXC 9%	ED 7%	NEE 7%	FE 7%	D 6%
Current Ratio	1.47	1/10	ED 1.47	NEE 1.47	DUK 1.39	D 1.37	FE 1.37	AEP 1.36	SO 1.34	EXC 1.33	PNW 1.33	ETR 1.31
Quick Ratio	0.03	1/10	NEE 49.31	D 29.78	FE 27.40	ED 24.40	SO 21.75	AEP 20.70	DUK 20.36	EXC 16.91	PNW 16.84	ETR 15.94
Long Term Debt to Equity	1.08	10/10	SO} 1.85	ETR} 1.78	FE} 1.67	EXC} 1.65	DUK} 1.54	AEP} 1.53	NEE} 1.39	D} 1.35	PNW} 1.30	ED} 1.08
Debt to Equity	1.23	10/10	SO 2.02	ETR 1.94	FE 1.86	PNW 1.80	EXC 1.77	AEP 1.70	DUK 1.68	NEE 1.68	D 1.54	ED 1.23
Burn Rate	1.05	1/10	ED 1.05	ETR 0.84	EXC 0.75	SO 0.53	NEE 0.45	AEP 0.11	DUK 0.11	D 0.09	FE 0.05	PNW 0.01
Cash to Cap	0.04	2/10	ETR 0.05	ED 0.04	EXC 0.04	SO 0.01	NEE 0.01	D 0.00	AEP 0.00	DUK 0.00	PNW 0.00	FE 0.00
CCR	0.89	2/10	NEE 1.10	ED 0.89	SO 0.35	DUK -0.05	AEP -0.38	EXC -0.53	PNW -1.69	ETR -3.21	D -3.73	FE
EV to EBITDA	73.57	3/10	FE} 114.58	NEE} 81.13	ED} 73.57	D} 61.68	AEP} 57.87	DUK} 54.90	SO} 51.08	EXC} 47.53	ETR} 47.52	PNW} 38.54
EV to Revenue	4.41	7/10	NEE 15.86	D 6.40	SO 6.30	DUK 5.76	AEP 5.02	ETR 4.62	ED 4.41	PNW 4.38	EXC 3.77	FE 3.67

Consolidated Edison, Inc. Peer Comparison

Cookies