Definitive Analysis
Loading...
Definitive Analysis

Financial Statements

Mode

Ticker

Industry

Sector

FIBRA Macquarie México (FIBRAMQ12.MX)

Company Dividend Discount ModelIndustry: REIT - IndustrialSector: Real Estate

Valuation Snapshot

Stable Growth$247.58 - $1,090.36$587.91
Multi-Stage$127.62 - $139.55$133.47
Blended Fair Value$360.69
Current Price$30.04
Upside1,100.70%
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 Rate7.37%7.37%7.37%
Growth Rate5.50%6.50%7.50%
Fair Value$247.58$587.91$1,090.36
Upside / Downside724.17%1,857.09%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 Rate7.37%7.37%7.37%
Growth Rate5.50%6.50%7.50%
Year 1 PV (M)2,144.152,164.482,184.80
Year 2 PV (M)2,529.732,577.922,626.56
Year 3 PV (M)2,901.242,984.523,069.39
Year 4 PV (M)3,259.053,384.383,513.29
Year 5 PV (M)3,603.513,777.573,958.28
PV of Terminal Value (M)87,312.7791,530.0195,908.65
Equity Value (M)101,750.45106,418.87111,260.97
Shares Outstanding (M)797.31797.31797.31
Fair Value$127.62$133.47$139.55
Upside / Downside324.82%344.31%364.53%

High-Yield Dividend Screener

« Prev Page 139 of 151 Next »
Ticker Company Dividend Yield % Dividend Per Share Payout Ratio %
DIFI.TADirect Finance of Direct Group (2006) Ltd0.05%$27.7672.89%
DOHOL.ISDogan Sirketler Grubu Holding A.S.0.05%$0.011.12%
DSW.LDSW Capital plc0.05%$0.0471.47%
EDIN.LThe Edinburgh Investment Trust plc0.05%$0.4323.09%
EKF.LEKF Diagnostics Holdings plc0.05%$0.0149.97%
FNTL.LFintel Plc0.05%$0.1086.78%
FSTA.LFuller, Smith & Turner PLC0.05%$0.3857.02%
GAW.LGames Workshop Group PLC0.05%$9.3789.20%
GCC.MXGCC, S.A.B. de C.V.0.05%$0.099.95%
GPE.LGreat Portland Estates Plc0.05%$0.1617.61%
HAT.LH&T Group plc0.05%$0.3434.09%
HEFT.LHenderson European Focus Trust plc0.05%$0.0964.95%
HWDN.LHowden Joinery Group Plc0.05%$0.4245.53%
I3E.Li3 Energy Plc0.05%$0.0115.40%
ISRS.TAIsras Investment Company Ltd0.05%$45.2156.32%
IX.Li(x) Net Zero Plc0.05%$0.000.12%
JSE.JOJSE Limited0.05%$7.9536.38%
JSG.LJohnson Service Group PLC0.05%$0.0741.78%
KGH.LKnights Group Holdings plc0.05%$0.0842.63%
KNOS.LKainos Group plc0.05%$0.5378.52%
LMP.LLondonMetric Property Plc0.05%$0.1043.71%
MDTR.TAMediterranean Towers Ltd.0.05%$0.6532.16%
MGNS.LMorgan Sindall Group plc0.05%$2.3541.65%
MLRN.TAM.L.R.N Projects and Trade Ltd.0.05%$0.7141.84%
NIOX.LNIOX Group Plc0.05%$0.0382.72%
NTBR.LNorthern Bear PLC0.05%$0.0724.02%
NWOR.LNational World Plc0.05%$0.0165.38%
PTBL.TAProperty & Building Corp. Ltd.0.05%$18.0065.50%
ROR.LRotork plc0.05%$0.1558.18%
SAIN.LThe Scottish American Investment Company PLC0.05%$0.2646.12%
SHRS.LShires Income Plc0.05%$0.178.90%
SLARL.TASella Capital Real Estate Ltd.0.05%$0.5543.38%
SMJ.LJ. Smart & Co. (Contractors) PLC0.05%$0.0737.45%
SOLI.LSolid State plc0.05%$0.0847.33%
SSE.LSSE plc0.05%$1.0339.40%
STB.LSecure Trust Bank PLC0.05%$0.6325.00%
THRG.LBlackRock Throgmorton Trust plc0.05%$0.2939.74%
TIFS.LTI Fluid Systems plc0.05%$0.1147.06%
TMPL.LTemple Bar Investment Trust PLC0.05%$0.2017.86%
TSTL.LTristel PLC0.05%$0.2493.73%
TUNE.LFocusrite plc0.05%$0.1397.00%
UPGS.LUP Global Sourcing Holdings plc0.05%$0.0725.06%
VOF.LVinaCapital Vietnam Opportunity Fund Limited0.05%$0.2516.06%
WTMWhite Mountains Insurance Group, Ltd.0.05%$1.021.85%
000230.KSIldong Holdings Co., Ltd.0.04%$5.330.12%
000729.SZBeijing Yanjing Brewery Co.,Ltd.0.04%$0.000.84%
001515.KSSK Securities Co., Ltd.0.04%$1.0611.94%
002159.SZWuhan Sante Cableway Group Co., Ltd.0.04%$0.010.86%
002252.SZShanghai RAAS Blood Products Co., Ltd.0.04%$0.001.00%
002316.SZJilin Asia Link Technology Development Co.,Ltd.0.04%$0.0016.75%