Definitive Analysis
Loading...
Definitive Analysis

Financial Statements

Ticker

Industry

Sector

FIBRA Macquarie México (FIBRAMQ12.MX)

Company Dividend Discount ModelIndustry: REIT - IndustrialSector: Real Estate

Valuation Snapshot

Stable Growth$410.48 - $1,090.36$1,021.83
Multi-Stage$155.08 - $169.70$162.25
Blended Fair Value$592.04
Current Price$30.04
Upside1,870.83%
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.48$1,021.83$1,090.36
Upside / Downside1,266.44%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.072,179.532,200.00
Year 2 PV (M)2,565.052,613.912,663.23
Year 3 PV (M)2,962.213,047.243,133.89
Year 4 PV (M)3,350.683,479.543,612.08
Year 5 PV (M)3,730.613,910.794,097.88
PV of Terminal Value (M)108,875.84114,134.59119,594.59
Equity Value (M)123,643.45129,365.60135,301.66
Shares Outstanding (M)797.31797.31797.31
Fair Value$155.08$162.25$169.70
Upside / Downside416.23%440.12%464.91%

High-Yield Dividend Screener

« Prev Page 70 of 151 Next »
Ticker Company Dividend Yield % Dividend Per Share Payout Ratio %
6101.TTsugami Corporation2.08%$59.7021.18%
9549.SRAbdulaziz and Mansour Ibrahim Albabtin Co.2.08%$0.5029.71%
FPAR-A.STFastPartner AB (publ)2.08%$0.9755.03%
GRNG.STGränges AB (publ)2.08%$3.0934.78%
ZGNErmenegildo Zegna N.V.2.08%$0.2228.26%
000983.SZShanxi Coking Coal Energy Group Co.,Ltd.2.07%$0.1344.44%
006090.KSOyang Corporation2.07%$187.5543.67%
0O1O.LVetoquinol S.A.2.07%$1.7419.10%
1748.HKXin Yuan Enterprises Group Limited2.07%$0.0462.70%
4677.KLYTL Corporation Berhad2.07%$0.0426.42%
603136.SSJiangsu Tianmu Lake Tourism Co.,Ltd2.07%$0.2464.23%
7965.TZojirushi Corporation2.07%$32.3536.35%
MRSA3B.SAMRS Logística S.A.2.07%$0.8118.86%
OCL.AXObjective Corporation Limited2.07%$0.3457.76%
TRTNTriton International Limited2.07%$1.6528.50%
001219.SZQingdao Foods CO.,LTD.2.06%$0.2955.25%
002351.SZEdifier Technology Co., Ltd.2.06%$0.2553.80%
004830.KSDuksung Co., Ltd.2.06%$100.3019.66%
600120.SSZhejiang Orient Financial Holdings Group Co., Ltd.2.06%$0.1332.28%
600143.SSKingfa Sci. & Tech. Co., Ltd.2.06%$0.4085.82%
7735.TSCREEN Holdings Co., Ltd.2.06%$314.4332.13%
ALSO3.SAAliansce Sonae Shopping Centers S.A.2.06%$0.529.27%
MLIA.JKPT Mulia Industrindo Tbk2.06%$6.9827.72%
REA.AXREA Group Limited2.06%$3.8151.46%
THEON.ASTheon International PLC2.06%$0.5552.53%
000902.SZYONFER Agricultural Technology Co., Ltd.2.05%$0.3226.06%
002938.SZAvary Holding(Shenzhen)Co., Limited2.05%$1.0459.37%
036930.KQJUSUNG ENGINEERING Co., Ltd.2.05%$625.5045.79%
086280.KSHyundai Glovis Co., Ltd.2.05%$3,700.1019.97%
2730.TEDION Corporation2.05%$43.4130.64%
4191.SRAbdullah Saad Mohammed Abo Moati for Bookstores Company2.05%$1.0176.56%
9527.SRAme Company For Medical Supplies2.05%$2.0027.73%
BMIN3.SABanco Mercantil de Investimentos S.A.2.05%$0.4728.32%
GUAR3.SAGuararapes Confecções S.A.2.05%$0.1820.09%
MGROS.ISMigros Ticaret A.S.2.05%$10.8831.41%
MLL.DEMüller - Die lila Logistik AG2.05%$0.106.76%
RAY-A.TOStingray Group Inc.2.05%$0.3039.32%
VIVA3.SAVivara Participações S.A.2.05%$0.6620.93%
268280.KSMiwon Specialty Chemical Co., Ltd.2.04%$2,814.5722.79%
2869.HKGreentown Service Group Co. Ltd.2.04%$0.0917.96%
450330.KQHass2.04%$131.7935.27%
605589.SSJinan Shengquan Group Share Holding Co., Ltd.2.04%$0.5844.86%
CEK.DECeoTronics AG2.04%$0.2634.71%
CSAP.JKPT Catur Sentosa Adiprana Tbk2.04%$6.5030.53%
ROTH.PARothschild & Co SCA2.04%$0.7813.71%
2476.TWG-SHANK Enterprise Co., Ltd.2.03%$1.8549.48%
2852.KLCahya Mata Sarawak Berhad2.03%$0.0328.80%
3788.HKChina Hanking Holdings Limited2.03%$0.0836.16%
4004.SRDallah Healthcare Company2.03%$2.5449.37%
601607.SSShanghai Pharmaceuticals Holding Co., Ltd2.03%$0.3623.77%