Definitive Analysis
Definitive Analysis

Financial Statements

Analysis Mode

Ticker

Industry

Sector

FIBRA Macquarie México (FIBRAMQ12.MX)

Company Dividend Discount ModelIndustry: REIT - IndustrialSector: Real Estate

Valuation Snapshot

Stable Growth$410.05 - $1,090.36$1,021.83
Multi-Stage$155.02 - $169.64$162.20
Blended Fair Value$592.01
Current Price$30.04
Upside1,870.74%
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.05$1,021.83$1,090.36
Upside / Downside1,265.01%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.512,199.97
Year 2 PV (M)2,564.992,613.852,663.17
Year 3 PV (M)2,962.113,047.143,133.78
Year 4 PV (M)3,350.533,479.383,611.92
Year 5 PV (M)3,730.403,910.584,097.65
PV of Terminal Value (M)108,834.38114,091.12119,549.05
Equity Value (M)123,601.45129,321.58135,255.54
Shares Outstanding (M)797.31797.31797.31
Fair Value$155.02$162.20$169.64
Upside / Downside416.05%439.94%464.71%

High-Yield Dividend Screener

« Prev Page 48 of 151 Next »
Ticker Company Dividend Yield % Dividend Per Share Payout Ratio %
3269.TAdvance Residence Investment Corporation3.39%$5,804.0552.10%
CTZ.VNamSys Inc.3.39%$0.0556.26%
FILTRA.BOFiltra Consultants and Engineers Limited3.39%$2.4484.66%
INWI.STInwido AB (publ)3.39%$5.4860.02%
000422.SZHubei Yihua Chemical Industry Co., Ltd.3.38%$0.4872.32%
002318.SZZhejiang Jiuli Hi-Tech Metals Co., Ltd.3.38%$0.9854.31%
002533.SZGold cup Electric Apparatus Co.,Ltd.3.38%$0.4250.59%
003490.KSKorean Air Lines Co., Ltd.3.38%$750.2629.70%
600578.SSBeijing Jingneng Power Co., Ltd.3.38%$0.1733.20%
601811.SSXinhua Winshare Publishing and Media Co., Ltd.3.38%$0.4534.30%
7270.TSubaru Corporation3.38%$114.7827.17%
JHGJanus Henderson Group plc3.38%$1.6146.72%
002714.SZMuyuan Foods Co., Ltd.3.37%$1.7041.84%
019210.KQYG-1 Co., Ltd.3.37%$174.8833.83%
1954.TNippon Koei Co., Ltd.3.37%$126.0437.37%
7TEC.BOSaven Technologies Limited3.37%$1.5048.59%
8252.TMarui Group Co., Ltd.3.37%$108.4166.71%
9739.TNSW Inc.3.37%$85.1035.17%
0JMU.Ltechnotrans SE3.36%$1.1552.64%
4321.SRArabian Centres Company3.36%$0.6424.31%
600141.SSHubei Xingfa Chemicals Group Co., Ltd.3.36%$1.1683.90%
601825.SSShanghai Rural Commercial Bank Co., Ltd.3.36%$0.3124.33%
KC4.DEKONE Oyj3.36%$1.8095.42%
OTEXOpen Text Corporation3.36%$1.0755.28%
294870.KSHDC Hyundai Development Company3.35%$700.0023.41%
4212.TSekisui Jushi Corporation3.35%$71.2959.28%
B61.SIBukit Sembawang Estates Limited3.35%$0.1636.24%
CAMB.BRCampine N.V.3.35%$7.6318.23%
ELIS.PAElis S.A.3.35%$0.8033.62%
KREATE.HEKreate Group Oyj3.35%$0.4379.17%
M12.DEM1 Kliniken AG3.35%$0.6132.73%
XGR2.DECompass Group PLC3.35%$0.9061.67%
004430.KSSongwon Industrial Co., Ltd.3.34%$301.2433.59%
0N66.LATOSS Software AG3.34%$3.8280.44%
6219.TWOFull Wang International Development Co., Ltd.3.34%$0.6777.89%
9537.SRAmwaj International Company3.34%$1.0094.38%
AMATAV.BKAmata VN Public Company Limited3.34%$0.0621.41%
EOAN.DEE.on Se3.34%$0.5547.88%
030190.KQNICE Information Service Co., Ltd.3.33%$331.9538.71%
089470.KSHDC Hyundai Engineering Plastics Co., Ltd.3.33%$140.0111.49%
2373.HKBeauty Farm Medical and Health Industry Inc.3.33%$0.8841.42%
600258.SSBTG Hotels (Group) Co., Ltd.3.33%$0.5674.23%
601518.SSJilin Expressway Co., Ltd.3.33%$0.0932.60%
6584.TSanoh Industrial Co., Ltd.3.33%$28.5739.95%
6843.TWOJDV Control Valves Co., Ltd.3.33%$1.9085.01%
ARASE.ISDogu Aras Enerji Yatirimlari AS3.33%$2.3841.72%
AZA.STAvanza Bank Holding AB (publ)3.33%$11.7070.53%
BAY-R.BKBank of Ayudhya Public Company Limited3.33%$0.8720.61%
SL.MISanlorenzo S.p.A.3.33%$1.0133.16%
STNGScorpio Tankers Inc.3.33%$1.6528.37%