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 11 of 30 Next »
Ticker Company Dividend Yield % Dividend Per Share Payout Ratio %
THFFFirst Financial Corporation3.32%$1.9831.67%
IRDMIridium Communications Inc.3.31%$0.5949.66%
PDCOPatterson Companies, Inc.3.31%$1.0466.64%
0HRZ.LCoterra Energy Inc.3.30%$0.8840.64%
ACIAlbertsons Companies, Inc.3.30%$0.5733.33%
KDPKeurig Dr Pepper Inc.3.30%$0.9278.89%
SPBSpectrum Brands Holdings, Inc.3.30%$1.9848.25%
0IUX.LGenuine Parts Company3.29%$4.0569.77%
BGBunge Global S.A.3.29%$3.0531.37%
HDGCXThe Hartford Dividend and Growth Fund Class C3.29%$1.0820.58%
PSBDPalmer Square Capital BDC Inc.3.29%$0.4090.32%
LIENChicago Atlantic BDC, Inc.3.28%$0.3423.50%
REXRRexford Industrial Realty, Inc.3.28%$1.2890.14%
CVCYCentral Valley Community Bancorp3.27%$0.5832.80%
F-PDFord Motor Company 6.500% Notes3.27%$0.7463.45%
FSBWFS Bancorp, Inc.3.27%$1.3331.78%
TRNOTerreno Realty Corporation3.27%$1.9362.02%
0I1P.LComerica Incorporated3.26%$2.8252.30%
ALEXAlexander & Baldwin, Inc.3.26%$0.6766.95%
BRXBrixmor Property Group Inc.3.26%$0.8578.30%
AGM-PCFederal Agricultural Mortgage Corporation3.24%$7.8539.89%
HTOH2O America3.24%$1.6052.08%
WECWEC Energy Group, Inc.3.24%$3.4566.21%
XOMExxon Mobil Corporation3.24%$3.9857.54%
SCLStepan Company3.22%$1.5276.82%
HBTHBT Financial, Inc.3.21%$0.8333.20%
KALUKaiser Aluminum Corporation3.21%$3.8670.13%
SMPStandard Motor Products, Inc.3.20%$1.1838.74%
0QZA.LConocoPhillips3.19%$3.0943.65%
PAGPenske Automotive Group, Inc.3.18%$5.0435.22%
CRBGCorebridge Financial, Inc.3.17%$0.9652.57%
EDConsolidated Edison, Inc.3.17%$3.1756.36%
LARKLandmark Bancorp, Inc.3.17%$0.8238.75%
NBPU.LNB Private Equity Partners Limited3.17%$0.6770.20%
PFBCPreferred Bank3.16%$3.0329.67%
HNIHNI Corporation3.15%$1.3444.63%
RBBRBB Bancorp3.15%$0.6443.45%
FGF&G Annuities & Life, Inc.3.14%$0.9428.23%
NBHCNational Bank Holdings Corporation3.14%$1.1937.27%
0KZA.LSM Energy Company3.13%$0.609.44%
CBUCommunity Bank System, Inc.3.13%$1.8246.85%
DTEDTE Energy Company3.13%$4.0887.19%
RNSTRenasant Corporation3.13%$1.1148.14%
BSRRSierra Bancorp3.11%$1.0134.68%
FCFFirst Commonwealth Financial Corporation3.11%$0.5238.19%
PNCThe PNC Financial Services Group, Inc.3.11%$6.5739.89%
PRKPark National Corporation3.11%$4.8044.20%
GEFGreif, Inc.3.10%$2.1212.04%
0QAH.LMerck & Co., Inc.3.09%$3.2542.60%
BANRBanner Corporation3.09%$1.9335.15%