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 24 of 30 Next »
Ticker Company Dividend Yield % Dividend Per Share Payout Ratio %
EXPDExpeditors International of Washington, Inc.0.99%$1.5024.32%
LISOXLazard International Strategic Equity Ptf Open Shares0.99%$0.1336.87%
MXCMexco Energy Corporation0.99%$0.1012.25%
NICNicolet Bankshares, Inc.0.99%$1.1912.58%
PAYCPaycom Software, Inc.0.99%$1.5118.80%
RRCRange Resources Corporation0.99%$0.3514.60%
WLFCWillis Lease Finance Corporation0.99%$1.327.58%
WORWorthington Industries, Inc.0.99%$0.5223.95%
CNXNPC Connection, Inc.0.98%$0.5616.89%
CATCaterpillar Inc.0.97%$5.7829.40%
CNKCinemark Holdings, Inc.0.97%$0.2318.28%
ECLEcolab Inc.0.97%$2.5436.57%
EVREvercore Inc.0.97%$3.4127.02%
LSBKLake Shore Bancorp, Inc.0.96%$0.1424.34%
0ITL.LArthur J. Gallagher & Co.0.95%$2.4239.43%
0IZI.LW.W. Grainger, Inc.0.95%$9.5226.47%
0L5V.LThe Sherwin-Williams Company0.95%$3.1130.09%
0R2S.LStryker Corporation0.95%$3.2843.09%
RRXRegal Rexnord Corporation0.95%$1.3936.07%
WTWisdomTree, Inc.0.95%$0.1218.12%
JJacobs Solutions Inc.0.94%$1.2753.80%
ORCLOracle Corporation0.94%$1.8434.81%
TCBSTexas Community Bancshares, Inc.0.94%$0.1719.22%
IMKTAIngles Markets, Incorporated0.93%$0.6514.68%
ODCOil-Dri Corporation of America0.93%$0.4512.28%
PENGPenguin Solutions, Inc.0.93%$0.1940.17%
SSBKSouthern States Bancshares, Inc.0.93%$0.349.19%
DALDelta Air Lines, Inc.0.92%$0.638.94%
HIFSHingham Institution for Savings0.92%$2.4912.15%
RLRalph Lauren Corporation0.92%$3.3424.37%
OPYOppenheimer Holdings Inc.0.91%$0.668.90%
BGCBGC Group, Inc0.90%$0.0823.56%
CDRECadre Holdings, Inc.0.90%$0.3733.35%
MBNKPMedallion Bank0.90%$0.2312.50%
JBHTJ.B. Hunt Transport Services, Inc.0.89%$1.7530.14%
NYTThe New York Times Company0.89%$0.6230.32%
RMDResMed Inc.0.89%$2.1822.31%
VBFCVillage Bank and Trust Financial Corp.0.89%$0.7215.35%
0I14.LCognex Corporation0.88%$0.3249.16%
ARAntero Resources Corporation0.88%$0.3017.15%
LDOSLeidos Holdings, Inc.0.88%$1.6114.88%
LMATLeMaitre Vascular, Inc.0.88%$0.7032.20%
NNINelnet, Inc.0.88%$1.149.52%
PFSIPennyMac Financial Services, Inc.0.88%$1.1612.49%
SMBKSmartFinancial, Inc.0.88%$0.3211.76%
BYDBoyd Gaming Corporation0.87%$0.753.22%
ROSTRoss Stores, Inc.0.87%$1.5924.85%
BBSIBarrett Business Services, Inc.0.86%$0.3115.02%
BCOThe Brink's Company0.86%$1.0024.81%
HXLHexcel Corporation0.86%$0.6677.18%