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 14 of 151 Next »
Ticker Company Dividend Yield % Dividend Per Share Payout Ratio %
FGG.AXFuture Generation Global Limited7.59%$0.1235.11%
WINNER.BKWinner Group Enterprise Public Company Limited7.59%$0.1677.25%
1666.HKTong Ren Tang Technologies Co. Ltd.7.58%$0.3439.83%
ALHOP.PAHopscotch Global PR Group7.58%$1.0034.20%
4305.TWOShih-Kuen Plastics Co., Ltd.7.57%$3.1886.35%
KLEE-B.COBrd. Klee A/S7.57%$284.4657.64%
TACC.BKT.A.C. Consumer Public Company Limited7.56%$0.3986.66%
PCC.BKPrecise Corporation Public Company Limited7.55%$0.2054.85%
2180.HKManpowerGroup Greater China Limited7.54%$0.3930.76%
BASGZ.ISBaskent Dogalgaz Dagitim Gayrimenkul Yatirim Ortakligi A.S.7.54%$3.4364.56%
ISAE4.SAISA Energía Brasil S.A.7.54%$2.0345.68%
TRPL4.SACTEEP - Companhia de Transmissão de Energia Elétrica Paulista S.A.7.53%$1.8837.46%
QH-R.BKQuality Houses Public Company Limited7.52%$0.1063.63%
0189.HKDongyue Group Limited7.51%$0.8267.14%
3034.KLHap Seng Consolidated Berhad7.50%$0.2189.85%
9985.HKWEILONG Delicious Global Holdings Ltd7.50%$0.8387.47%
CBQK.QAThe Commercial Bank (P.S.Q.C.)7.50%$0.3248.96%
BMGB4.SABanco BMG S.A.7.49%$0.3767.48%
DJW.AXDjerriwarrh Investments Limited7.49%$0.2378.76%
JSMR.JKPT Jasa Marga (Persero) Tbk7.49%$256.8147.02%
TGMA3.SATegma Gestão Logística S.A.7.49%$2.7365.23%
014440.KSYoungbo Chemical Co., Ltd.7.48%$350.9938.29%
CPW.BKCopperwired Public Company Limited7.48%$0.1585.48%
003080.KSSBSUNGBO Co., Ltd.7.47%$205.009.79%
226320.KSIt'S Hanbul Co., Ltd.7.47%$887.8495.70%
AYGAZ.ISAygaz A.S.7.47%$14.7993.51%
3290.TOne REIT, Inc.7.46%$6,781.0766.29%
TOTL.JKPT Total Bangun Persada Tbk7.46%$75.0067.24%
1497.HKXiamen Yan Palace Bird's Nest Indus7.45%$0.4461.94%
ANIM.MIAnima Holding S.p.A.7.45%$0.4555.56%
DCC-R.BKDynasty Ceramic Public Company Limited7.45%$0.0981.26%
0751.HKSkyworth Group Limited7.44%$0.3953.99%
8957.TTokyu REIT, Inc.7.44%$15,400.2079.77%
2504.TWGoldsun Building Materials Co., Ltd.7.43%$2.8186.16%
KEPL3.SAKepler Weber S.A.7.43%$0.7389.80%
POLY.BKPolynet Public Company Limited7.43%$0.5288.16%
XTB.WAXTB S.A.7.43%$5.4679.70%
TIPH.BKDhipaya Group Holdings Public Company Limited7.42%$1.5476.50%
ALFRE.PAFreelance.com S.A.7.40%$0.1623.60%
RING.OLSpareBank 1 Ringerike Hadeland7.40%$30.8074.39%
SEAOIL.BKSea Oil Public Company Limited7.39%$0.2246.45%
IRC.BKInoue Rubber (Thailand) Public Company Limited7.36%$0.8790.55%
ILM-R.BKIndex Living Mall Public Company Limited7.34%$1.0067.79%
SHIPSeanergy Maritime Holdings Corp.7.34%$0.6791.71%
5009.TWOGloria Material Technology Corp.7.33%$2.3477.68%
9922.HKJiumaojiu International Holdings Limited7.33%$0.1455.41%
8977.THankyu Hanshin REIT, Inc.7.32%$12,179.9195.79%
BAREIT.BKBA Airport Leasehold Real Estate Investment Trust7.32%$0.7589.39%
SIDO.JKPT Industri Jamu dan Farmasi Sido Muncul Tbk7.32%$39.5596.37%
0QQK.LMeier Tobler Group AG7.31%$2.8980.26%