Definitive Analysis
Definitive Analysis
Get Full Access
See Pricing Start Free Trial

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 6 of 30 Next »
Ticker Company Dividend Yield % Dividend Per Share Payout Ratio %
FFord Motor Company5.53%$0.7463.45%
LCNBLCNB Corp.5.48%$0.8953.03%
PPBIPacific Premier Bancorp, Inc.5.48%$1.3492.42%
VGRVector Group Ltd.5.48%$0.8263.35%
DLXDeluxe Corporation5.43%$1.2166.43%
BAFNBayFirst Financial Corp.5.41%$0.4321.50%
IPGThe Interpublic Group of Companies, Inc.5.41%$1.3388.72%
PEBOPeoples Bancorp Inc.5.39%$1.6256.40%
OKEONEOK, Inc.5.38%$4.0075.29%
BUSEFirst Busey Corporation5.37%$1.2875.92%
OASOasis Petroleum Inc.5.37%$5.8765.40%
EIXEdison International5.36%$3.2639.45%
0R1X.LGeneral Mills, Inc.5.35%$2.4545.62%
FIBKFirst Interstate BancSystem, Inc.5.35%$1.8979.54%
FNCBFNCB Bancorp, Inc.5.33%$0.3651.41%
DHILDiamond Hill Investment Group, Inc.5.31%$9.0552.46%
SLRCSLR Investment Corp.5.31%$0.8249.67%
EPSNEpsilon Energy Ltd.5.30%$0.2491.92%
UVVUniversal Corporation5.28%$2.7862.64%
FLICThe First of Long Island Corporation5.27%$0.6386.64%
AUBAtlantic Union Bankshares Corporation5.22%$1.8576.04%
SAFESafehold Inc.5.20%$0.7145.17%
GAB-PGThe Gabelli Equity Trust Inc. PFD-G5.19%$1.0881.70%
HPQHP Inc.5.19%$1.1543.02%
SOISolaris Oilfield Infrastructure, Inc.5.18%$0.7025.64%
MBINOMerchants Bancorp5.17%$1.2924.09%
0JXQ.LMain Street Capital Corporation5.13%$3.1752.63%
EMNEastman Chemical Company5.12%$3.2954.36%
EMBCEmbecta Corp.5.10%$0.5936.96%
AMAntero Midstream Corporation5.09%$0.9193.18%
CZNCCitizens & Northern Corporation5.09%$1.0257.64%
FMNBFarmers National Banc Corp.5.09%$0.6846.83%
0J66.LHost Hotels & Resorts, Inc.5.08%$0.9084.69%
GLPIGaming and Leisure Properties, Inc.5.07%$2.2582.42%
PFISPeoples Financial Services Corp.5.07%$2.4446.22%
TBBAT&T Inc. 5.35% GLB NTS 665.07%$1.1436.88%
KFRCKforce Inc.5.02%$1.5768.10%
TTPTortoise Pipeline & Energy Fund, Inc.5.02%$2.3920.11%
STAR-PGiStar Inc.4.94%$1.2434.23%
PFSProvident Financial Services, Inc.4.93%$0.9761.13%
UBFOUnited Security Bancshares4.92%$0.4873.45%
DDTDillards Capital Trust I CAP SECS 7.5%4.90%$1.293.46%
SGUStar Group, L.P.4.89%$0.5836.90%
AGRAvangrid, Inc.4.88%$1.7660.70%
KMBKimberly-Clark Corporation4.88%$4.9583.80%
OCFCOceanFirst Financial Corp.4.86%$0.8761.98%
0I0J.LThe Clorox Company4.85%$4.8976.11%
FNLCThe First Bancorp, Inc.4.83%$1.2845.40%
RILYZB. Riley Financial, Inc. 5.25% Senior Notes due 20284.83%$0.5856.91%
BSETBassett Furniture Industries, Incorporated4.82%$0.8089.43%