DDM Analysis: LLY

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
Upside	29.81%
Decision	Don't Buy

Dividend History & Growth Metrics (10Y)

Metric	5Y CAGR	10Y CAGR	2024	2023	2022	2021	2020	2019	2018	2017	2016	2015
DPS	14.20%	8.34%	5.20	4.52	3.93	3.43	2.98	2.68	2.57	2.43	2.40	2.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

Metric	LOW	BASE	HIGH
Required Retention Ratio	20.0%	12.5%	7.5%
(=) Cash Required (M)	3,682.42	2,301.51	1,380.91
Cash Retained (M)	13,205.30	13,205.30	13,205.30
(-) Cash Required (M)	-3,682.42	-2,301.51	-1,380.91
(=) Excess Retained (M)	9,522.88	10,903.79	11,824.39
(/) Shares Outstanding (M)	900.59	900.59	900.59
(=) Excess Retained per Share	10.57	12.11	13.13
LTM Dividend per Share	5.78	5.78	5.78
(+) Excess Retained per Share	10.57	12.11	13.13
(=) Adjusted Dividend	16.36	17.89	18.91
WACC / Discount Rate	7.75%	7.75%	7.75%
Growth Rate	5.50%	6.50%	7.50%
Fair Value	$768.38	$1,529.46	$4,065.90
Upside / Downside	0.71%	100.45%	432.88%

Multi-Stage Model: Projections

(USD in Millions)

Metric	TTM	Dec-27	Dec-28	Dec-29	Dec-30	Dec-31	Terminal
Net Income (M)	18,412.10	19,608.89	20,883.46	22,240.89	23,686.55	25,226.17	25,982.96
Payout Ratio	28.28%	40.62%	52.97%	65.31%	77.66%	90.00%	92.50%
Projected Dividends (M)	5,206.80	7,965.79	11,061.46	14,525.90	18,393.99	22,703.56	24,034.24

Multi-Stage Valuation

Metric	LOW	BASE	HIGH
WACC / Discount Rate	7.75%	7.75%	7.75%
Growth Rate	5.50%	6.50%	7.50%
Year 1 PV (M)	7,323.73	7,393.15	7,462.57
Year 2 PV (M)	9,350.15	9,528.24	9,708.02
Year 3 PV (M)	11,288.92	11,612.98	11,943.19
Year 4 PV (M)	13,142.81	13,648.25	14,168.12
Year 5 PV (M)	14,914.52	15,634.90	16,382.85
PV of Terminal Value (M)	332,697.96	348,767.40	365,451.85
Equity Value (M)	388,718.09	406,584.92	425,116.60
Shares Outstanding (M)	900.59	900.59	900.59
Fair Value	$431.63	$451.47	$472.04
Upside / Downside	-43.43%	-40.83%	-38.13%

High-Yield Dividend Screener

US Stocks Global Stocks

« Prev Page 61 of 151 Next »

Ticker ⇵	Company ⇵	Dividend Yield % ▼	Dividend Per Share ⇵	Payout Ratio % ⇵
017810.KS	Pulmuone Co., Ltd.	2.55%	$331.61	65.57%
023160.KQ	Tae Kwang Corporation	2.55%	$535.13	21.10%
3152.TWO	Advanced Ceramic X Corporation	2.55%	$3.66	36.41%
600415.SS	Zhejiang China Commodities City Group Co., Ltd.	2.55%	$0.41	53.66%
601808.SS	China Oilfield Services Limited	2.55%	$0.36	43.75%
7606.T	United Arrows Ltd.	2.55%	$62.63	43.42%
CYRE3.SA	Cyrela Brazil Realty S.A. Empreendimentos e Participações	2.55%	$0.61	12.29%
JUNGH.SW	Jungheinrich AG	2.55%	$0.79	22.62%
RENT3.SA	Localiza Rent a Car S.A.	2.55%	$1.11	66.67%
002380.KS	KCC Corporation	2.54%	$10,000.23	6.25%
1527.HK	Zhejiang Tengy Environmental Technology Co., Ltd	2.54%	$0.05	4.95%
5212.KL	Pavilion Real Estate Investment Trust	2.54%	$0.05	39.63%
5489.TWO	DynaColor, Inc.	2.54%	$1.02	50.42%
600273.SS	Zhejiang Jiahua Energy Chemical Industry Co.,Ltd.	2.54%	$0.22	28.18%
600724.SS	Ningbo Fuda Company Limited	2.54%	$0.15	96.79%
7505.T	Fuso Dentsu Co., Ltd.	2.54%	$48.50	22.36%
8850.T	Starts Corporation Inc.	2.54%	$121.52	25.36%
BLAU3.SA	Blau Farmacêutica S.A.	2.54%	$0.35	19.81%
2367.HK	Giant Biogene Holding Co., Ltd.	2.53%	$0.87	22.55%
2701.TW	Wan Hwa Enterprise Company Ltd.	2.53%	$0.28	52.89%
600963.SS	Yueyang Forest & Paper Co., Ltd.	2.53%	$0.12	48.95%
603697.SS	YouYou Foods Co., Ltd.	2.53%	$0.31	63.16%
CK-R.BK	CH. Karnchang Public Company Limited	2.53%	$0.30	25.56%
SCHO.CO	Aktieselskabet Schouw & Co.	2.53%	$16.81	42.51%
003006.SZ	Chongqing Baiya Sanitary Products Co., Ltd.	2.52%	$0.55	80.44%
5191.T	Sumitomo Riko Company Limited	2.52%	$66.01	23.54%
600406.SS	NARI Technology Co., Ltd.	2.52%	$0.57	56.63%
600909.SS	Huaan Securities Co., Ltd.	2.52%	$0.17	38.30%
603811.SS	Zhejiang Cheng Yi Pharmaceutical Co., Ltd.	2.52%	$0.26	37.15%
BESALCO.SN	Besalco S.A.	2.52%	$30.59	34.76%
000019.SZ	Shenzhen Cereals Holdings Co., Ltd.	2.51%	$0.17	62.11%
094820.KQ	Iljin Power Co., Ltd.	2.51%	$320.01	48.44%
0QVR.L	Scandi Standard AB (publ)	2.51%	$2.49	52.58%
4041.T	Nippon Soda Co., Ltd.	2.51%	$90.77	32.02%
600056.SS	China Meheco Group Co., Ltd.	2.51%	$0.26	71.36%
605169.SS	Xinjiang Hongtong Natural Gas Co., Ltd.	2.51%	$0.33	91.06%
6691.TW	Yankey Engineering Co., Ltd.	2.51%	$13.92	62.80%
7483.T	Doshisha Co.,Ltd.	2.51%	$82.93	37.87%
GPSC-R.BK	Global Power Synergy Public Company Limited	2.51%	$0.90	51.48%
HOVE.CO	Hove A/S	2.51%	$0.14	34.71%
NOLA-B.ST	Nolato AB (publ)	2.51%	$1.50	51.20%
0QNH.L	Huber+Suhner AG	2.50%	$3.61	49.61%
100840.KS	SNT Energy Co., Ltd.	2.50%	$899.87	27.57%
138490.KS	Kolon Plastics, Inc.	2.50%	$200.40	17.45%
2612.T	Kadoya Sesame Mills Incorporated	2.50%	$99.85	34.73%
603112.SS	Shanxi Huaxiang Group Co., Ltd.	2.50%	$0.43	43.19%
603766.SS	Loncin Motor Co., Ltd.	2.50%	$0.40	45.87%
ISCTR.IS	Türkiye Is Bankasi A.S.	2.50%	$0.36	16.38%
002539.SZ	Chengdu Wintrue Holding Co., Ltd.	2.49%	$0.29	41.75%
2542.TW	Highwealth Construction Corp.	2.49%	$0.98	39.34%

Financial Statements

Fundamentals

Valuations

Miscellaneous

Mode

Ticker

Industry

Sector

Eli Lilly and Company (LLY)

Valuation Snapshot

Dividend History & Growth Metrics (10Y)

Stable Growth Model (Adjusted)

Multi-Stage Model: Projections

Multi-Stage Valuation

High-Yield Dividend Screener