DDM Analysis: CHDRAUIB.MX

Valuation Snapshot

Stable Growth	$503.46 - $1,324.24	$1,241.01
Multi-Stage	$185.79 - $203.48	$194.47
Blended Fair Value	$717.74
Current Price	$149.00
Upside	381.70%
Decision	Buy

Dividend History & Growth Metrics (10Y)

Metric	5Y CAGR	10Y CAGR	2024	2023	2022	2021	2020	2019	2018	2017	2016	2015
DPS	23.75%	0.00%	1.18	0.93	0.52	0.48	0.45	0.41	0.39	0.33	0.26	0.25
YoY Growth	-	-	26.82%	78.22%	10.00%	7.01%	9.09%	4.14%	18.40%	29.26%	2.12%	0.00%
Dividend Yield	-	-	1.03%	0.70%	0.51%	0.93%	1.38%	1.63%	1.01%	0.86%	0.63%	0.46%

Stable Growth Model (Adjusted)

(USD in Millions except Per Share Data)

Net Income To Common (M)	6,401.56
(-) Cash Dividends Paid (M)	1,006.04
(=) Cash Retained (M)	5,395.52

Metric	LOW	BASE	HIGH
Required Retention Ratio	20.0%	12.5%	7.5%
(=) Cash Required (M)	1,280.31	800.20	480.12
Cash Retained (M)	5,395.52	5,395.52	5,395.52
(-) Cash Required (M)	-1,280.31	-800.20	-480.12
(=) Excess Retained (M)	4,115.21	4,595.32	4,915.40
(/) Shares Outstanding (M)	961.39	961.39	961.39
(=) Excess Retained per Share	4.28	4.78	5.11
LTM Dividend per Share	1.05	1.05	1.05
(+) Excess Retained per Share	4.28	4.78	5.11
(=) Adjusted Dividend	5.33	5.83	6.16
WACC / Discount Rate	6.62%	6.62%	6.62%
Growth Rate	5.50%	6.50%	7.50%
Fair Value	$503.46	$1,241.01	$1,324.24
Upside / Downside	237.90%	732.89%	788.75%

Multi-Stage Model: Projections

(USD in Millions)

Metric	TTM	Dec-27	Dec-28	Dec-29	Dec-30	Dec-31	Terminal
Net Income (M)	6,401.56	6,817.67	7,260.81	7,732.77	8,235.40	8,770.70	9,033.82
Payout Ratio	15.72%	30.57%	45.43%	60.29%	75.14%	90.00%	92.50%
Projected Dividends (M)	1,006.04	2,084.33	3,298.54	4,661.79	6,188.33	7,893.63	8,356.28

Multi-Stage Valuation

Metric	LOW	BASE	HIGH
WACC / Discount Rate	6.62%	6.62%	6.62%
Growth Rate	5.50%	6.50%	7.50%
Year 1 PV (M)	1,936.63	1,954.98	1,973.34
Year 2 PV (M)	2,847.61	2,901.85	2,956.60
Year 3 PV (M)	3,739.31	3,846.65	3,956.03
Year 4 PV (M)	4,612.02	4,789.39	4,971.82
Year 5 PV (M)	5,466.05	5,730.07	6,004.18
PV of Terminal Value (M)	160,011.94	167,740.58	175,765.01
Equity Value (M)	178,613.57	186,963.52	195,626.99
Shares Outstanding (M)	961.39	961.39	961.39
Fair Value	$185.79	$194.47	$203.48
Upside / Downside	24.69%	30.52%	36.57%

High-Yield Dividend Screener

US Stocks Global Stocks

« Prev Page 15 of 30 Next »

Ticker ⇵	Company ⇵	Dividend Yield % ▼	Dividend Per Share ⇵	Payout Ratio % ⇵
0R28.L	Newmont Corporation	2.49%	$1.01	15.53%
ETR	Entergy Corporation	2.49%	$2.34	57.35%
NKE	NIKE, Inc.	2.49%	$1.58	80.59%
OTTR	Otter Tail Corporation	2.49%	$2.03	30.69%
FHN	First Horizon Corporation	2.48%	$0.60	34.42%
PWP	Perella Weinberg Partners	2.48%	$0.44	69.65%
SCS	Steelcase Inc.	2.48%	$0.40	50.05%
PBI	Pitney Bowes Inc.	2.46%	$0.25	61.37%
RBCAA	Republic Bancorp, Inc.	2.45%	$1.67	25.85%
SRCE	1st Source Corporation	2.45%	$1.53	25.20%
TRMK	Trustmark Corporation	2.45%	$0.96	26.11%
VOYA	Voya Financial, Inc.	2.45%	$1.86	29.46%
AWK	American Water Works Company, Inc.	2.44%	$3.18	55.85%
LSTR	Landstar System, Inc.	2.44%	$3.58	90.21%
NGL	NGL Energy Partners LP	2.44%	$0.24	24.52%
TCFC	The Community Financial Corporation	2.44%	$0.66	12.72%
CADE	Cadence Bank	2.43%	$1.05	37.49%
JNJ	Johnson & Johnson	2.43%	$5.04	48.70%
MBCN	Middlefield Banc Corp.	2.43%	$0.83	42.36%
0L7G.L	Snap-on Incorporated	2.42%	$8.43	44.15%
ITW	Illinois Tool Works Inc.	2.42%	$6.04	58.20%
MOFG	MidWestOne Financial Group, Inc.	2.40%	$0.92	32.44%
FFIN	First Financial Bankshares, Inc.	2.39%	$0.72	42.45%
ADP	Automatic Data Processing, Inc.	2.38%	$6.03	59.30%
CAL	Caleres, Inc.	2.38%	$0.29	46.21%
ABM	ABM Industries Incorporated	2.37%	$1.01	54.79%
FUNC	First United Corporation	2.36%	$0.88	22.87%
HON	Honeywell International Inc.	2.36%	$4.63	48.21%
RILYK	B. Riley Financial, Inc. 5.50% Senior Notes Due 2026	2.36%	$0.58	56.91%
CDW	CDW Corporation	2.35%	$3.14	39.31%
CHMG	Chemung Financial Corporation	2.35%	$1.28	46.47%
LZB	La-Z-Boy Incorporated	2.35%	$0.88	40.20%
PKG	Packaging Corporation of America	2.35%	$4.97	50.31%
UNP	Union Pacific Corporation	2.35%	$5.44	45.77%
0K91.L	Northern Trust Corporation	2.34%	$3.20	35.68%
MCD	McDonald's Corporation	2.33%	$7.07	60.14%
MGEE	MGE Energy, Inc.	2.32%	$1.82	49.49%
MZTI	The Marzetti Company	2.32%	$3.82	61.80%
UNM	Unum Group	2.32%	$1.79	33.52%
RILYM	B. Riley Financial, Inc. - 6.37	2.31%	$0.58	56.91%
RILYO	B. Riley Financial, Inc. - 6.75	2.31%	$0.58	56.91%
HONIV	Honeywell International Inc. Common Stock Ex Distribution When Issued	2.30%	$4.63	48.21%
PGR	The Progressive Corporation	2.30%	$4.88	26.80%
WNEB	Western New England Bancorp, Inc.	2.30%	$0.28	43.00%
0R23.L	Halliburton Company	2.29%	$0.68	44.61%
ADS	Bread Financial Holdings, Inc.	2.29%	$1.30	21.08%
HLNE	Hamilton Lane Incorporated	2.29%	$3.13	74.09%
BSVN	Bank7 Corp.	2.28%	$0.94	20.81%
MCBC	Macatawa Bank Corporation	2.28%	$0.34	28.37%
BRKL	Brookline Bancorp, Inc.	2.27%	$0.54	61.06%

Financial Statements

Fundamentals

Valuations

Miscellaneous

Mode

Ticker

Industry

Sector

Grupo Comercial Chedraui, S.A.B. de C.V. (CHDRAUIB.MX)

Valuation Snapshot

Dividend History & Growth Metrics (10Y)

Stable Growth Model (Adjusted)

Multi-Stage Model: Projections

Multi-Stage Valuation

High-Yield Dividend Screener