DDM Analysis: FIBRAMQ12.MX

Valuation Snapshot

Stable Growth	$410.55 - $1,090.36	$1,021.83
Multi-Stage	$155.08 - $169.71	$162.26
Blended Fair Value	$592.04
Current Price	$30.04
Upside	1,870.85%
Decision	Buy

Dividend History & Growth Metrics (10Y)

Metric	5Y CAGR	10Y CAGR	2024	2023	2022	2021	2020	2019	2018	2017	2016	2015
DPS	16.96%	6.51%	2.70	2.80	1.86	1.81	1.78	1.23	1.54	1.59	1.81	1.55
YoY Growth	-	-	-3.46%	50.20%	2.61%	1.88%	44.36%	-19.96%	-2.99%	-12.28%	16.99%	7.72%
Dividend Yield	-	-	8.93%	8.52%	6.51%	7.62%	6.99%	6.26%	7.17%	8.14%	8.65%	7.09%

Stable Growth Model (Adjusted)

(USD in Millions except Per Share Data)

Net Income To Common (M)	4,371.36
(-) Cash Dividends Paid (M)	1,744.12
(=) Cash Retained (M)	2,627.24

Metric	LOW	BASE	HIGH
Required Retention Ratio	20.0%	12.5%	7.5%
(=) Cash Required (M)	874.27	546.42	327.85
Cash Retained (M)	2,627.24	2,627.24	2,627.24
(-) Cash Required (M)	-874.27	-546.42	-327.85
(=) Excess Retained (M)	1,752.97	2,080.82	2,299.39
(/) Shares Outstanding (M)	797.31	797.31	797.31
(=) Excess Retained per Share	2.20	2.61	2.88
LTM Dividend per Share	2.19	2.19	2.19
(+) Excess Retained per Share	2.20	2.61	2.88
(=) Adjusted Dividend	4.39	4.80	5.07
WACC / Discount Rate	6.63%	6.63%	6.63%
Growth Rate	5.50%	6.50%	7.50%
Fair Value	$410.55	$1,021.83	$1,090.36
Upside / Downside	1,266.67%	3,301.55%	3,529.69%

Multi-Stage Model: Projections

(USD in Millions)

Metric	TTM	Dec-27	Dec-28	Dec-29	Dec-30	Dec-31	Terminal
Net Income (M)	4,371.36	4,655.50	4,958.11	5,280.38	5,623.61	5,989.14	6,168.82
Payout Ratio	39.90%	49.92%	59.94%	69.96%	79.98%	90.00%	92.50%
Projected Dividends (M)	1,744.12	2,323.98	2,971.85	3,694.13	4,497.75	5,390.23	5,706.16

Multi-Stage Valuation

Metric	LOW	BASE	HIGH
WACC / Discount Rate	6.63%	6.63%	6.63%
Growth Rate	5.50%	6.50%	7.50%
Year 1 PV (M)	2,159.07	2,179.54	2,200.00
Year 2 PV (M)	2,565.06	2,613.92	2,663.24
Year 3 PV (M)	2,962.22	3,047.26	3,133.90
Year 4 PV (M)	3,350.70	3,479.56	3,612.10
Year 5 PV (M)	3,730.64	3,910.83	4,097.92
PV of Terminal Value (M)	108,882.47	114,141.54	119,601.88
Equity Value (M)	123,650.17	129,372.64	135,309.04
Shares Outstanding (M)	797.31	797.31	797.31
Fair Value	$155.08	$162.26	$169.71
Upside / Downside	416.26%	440.15%	464.94%

High-Yield Dividend Screener

US Stocks Global Stocks

« Prev Page 90 of 151 Next »

Ticker ⇵	Company ⇵	Dividend Yield % ▼	Dividend Per Share ⇵	Payout Ratio % ⇵
688267.SS	China Catalyst Holding Co., Ltd.	1.26%	$0.35	34.87%
8848.T	Leopalace21 Corporation	1.26%	$8.31	27.11%
BAUH4.SA	Excelsior Alimentos S.A.	1.26%	$1.17	21.88%
CAST.ST	Castellum AB (publ)	1.26%	$1.33	21.53%
CRH	CRH plc	1.26%	$1.60	33.62%
HBEL.BO	Humming Bird Education Limited	1.26%	$0.30	36.54%
JCI	Johnson Controls International plc	1.26%	$1.54	56.71%
KOG.OL	Kongsberg Gruppen ASA	1.26%	$3.40	42.40%
OEM-B.ST	OEM International AB (publ)	1.26%	$1.74	40.26%
SAREGAMA.BO	Saregama India Limited	1.26%	$4.51	42.77%
SDPC.JK	PT Millennium Pharmacon International Tbk	1.26%	$2.00	15.16%
002448.SZ	ZYNP Corporation	1.25%	$0.16	32.06%
0QLU.L	Basler Kantonalbank	1.25%	$1.11	12.42%
145720.KS	Dentium Co. Ltd.	1.25%	$599.51	9.81%
204320.KS	Mando Corporation	1.25%	$820.37	29.46%
3684.TWO	Grand-Tek Technology Co., Ltd.	1.25%	$0.80	29.94%
5819.KL	Hong Leong Bank Berhad	1.25%	$0.28	13.43%
600633.SS	Zhejiang Daily Digital Culture Group Co.,Ltd.	1.25%	$0.16	35.54%
600850.SS	CETC Digital Technology Co.,Ltd.	1.25%	$0.37	49.83%
603329.SS	Shanghai Ace Investment & Development Co., Ltd.	1.25%	$0.14	79.14%
603920.SS	Olympic Circuit Technology Co., Ltd	1.25%	$0.61	53.40%
6632.T	JVCKENWOOD Corporation	1.25%	$15.03	12.26%
9717.T	JASTEC Co., Ltd.	1.25%	$24.25	22.00%
9719.T	SCSK Corporation	1.25%	$70.95	36.13%
ENTER.AT	Entersoft S.A.	1.25%	$0.10	20.30%
ETN	Eaton Corporation plc	1.25%	$4.08	40.54%
IRFC.BO	Indian Railway Finance Corporation Limited	1.25%	$1.60	30.59%
LVC.WA	LiveChat Software S.A.	1.25%	$1.46	20.71%
ORSTED.CO	Ørsted A/S	1.25%	$1.60	10.19%
000514.SZ	Chongqing Yukaifa Co., Ltd	1.24%	$0.06	55.20%
002346.SZ	Shanghai Zhezhong Group Co.,Ltd	1.24%	$0.25	18.48%
002748.SZ	Jiangxi Selon Industrial Co., Ltd.	1.24%	$0.16	89.09%
1976.T	MEISEI INDUSTRIAL Co.,Ltd.	1.24%	$21.03	12.53%
300763.SZ	Ginlong Technologies Co., Ltd.	1.24%	$0.88	39.17%
600871.SS	Sinopec Oilfield Service Corporation	1.24%	$0.03	81.02%
603585.SS	Suli Co., Ltd.	1.24%	$0.23	35.70%
605116.SS	Aurisco Pharmaceutical Co.,Ltd.	1.24%	$0.31	29.49%
ALWED.PA	Wedia S.A.	1.24%	$0.38	21.38%
MNC.WA	Mennica Polska S.A.	1.24%	$0.60	6.22%
MTHH.CO	MT Højgaard Holding A/S	1.24%	$6.49	19.74%
WALL-B.ST	Wallenstam AB (publ)	1.24%	$0.51	17.40%
WRT1V.HE	Wärtsilä Oyj Abp	1.24%	$0.38	40.46%
041830.KQ	InBody Co.,Ltd	1.23%	$400.00	16.47%
0QHK.L	SeSa S.p.A.	1.23%	$1.12	27.54%
0Y5C.L	Allegion plc	1.23%	$1.99	26.83%
300726.SZ	Zhuzhou Hongda Electronics Corp.,Ltd.	1.23%	$0.63	74.98%
300916.SZ	Shenzhen Longtech Smart Control Co., Ltd.	1.23%	$0.40	42.79%
4148.TW	All Cosmos Bio-Tech Holding Corporation	1.23%	$0.48	23.21%
544.SI	CSE Global Limited	1.23%	$0.01	26.84%
600104.SS	SAIC Motor Corporation Limited	1.23%	$0.19	75.02%

Financial Statements

Fundamentals

Valuations

Miscellaneous

Mode

Ticker

Industry

Sector

FIBRA Macquarie México (FIBRAMQ12.MX)

Valuation Snapshot

Dividend History & Growth Metrics (10Y)

Stable Growth Model (Adjusted)

Multi-Stage Model: Projections

Multi-Stage Valuation

High-Yield Dividend Screener