Definitive Analysis
Loading...
Definitive Analysis

Financial Statements

Company Industry Sector

Fundamentals

Margins Returns Growth Rates Metrics/Ratios

Valuations

Projections DCF DDM EPV Multiples Valuations

Miscellaneous

Indicators Charts WACC Beta Predictability

Mode

Company Industry Sector

Ticker

Industry

Sector

Eli Lilly and Company (LLY)

Company Dividend Discount ModelIndustry: Drug Manufacturers - GeneralSector: Healthcare

Valuation Snapshot

Stable Growth$768.38 - $4,065.90$1,529.46
Multi-Stage$431.63 - $472.04$451.47
Blended Fair Value$990.46
Current Price$763.00
Upside29.81%
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 Rate7.75%7.75%7.75%
Growth Rate5.50%6.50%7.50%
Fair Value$768.38$1,529.46$4,065.90
Upside / Downside0.71%100.45%432.88%

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 Rate7.75%7.75%7.75%
Growth Rate5.50%6.50%7.50%
Year 1 PV (M)7,323.737,393.157,462.57
Year 2 PV (M)9,350.159,528.249,708.02
Year 3 PV (M)11,288.9211,612.9811,943.19
Year 4 PV (M)13,142.8113,648.2514,168.12
Year 5 PV (M)14,914.5215,634.9016,382.85
PV of Terminal Value (M)332,697.96348,767.40365,451.85
Equity Value (M)388,718.09406,584.92425,116.60
Shares Outstanding (M)900.59900.59900.59
Fair Value$431.63$451.47$472.04
Upside / Downside-43.43%-40.83%-38.13%

High-Yield Dividend Screener

« Prev Page 64 of 151 Next »
Ticker ⇵ Company ⇵ Dividend Yield % ▼ Dividend Per Share ⇵ Payout Ratio % ⇵
WAC.DEWacker Neuson SE2.39%$0.6066.56%
002984.SZQingdao Sentury Tire Co., Ltd.2.38%$0.5036.63%
003650.KSMichang Oil Ind .Co.,Ltd.2.38%$2,999.969.11%
008420.KSMoonbaesteel Co.,Ltd2.38%$49.9345.80%
033270.KSKorea United Pharm Inc.2.38%$452.5915.84%
2200.SRArabian Pipes Company2.38%$0.1119.59%
600916.SSChina National Gold Group Gold Jewellery Co.,Ltd.2.38%$0.1975.48%
6683.TWOKeystone Microtech Corporation2.38%$9.9865.32%
8255.TAxial Retailing Inc.2.38%$27.3926.77%
CPIN.JKPT Charoen Pokphand Indonesia Tbk2.38%$108.0046.06%
ECILC.ISEIS Eczacibasi Ilaç, Sinai ve Finansal Yatirimlar Sanayi ve Ticaret A.S.2.38%$1.9955.96%
MALEE.BKMalee Group Public Company Limited2.38%$0.1027.58%
MERC4.SAMercantil Financeira S.A. - Crédito, Financiamento e Investimento2.38%$0.3033.30%
002734.SZLimin Group Co., Ltd.2.37%$0.3841.84%
0RC6.LPharma Mar, S.A.2.37%$0.7933.20%
601066.SSCSC Financial Co., Ltd.2.37%$0.6349.15%
601199.SSJiangsu Jiangnan Water Co., Ltd.2.37%$0.1330.40%
6752.TPanasonic Holdings Corporation2.37%$48.0035.05%
8732.TMoney Partners Group Co.,Ltd.2.37%$11.2256.03%
TMILL.BKT S Flour Mill Public Company Limited2.37%$0.0550.08%
000923.SZHBIS Resources Co., Ltd.2.36%$0.5062.02%
003100.KQSUN KWANG CO.,Ltd.2.36%$450.009.05%
0322.HKTingyi (Cayman Islands) Holding Corp.2.36%$0.2837.83%
092780.KSDYP Co.,Ltd2.36%$80.0413.83%
194370.KSJS Corporation2.36%$289.3014.00%
300498.SZWens Foodstuff Group Co., Ltd.2.36%$0.4033.81%
3715.TWDynamic Holding Co., Ltd.2.36%$3.0087.49%
601126.SSBeijing Sifang Automation Co.,Ltd2.36%$0.7174.03%
603167.SSBohai Ferry Group Co., Ltd.2.36%$0.2236.07%
6062.TCharm Care Corporation2.36%$29.9333.34%
6197.TSolasto Corporation2.36%$20.0442.12%
6586.TMakita Corporation2.36%$111.8037.02%
GUNA.JKGunanusa Eramandiri Tbk.2.36%$7.1827.33%
LLQ.SWLalique Group S.A.2.36%$0.8354.12%
003480.KSHanjin Heavy Industries & Construction Holdings Co., Ltd.2.35%$109.434.27%
007310.KSOtoki Corporation2.35%$9,000.8630.39%
200130.KQKolmar BNH Co., Ltd.2.35%$308.5362.12%
5263.KLSunway Construction Group Bhd2.35%$0.1363.40%
7522.TWatami Co., Ltd.2.35%$22.6923.93%
ALMOU.PAMoulinvest S.A.2.35%$0.5245.03%
AMFG.JKPT Asahimas Flat Glass Tbk2.35%$80.2525.12%
DIF.BKDigital Telecommunications Infrastructure Fund2.35%$0.2219.79%
002959.SZBear Electric Appliance Co.,Ltd.2.34%$0.9944.00%
069080.KQWebzen Inc.2.34%$303.4628.97%
2421.TWSunonwealth Electric Machine Industry Co., Ltd.2.34%$3.7151.15%
300470.SZSinoseal Holding Co., Ltd.2.34%$0.8845.78%
3031.TRACCOON HOLDINGS, Inc.2.34%$15.1438.54%
4260.SRUnited International Transportation Company2.34%$1.4533.16%
600211.SSTibet Rhodiola Pharmaceutical Holding Co.2.34%$1.0032.69%
600739.SSLiaoning Cheng Da Co., Ltd.2.34%$0.2646.23%