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

Ticker ⇵	Company ⇵	Dividend Yield % ▼	Dividend Per Share ⇵	Payout Ratio % ⇵
QFBQ.QA	Lesha Bank L.L.C	2.69%	$0.05	32.62%
002442.SZ	Longxing Chemical Stock Co., Ltd.	2.68%	$0.17	99.79%
016800.KS	Fursys Inc.	2.68%	$1,200.17	30.47%
265520.KQ	Advanced Process Systems Corporation	2.68%	$538.10	30.22%
300896.SZ	Imeik Technology Development Co.,Ltd.	2.68%	$3.80	78.17%
3123.T	Saibo Co., Ltd.	2.68%	$16.14	26.87%
9057.T	Enshu Truck Co.,Ltd.	2.68%	$96.08	31.06%
CHC.AX	Charter Hall Group	2.68%	$0.65	53.83%
IFT.AX	Infratil Limited	2.68%	$0.26	47.86%
KRZ.IR	Kerry Group plc	2.68%	$2.04	27.68%
MGH.AX	MAAS Group Holdings Limited	2.68%	$0.15	37.02%
NOA	North American Construction Group Ltd.	2.68%	$0.39	32.95%
U06.SI	Singapore Land Group Limited	2.68%	$0.09	24.45%
000089.SZ	Shenzhen Airport Co., Ltd.	2.67%	$0.19	65.57%
000830.SZ	Luxi Chemical Group Co., Ltd.	2.67%	$0.44	57.18%
005820.KS	Wonlim Corporation	2.67%	$399.88	22.01%
007980.KS	TP Inc.	2.67%	$51.62	7.46%
049800.KS	Woojin Plaimm Co., Ltd.	2.67%	$50.67	26.03%
300009.SZ	Anhui Anke Biotechnology (Group) Co., Ltd.	2.67%	$0.26	62.51%
6220.TWO	YFC-Boneagle Electric Co., Ltd.	2.67%	$0.69	89.25%
002753.SZ	Shanxi Yongdong Chemistry Industry Co., Ltd.	2.66%	$0.19	90.03%
011200.KS	HMM Co.,Ltd	2.66%	$537.67	22.84%
014830.KS	UNID Company Ltd.	2.66%	$1,782.26	16.95%
023450.KS	Dongnam Chemical Co., Ltd.	2.66%	$914.85	45.96%
210540.KS	DY Power Corporation	2.66%	$350.13	14.53%
600729.SS	Chongqing Department Store Co.,Ltd.	2.66%	$0.69	21.76%
7282.T	Toyoda Gosei Co., Ltd.	2.66%	$104.88	29.11%
7989.T	Tachikawa Corporation	2.66%	$52.44	33.02%
9699.T	Nishio Rent All Co., Ltd.	2.66%	$125.96	28.89%
069730.KS	DSR Wire Corp	2.65%	$99.93	6.22%
118990.KQ	Motrex Co., Ltd	2.65%	$249.25	35.67%
OLGERD.IC	Ölgerðin Egill Skallagrímsson hf.	2.65%	$0.48	62.79%
084010.KS	Daehan Steel Co., Ltd.	2.64%	$516.54	29.55%
0DH7.L	AF Gruppen ASA	2.64%	$4.97	52.35%
1504.TW	TECO Electric & Machinery Co., Ltd.	2.64%	$2.23	87.91%
2587.T	Suntory Beverage & Food Limited	2.64%	$125.00	45.12%
6922.TWO	Neousys Technology Inc.	2.64%	$4.54	61.30%
SHR.BK	S Hotels and Resorts Public Company Limited	2.64%	$0.05	33.96%
002871.SZ	Qingdao Weflo Valve Co., Ltd.	2.63%	$0.47	79.89%
600918.SS	Zhongtai Securities Co., Ltd.	2.63%	$0.17	68.20%
8572.T	Acom Co., Ltd.	2.63%	$13.00	38.71%
LIAB.ST	Lindab International AB (publ)	2.63%	$5.40	76.19%
MYOR.JK	PT Mayora Indah Tbk	2.63%	$57.38	45.12%
002443.SZ	Zhejiang Kingland Pipeline and Technologies Co.,Ltd.	2.62%	$0.21	64.11%
039490.KS	Kiwoom Securities Co., Ltd.	2.62%	$7,904.33	20.30%
155660.KS	DSR Corp	2.62%	$100.15	11.70%
4263.SR	SAL Saudi Logistics Services Co	2.62%	$4.23	55.27%
AFK.OL	Arendals Fossekompani ASA	2.62%	$3.52	5.05%
INSTAL.ST	Instalco AB (publ)	2.62%	$0.68	65.47%
000048.SZ	Shenzhen Kingkey Smart Agriculture Times Co.,Ltd	2.61%	$0.46	58.98%

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