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 86 of 151 Next »
Ticker Company Dividend Yield % Dividend Per Share Payout Ratio %
LTMC.MILottomatica Group S.p.A.1.41%$0.3155.88%
002064.SZHuafon Chemical Co., Ltd.1.40%$0.1545.82%
002203.SZZhe Jiang Hai Liang Co., Ltd1.40%$0.1852.28%
002357.SZSichuan Fulin Transportation Group Co., Ltd.1.40%$0.1525.09%
300105.SZYanTai LongYuan Power Technology Co., Ltd.1.40%$0.1064.82%
4005.SRNational Medical Care Company1.40%$2.0028.58%
600517.SSState Grid Yingda Co.,Ltd.1.40%$0.0820.41%
CCL-A.TOCCL Industries Inc.1.40%$1.2527.03%
CGAUCenterra Gold Inc.1.40%$0.2012.28%
MHKI.JKMulti Hanna Kreasindo Tbk.1.40%$2.9229.72%
ROVIO.HERovio Entertainment Oyj1.40%$0.1342.86%
000750.SZSealand Securities Co., Ltd.1.39%$0.0639.70%
011210.KSHYUNDAI WIA Corporation1.39%$1,101.7920.24%
2610.HKNanshan Aluminium Intrnatnl Holdings Ltd1.39%$0.6969.79%
272290.KQINNOX Advanced Materials Co.,Ltd.1.39%$328.809.47%
301158.SZDezhou United Petroleum Technology Co.,Ltd.1.39%$0.3135.01%
600777.SSShandong Xinchao Energy Corporation Limited1.39%$0.0521.18%
603393.SSXinjiang Xintai Natural Gas Co., Ltd.1.39%$0.3714.02%
CLAS-B.STClas Ohlson AB (publ)1.39%$4.2228.54%
GMG.AXGoodman Group1.39%$0.4354.37%
LASP.COLån & Spar Bank A/S1.39%$20.0415.86%
000061.SZShenzhen Agricultural Products Group Co., Ltd.1.38%$0.1471.88%
002536.SZFeilong Auto Components Co., Ltd.1.38%$0.4167.28%
002797.SZFirst Capital Securities Co., Ltd.1.38%$0.0938.51%
2172.HKMicroPort NeuroTech Limited1.38%$0.1621.06%
600549.SSXiamen Tungsten Co., Ltd.1.38%$0.5642.55%
603203.SSQuick Intelligent Equipment Co., Ltd.1.38%$0.5151.54%
688597.SSBeijing Yupont Electric Power Technology Co., Ltd.1.38%$0.1138.03%
9422.TConexio Corporation1.38%$26.3532.61%
FESTI.ICFesti hf.1.38%$4.4930.70%
FSIFlexible Solutions International, Inc.1.38%$0.0927.13%
OMED.JKPT Jayamas Medica Industri Tbk1.38%$2.8823.51%
RY4C.DERyanair Holdings plc1.38%$0.4118.55%
SELIC.BKSelic Corp Public Company Limited1.38%$0.0417.06%
TALF.JKPT Tunas Alfin Tbk1.38%$8.0038.14%
YRM.MIRosetti Marino S.p.A.1.38%$4.0036.08%
000795.SZInnuovo Technology Co., Ltd.1.37%$0.1461.81%
001268.SZGuangdong Yangshan United Precision Manufacturing Co., Ltd.1.37%$0.4964.59%
600196.SSShanghai Fosun Pharmaceutical (Group) Co., Ltd.1.37%$0.3629.17%
603707.SSNanjing King-Friend Biochemical Pharmaceutical Co., Ltd1.37%$0.1230.81%
605222.SSShanghai QiFan Cable Co., Ltd1.37%$0.2569.76%
6782.TWVisco Vision Inc.1.37%$2.3921.51%
LINLinde plc1.37%$5.8839.08%
RAY-B.STRaySearch Laboratories AB (publ)1.37%$3.0046.95%
SHAWGELTIN.BONarmada Gelatines Limited1.37%$5.0013.05%
006220.KSJeju Bank1.36%$156.0067.72%
2505.HKEDA Group Holdings Limited1.36%$0.028.61%
300207.SZSunwoda Electronic Co.,Ltd1.36%$0.3539.10%
300993.SZShandong Yuma Sun-shading Technology Corp., Ltd.1.36%$0.2035.95%
3794.KLMalayan Cement Berhad1.36%$0.1129.56%