DDM Analysis: MEGACPO.MX

Valuation Snapshot

Stable Growth	$50.44 - $100.84	$70.08
Multi-Stage	$40.02 - $43.79	$41.87
Blended Fair Value	$55.98
Current Price	$52.51
Upside	6.60%
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	6.63%	0.00%	3.08	2.96	2.98	2.67	1.89	2.23	1.85	1.73	1.36	1.14
YoY Growth	-	-	4.16%	-0.81%	11.48%	41.74%	-15.58%	20.50%	7.10%	27.14%	19.30%	0.00%
Dividend Yield	-	-	7.20%	6.07%	6.47%	4.46%	2.58%	3.44%	2.05%	2.09%	1.88%	1.59%

Stable Growth Model (Adjusted)

(USD in Millions except Per Share Data)

Net Income To Common (M)	2,514.98
(-) Cash Dividends Paid (M)	6.71
(=) Cash Retained (M)	2,508.27

Metric	LOW	BASE	HIGH
Required Retention Ratio	20.0%	12.5%	7.5%
(=) Cash Required (M)	503.00	314.37	188.62
Cash Retained (M)	2,508.27	2,508.27	2,508.27
(-) Cash Required (M)	-503.00	-314.37	-188.62
(=) Excess Retained (M)	2,005.28	2,193.90	2,319.65
(/) Shares Outstanding (M)	858.48	858.48	858.48
(=) Excess Retained per Share	2.34	2.56	2.70
LTM Dividend per Share	0.01	0.01	0.01
(+) Excess Retained per Share	2.34	2.56	2.70
(=) Adjusted Dividend	2.34	2.56	2.71
WACC / Discount Rate	9.68%	9.68%	9.68%
Growth Rate	4.81%	5.81%	6.81%
Fair Value	$50.44	$70.08	$100.84
Upside / Downside	-3.95%	33.46%	92.04%

Multi-Stage Model: Projections

(USD in Millions)

Metric	TTM	Dec-27	Dec-28	Dec-29	Dec-30	Dec-31	Terminal
Net Income (M)	2,514.98	2,661.09	2,815.69	2,979.28	3,152.36	3,335.50	3,435.57
Payout Ratio	0.27%	18.21%	36.16%	54.11%	72.05%	90.00%	92.50%
Projected Dividends (M)	6.71	484.67	1,018.16	1,611.99	2,271.38	3,001.95	3,177.90

Multi-Stage Valuation

Metric	LOW	BASE	HIGH
WACC / Discount Rate	9.68%	9.68%	9.68%
Growth Rate	4.81%	5.81%	6.81%
Year 1 PV (M)	437.72	441.90	446.08
Year 2 PV (M)	830.45	846.37	862.44
Year 3 PV (M)	1,187.43	1,221.74	1,256.71
Year 4 PV (M)	1,511.07	1,569.57	1,629.76
Year 5 PV (M)	1,803.63	1,891.33	1,982.41
PV of Terminal Value (M)	28,583.38	29,973.24	31,416.64
Equity Value (M)	34,353.69	35,944.16	37,594.04
Shares Outstanding (M)	858.48	858.48	858.48
Fair Value	$40.02	$41.87	$43.79
Upside / Downside	-23.79%	-20.26%	-16.60%

High-Yield Dividend Screener

US Stocks Global Stocks

« Prev Page 13 of 30 Next »

Ticker ⇵	Company ⇵	Dividend Yield % ▼	Dividend Per Share ⇵	Payout Ratio % ⇵
CL	Colgate-Palmolive Company	2.88%	$2.24	62.40%
TCBK	TriCo Bancshares	2.87%	$1.35	37.83%
0U6R.L	Bunge Limited	2.86%	$3.05	31.37%
FBMS	The First Bancshares, Inc.	2.86%	$0.97	39.72%
RILYG	B. Riley Financial, Inc. 5.00% Senior Notes due 2026	2.86%	$0.58	56.91%
CNS	Cohen & Steers, Inc.	2.85%	$1.81	56.91%
MRBK	Meridian Corporation	2.85%	$0.49	27.85%
AMGN	Amgen Inc.	2.84%	$9.31	72.03%
BKH	Black Hills Corporation	2.84%	$1.98	50.60%
GABC	German American Bancorp, Inc.	2.84%	$1.11	40.35%
HOMB	Home Bancshares, Inc.	2.84%	$0.79	34.17%
KO	The Coca-Cola Company	2.84%	$1.96	65.04%
SBFG	SB Financial Group, Inc.	2.84%	$0.61	28.02%
TSBK	Timberland Bancorp, Inc.	2.84%	$1.00	27.24%
CATY	Cathay General Bancorp	2.83%	$1.38	31.20%
CWT	California Water Service Group	2.83%	$1.22	53.25%
EBIX	Ebix, Inc.	2.83%	$0.08	46.85%
CMS-PB	Consumers Energy Company	2.82%	$2.17	62.27%
EPRT	Essential Properties Realty Trust, Inc.	2.82%	$0.85	70.58%
GPK	Graphic Packaging Holding Company	2.82%	$0.43	24.85%
VALSX	Value Line Select Growth Fund	2.82%	$0.87	56.29%
CCNE	CNB Financial Corporation	2.81%	$0.72	35.05%
ORRF	Orrstown Financial Services, Inc.	2.81%	$0.98	26.05%
TXNM	TXNM Energy, Inc.	2.80%	$1.65	86.75%
STC	Stewart Information Services Corporation	2.79%	$1.95	54.56%
CVLY	Codorus Valley Bancorp, Inc.	2.77%	$0.67	28.98%
KKRS	KKR Group Finance Co. IX LLC 4.	2.77%	$0.49	7.61%
SHBI	Shore Bancshares, Inc.	2.77%	$0.48	28.28%
HNNA	Hennessy Advisors, Inc.	2.76%	$0.27	21.11%
HONE	HarborOne Bancorp, Inc.	2.76%	$0.33	51.05%
KMT	Kennametal Inc.	2.76%	$0.80	65.12%
PNM	PNM Resources, Inc.	2.76%	$1.12	57.65%
HWC	Hancock Whitney Corporation	2.75%	$1.77	31.35%
YOU	Clear Secure, Inc.	2.75%	$0.95	50.89%
0HE2.L	Ameren Corporation	2.74%	$2.78	53.51%
MTDR	Matador Resources Company	2.74%	$1.19	18.96%
OFG	OFG Bancorp	2.74%	$1.12	25.13%
VLO	Valero Energy Corporation	2.74%	$4.53	93.65%
YORW	The York Water Company	2.73%	$0.87	62.37%
CCZ	Comcast Holdings Corp.	2.72%	$1.63	26.92%
K	Kellanova	2.72%	$2.27	62.18%
ADT	ADT Inc.	2.71%	$0.22	29.95%
AVT	Avnet, Inc.	2.71%	$1.34	48.46%
BKU	BankUnited, Inc.	2.71%	$1.21	34.19%
CNOB	ConnectOne Bancorp, Inc.	2.71%	$0.71	48.64%
GBX	The Greenbrier Companies, Inc.	2.71%	$1.28	19.40%
PBHC	Pathfinder Bancorp, Inc.	2.71%	$0.38	26.39%
TRIN	Trinity Capital Inc.	2.71%	$0.41	20.50%
RILYN	B. Riley Financial, Inc. - 6.50	2.70%	$0.58	56.91%
0L5A.L	Sempra	2.69%	$2.41	72.79%

Financial Statements

Fundamentals

Valuations

Miscellaneous

Mode

Ticker

Industry

Sector

Megacable Holdings, S. A. B. de C. V. (MEGACPO.MX)

Valuation Snapshot

Dividend History & Growth Metrics (10Y)

Stable Growth Model (Adjusted)

Multi-Stage Model: Projections

Multi-Stage Valuation

High-Yield Dividend Screener