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 62 of 151 Next »

Ticker ⇵	Company ⇵	Dividend Yield % ▼	Dividend Per Share ⇵	Payout Ratio % ⇵
5139.KL	AEON Credit Service (M) Berhad	2.49%	$0.14	21.23%
MOBA.OL	Morrow Bank ASA	2.49%	$0.40	35.32%
NOKIA.HE	Nokia Oyj	2.49%	$0.14	65.00%
SUNI.JK	PT Sunindo Pratama Tbk	2.49%	$20.78	27.09%
TIPCO.BK	Tipco Foods Public Company Limited	2.49%	$0.19	33.58%
003220.KS	Daewon Pharmaceutical Co., Ltd.	2.48%	$297.36	78.76%
081000.KS	Iljin Diamond Co.,Ltd	2.48%	$298.16	39.09%
2489.HK	Persistence Resources Group Ltd	2.48%	$0.03	48.82%
2755.TWO	YoungQin International Co., Ltd.	2.48%	$2.90	54.00%
5474.TWO	Yuan High-Tech Development Co., Ltd.	2.48%	$3.99	63.53%
6665.TWO	Healthconn Corp.	2.48%	$0.51	86.65%
7276.T	Koito Manufacturing Co., Ltd.	2.48%	$57.37	33.13%
BREB.BR	Brederode S.A.	2.48%	$2.66	20.88%
ICBP.JK	PT Indofood CBP Sukses Makmur Tbk	2.48%	$200.00	25.69%
ILU.AX	Iluka Resources Limited	2.48%	$0.15	13.66%
LOXLEY.BK	Loxley Public Company Limited	2.48%	$0.03	32.70%
203450.KQ	UNION biometrics Co., Ltd.	2.47%	$77.45	17.43%
300138.SZ	ChenGuang Biotech Group Co., Ltd.	2.47%	$0.31	44.10%
600854.SS	Jiangsu chunlan refrigerating equipment stock co.,ltd.	2.47%	$0.12	53.56%
601108.SS	Caitong Securities Co.,Ltd.	2.47%	$0.22	38.34%
ACTINVRB.MX	Corporación Actinver, S. A. B. de C. V.	2.47%	$0.55	16.64%
ALCIS.PA	Catering International & Services S.A.	2.47%	$0.34	26.64%
QBR-A.TO	Quebecor Inc.	2.47%	$1.37	38.63%
U13.SI	United Overseas Insurance Limited	2.47%	$0.19	47.92%
002415.SZ	Hangzhou Hikvision Digital Technology Co., Ltd.	2.46%	$0.74	51.16%
2897.T	Nissin Foods Holdings Co.,Ltd.	2.46%	$71.75	42.73%
300144.SZ	Songcheng Performance Development Co.,Ltd	2.46%	$0.20	66.36%
300257.SZ	Kaishan Group Co., Ltd.	2.46%	$0.35	85.09%
4452.T	Kao Corporation	2.46%	$153.90	58.66%
6530.TWO	Axcen Photonics Corporation	2.46%	$1.53	82.52%
6571.T	QB Net Holdings Co.,Ltd.	2.46%	$34.31	43.61%
7298.T	Yachiyo Industry Co., Ltd.	2.46%	$34.07	16.58%
2478.TW	TA-I Technology Co., Ltd.	2.45%	$1.52	53.44%
603305.SS	Ningbo Xusheng Auto Technology Co., Ltd.	2.45%	$0.40	98.16%
603919.SS	JINHUI LIQUOR Co.,Ltd.	2.45%	$0.50	65.59%
688616.SS	Hangzhou Xili Intelligent Technology Co.,Ltd	2.45%	$0.30	55.59%
KALMAR.HE	Kalmar Oyj	2.45%	$1.00	44.14%
TOWR.JK	PT Sarana Menara Nusantara Tbk.	2.45%	$14.34	23.50%
VIVT3.SA	Telefônica Brasil S.A.	2.45%	$0.80	42.63%
103140.KS	Poongsan Corporation	2.44%	$2,600.49	39.75%
300017.SZ	Wangsu Science & Technology Co.,Ltd.	2.44%	$0.25	72.18%
3086.T	J. Front Retailing Co., Ltd.	2.44%	$53.53	43.66%
600182.SS	Giti Tire Corporation	2.44%	$0.37	89.97%
600785.SS	Yinchuan Xinhua Commercial (Group) Co., Ltd.	2.44%	$0.33	55.95%
601636.SS	Zhuzhou Kibing Group Co.,Ltd	2.44%	$0.15	64.94%
ELET5.SA	Centrais Elétricas Brasileiras S.A. - Eletrobrás	2.44%	$1.92	63.99%
LISN.SW	Chocoladefabriken Lindt & Sprüngli AG	2.44%	$2,845.60	50.18%
SCA-A.ST	Svenska Cellulosa Aktiebolaget SCA (publ)	2.44%	$3.00	59.52%
000858.SZ	Wuliangye Yibin Co.,Ltd.	2.43%	$2.58	35.17%
002328.SZ	Shanghai Xinpeng Industry Co.,Ltd.	2.43%	$0.16	82.89%

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