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 15 of 30 Next »
Ticker Company Dividend Yield % Dividend Per Share Payout Ratio %
0R28.LNewmont Corporation2.49%$1.0115.53%
ETREntergy Corporation2.49%$2.3457.35%
NKENIKE, Inc.2.49%$1.5880.59%
OTTROtter Tail Corporation2.49%$2.0330.69%
FHNFirst Horizon Corporation2.48%$0.6034.42%
PWPPerella Weinberg Partners2.48%$0.4469.65%
SCSSteelcase Inc.2.48%$0.4050.05%
PBIPitney Bowes Inc.2.46%$0.2561.37%
RBCAARepublic Bancorp, Inc.2.45%$1.6725.85%
SRCE1st Source Corporation2.45%$1.5325.20%
TRMKTrustmark Corporation2.45%$0.9626.11%
VOYAVoya Financial, Inc.2.45%$1.8629.46%
AWKAmerican Water Works Company, Inc.2.44%$3.1855.85%
LSTRLandstar System, Inc.2.44%$3.5890.21%
NGLNGL Energy Partners LP2.44%$0.2424.52%
TCFCThe Community Financial Corporation2.44%$0.6612.72%
CADECadence Bank2.43%$1.0537.49%
JNJJohnson & Johnson2.43%$5.0448.70%
MBCNMiddlefield Banc Corp.2.43%$0.8342.36%
0L7G.LSnap-on Incorporated2.42%$8.4344.15%
ITWIllinois Tool Works Inc.2.42%$6.0458.20%
MOFGMidWestOne Financial Group, Inc.2.40%$0.9232.44%
FFINFirst Financial Bankshares, Inc.2.39%$0.7242.45%
ADPAutomatic Data Processing, Inc.2.38%$6.0359.30%
CALCaleres, Inc.2.38%$0.2946.21%
ABMABM Industries Incorporated2.37%$1.0154.79%
FUNCFirst United Corporation2.36%$0.8822.87%
HONHoneywell International Inc.2.36%$4.6348.21%
RILYKB. Riley Financial, Inc. 5.50% Senior Notes Due 20262.36%$0.5856.91%
CDWCDW Corporation2.35%$3.1439.31%
CHMGChemung Financial Corporation2.35%$1.2846.47%
LZBLa-Z-Boy Incorporated2.35%$0.8840.20%
PKGPackaging Corporation of America2.35%$4.9750.31%
UNPUnion Pacific Corporation2.35%$5.4445.77%
0K91.LNorthern Trust Corporation2.34%$3.2035.68%
MCDMcDonald's Corporation2.33%$7.0760.14%
MGEEMGE Energy, Inc.2.32%$1.8249.49%
MZTIThe Marzetti Company2.32%$3.8261.80%
UNMUnum Group2.32%$1.7933.52%
RILYMB. Riley Financial, Inc. - 6.372.31%$0.5856.91%
RILYOB. Riley Financial, Inc. - 6.752.31%$0.5856.91%
HONIVHoneywell International Inc. Common Stock Ex Distribution When Issued2.30%$4.6348.21%
PGRThe Progressive Corporation2.30%$4.8826.80%
WNEBWestern New England Bancorp, Inc.2.30%$0.2843.00%
0R23.LHalliburton Company2.29%$0.6844.61%
ADSBread Financial Holdings, Inc.2.29%$1.3021.08%
HLNEHamilton Lane Incorporated2.29%$3.1374.09%
BSVNBank7 Corp.2.28%$0.9420.81%
MCBCMacatawa Bank Corporation2.28%$0.3428.37%
BRKLBrookline Bancorp, Inc.2.27%$0.5461.06%