Definitive Analysis
Definitive Analysis

Financial Statements

Fundamentals

Valuations

Miscellaneous

Analysis Mode

Search

FIBRA Macquarie México (FIBRAMQ12.MX)

Company Dividend Discount ModelIndustry: REIT - IndustrialSector: Real Estate

Valuation Snapshot

Stable Growth$410.20 - $1,090.36$1,021.83
Multi-Stage$155.04 - $169.66$162.22
Blended Fair Value$592.02
Current Price$30.04
Upside1,870.78%
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.20$1,021.83$1,090.36
Upside / Downside1,265.52%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.052,179.522,199.98
Year 2 PV (M)2,565.012,613.872,663.19
Year 3 PV (M)2,962.143,047.183,133.82
Year 4 PV (M)3,350.583,479.443,611.97
Year 5 PV (M)3,730.473,910.664,097.74
PV of Terminal Value (M)108,849.30114,106.76119,565.44
Equity Value (M)123,616.57129,337.42135,272.14
Shares Outstanding (M)797.31797.31797.31
Fair Value$155.04$162.22$169.66
Upside / Downside416.12%440.00%464.78%

High-Yield Dividend Screener

« Prev Page 13 of 151 Next »
Ticker Company Dividend Yield % Dividend Per Share Payout Ratio %
PCR.WAPCC Rokita S.A.7.82%$5.0595.33%
TQR.BKTQR Public Company Limited7.82%$0.3990.56%
KGI.BKKGI Securities (Thailand) Public Company Limited7.81%$0.3162.80%
PRDA.JKPT Prodia Widyahusada Tbk7.81%$180.5285.06%
AIMIRT.BKAIM Industrial Growth Freehold and Leasehold Real Estate Investment Trust7.80%$0.8581.01%
AKRA.JKPT AKR Corporindo Tbk7.80%$99.8882.20%
SPREME.BKSupreme Distribution Public Company Limited7.80%$0.1190.62%
AYV.PAAyvens7.79%$0.9171.87%
1378.HKChina Hongqiao Group Limited7.78%$2.6556.89%
NRG.PANRJ Group S.A.7.78%$0.6363.81%
D2O.AXDuxton Water Limited7.77%$0.1250.68%
TVO-R.BKThai Vegetable Oil Public Company Limited7.77%$1.7462.11%
C38U.SICapitaLand Integrated Commercial Trust7.76%$0.1874.73%
002839.SZJiangsu Zhangjiagang Rural Commercial Bank Co., Ltd7.75%$0.3544.09%
0710.HKBOE Varitronix Limited7.75%$0.4239.15%
0951.HKChaowei Power Holdings Limited7.75%$0.1120.52%
1681.HKConsun Pharmaceutical Group Limited7.75%$1.2055.92%
AXA.DEAXA S.A.7.75%$3.1752.74%
RND.AXRand Mining Limited7.75%$0.2057.47%
601881.SSChina Galaxy Securities Co., Ltd.7.74%$1.2298.30%
TA1.DETelekom Austria AG7.74%$0.7679.04%
0746.HKLee & Man Chemical Company Limited7.73%$0.4035.48%
NESN.SWNestlé S.A.7.73%$6.0972.83%
2633.HKJacobson Pharma Corporation Limited7.72%$0.1036.63%
000498.SZShandong Hi-Speed Road and Bridge Group Co., Ltd.7.71%$0.4748.64%
0016.HKSun Hung Kai Properties Limited7.71%$7.4556.97%
0QKE.LVontobel Holding AG7.70%$4.4661.99%
HAEK.DEHaemato AG7.70%$1.6385.37%
2688.HKENN Energy Holdings Limited7.68%$5.3950.36%
ASIMAR.BKAsian Marine Services Public Company Limited7.68%$0.1260.54%
SAMS.PASamse S.A.7.68%$10.2556.16%
SEC.AXSpheria Emerging Companies Limited7.68%$0.2215.84%
UVAN.BKUnivanich Palm Oil Public Company Limited7.68%$1.0063.09%
JCT.BKJack Chia Industries (Thailand) Public Company Limited7.67%$6.4483.85%
KFL.NZKingfish Limited7.67%$0.1038.05%
ALRIB.PARiber S.A.7.65%$0.2771.18%
DXI.AXDexus Industria REIT7.65%$0.2117.56%
NISP.JKPT Bank OCBC NISP Tbk7.65%$106.0049.91%
SCG.AXScentre Group7.65%$0.3291.06%
002572.SZSuofeiya Home Collection Co., Ltd.7.62%$1.0488.29%
035000.KSHS Ad Inc.7.62%$648.8381.78%
JMT-R.BKJMT Network Services Public Company Limited7.62%$0.6769.23%
SQU.DEVinci S.A.7.62%$9.2455.99%
0QP2.LZurich Insurance Group AG7.61%$32.4879.70%
BAMI.MIBanco BPM S.p.A.7.61%$1.0080.93%
600795.SSGD Power Development Co.,Ltd7.60%$0.3892.13%
BTI.AXBailador Technology Investments Limited7.60%$0.0934.83%
SMPC.BKSahamitr Pressure Container Public Company Limited7.60%$0.6757.18%
0O33.LOeneo S.A.7.59%$0.7076.88%
BOREO.HEBoreo Oyj7.59%$1.0882.86%