ED Competition Analysis

Consolidated Edison, Inc. Peer Comparison

Metric	Value	Ranking
Market Cap	$33.2 Billion	7/10	NEE $150.9B	SO $89.3B	DUK $83.0B	AEP $50.5B	D $43.8B	EXC $36.5B	ED $33.2B	ETR $23.8B	FE $23.3B	PNW $9.5B
Gross Margin	56%	4/10	SO 73%	AEP 69%	NEE 59%	ED 56%	D 56%	DUK 30%	FE 28%	EXC 25%	ETR 24%	PNW 19%
Profit Margin	17%	4/10	NEE 40%	AEP 20%	D 19%	ED 17%	SO 17%	DUK 15%	EXC 11%	FE 8%	ETR 3%	PNW 2%
EBITDA margin	40%	4/10	NEE 56%	D 46%	DUK 44%	ED 40%	PNW 37%	ETR 35%	EXC 33%	SO 27%	FE 25%	AEP 24%
Quarterly Revenue	$4.3 Billion	6/10	DUK $7.7B	SO $6.6B	EXC $6.0B	NEE $5.7B	AEP $5.0B	ED $4.3B	D $3.6B	FE $3.3B	ETR $2.8B	PNW $951.7M
Quarterly Earnings	$720.0 Million	5/10	NEE $2.3B	DUK $1.1B	SO $1.1B	AEP $1.0B	ED $720.0M	D $674.0M	EXC $658.0M	FE $253.0M	ETR $76.5M	PNW $16.9M
Quarterly Free Cash Flow	-$664.0 Million	5/10	NEE $609.0M	SO $248.0M	PNW -$170.4M	AEP -$353.2M	ED -$664.0M	DUK -$734.0M	ETR -$746.0M	EXC -$775.0M	FE -$830.0M	D -$948.0M
Trailing 4 Quarters Revenue	$15.1 Billion	6/10	DUK $29.5B	SO $25.4B	EXC $22.2B	AEP $19.3B	NEE $17.4B	ED $15.1B	D $14.4B	FE $12.9B	ETR $12.0B	PNW $4.7B
Trailing 4 Quarters Earnings	$2.7 Billion	5/10	DUK $7.7B	SO $6.6B	EXC $6.0B	NEE $5.7B	AEP $5.0B	ED $4.3B	D $3.6B	FE $3.3B	ETR $2.8B	PNW $951.7M
Quarterly Earnings Growth	279%	2/10	PNW 1571%	ED 279%	AEP 153%	DUK 42%	SO 31%	NEE 9%	EXC -2%	FE -13%	D -32%	ETR -75%
Annual Earnings Growth	33%	7/10	PNW 976%	SO 847%	ETR 250%	FE 225%	D 88%	AEP 80%	ED 33%	EXC 18%	DUK 1%	NEE -29%
Quarterly Revenue Growth	6%	3/10	EXC 9%	AEP 7%	ED 6%	DUK 5%	SO 3%	FE 2%	PNW 1%	ETR -6%	NEE -15%	D -32%
Annual Revenue Growth	-9%	8/10	PNW 18%	EXC 14%	DUK 4%	FE 1%	AEP 0%	ETR -7%	SO -8%	ED -9%	D -28%	NEE -31%
Cash On Hand	$169.0 Million	8/10	NEE $1.6B	ETR $1.3B	EXC $1.2B	FE $915.0M	DUK $492.0M	D $295.0M	AEP $230.7M	ED $169.0M	PNW $9.6M	SO -$0
Short Term Debt	$2.7 Billion	8/10	NEE $14.1B	DUK $6.4B	D $6.4B	AEP $5.0B	ETR $4.1B	FE $2.9B	EXC $2.7B	ED $2.7B	SO $2.6B	PNW $1.7B
Long Term Debt	$22.4 Billion	8/10	DUK $75.0B	NEE $65.9B	SO $60.7B	EXC $42.3B	AEP $39.1B	D $34.9B	ETR $24.3B	ED $22.4B	FE $21.7B	PNW $7.5B
PE	12.23	9/10	NEE 31.87	D 26.23	DUK 25.12	FE 21.52	SO 21.04	PNW 18.66	AEP 18.06	EXC 15.74	ED 12.23	ETR 11.22
PS	2.20	6/10	NEE 8.68	SO 3.51	D 3.04	DUK 2.82	AEP 2.62	ED 2.20	PNW 2.02	ETR 1.99	FE 1.80	EXC 1.64
PB	1.53	7/10	NEE 2.54	AEP 1.95	FE 1.71	DUK 1.64	ETR 1.61	D 1.60	ED 1.53	PNW 1.50	EXC 1.40	SO 0.00
PC	196.29	3/10	PNW 985.30	AEP 218.98	ED 196.29	DUK 168.72	D 148.60	NEE 91.89	EXC 30.17	FE 25.44	ETR 18.37	SO -1.00
Liabilities to Equity	2.08	10/10	ETR 3.19	FE 3.04	PNW 2.99	EXC 2.96	SO 2.93	AEP 2.79	D 2.72	DUK 2.58	NEE 2.48	ED 2.08
ROA	0.04	2/10	SO 38%	ED 4%	AEP 3%	NEE 3%	ETR 3%	D 2%	DUK 2%	EXC 2%	PNW 2%	FE 2%
ROE	0.13	2/10	ETR 14%	ED 13%	SO 12%	AEP 11%	NEE 10%	EXC 9%	FE 9%	PNW 8%	DUK 7%	D 6%
Current Ratio	1.48	2/10	NEE 1.49	ED 1.48	DUK 1.40	D 1.37	AEP 1.36	FE 1.36	EXC 1.34	PNW 1.34	ETR 1.32	SO 0.11
Quick Ratio	0.00	6/10	NEE 31.87	D 26.23	DUK 25.12	FE 21.52	SO 21.04	PNW 18.66	AEP 18.06	EXC 15.74	ED 12.23	ETR 11.22
Long Term Debt to Equity	1.03	10/10	FE} 1.75	SO} 1.70	ETR} 1.66	EXC} 1.62	AEP} 1.52	DUK} 1.51	NEE} 1.35	D} 1.27	PNW} 1.22	ED} 1.03
Debt to Equity	1.16	10/10	FE 1.98	ETR 1.93	SO 1.78	EXC 1.74	AEP 1.71	PNW 1.69	DUK 1.66	NEE 1.64	D 1.51	ED 1.16
Burn Rate	0.20	5/10	EXC 0.71	FE 0.69	ETR 0.67	NEE 0.42	ED 0.20	DUK 0.14	D 0.13	AEP 0.13	PNW 0.01	SO 0.00
Cash to Cap	0.01	4/10	ETR 0.05	FE 0.04	EXC 0.03	ED 0.01	D 0.01	DUK 0.01	NEE 0.01	AEP 0.00	SO 0.00	PNW 0.00
CCR	-0.92	5/10	NEE 0.27	SO 0.22	AEP -0.35	DUK -0.64	ED -0.92	EXC -1.18	D -1.41	FE -3.28	ETR -9.75	PNW -10.11
EV to EBITDA	33.48	10/10	SO} 86.00	AEP} 79.34	NEE} 71.22	PNW} 57.25	FE} 56.55	ETR} 52.46	D} 52.23	DUK} 49.37	EXC} 40.48	ED} 33.48
EV to Revenue	3.85	8/10	NEE 13.19	SO 6.00	D 5.90	DUK 5.60	AEP 4.89	ETR 4.26	PNW 4.25	ED 3.85	EXC 3.63	FE 3.63

Consolidated Edison, Inc. Peer Comparison

Cookies