Consolidated Edison, Inc. (ED)
Quantitative Summary
DeterministicED trades at 17.8x earnings, roughly in line with its sector average of 24.4x. Financial health is average: Piotroski 6/9, Altman Z 1.2.
Generated deterministically from quant metrics and financial statements. Not a recommendation.
Algorithmic Teardown
AI-GeneratedThe fundamental economics of Consolidated Edison reveal a capital structure where the cost of equity significantly outpaces returns on invested capital, creating an ROIC-WACC spread of -1.4%. Despite this negative economic moat, the DuPont decomposition shows earnings are driven primarily by high leverage (Equity Multiplier 3.08x) rather than operational efficiency or margin expansion, resulting in a net margin of 12.0% supported only modestly by asset turnover at 0.23x. While the Piotroski F-Score of 6/9 suggests reasonable financial strength and the Beneish M-Score of -2.65 indicates low earnings manipulation risk, the Altman Z-Score of 1.2 flags elevated bankruptcy probability relative to historical norms, creating a tension between solvency metrics and capital allocation efficiency.
Valuation multiples currently sit at 20.5x P/E, trading below the sector average of 22.5x, which may reflect market skepticism regarding the negative spread or the specific risk profile indicated by the Altman score. This discount contrasts sharply with a ten-year implied free cash flow growth rate of 50.0%, suggesting significant divergence between current pricing and long-term earnings trajectory assumptions if such high growth persists. The Fama-French alpha of 7.91% annually indicates strong outperformance relative to standard factor models, yet this is partially offset by a negative profitability factor (RMW) of -0.035, highlighting that the stock's premium valuation does not align with its underlying profit generation capabilities compared to peers.
Insider activity over the last 90 days shows net selling totaling $1.1 million, adding a layer of caution to the investment thesis despite the value tilt evidenced by an HML factor of 0.486. The combination of negative capital returns, elevated distress signals in credit metrics, and insider distribution suggests that while the stock offers exposure to utility sector stability at a relative discount to peers, the underlying economic engine lacks the reinvestment efficiency required to sustain high growth without increasing leverage further.
Generated by LLM from quantitative data inputs. May contain inaccuracies. Not investment advice.
Valuation Context
Currently trading 4% below its 5-year average P/E of 20.9x.
Price Chart with Moving Averages
Technical Setup
AI GeneratedConsolidated Edison, Inc. is currently trading at $108.14 within the Utilities sector, presenting a technical snapshot that requires further context regarding its moving averages to fully assess trend alignment. Without specific data on whether the price sits above or below key short-term and long-term moving averages, it remains unclear if the asset is in an established uptrend, downtrend, or consolidation phase based solely on this single data point. The absence of Moving Average Convergence Divergence indicators or explicit average values prevents a definitive conclusion on trend strength or potential reversal zones at this moment. Regarding short-term momentum, the Relative Strength Index (RSI) is not provided in the current dataset, which limits the ability to gauge overbought or oversold conditions effectively. Typically, an RSI reading above 70 suggests excessive bullishness and potential pullback risks, while a reading below 30 indicates bearish exhaustion and possible upward pressure; however, without these specific figures for ED, no such momentum characterization can be made factually. The current price level alone does not reveal the velocity of recent buying or selling activity relative to historical norms. Consequently, any assessment of whether the stock is exhibiting strong bullish characteristics or significant bearish weakness relies on missing technical metrics that define trend direction and immediate momentum shifts. Investors must await additional data points regarding moving average positioning and RSI values before forming a complete picture of the asset's short-term trajectory. The existing information confirms only the current valuation
Quant Health Deep Dive
Profitability & Value Creation
⚠️ Dividend consumes >80% of FCF — sustainability risk.
DuPont Analysis — ROE Decomposition
Breaking down Return on Equity to see how the company generates its ROE — efficiency, margins, or leverage.
Balance Sheet Health
Insider Activity (Last 90 Days)
Open-market buys vs sells by company insiders. Source: yfinance.
Earnings Surprise History
EPS estimates vs actuals for the most recent reported quarters. Source: yfinance.
Dividend History
| Date | Amount | Change |
|---|---|---|
| 2026-05-13 | $0.8880 | 0.0% |
| 2026-02-18 | $0.8880 | +4.5% |
| 2025-11-19 | $0.8500 | 0.0% |
| 2025-08-13 | $0.8500 | 0.0% |
| 2025-05-14 | $0.8500 | 0.0% |
| 2025-02-19 | $0.8500 | +2.4% |
| 2024-11-13 | $0.8300 | 0.0% |
| 2024-08-14 | $0.8300 | 0.0% |
| 2024-05-14 | $0.8300 | 0.0% |
| 2024-02-13 | $0.8300 | +2.5% |
| 2023-11-14 | $0.8100 | 0.0% |
| 2023-08-15 | $0.8100 | 0.0% |
Dividend and split data from SEC filings and market data. Amounts are per share, not adjusted for splits. Source: yfinance.
Risk Profile
Sharpe = risk-adjusted return (higher is better). Max drawdown = largest peak-to-trough decline. 1,200+ trading days.
Underwater (Drawdown from Peak)
How far below the all-time high the price has been over time. Deeper = more pain for holders.
Rolling 60-Day Beta vs S&P 500 (VOO)
How the stock's sensitivity to market moves changes over time. β > 1 = more volatile than the market.
Fama-French 5-Factor Exposure
Academic factor model decomposition — what's really driving this stock's returns.
Fama-French 5-Factor Model. Data: Kenneth French Data Library. Regression over 3 years of daily returns.
Fundamentals
Passive Flow Attribution
ETF Draft EffectWhen investors buy or sell ETFs like XLU or VPU, the fund manager is mechanically forced to buy or sell ED shares regardless of Consolidated Edison, Inc.'s individual fundamentals. We estimate $6.8B of passive capital is structurally linked to ED through 8 tracked ETFs. This substantial passive exposure means that ETF inflows and outflows — not company fundamentals — can dominate daily volume on this stock.
Passive exposure = Σ (ETF AUM × stock weight in ETF) across 8 tracked ETFs. Actual passive ownership is larger (includes mutual funds). Not investment advice.
ETF Contagion Visualizer
Simulate a price drop in Consolidated Edison, Inc. to visualize passive redemption contagion across ETFs and collateral stocks.
If Consolidated Edison, Inc. (ED) experiences a significant drawdown, ETF redemptions can create collateral selling pressure on co-held stocks. Our model identifies NEXTERA ENERGY INC (NEE) as the most exposed collateral stock, sharing 2 ETFs with ED. This is the "Passive Contagion" effect described in the Inelastic Market Hypothesis.
Contagion model based on shared ETF exposure and constituent weights across 31 tracked ETFs. Estimated selling pressure is a simplified model — actual impact depends on market liquidity, ETF redemption mechanics, and market-maker activity.
ED Ownership Dynamics
Passive funds hold 1 in every 6 ED shares, reducing daily market volatility.
Consolidated Edison, Inc. (ED) exerts notable gravity on the passive index market, currently representing 2.8% of the State Street Utilities Select Sector SPDR ETF (XLU) and 2.5% of the VPU (VPU). Across 31 tracked ETFs, approximately 63M shares (17.1% of float) are held by passive funds and rarely trade on the open market. This level of passive ownership means index rebalances can create outsized volume events.
ETFs with Highest ED Exposure
Float lock-up computed from 31 ETFs tracked by SecuritiesDB. Actual passive ownership is higher (includes mutual funds, pension funds, etc.).
ED Institutional Volume Profile
252-day volume distribution by price level. The Point of Control (POC) marks — the price where the most institutional volume transacted — an implicit support/resistance floor.
The highest-volume price zone for Consolidated Edison, Inc. over the past year sits near $98.80 (16% of 252-day volume). The current price of $103.79 trades 5.1% above this institutional floor — a sign of upside momentum, though a pullback to the POC zone is a common reversion target. The highly concentrated volume profile (16% at POC) indicates strong consensus on fair value — institutional participants have repeatedly transacted near this price.
Volume Profile computed from 252 trading days of OHLCV data. Volume allocated to price bins proportionally based on daily high-low range. Not investment advice.
ED Capital Efficiency
How efficiently does Consolidated Edison, Inc. convert operating profits into free cash? The FCF Conversion ratio measures the gap between accounting earnings and real cash generation.
Consolidated Edison, Inc. converts 1% of its EBITDA into free cash flow, a low conversion rate suggesting heavy reinvestment. This may indicate a growth phase (building capacity) or structural capital intensity. The 99% reinvestment rate signals aggressive capacity expansion. However, the ROIC-WACC spread is negative (-2.0%), suggesting reinvested capital is destroying shareholder value.
Capital efficiency = Free Cash Flow ÷ EBITDA. Reinvestment = (EBITDA − FCF) ÷ EBITDA. Metrics from latest annual filings. Not investment advice.
Fails-to-Deliver (FTD) History
SEC-reported settlement failures. Elevated FTDs can indicate high short-selling pressure, operational settlement issues, or naked shorting activity.
| Date | Failed Shares | Close Price | Notional Value |
|---|---|---|---|
| 2026-05-13 | 6,023 | $106.90 | $643,858.7 |
| 2026-05-11 | 61 | $106.31 | $6,484.91 |
| 2026-05-08 | 60 | $106.39 | $6,383.4 |
| 2026-05-07 | 61 | $106.87 | $6,519.07 |
| 2026-04-22 | 707 | $108.19 | $76,490.33 |
| 2026-04-16 | 12,648 | $110.28 | $1.4M |
| 2026-04-15 | 3 | $111.66 | $334.98 |
| 2026-04-14 | 1,030 | $111.89 | $115,246.7 |
| 2026-04-07 | 112,772 | $114.61 | $12.9M |
| 2026-04-06 | 100 | $115.43 | $11,543 |
| 2026-04-02 | 6 | $113.91 | $683.46 |
| 2026-03-30 | 20 | $111.68 | $2,233.6 |
| 2026-03-25 | 36 | $109.88 | $3,955.68 |
| 2026-03-17 | 492 | $115.46 | $56,806.32 |
| 2026-03-09 | 9,982 | $112.28 | $1.1M |
| 2026-02-18 | 363 | $113.92 | $41,352.96 |
| 2026-02-17 | 806 | $113.72 | $91,658.32 |
| 2026-01-28 | 1 | $105.35 | $105.35 |
| 2025-12-23 | 78 | $98.57 | $7,688.46 |
| 2025-12-15 | 30 | $97.53 | $2,925.9 |
| 2025-12-03 | 207 | $96.87 | $20,052.09 |
| 2025-12-02 | 19,186 | $97.88 | $1.9M |
| 2025-12-01 | 5 | $100.36 | $501.8 |
| 2025-11-21 | 234 | $100.95 | $23,622.3 |
| 2025-11-19 | 200 | $102.91 | $20,582 |
| 2025-11-12 | 39 | $99.59 | $3,884.01 |
| 2025-10-27 | 47,448 | $100.04 | $4.7M |
| 2025-10-24 | 89,736 | $100.77 | $9.0M |
| 2025-10-23 | 92,841 | $101.94 | $9.5M |
| 2025-10-22 | 60,165 | $101.56 | $6.1M |
Source: SEC Regulation SHO FTD data. Data is reported with a ~30 day delay. High FTD quantities relative to average daily volume may indicate settlement stress.
Price Correlations
Statistical correlation of daily returns with other stocks. High correlations indicate stocks that move together; negative correlations can offer diversification.
| Peer | 252-Day (1Y) | 126-Day (6M) | Direction |
|---|---|---|---|
| WTGXX | NaN | NaN | |
| DUK | 0.821 | 0.795 | High co-movement |
| WEC | 0.775 | 0.719 | High co-movement |
| CMS | 0.746 | 0.693 | High co-movement |
| SO | 0.743 | 0.669 | High co-movement |
| PNW | 0.721 | 0.695 | High co-movement |
| EXC | 0.715 | 0.616 | High co-movement |
| AEE | 0.714 | 0.693 | High co-movement |
| ATO | 0.698 | 0.668 | Moderate |
| FE | 0.688 | 0.638 | Moderate |
Pearson correlation of daily log returns. 252d ≈ 1 trading year. Computed from price history. Not investment advice.
Compare ED to Peers
Quant metrics computed deterministically from financial statements and price data. Updated: 2026-06-02.
SecuritiesDB provides programmatic data aggregation for informational purposes only. None of the metrics, summaries, or algorithmic flags constitute a recommendation to buy or sell any security.