Definitive Analysis
Loading...
Definitive Analysis

Financial Statements

Ticker

Industry

Sector

FIBRA Macquarie México (FIBRAMQ12.MX)

Company Dividend Discount ModelIndustry: REIT - IndustrialSector: Real Estate

Valuation Snapshot

Stable Growth$410.44 - $1,090.36$1,021.83
Multi-Stage$155.07 - $169.69$162.25
Blended Fair Value$592.04
Current Price$30.04
Upside1,870.83%
DecisionBuy

Dividend History & Growth Metrics (10Y)

Metric5Y CAGR10Y CAGR2024202320222021202020192018201720162015
DPS16.96%6.51%2.702.801.861.811.781.231.541.591.811.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
MetricLOWBASEHIGH
Required Retention Ratio20.0%12.5%7.5%
(=) Cash Required (M)874.27546.42327.85
Cash Retained (M)2,627.242,627.242,627.24
(-) Cash Required (M)-874.27-546.42-327.85
(=) Excess Retained (M)1,752.972,080.822,299.39
(/) Shares Outstanding (M)797.31797.31797.31
(=) Excess Retained per Share2.202.612.88
LTM Dividend per Share2.192.192.19
(+) Excess Retained per Share2.202.612.88
(=) Adjusted Dividend4.394.805.07
WACC / Discount Rate6.63%6.63%6.63%
Growth Rate5.50%6.50%7.50%
Fair Value$410.44$1,021.83$1,090.36
Upside / Downside1,266.31%3,301.55%3,529.69%

Multi-Stage Model: Projections

(USD in Millions)
MetricTTMDec-27Dec-28Dec-29Dec-30Dec-31Terminal
Net Income (M)4,371.364,655.504,958.115,280.385,623.615,989.146,168.82
Payout Ratio39.90%49.92%59.94%69.96%79.98%90.00%92.50%
Projected Dividends (M)1,744.122,323.982,971.853,694.134,497.755,390.235,706.16

Multi-Stage Valuation

MetricLOWBASEHIGH
WACC / Discount Rate6.63%6.63%6.63%
Growth Rate5.50%6.50%7.50%
Year 1 PV (M)2,159.072,179.532,200.00
Year 2 PV (M)2,565.052,613.902,663.22
Year 3 PV (M)2,962.203,047.233,133.88
Year 4 PV (M)3,350.673,479.523,612.06
Year 5 PV (M)3,730.593,910.784,097.86
PV of Terminal Value (M)108,872.23114,130.80119,590.62
Equity Value (M)123,639.79129,361.76135,297.64
Shares Outstanding (M)797.31797.31797.31
Fair Value$155.07$162.25$169.69
Upside / Downside416.21%440.11%464.89%

High-Yield Dividend Screener

« Prev Page 81 of 151 Next »
Ticker Company Dividend Yield % Dividend Per Share Payout Ratio %
003003.SZGuangdong Tengen Industrial Group Co.,Ltd.1.60%$0.2158.54%
3026.KLDutch Lady Milk Industries Berhad1.60%$0.5028.77%
4380.TM - mart Inc.1.60%$20.8626.17%
5878.KLKPJ Healthcare Berhad1.60%$0.0454.29%
BUAH.JKPT Segar Kumala Indonesia Tbk1.60%$10.5034.44%
CBTT-B.STChristian Berner Tech Trade AB (publ)1.60%$0.6024.79%
SEER3.SASer Educacional S.A.1.60%$0.1517.88%
SPNSSapiens International Corporation N.V.1.60%$0.7061.01%
000963.SZHuadong Medicine Co., Ltd1.59%$0.6329.78%
002560.SZHenan Tong-Da Cable Co., Ltd.1.59%$0.1698.75%
002942.SZZhejiang XinNong Chemical Co.,Ltd.1.59%$0.3153.92%
016590.KSShindaeyang Paper Co., Ltd.1.59%$202.4828.25%
0J7X.LMBB SE1.59%$3.3332.74%
300957.SZYunnan Botanee Bio-Technology Group Co.LTD1.59%$0.6373.46%
366030.KQ09WOMEN Co., Ltd.1.59%$90.0829.50%
4736.TNippon RAD Inc.1.59%$9.9013.56%
600487.SSHengtong Optic-Electric Co., Ltd.1.59%$0.3933.97%
6201.TToyota Industries Corporation1.59%$283.1141.29%
688129.SSDonglai Coating Technology (Shanghai) Co., Ltd.1.59%$0.3241.19%
688312.SSShenzhen Yanmade Technology Inc.1.59%$0.5361.22%
688569.SSBeijing Tieke Shougang Rail Way-Tech Co., Ltd.1.59%$0.3543.76%
9324.TYasuda Logistics Corporation1.59%$34.9731.59%
ASSA-B.STASSA ABLOY AB (publ)1.59%$5.6642.81%
BEI-UN.TOBoardwalk Real Estate Investment Trust1.59%$1.0317.62%
DEPO.JKPT Caturkarda Depo Bangunan Tbk1.59%$4.2032.09%
DSNG.JKPT Dharma Satya Nusantara Tbk1.59%$24.0015.91%
F9D.SIBoustead Singapore Limited1.59%$0.0314.46%
OZL.AXOZ Minerals Limited1.59%$0.4555.76%
000920.SZVontron Technology Co., Ltd.1.58%$0.2038.51%
000960.SZYunnan Tin Company Limited1.58%$0.4438.02%
002340.SZGEM Co., Ltd.1.58%$0.1355.09%
300015.SZAier Eye Hospital Group Co., Ltd.1.58%$0.1749.80%
3925.TDouble Standard Inc.1.58%$27.4225.04%
4721.TWOMechema Chemicals International Corp.1.58%$1.1041.13%
603082.SSRIAMB (Beijing) Tech Dvlp Co1.58%$0.5857.18%
603289.SSZhejiang Tederic Machinery Co., Ltd.1.58%$0.1644.78%
603332.SSSuzhou Longjie Special Fiber Co., Ltd.1.58%$0.2287.52%
603993.SSCMOC Group Limited1.58%$0.3234.49%
7555.TOta Floriculture Auction Co.,Ltd.1.58%$11.8147.37%
ALPHA.ATAlpha Bank S.A.1.58%$0.0615.49%
OTP.BDOTP Bank Nyrt.1.58%$554.0413.23%
002550.SZChangzhou Qianhong Biopharma CO.,LTD1.57%$0.1235.18%
033530.KSSjg Sejong Co. Ltd.1.57%$162.926.60%
056190.KQSFA Engineering Corporation1.57%$380.3551.85%
300035.SZHunan Zhongke Electric Co., Ltd.1.57%$0.3343.86%
AGOAssured Guaranty Ltd.1.57%$1.4017.16%
CJA.FAlimentation Couche-Tard Inc.1.57%$0.5520.13%
MNIT.BKMFC-Nichada Thani Property Fund 21.57%$0.0321.78%
000573.SZDongGuan Winnerway Industry Zone Ltd.1.56%$0.0663.16%
000958.SZSPIC Industry-Finance Holdings Co., Ltd.1.56%$0.1060.59%