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 42 of 151 Next »
Ticker Company Dividend Yield % Dividend Per Share Payout Ratio %
0O1S.LAlten S.A.3.81%$4.4339.82%
3607.TKuraudia Holdings Co.,Ltd.3.81%$11.9934.63%
7179.KLLagenda Properties Berhad3.81%$0.0530.12%
8188.HKGME Group Holdings Limited3.81%$0.0423.08%
FC9.DEFCR Immobilien AG3.81%$0.4615.59%
PSGO.JKPT Palma Serasih Tbk3.81%$8.0038.48%
TASA3.SATaurus Armas S.A.3.81%$0.1920.71%
000726.SZLu Thai Textile Co., Ltd.3.80%$0.2741.15%
012750.KSS-1 Corporation3.80%$2,699.9250.51%
603198.SSAnhui Yingjia Distillery Co., Ltd.3.80%$1.5057.46%
8273.TIzumi Co., Ltd.3.80%$113.8567.94%
LMKDC.ISLimak Dogu Anadolu Cimento Sny Ve Tcr AS3.80%$1.0927.90%
THULE.STThule Group AB (publ)3.80%$8.8190.05%
ZUGER.SWZuger Kantonalbank3.80%$335.4837.77%
000430.KSDaewon Kang Up Co., Ltd.3.79%$151.1888.95%
0558.HKL.K. Technology Holdings Limited3.79%$0.1321.83%
1888.HKKingboard Laminates Holdings Limited3.79%$0.5157.98%
603055.SSZhe Jiang Taihua New Material Co., Ltd.3.79%$0.3660.25%
CPU.AXComputershare Limited3.79%$1.2951.79%
INDS.JKPT Indospring Tbk3.79%$8.5681.55%
002120.SZYUNDA Holding Co., Ltd.3.78%$0.2559.62%
6305.THitachi Construction Machinery Co., Ltd.3.78%$175.1342.61%
GROREIT.BKGrande Royal Orchid Hospitality Real Estate Investment Trust with Buy-Back Condition3.78%$0.2834.44%
QNBK.QAQatar National Bank (Q.P.S.C.)3.78%$0.7138.00%
SISB.BKSISB Public Company Limited3.78%$0.4242.68%
078520.KSAble C&C Co., Ltd.3.77%$412.0869.50%
192400.KSCuckoo Holdings Co., Ltd.3.77%$1,087.9926.79%
6435.TWOSinopower Semiconductor, Inc.3.77%$4.2656.41%
6523.TPHC Holdings Corporation3.77%$41.8790.94%
6724.TSeiko Epson Corporation3.77%$74.7647.38%
ASCArdmore Shipping Corporation3.77%$0.3945.12%
BAHN-B.STBahnhof AB (publ)3.77%$2.0097.05%
CNDF.PACaisse Régionale de Crédit Agricole Mutuel Nord de France Société coopérative3.77%$1.0314.19%
0QLT.LGraubündner Kantonalbank3.76%$69.0139.45%
603587.SSDazzle Fashion Co., Ltd3.76%$0.5090.21%
A1OS.DEAll for One Group SE3.76%$1.6250.06%
CWY.AXCleanaway Waste Management Limited3.76%$0.1069.98%
GYT.BKGoodyear (Thailand) Public Company Limited3.76%$7.4022.93%
KARE.ATKarelia Tobacco Company Inc.3.76%$13.3038.58%
THEP.PAThermador Groupe S.A.3.76%$2.9736.00%
000708.SZCitic Pacific Special Steel Group Co., Ltd.3.75%$0.6156.33%
002615.SZZheJiang Haers Vacuum Containers Co.,Ltd.3.75%$0.2979.55%
004980.KSSungshin Cement Co., Ltd3.75%$351.1039.08%
2072.TWOCentury Wind Power Co., Ltd.3.75%$10.1549.95%
3455.TWOUtechzone Co., Ltd.3.75%$4.4995.02%
600519.SSKweichow Moutai Co., Ltd.3.75%$51.6271.84%
KUAS.JKPT Ace Oldfields Tbk3.75%$3.0033.35%
002142.SZBank of Ningbo Co., Ltd.3.74%$1.0524.03%
083420.KSGreen Chemical Co., Ltd.3.74%$240.1458.66%
0QPY.LSonova Holding AG3.74%$8.8746.46%