Definitive Analysis
Definitive Analysis

Financial Statements

Fundamentals

Valuations

Miscellaneous

Analysis Mode

Search

Eli Lilly and Company (LLY)

Company Dividend Discount ModelIndustry: Drug Manufacturers - GeneralSector: Healthcare

Valuation Snapshot

Stable Growth$479.58 - $1,272.18$733.32
Multi-Stage$329.79 - $360.24$344.74
Blended Fair Value$539.03
Current Price$763.00
Upside-29.35%
DecisionDon't Buy

Dividend History & Growth Metrics (10Y)

Metric5Y CAGR10Y CAGR2024202320222021202020192018201720162015
DPS14.20%8.34%5.204.523.933.432.982.682.572.432.402.36
YoY Growth--15.02%15.09%14.55%14.87%11.51%4.24%5.46%1.56%1.47%1.24%
Dividend Yield--0.63%0.59%1.14%1.20%1.60%1.93%1.99%3.15%2.85%3.28%

Stable Growth Model (Adjusted)

(USD in Millions except Per Share Data)
Net Income To Common (M)18,412.10
(-) Cash Dividends Paid (M)5,206.80
(=) Cash Retained (M)13,205.30
MetricLOWBASEHIGH
Required Retention Ratio20.0%12.5%7.5%
(=) Cash Required (M)3,682.422,301.511,380.91
Cash Retained (M)13,205.3013,205.3013,205.30
(-) Cash Required (M)-3,682.42-2,301.51-1,380.91
(=) Excess Retained (M)9,522.8810,903.7911,824.39
(/) Shares Outstanding (M)900.59900.59900.59
(=) Excess Retained per Share10.5712.1113.13
LTM Dividend per Share5.785.785.78
(+) Excess Retained per Share10.5712.1113.13
(=) Adjusted Dividend16.3617.8918.91
WACC / Discount Rate9.10%9.10%9.10%
Growth Rate5.50%6.50%7.50%
Fair Value$479.58$733.32$1,272.18
Upside / Downside-37.15%-3.89%66.73%

Multi-Stage Model: Projections

(USD in Millions)
MetricTTMDec-27Dec-28Dec-29Dec-30Dec-31Terminal
Net Income (M)18,412.1019,608.8920,883.4622,240.8923,686.5525,226.1725,982.96
Payout Ratio28.28%40.62%52.97%65.31%77.66%90.00%92.50%
Projected Dividends (M)5,206.807,965.7911,061.4614,525.9018,393.9922,703.5624,034.24

Multi-Stage Valuation

MetricLOWBASEHIGH
WACC / Discount Rate9.10%9.10%9.10%
Growth Rate5.50%6.50%7.50%
Year 1 PV (M)7,232.947,301.507,370.06
Year 2 PV (M)9,119.789,293.499,468.83
Year 3 PV (M)10,874.3011,186.4611,504.54
Year 4 PV (M)12,503.1712,984.0113,478.58
Year 5 PV (M)14,012.7814,689.6015,392.32
PV of Terminal Value (M)243,261.41255,011.02267,210.33
Equity Value (M)297,004.38310,466.08324,424.67
Shares Outstanding (M)900.59900.59900.59
Fair Value$329.79$344.74$360.24
Upside / Downside-56.78%-54.82%-52.79%

High-Yield Dividend Screener

« Prev Page 13 of 151 Next »
Ticker Company Dividend Yield % Dividend Per Share Payout Ratio %
PCR.WAPCC Rokita S.A.7.82%$5.0595.33%
TQR.BKTQR Public Company Limited7.82%$0.3990.56%
KGI.BKKGI Securities (Thailand) Public Company Limited7.81%$0.3162.80%
PRDA.JKPT Prodia Widyahusada Tbk7.81%$180.5285.06%
AIMIRT.BKAIM Industrial Growth Freehold and Leasehold Real Estate Investment Trust7.80%$0.8581.01%
AKRA.JKPT AKR Corporindo Tbk7.80%$99.8882.20%
SPREME.BKSupreme Distribution Public Company Limited7.80%$0.1190.62%
AYV.PAAyvens7.79%$0.9171.87%
1378.HKChina Hongqiao Group Limited7.78%$2.6556.89%
NRG.PANRJ Group S.A.7.78%$0.6363.81%
D2O.AXDuxton Water Limited7.77%$0.1250.68%
TVO-R.BKThai Vegetable Oil Public Company Limited7.77%$1.7462.11%
C38U.SICapitaLand Integrated Commercial Trust7.76%$0.1874.73%
002839.SZJiangsu Zhangjiagang Rural Commercial Bank Co., Ltd7.75%$0.3544.09%
0710.HKBOE Varitronix Limited7.75%$0.4239.15%
0951.HKChaowei Power Holdings Limited7.75%$0.1120.52%
1681.HKConsun Pharmaceutical Group Limited7.75%$1.2055.92%
AXA.DEAXA S.A.7.75%$3.1752.74%
RND.AXRand Mining Limited7.75%$0.2057.47%
601881.SSChina Galaxy Securities Co., Ltd.7.74%$1.2298.30%
TA1.DETelekom Austria AG7.74%$0.7679.04%
0746.HKLee & Man Chemical Company Limited7.73%$0.4035.48%
NESN.SWNestlé S.A.7.73%$6.0972.83%
2633.HKJacobson Pharma Corporation Limited7.72%$0.1036.63%
000498.SZShandong Hi-Speed Road and Bridge Group Co., Ltd.7.71%$0.4748.64%
0016.HKSun Hung Kai Properties Limited7.71%$7.4556.97%
0QKE.LVontobel Holding AG7.70%$4.4661.99%
HAEK.DEHaemato AG7.70%$1.6385.37%
2688.HKENN Energy Holdings Limited7.68%$5.3950.36%
ASIMAR.BKAsian Marine Services Public Company Limited7.68%$0.1260.54%
SAMS.PASamse S.A.7.68%$10.2556.16%
SEC.AXSpheria Emerging Companies Limited7.68%$0.2215.84%
UVAN.BKUnivanich Palm Oil Public Company Limited7.68%$1.0063.09%
JCT.BKJack Chia Industries (Thailand) Public Company Limited7.67%$6.4483.85%
KFL.NZKingfish Limited7.67%$0.1038.05%
ALRIB.PARiber S.A.7.65%$0.2771.18%
DXI.AXDexus Industria REIT7.65%$0.2117.56%
NISP.JKPT Bank OCBC NISP Tbk7.65%$106.0049.91%
SCG.AXScentre Group7.65%$0.3291.06%
002572.SZSuofeiya Home Collection Co., Ltd.7.62%$1.0488.29%
035000.KSHS Ad Inc.7.62%$648.8381.78%
JMT-R.BKJMT Network Services Public Company Limited7.62%$0.6769.23%
SQU.DEVinci S.A.7.62%$9.2455.99%
0QP2.LZurich Insurance Group AG7.61%$32.4879.70%
BAMI.MIBanco BPM S.p.A.7.61%$1.0080.93%
600795.SSGD Power Development Co.,Ltd7.60%$0.3892.13%
BTI.AXBailador Technology Investments Limited7.60%$0.0934.83%
SMPC.BKSahamitr Pressure Container Public Company Limited7.60%$0.6757.18%
0O33.LOeneo S.A.7.59%$0.7076.88%
BOREO.HEBoreo Oyj7.59%$1.0882.86%