DDM Analysis: LLY

Valuation Snapshot

Stable Growth	$767.84 - $4,065.90	$1,527.51
Multi-Stage	$431.47 - $471.87	$451.30
Blended Fair Value	$989.41
Current Price	$763.00
Upside	29.67%
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	$767.84	$1,527.51	$4,065.90
Upside / Downside	0.63%	100.20%	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.62	7,393.04	7,462.46
Year 2 PV (M)	9,349.87	9,527.96	9,707.73
Year 3 PV (M)	11,288.42	11,612.47	11,942.66
Year 4 PV (M)	13,142.04	13,647.44	14,167.29
Year 5 PV (M)	14,913.43	15,633.75	16,381.64
PV of Terminal Value (M)	332,562.24	348,625.12	365,302.76
Equity Value (M)	388,579.62	406,439.78	424,964.55
Shares Outstanding (M)	900.59	900.59	900.59
Fair Value	$431.47	$451.30	$471.87
Upside / Downside	-43.45%	-40.85%	-38.16%

High-Yield Dividend Screener

US Stocks Global Stocks

« Prev Page 70 of 151 Next »

Ticker ⇵	Company ⇵	Dividend Yield % ▼	Dividend Per Share ⇵	Payout Ratio % ⇵
6101.T	Tsugami Corporation	2.08%	$59.70	21.18%
9549.SR	Abdulaziz and Mansour Ibrahim Albabtin Co.	2.08%	$0.50	29.71%
FPAR-A.ST	FastPartner AB (publ)	2.08%	$0.97	55.03%
GRNG.ST	Gränges AB (publ)	2.08%	$3.09	34.78%
ZGN	Ermenegildo Zegna N.V.	2.08%	$0.22	28.26%
000983.SZ	Shanxi Coking Coal Energy Group Co.,Ltd.	2.07%	$0.13	44.44%
006090.KS	Oyang Corporation	2.07%	$187.55	43.67%
0O1O.L	Vetoquinol S.A.	2.07%	$1.74	19.10%
1748.HK	Xin Yuan Enterprises Group Limited	2.07%	$0.04	62.70%
4677.KL	YTL Corporation Berhad	2.07%	$0.04	26.42%
603136.SS	Jiangsu Tianmu Lake Tourism Co.,Ltd	2.07%	$0.24	64.23%
7965.T	Zojirushi Corporation	2.07%	$32.35	36.35%
MRSA3B.SA	MRS Logística S.A.	2.07%	$0.81	18.86%
OCL.AX	Objective Corporation Limited	2.07%	$0.34	57.76%
TRTN	Triton International Limited	2.07%	$1.65	28.50%
001219.SZ	Qingdao Foods CO.,LTD.	2.06%	$0.29	55.25%
002351.SZ	Edifier Technology Co., Ltd.	2.06%	$0.25	53.80%
004830.KS	Duksung Co., Ltd.	2.06%	$100.30	19.66%
600120.SS	Zhejiang Orient Financial Holdings Group Co., Ltd.	2.06%	$0.13	32.28%
600143.SS	Kingfa Sci. & Tech. Co., Ltd.	2.06%	$0.40	85.82%
7735.T	SCREEN Holdings Co., Ltd.	2.06%	$314.43	32.13%
ALSO3.SA	Aliansce Sonae Shopping Centers S.A.	2.06%	$0.52	9.27%
MLIA.JK	PT Mulia Industrindo Tbk	2.06%	$6.98	27.72%
REA.AX	REA Group Limited	2.06%	$3.81	51.46%
THEON.AS	Theon International PLC	2.06%	$0.55	52.53%
000902.SZ	YONFER Agricultural Technology Co., Ltd.	2.05%	$0.32	26.06%
002938.SZ	Avary Holding(Shenzhen)Co., Limited	2.05%	$1.04	59.37%
036930.KQ	JUSUNG ENGINEERING Co., Ltd.	2.05%	$625.50	45.79%
086280.KS	Hyundai Glovis Co., Ltd.	2.05%	$3,700.10	19.97%
2730.T	EDION Corporation	2.05%	$43.41	30.64%
4191.SR	Abdullah Saad Mohammed Abo Moati for Bookstores Company	2.05%	$1.01	76.56%
9527.SR	Ame Company For Medical Supplies	2.05%	$2.00	27.73%
BMIN3.SA	Banco Mercantil de Investimentos S.A.	2.05%	$0.47	28.32%
GUAR3.SA	Guararapes Confecções S.A.	2.05%	$0.18	20.09%
MGROS.IS	Migros Ticaret A.S.	2.05%	$10.88	31.41%
MLL.DE	Müller - Die lila Logistik AG	2.05%	$0.10	6.76%
RAY-A.TO	Stingray Group Inc.	2.05%	$0.30	39.32%
VIVA3.SA	Vivara Participações S.A.	2.05%	$0.66	20.93%
268280.KS	Miwon Specialty Chemical Co., Ltd.	2.04%	$2,814.57	22.79%
2869.HK	Greentown Service Group Co. Ltd.	2.04%	$0.09	17.96%
450330.KQ	Hass	2.04%	$131.79	35.27%
605589.SS	Jinan Shengquan Group Share Holding Co., Ltd.	2.04%	$0.58	44.86%
CEK.DE	CeoTronics AG	2.04%	$0.26	34.71%
CSAP.JK	PT Catur Sentosa Adiprana Tbk	2.04%	$6.50	30.53%
ROTH.PA	Rothschild & Co SCA	2.04%	$0.78	13.71%
2476.TW	G-SHANK Enterprise Co., Ltd.	2.03%	$1.85	49.48%
2852.KL	Cahya Mata Sarawak Berhad	2.03%	$0.03	28.80%
3788.HK	China Hanking Holdings Limited	2.03%	$0.08	36.16%
4004.SR	Dallah Healthcare Company	2.03%	$2.54	49.37%
601607.SS	Shanghai Pharmaceuticals Holding Co., Ltd	2.03%	$0.36	23.77%

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