Compare Stocks › ED vs LLY
Consolidated Edison, Inc. (ED) vs Eli Lilly and Company (LLY)
ED
Consolidated Edison, Inc.
$111.69
VS
LLY
Eli Lilly and Company
$917.50
Rewards
ED
LLY
- ★Eli Lilly and Company has maintained ROIC above 15% for 4 consecutive years, indicating a durable competitive advantage.
- ★Gross margin of 83.0% indicates strong pricing power — typical of businesses with significant intellectual property or brand strength.
- ★Eli Lilly and Company scores 73/100 on the Economic Moat Score (Wide Moat), with roic consistency as the strongest competitive dimension.
Risks
ED
- ⚠Net debt/EBITDA of 4.4x indicates heavy leverage — it would take over 4 years of EBITDA to pay off net debt.
- ⚠Altman Z-Score of 1.07 places the company in the distress zone — financial patterns resemble those of companies that experienced bankruptcy.
LLY
- ⚠FCF yield of 0.7% is below 3%, meaning the market is pricing in substantial future growth to justify the current price.
- ⚠5 insider sales totaling $330.9M with no purchases in the past 3 months — insiders are reducing their exposure.
Key Valuation Metrics
Learn more →ED
LLY
Valuation
$-145.25M
Free Cash Flow
$5.96B
-0.36%
FCF Yield
0.73%
19.80
Trailing P/E
40.00
17.21
Forward P/E
21.79
Quality & Moat
4.53%
ROIC
32.84%
8.36%
ROE
77.78%
53.25%
Gross Margin
83.04%
N/A
PEG Ratio
0.78
Balance Sheet Safety
1.17
Debt / Equity
1.65
N/A
Interest Coverage
N/A
4.44
Net Debt / EBITDA
1.15
3.08%
Dividend Yield
0.68%
ED: 4Ties: 1LLY: 6
EDLLY
Historical Fundamentals
Learn more →ED
Price ÷ Earnings Per Share — how many years of current earnings you're paying for at today's price. Lower P/E may indicate undervaluation.
LLY
Price ÷ Earnings Per Share — how many years of current earnings you're paying for at today's price. Lower P/E may indicate undervaluation.
Price ÷ Earnings Per Share — how many years of current earnings you're paying for at today's price. Lower P/E may indicate undervaluation.
$1 Retained Earnings Test
Learn more →ED
$0.68
created per $1 retained over 3 years
Mediocre Allocator
Σ Retained
$3.00B
Δ Market Cap
+$2.04B
Buffett's "$1 Test": For every $1 of earnings retained, has management created at least $1 of market value?
> $1 created per $1 retained = Value Creator · < $1 created = Value Destroyer
> $1 created per $1 retained = Value Creator · < $1 created = Value Destroyer
LLY
$27.47
created per $1 retained over 3 years
Exceptional Value Creator
Σ Retained
$22.34B
Δ Market Cap
+$613.62B
Buffett's "$1 Test": For every $1 of earnings retained, has management created at least $1 of market value?
> $1 created per $1 retained = Value Creator · < $1 created = Value Destroyer
> $1 created per $1 retained = Value Creator · < $1 created = Value Destroyer
Buffett's "$1 Test": For every $1 of earnings retained, has management created at least $1 of market value?
> $1 created per $1 retained = Value Creator · < $1 created = Value Destroyer
Discounted Cash Flow (DCF) Analysis
Learn more →ED
185.0% Overvalued
Price is 185.0% above estimated fair value
Current Price: $111.69
Strongly undervalued
Strongly overvalued
Fair Value: $39.18
Strongly undervalued
Undervalued
Fairly valued
Overvalued
Strongly overvalued
LLY
12.5% Margin of Safety
Price is 12.5% below estimated fair value
Current Price: $917.50
Strongly undervalued
Undervalued
Fairly valued
Overvalued
Strongly overvalued
Fair Value: $1048.80
Strongly undervalued
Undervalued
Fairly valued
Overvalued
Strongly overvalued
Reverse DCF — Market-Implied Growth
Learn more →ED
Requires positive FCF to compute implied growth rate.
LLY
What growth rate is the market pricing in at $918?
+17.7%
Market-Implied Owner Earnings Growth
Standard FCF implies +35.1%
The market implies +17.7% Owner Earnings growth, below historical trends — potential opportunity.
Standard FCF implies a more demanding +35.1%, reflecting heavy growth investment expected to generate future returns.
Economic Moat Score
Learn more →ED
46/100
Narrow Moat
70+ Wide · 40-69 Narrow · <40 None
Narrow moat with margin stability as the key competitive advantage. Improving roic consistency would strengthen the moat.
Composite score measuring competitive advantage durability across four dimensions: returns above cost of capital, pricing power stability, revenue predictability, and capital efficiency. Based on 4 years of fundamental data.
LLY
73/100
Wide Moat
70+ Wide · 40-69 Narrow · <40 None
Wide moat driven primarily by roic consistency. Reinvestment Efficiency is the area most vulnerable to competitive pressure.
Composite score measuring competitive advantage durability across four dimensions: returns above cost of capital, pricing power stability, revenue predictability, and capital efficiency. Based on 5 years of fundamental data.
Forensic Accounting
Learn more →ED
-2.58
Unlikely Manipulator
Above -1.78 = likely manipulator · -2.22 to -1.78 = grey zone
M-Score Trend
Beneish's 8-variable model estimates the probability of earnings manipulation. An M-Score above -1.78 signals elevated risk — companies in this range have historically been 3-5× more likely to be manipulating earnings. Scores between -2.22 and -1.78 fall in a grey zone warranting further investigation.
LLY
-1.83
Possible Manipulator
Above -1.78 = likely manipulator · -2.22 to -1.78 = grey zone
M-Score Trend
Beneish's 8-variable model estimates the probability of earnings manipulation. An M-Score above -1.78 signals elevated risk — companies in this range have historically been 3-5× more likely to be manipulating earnings. Scores between -2.22 and -1.78 fall in a grey zone warranting further investigation.
Beneish's 8-variable model estimates the probability of earnings manipulation. An M-Score above -1.78 signals elevated risk — companies in this range have historically been 3-5× more likely to be manipulating earnings. Scores between -2.22 and -1.78 fall in a grey zone warranting further investigation.
Ownership Breakdown
Learn more →ED
Insiders 0.2%Institutions 73.8%Retail & Other 26.0%
No. of Institutional Holders1,775
High insider ownership aligns management incentives with shareholders — a key signal in Buffett-style analysis. Institutional concentration can indicate smart-money conviction but also crowding risk.
LLY
Insiders 0.2%Institutions 84.7%Retail & Other 15.1%
No. of Institutional Holders5,561
High insider ownership aligns management incentives with shareholders — a key signal in Buffett-style analysis. Institutional concentration can indicate smart-money conviction but also crowding risk.
High insider ownership aligns management incentives with shareholders. Institutional concentration can indicate smart-money conviction but also crowding risk.
Insider Buying Activity
Learn more →ED
0
Buys (3M)
2
Buys (12M)
Total value (12M): $207.00
MILLER JOSEPH
Officer
$104.00
@ $104.00 · 2025-12-15
MILLER JOSEPH
Officer
$103.00
@ $103.00 · 2025-09-15
SANCHEZ ROBERT
Officer
$2,311
@ $96.29 · 2024-04-30
CAWLEY TIMOTHY P
Chief Executive Officer
$2,316
@ $96.50 · 2024-04-30
HOGLUND ROBERT N
Chief Financial Officer
$2,315
@ $96.46 · 2024-04-30
Open market purchases · includes direct & indirect ownership · excludes option exercises
LLY
0
Buys (3M)
8
Buys (12M)
Total value (12M): $4.54M
MONTARCE LUCAS E
Chief Financial Officer
$494,627
@ $691.79 · 2025-08-15
ALVAREZ RALPH
Director
$500,473
@ $660.25 · 2025-08-13
VAN NAARDEN JACOB S.
Officer
$647,360
@ $647.36 · 2025-08-13
FYRWALD J. ERIK
Director
$1.01M
@ $642.33 · 2025-08-12
RICKS DAVID A
Chief Executive Officer
$1.05M
@ $644.77 · 2025-08-12
SKOVRONSKY DANIEL
Officer
$634,405
@ $634.40 · 2025-08-12
SULZBERGER GABRIELLE
Director
$75,018
@ $641.18 · 2025-08-12
JACKSON JAMERE
Director
$127,913
@ $639.57 · 2025-08-08
Open market purchases · includes direct & indirect ownership · excludes option exercises
Open market purchases · includes direct & indirect ownership · excludes option exercises.
Insider Selling Activity
Learn more →ED
2
Sells (3M)
3
Sells (12M)
Total value (12M): $1.33M
DONNLEY DENEEN L
General Counsel
$218,993
@ $113.94 · 2026-03-12
MULROW WILLIAM J
Director
$892,553
@ $112.81 · 2026-02-27
KILLIAN JOHN F
Director
$220,522
@ $96.89 · 2025-12-11
KILLIAN JOHN F
Director
$145,680
@ $97.12 · 2024-05-22
Direct ownership only · excludes indirect, option exercises, planned (10b5-1) sales & derivatives
LLY
5
Sells (3M)
41
Sells (12M)
Total value (12M): $3.84B
LILLY ENDOWMENT, INC.
Beneficial Owner of more than 10% of a Class of Security
$322.38M
@ $1103.48 · 2026-01-07
LILLY ENDOWMENT, INC.
Beneficial Owner of more than 10% of a Class of Security
$1.51M
@ $1085.01 · 2026-01-05
LILLY ENDOWMENT, INC.
Beneficial Owner of more than 10% of a Class of Security
$3.90M
@ $1085.04 · 2025-12-29
LILLY ENDOWMENT, INC.
Beneficial Owner of more than 10% of a Class of Security
$2.85M
@ $1085.17 · 2025-12-24
LILLY ENDOWMENT, INC.
Beneficial Owner of more than 10% of a Class of Security
$260,409
@ $1085.04 · 2025-12-23
LILLY ENDOWMENT, INC.
Beneficial Owner of more than 10% of a Class of Security
$161.08M
@ $1095.35 · 2025-11-25
LILLY ENDOWMENT, INC.
Beneficial Owner of more than 10% of a Class of Security
$17.34M
@ $1109.30 · 2025-11-25
LILLY ENDOWMENT, INC.
Beneficial Owner of more than 10% of a Class of Security
$152.06M
@ $1068.52 · 2025-11-24
LILLY ENDOWMENT, INC.
Beneficial Owner of more than 10% of a Class of Security
$111.50M
@ $1058.66 · 2025-11-21
LILLY ENDOWMENT, INC.
Beneficial Owner of more than 10% of a Class of Security
$39.07M
@ $1051.66 · 2025-11-20
LILLY ENDOWMENT, INC.
Beneficial Owner of more than 10% of a Class of Security
$176.10M
@ $1051.17 · 2025-11-19
LILLY ENDOWMENT, INC.
Beneficial Owner of more than 10% of a Class of Security
$62.31M
@ $1034.78 · 2025-11-18
LILLY ENDOWMENT, INC.
Beneficial Owner of more than 10% of a Class of Security
$10.19M
@ $1030.68 · 2025-11-17
LILLY ENDOWMENT, INC.
Beneficial Owner of more than 10% of a Class of Security
$183.33M
@ $1028.25 · 2025-11-14
ZAKROWSKI DONALD A
Officer
$1.01M
@ $1010.50 · 2025-11-13
LILLY ENDOWMENT, INC.
Beneficial Owner of more than 10% of a Class of Security
$48.02M
@ $1030.26 · 2025-11-13
LILLY ENDOWMENT, INC.
Beneficial Owner of more than 10% of a Class of Security
$308.41M
@ $1011.18 · 2025-11-12
LILLY ENDOWMENT, INC.
Beneficial Owner of more than 10% of a Class of Security
$279.35M
@ $986.64 · 2025-11-11
LILLY ENDOWMENT, INC.
Beneficial Owner of more than 10% of a Class of Security
$16.41M
@ $972.52 · 2025-11-10
LILLY ENDOWMENT, INC.
Beneficial Owner of more than 10% of a Class of Security
$167.09M
@ $933.26 · 2025-11-05
LILLY ENDOWMENT, INC.
Beneficial Owner of more than 10% of a Class of Security
$38.47M
@ $951.56 · 2025-11-05
LILLY ENDOWMENT, INC.
Beneficial Owner of more than 10% of a Class of Security
$479,038
@ $910.72 · 2025-11-04
LILLY ENDOWMENT, INC.
Beneficial Owner of more than 10% of a Class of Security
$266.65M
@ $888.83 · 2025-11-03
LILLY ENDOWMENT, INC.
Beneficial Owner of more than 10% of a Class of Security
$260.17M
@ $863.35 · 2025-10-31
LILLY ENDOWMENT, INC.
Beneficial Owner of more than 10% of a Class of Security
$3.16M
@ $863.24 · 2025-10-10
LILLY ENDOWMENT, INC.
Beneficial Owner of more than 10% of a Class of Security
$9.04M
@ $852.49 · 2025-10-09
LILLY ENDOWMENT, INC.
Beneficial Owner of more than 10% of a Class of Security
$86.23M
@ $850.27 · 2025-10-08
LILLY ENDOWMENT, INC.
Beneficial Owner of more than 10% of a Class of Security
$22.72M
@ $848.01 · 2025-10-07
LILLY ENDOWMENT, INC.
Beneficial Owner of more than 10% of a Class of Security
$137.04M
@ $850.22 · 2025-10-06
LILLY ENDOWMENT, INC.
Beneficial Owner of more than 10% of a Class of Security
$161.22M
@ $837.93 · 2025-10-03
LILLY ENDOWMENT, INC.
Beneficial Owner of more than 10% of a Class of Security
$92.50M
@ $821.55 · 2025-10-02
LILLY ENDOWMENT, INC.
Beneficial Owner of more than 10% of a Class of Security
$107.36M
@ $794.15 · 2025-10-01
LILLY ENDOWMENT, INC.
Beneficial Owner of more than 10% of a Class of Security
$177.29M
@ $821.47 · 2025-10-01
LILLY ENDOWMENT, INC.
Beneficial Owner of more than 10% of a Class of Security
$86.79M
@ $763.39 · 2025-09-30
LILLY ENDOWMENT, INC.
Beneficial Owner of more than 10% of a Class of Security
$18.06M
@ $763.09 · 2025-09-19
LILLY ENDOWMENT, INC.
Beneficial Owner of more than 10% of a Class of Security
$81.53M
@ $764.65 · 2025-09-18
ZAKROWSKI DONALD A
Officer
$734,930
@ $734.93 · 2025-08-28
YUFFA ILYA
Officer
$783,762
@ $627.01 · 2025-08-11
LILLY ENDOWMENT, INC.
Beneficial Owner of more than 10% of a Class of Security
$225.42M
@ $805.07 · 2025-07-24
ZAKROWSKI DONALD A
Officer
$716,410
@ $716.41 · 2025-05-27
YUFFA ILYA
Officer
$936,550
@ $749.24 · 2025-05-14
ZAKROWSKI DONALD A
Officer
$818,240
@ $818.24 · 2025-03-13
LILLY ENDOWMENT, INC.
Beneficial Owner of more than 10% of a Class of Security
$204.33M
@ $928.76 · 2025-03-03
Direct ownership only · excludes indirect, option exercises, planned (10b5-1) sales & derivatives
Direct ownership only · excludes indirect, option exercises, planned (10b5-1) sales & derivatives.
🎭 Mr. Market's Mood
Learn more →ED
😐Neutral(60/100)
"Market is pricing this stock without strong emotion in either direction"
Composite sentiment score based on 6 market signals. Inspired by Buffett's "Mr. Market" allegory — fear = potential opportunity, greed = potential risk. Must be used alongside fundamental analysis, not in isolation.
LLY
😐Neutral(43/100)
"Market is pricing this stock without strong emotion in either direction"
Composite sentiment score based on 6 market signals. Inspired by Buffett's "Mr. Market" allegory — fear = potential opportunity, greed = potential risk. Must be used alongside fundamental analysis, not in isolation.
Composite sentiment score based on market signals. Inspired by Buffett’s "Mr. Market" allegory — fear = potential opportunity, greed = potential risk. Must be used alongside fundamental analysis, not in isolation.
⚖️ Buffett Signal
Learn more →ED
⚪Awaiting DCF Data
The Buffett Signal cross-references market sentiment with DCF valuation. Configure the DCF Analysis above to generate a signal.
DCF Margin of Safety: N/AMr. Market's Mood: Neutral (60)
LLY
⚪Awaiting DCF Data
The Buffett Signal cross-references market sentiment with DCF valuation. Configure the DCF Analysis above to generate a signal.
DCF Margin of Safety: N/AMr. Market's Mood: Neutral (43)