* Note: Prices are in Million (M) USD.
Description:
Consolidated Edison, Inc., commonly known as Con Edison (stylized as conEdison) or ConEd, is one of the largest investor-owned energy companies in the United States, with approximately $12 billion in annual revenues as of 2017, and over $48 billion in assets. The company provides a wide range of energy-related products and services to its customers through its subsidiaries.
These criteria used Company's Cash, EBITDA and Debt balance to determines its fair value:
Cash : $1,506 M
Debt : $27,091 M
EBITDA : $5,838 M
Net Debt (Debt - Cash): $25,585 M
Since EBITDA cannot cover net debt within 3 years, Avoid This Stock.
This criteria used industry in which company operates:
Sector: Utilities
Industry: Utilities - regulated electric
Based on industry, 3 points assigned.
This criteria used Company's Price To Earning (P/E) Ratio to determines its fair value:
Forward PE Ratio: 16.46
Since Forward PE Ratio is between 15 - 20, 3 points assigned.
This criteria used Company's ability to convert Sales into free cash flow to determine fair value:
Using last 20 overlapping fiscal years (max 20).Average Free Cash Flow: $-428 M
Average Revenue: $13,005 M
Revenue Converted To Free Cash Flow (%): -3.3%
Since Free Cash Flow (FCF) to Revenue percentage is non-positive, 0 point assigned.
This criteria used company's growth potential to calculate its fair value:
Latest Revenue (2024-12-31): $15,256 M
Revenue 5 Years Ago (2019-12-31): $12,549 M
Total Growth over 5 Years: 21.6%
5-Year Revenue CAGR (Historical): 4.0%
Forward 5-Year CAGR (Tapered): 3.6%
Since historical Revenue CAGR is between 0 - 5, 1 point assigned.
This criteria used Company's ability to buy back its own share:
Latest Share Count (2024-12-31): $347 M
Share Count 5 Years Ago (2020-12-31): $336 M
Company is not buying back its own shares, 0 points assigned.
This criteria used Company's dividend payout ratio to determine its fair value:
Next Year Earnings Per Share (EPS): $6.01
Trailing 12-Month Earnings Per Share (EPS): $5.60
Average Earnings Per Share (EPS): $5.81
Dividend Per Share (DPS): $3
Payout Ratio: 58%
Dividend Yield: 3%
Since company Payout Ratio is greater than 50, 1 point assigned.
Since Dividend Yield is greater than 3, 3 points assigned.
This criteria used Company's Return On Equity (ROE%) to determine its fair value:
Using last 20 valid ROE years (max 20).Average ROE: 8.9%
Since Average ROE is less than 10, 1 point assigned.
This criteria used Company's current price to its 52 week low price to determines its fair value:
Current Price: $96
52-Week Low: $85
Threshold Price (15% Above 52-Week Low): $98
Since Current price is within 15% threshold, 5 points assigned.
This criteria used Company's Market Cap to determines its fair value:
Market Capitalization: $34,976 M
Since Market Cap is between 10B - 100B, 2 points assigned.
% Exposure to Total Portfolio
Based on the market cap, we recommend do not exceed 3% exposure of Total Portfolio.
Warren Buffet's Owners' Earnings:
Latest Positive Owners' Earnings (FCF/Share) (2015-12-31): $0.64
Note: Many highly growing companies reinvest heavily back into the business,
so their Owners' Earnings may appear very low. In such cases, other criteria should
be considered to assess the company’s true worth.
Value-Trade has assigned 19 points to above Consolidated Edison Inc (ED) stock.
Last 20 Years Avg PE
16.85, Fair Value PE
12, Industry Based PE
15, Growth Based PE
15, ROE Based PE
8.91, Risk-Free Anchored PE (25% MoS)
17.61. Based on these 6 values, average assigned is
14.23. Value-Trades has assined P/E value
14.23. An average (Current Year EPS + Next Year EPS) earning per share is
$5.805.
Fair value using multiple P/Es (blended): $82.59 (PE 14.23 × EPS $5.81)
So the Final Fair Value is: $82.59
Understanding the Value-Trades P/E Blend (click to expand)
▾
What goes into the blended P/E?
- 20-Year Avg P/E — Long-run market baseline; conservative anchor.
- Fair Value P/E — Score-based (cash, debt, sector, etc.).
- Industry P/E — Peer group norm.
- Growth-Based P/E — Uses tapered growth rates, floored at 15.
- RCFC-Based P/E — Maps cash conversion efficiency.
- ROE-Based P/E — Higher ROE supports higher multiples.
- Risk-Free Anchored P/E — Macro floor tied to 10y yield w/ MoS.
How it works
- Extreme values are clamped/filtered (IQR method).
- Anchors (20y avg, RCFC/ROE, risk-free) are always kept if valid.
- Final fair value = min(Blended PE × EPS, Avg PE × EPS).
P/E Reference Summary
Using EPS: $5.81
Using Owners' Earnings (Latest FCF/Share): $0.64
Note: Many highly growing companies reinvest heavily back into the business,
so their Owners' Earnings may appear very low. In such cases, other criteria should
be considered to assess the company’s true worth.
| Source |
P/E Ratio |
Implied Fair Value |
| Market (1 Yr Ago) | 16.52 | $95.90 |
| 20 Yrs Avg-PE | 16.85 | $97.81 |
| Value-Trades Assigned | 14.23 | $82.61 |
| Owners' Earnings × 20 Yrs Avg-PE | 16.85 | $10.78 |
