DDM Analysis: FIBRAMQ12.MX

Valuation Snapshot

Stable Growth	$410.47 - $1,090.36	$1,021.83
Multi-Stage	$155.08 - $169.70	$162.25
Blended Fair Value	$592.04
Current Price	$30.04
Upside	1,870.83%
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.47	$1,021.83	$1,090.36
Upside / Downside	1,266.42%	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.53	2,200.00
Year 2 PV (M)	2,565.05	2,613.91	2,663.23
Year 3 PV (M)	2,962.21	3,047.24	3,133.89
Year 4 PV (M)	3,350.68	3,479.53	3,612.07
Year 5 PV (M)	3,730.60	3,910.79	4,097.88
PV of Terminal Value (M)	108,875.42	114,134.14	119,594.13
Equity Value (M)	123,643.02	129,365.15	135,301.19
Shares Outstanding (M)	797.31	797.31	797.31
Fair Value	$155.08	$162.25	$169.70
Upside / Downside	416.23%	440.12%	464.90%

High-Yield Dividend Screener

US Stocks Global Stocks

« Prev Page 63 of 151 Next »

Ticker ⇵	Company ⇵	Dividend Yield % ▼	Dividend Per Share ⇵	Payout Ratio % ⇵
112610.KS	CS Wind Corporation	2.43%	$982.89	21.73%
300452.SZ	Anhui Sunhere Pharmaceutical Excipients Co.,Ltd.	2.43%	$0.33	58.46%
603599.SS	Anhui Guangxin Agrochemical Co., Ltd.	2.43%	$0.28	35.02%
605286.SS	Jiangsu Tongli Risheng Machinery Co., Ltd.	2.43%	$0.99	75.51%
9569.SR	Almuneef Company for Trade, Industry, Agriculture and Contracting	2.43%	$0.20	19.26%
ALV	Autoliv, Inc.	2.43%	$2.97	30.32%
KEPEN.AT	Flour Mills Kepenos S.A.	2.43%	$0.05	39.82%
MSAB-B.ST	Micro Systemation AB (publ)	2.43%	$1.50	65.33%
NEOE3.SA	Neoenergia S.A.	2.43%	$0.77	21.26%
OV8.SI	Sheng Siong Group Ltd	2.43%	$0.06	66.54%
VIL.PA	VIEL & Cie, S.A.	2.43%	$0.40	12.44%
002236.SZ	Zhejiang Dahua Technology Co., Ltd.	2.42%	$0.46	38.43%
006730.KQ	Seobu T&D Co., Ltd.	2.42%	$309.73	27.66%
071050.KS	Korea Investment Holdings Co., Ltd.	2.42%	$3,984.93	13.09%
0DQK.L	Beter Bed Holding N.V.	2.42%	$0.15	53.98%
2409.TW	AUO Corporation	2.42%	$0.31	41.22%
300453.SZ	Jiangxi Sanxin Medtec Co.,Ltd.	2.42%	$0.21	45.08%
600064.SS	Nanjing Gaoke Company Limited	2.42%	$0.21	15.60%
601236.SS	Hongta Securities Co., Ltd.	2.42%	$0.20	95.69%
9550.SR	Sure Global Tech Company	2.42%	$1.52	28.67%
9562.SR	Foods Gate Trading Co.	2.42%	$0.67	13.40%
AEONTS-R.BK	AEON Thana Sinsap (Thailand) Public Company Limited	2.42%	$2.60	21.04%
NMAN.ST	Nederman Holding AB (publ)	2.42%	$4.00	47.45%
SALIK.AE	Salik Company P.J.S.C.	2.42%	$0.16	83.74%
SKMO.ST	Skåne-möllan AB (publ)	2.42%	$1.40	96.86%
001130.KS	Daehan Flour Mills Co.,Ltd	2.41%	$3,470.92	10.83%
080160.KQ	Modetour Network Inc.	2.41%	$249.37	24.80%
0U96.L	Everest Re Group, Ltd.	2.41%	$8.07	61.23%
3591.T	Wacoal Holdings Corp.	2.41%	$106.27	49.77%
601966.SS	Shandong Linglong Tyre Co.,Ltd.	2.41%	$0.35	42.43%
7951.T	Yamaha Corporation	2.41%	$26.35	66.95%
BORG.ST	Björn Borg AB (publ)	2.41%	$1.50	43.49%
EIOF.OL	Eidesvik Offshore ASA	2.41%	$0.30	28.32%
ETTE.HE	Etteplan Oyj	2.41%	$0.23	71.21%
ZZ-B.ST	Zinzino AB (publ)	2.41%	$3.76	58.64%
002968.SZ	New Dazheng Property Group Co., Ltd.	2.40%	$0.29	59.28%
0NZN.L	Robertet S.A.	2.40%	$21.10	23.60%
4015.SR	Jamjoom Pharmaceuticals Factory Company	2.40%	$3.46	54.14%
7703.TWO	Rayzher	2.40%	$5.49	59.71%
BBL.AX	Brisbane Broncos Limited	2.40%	$0.04	25.15%
002158.SZ	Shanghai Hanbell Precise Machinery Co., Ltd.	2.39%	$0.60	60.14%
004690.KS	Samchully Co.,Ltd	2.39%	$3,000.02	10.30%
0GVS.L	Catena AB (publ)	2.39%	$8.76	32.84%
300577.SZ	Anhui Korrun Co., Ltd.	2.39%	$0.51	36.22%
3044.TW	Tripod Technology Corporation	2.39%	$7.48	42.14%
603080.SS	Xinjiang Torch Gas Co., Ltd	2.39%	$0.57	43.55%
6780.TWO	Study King Co., Ltd.	2.39%	$0.80	89.60%
6804.T	Hosiden Corporation	2.39%	$59.44	25.81%
KBLM.JK	PT Kabelindo Murni Tbk	2.39%	$8.08	12.05%
SCANFL.HE	Scanfil Oyj	2.39%	$0.24	42.33%

Financial Statements

Fundamentals

Valuations

Miscellaneous

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