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 20 of 30 Next »
Ticker Company Dividend Yield % Dividend Per Share Payout Ratio %
SMBCSouthern Missouri Bancorp, Inc.1.61%$0.9417.19%
VIRCVirco Mfg. Corporation1.61%$0.1041.34%
CNOCNO Financial Group, Inc.1.60%$0.6722.53%
IVTInvenTrust Properties Corp.1.60%$0.4529.49%
KBRKBR, Inc.1.60%$0.6521.84%
OBKOrigin Bancorp, Inc.1.60%$0.6031.45%
TNCTennant Company1.60%$1.1839.96%
DELLDell Technologies Inc.1.59%$2.0327.33%
RVSBRiverview Bancorp, Inc.1.59%$0.0835.84%
0HPW.LBroadridge Financial Solutions, Inc.1.58%$3.4944.54%
CCFChase Corporation1.58%$2.0157.26%
MSIFMSC Income Fund, Inc.1.58%$0.2112.72%
PRIPrimerica, Inc.1.58%$4.1018.44%
IEXIDEX Corporation1.57%$2.8244.28%
LHXL3Harris Technologies, Inc.1.57%$4.7951.11%
MROMarathon Oil Corporation1.57%$0.4519.02%
NEUNewMarket Corporation1.57%$10.8222.69%
PSMTPriceSmart, Inc.1.57%$1.9339.29%
TFSLTFS Financial Corporation1.57%$0.2165.45%
UFPIUFP Industries, Inc.1.57%$1.4425.79%
0M3Q.LZoetis Inc.1.56%$1.9532.55%
0K92.LNorthrop Grumman Corporation1.55%$8.8031.43%
0QZ5.LCognizant Technology Solutions Corporation1.55%$1.2528.62%
EMREmerson Electric Co.1.55%$2.1151.98%
SYFSynchrony Financial1.55%$1.3213.96%
TXRHTexas Roadhouse, Inc.1.55%$2.6540.30%
0HQW.LC.H. Robinson Worldwide, Inc.1.54%$2.4850.26%
0J76.LHuntington Ingalls Industries, Inc.1.54%$5.3637.08%
BHEBenchmark Electronics, Inc.1.54%$0.6865.62%
DPZDomino's Pizza, Inc.1.54%$6.5437.90%
GRCThe Gorman-Rupp Company1.54%$0.7438.69%
DFSDiscover Financial Services1.53%$3.0616.08%
SPFISouth Plains Financial, Inc.1.53%$0.5916.67%
JMSBJohn Marshall Bancorp, Inc.1.52%$0.3029.07%
0J3H.LThe Hartford Financial Services Group, Inc.1.51%$2.0616.53%
TRVThe Travelers Companies, Inc.1.51%$4.2916.63%
CISMXClarkston Partners Fund Institutional Class1.50%$0.1932.74%
FCAPFirst Capital, Inc.1.50%$0.8828.53%
MGYRMagyar Bancorp, Inc.1.50%$0.2622.66%
OBTOrange County Bancorp, Inc.1.50%$0.4315.62%
OSKOshkosh Corporation1.50%$1.9919.24%
SAICScience Applications International Corporation1.50%$1.5119.14%
FULH.B. Fuller Company1.49%$0.9043.28%
CBNKCapital Bancorp, Inc.1.48%$0.4114.04%
FRBAFirst Bank1.48%$0.2414.40%
ANDEThe Andersons, Inc.1.47%$0.7836.39%
IROQIF Bancorp, Inc.1.47%$0.4025.40%
WMWaste Management, Inc.1.47%$3.2250.78%
ATRAptarGroup, Inc.1.45%$1.7828.44%
CHXChampionX Corporation1.45%$0.3724.70%